WEBVTT
Kind: captions
Language: en

00:00:00.000 --> 00:00:02.060 align:start position:0%
 
I'm<00:00:00.480><c> going</c><00:00:00.750><c> to</c><00:00:00.840><c> show</c><00:00:00.989><c> you</c><00:00:01.050><c> a</c><00:00:01.140><c> quick</c><00:00:01.469><c> shortcut</c>

00:00:02.060 --> 00:00:02.070 align:start position:0%
I'm going to show you a quick shortcut
 

00:00:02.070 --> 00:00:04.490 align:start position:0%
I'm going to show you a quick shortcut
for<00:00:02.280><c> creating</c><00:00:02.429><c> absolute</c><00:00:03.270><c> references</c><00:00:03.870><c> and</c><00:00:04.080><c> you</c>

00:00:04.490 --> 00:00:04.500 align:start position:0%
for creating absolute references and you
 

00:00:04.500 --> 00:00:05.869 align:start position:0%
for creating absolute references and you
can<00:00:04.620><c> use</c><00:00:04.770><c> this</c><00:00:04.920><c> when</c><00:00:05.160><c> you're</c><00:00:05.250><c> typing</c><00:00:05.700><c> or</c>

00:00:05.869 --> 00:00:05.879 align:start position:0%
can use this when you're typing or
 

00:00:05.879 --> 00:00:08.930 align:start position:0%
can use this when you're typing or
editing<00:00:06.299><c> a</c><00:00:06.390><c> formula</c><00:00:06.950><c> so</c><00:00:07.950><c> first</c><00:00:08.189><c> of</c><00:00:08.340><c> all</c><00:00:08.400><c> what</c>

00:00:08.930 --> 00:00:08.940 align:start position:0%
editing a formula so first of all what
 

00:00:08.940 --> 00:00:11.299 align:start position:0%
editing a formula so first of all what
is<00:00:08.970><c> an</c><00:00:09.330><c> absolute</c><00:00:09.750><c> reference</c><00:00:09.929><c> an</c><00:00:10.349><c> absolute</c>

00:00:11.299 --> 00:00:11.309 align:start position:0%
is an absolute reference an absolute
 

00:00:11.309 --> 00:00:13.580 align:start position:0%
is an absolute reference an absolute
reference<00:00:11.519><c> is</c><00:00:11.969><c> a</c><00:00:12.389><c> cell</c><00:00:12.660><c> reference</c><00:00:12.840><c> that</c><00:00:13.290><c> stays</c>

00:00:13.580 --> 00:00:13.590 align:start position:0%
reference is a cell reference that stays
 

00:00:13.590 --> 00:00:16.279 align:start position:0%
reference is a cell reference that stays
locked<00:00:13.950><c> on</c><00:00:14.280><c> a</c><00:00:14.309><c> specific</c><00:00:15.000><c> cell</c><00:00:15.299><c> or</c><00:00:15.570><c> cell</c><00:00:15.990><c> range</c>

00:00:16.279 --> 00:00:16.289 align:start position:0%
locked on a specific cell or cell range
 

00:00:16.289 --> 00:00:19.250 align:start position:0%
locked on a specific cell or cell range
even<00:00:16.770><c> if</c><00:00:17.039><c> the</c><00:00:17.160><c> formula</c><00:00:17.460><c> is</c><00:00:17.760><c> copied</c><00:00:18.260><c> for</c>

00:00:19.250 --> 00:00:19.260 align:start position:0%
even if the formula is copied for
 

00:00:19.260 --> 00:00:21.170 align:start position:0%
even if the formula is copied for
example<00:00:19.680><c> if</c><00:00:19.859><c> we</c><00:00:20.010><c> create</c><00:00:20.340><c> a</c><00:00:20.369><c> formula</c><00:00:20.699><c> that</c><00:00:21.000><c> uses</c>

00:00:21.170 --> 00:00:21.180 align:start position:0%
example if we create a formula that uses
 

00:00:21.180 --> 00:00:23.960 align:start position:0%
example if we create a formula that uses
the<00:00:21.510><c> tax</c><00:00:21.750><c> rate</c><00:00:22.020><c> in</c><00:00:22.199><c> cell</c><00:00:22.470><c> d2</c><00:00:22.830><c> we'll</c><00:00:23.730><c> want</c><00:00:23.910><c> to</c>

00:00:23.960 --> 00:00:23.970 align:start position:0%
the tax rate in cell d2 we'll want to
 

00:00:23.970 --> 00:00:25.880 align:start position:0%
the tax rate in cell d2 we'll want to
make<00:00:24.090><c> it</c><00:00:24.240><c> an</c><00:00:24.330><c> absolute</c><00:00:24.869><c> reference</c><00:00:25.109><c> to</c><00:00:25.590><c> ensure</c>

00:00:25.880 --> 00:00:25.890 align:start position:0%
make it an absolute reference to ensure
 

00:00:25.890 --> 00:00:27.830 align:start position:0%
make it an absolute reference to ensure
that<00:00:25.920><c> any</c><00:00:26.310><c> copies</c><00:00:26.880><c> of</c><00:00:27.000><c> this</c><00:00:27.090><c> formula</c><00:00:27.570><c> are</c>

00:00:27.830 --> 00:00:27.840 align:start position:0%
that any copies of this formula are
 

00:00:27.840 --> 00:00:30.009 align:start position:0%
that any copies of this formula are
still<00:00:28.170><c> looking</c><00:00:28.320><c> at</c><00:00:28.619><c> the</c><00:00:28.859><c> same</c><00:00:29.130><c> tax</c><00:00:29.490><c> rate</c>

00:00:30.009 --> 00:00:30.019 align:start position:0%
still looking at the same tax rate
 

00:00:30.019 --> 00:00:32.540 align:start position:0%
still looking at the same tax rate
generally<00:00:31.019><c> the</c><00:00:31.260><c> way</c><00:00:31.349><c> to</c><00:00:31.410><c> do</c><00:00:31.619><c> this</c><00:00:31.769><c> is</c><00:00:32.040><c> to</c><00:00:32.309><c> type</c>

00:00:32.540 --> 00:00:32.550 align:start position:0%
generally the way to do this is to type
 

00:00:32.550 --> 00:00:34.459 align:start position:0%
generally the way to do this is to type
dollar<00:00:32.940><c> signs</c><00:00:33.300><c> before</c><00:00:33.750><c> the</c><00:00:33.899><c> column</c><00:00:34.260><c> letter</c>

00:00:34.459 --> 00:00:34.469 align:start position:0%
dollar signs before the column letter
 

00:00:34.469 --> 00:00:37.030 align:start position:0%
dollar signs before the column letter
and<00:00:34.739><c> row</c><00:00:35.010><c> number</c><00:00:35.040><c> but</c><00:00:35.910><c> there's</c><00:00:36.270><c> a</c><00:00:36.329><c> faster</c><00:00:36.960><c> way</c>

00:00:37.030 --> 00:00:37.040 align:start position:0%
and row number but there's a faster way
 

00:00:37.040 --> 00:00:40.430 align:start position:0%
and row number but there's a faster way
just<00:00:38.040><c> press</c><00:00:38.309><c> the</c><00:00:38.520><c> f4</c><00:00:39.149><c> key</c><00:00:39.210><c> at</c><00:00:39.629><c> the</c><00:00:39.899><c> top</c><00:00:39.930><c> of</c><00:00:40.290><c> your</c>

00:00:40.430 --> 00:00:40.440 align:start position:0%
just press the f4 key at the top of your
 

00:00:40.440 --> 00:00:42.830 align:start position:0%
just press the f4 key at the top of your
keyboard<00:00:40.879><c> this</c><00:00:41.879><c> will</c><00:00:41.940><c> automatically</c><00:00:42.600><c> add</c>

00:00:42.830 --> 00:00:42.840 align:start position:0%
keyboard this will automatically add
 

00:00:42.840 --> 00:00:44.600 align:start position:0%
keyboard this will automatically add
both<00:00:43.200><c> dollar</c><00:00:43.500><c> signs</c><00:00:43.829><c> with</c><00:00:44.190><c> a</c><00:00:44.219><c> single</c>

00:00:44.600 --> 00:00:44.610 align:start position:0%
both dollar signs with a single
 

00:00:44.610 --> 00:00:48.260 align:start position:0%
both dollar signs with a single
keystroke<00:00:45.649><c> you</c><00:00:46.649><c> can</c><00:00:46.800><c> also</c><00:00:46.920><c> press</c><00:00:47.309><c> F</c><00:00:47.520><c> for</c><00:00:47.910><c> more</c>

00:00:48.260 --> 00:00:48.270 align:start position:0%
keystroke you can also press F for more
 

00:00:48.270 --> 00:00:49.940 align:start position:0%
keystroke you can also press F for more
than<00:00:48.420><c> once</c><00:00:48.629><c> which</c><00:00:49.260><c> will</c><00:00:49.469><c> cycle</c><00:00:49.739><c> through</c>

00:00:49.940 --> 00:00:49.950 align:start position:0%
than once which will cycle through
 

00:00:49.950 --> 00:00:52.069 align:start position:0%
than once which will cycle through
different<00:00:50.550><c> types</c><00:00:50.760><c> of</c><00:00:51.000><c> cell</c><00:00:51.270><c> references</c><00:00:51.510><c> and</c>

00:00:52.069 --> 00:00:52.079 align:start position:0%
different types of cell references and
 

00:00:52.079 --> 00:00:54.709 align:start position:0%
different types of cell references and
this<00:00:52.890><c> is</c><00:00:53.039><c> useful</c><00:00:53.250><c> if</c><00:00:53.610><c> you</c><00:00:53.640><c> only</c><00:00:54.059><c> want</c><00:00:54.420><c> to</c><00:00:54.480><c> lock</c>

00:00:54.709 --> 00:00:54.719 align:start position:0%
this is useful if you only want to lock
 

00:00:54.719 --> 00:00:57.529 align:start position:0%
this is useful if you only want to lock
the<00:00:54.930><c> row</c><00:00:55.199><c> or</c><00:00:55.469><c> the</c><00:00:55.710><c> column</c><00:00:56.000><c> but</c><00:00:57.000><c> most</c><00:00:57.300><c> of</c><00:00:57.449><c> the</c>

00:00:57.529 --> 00:00:57.539 align:start position:0%
the row or the column but most of the
 

00:00:57.539 --> 00:00:59.180 align:start position:0%
the row or the column but most of the
time<00:00:57.719><c> you'll</c><00:00:57.989><c> probably</c><00:00:58.050><c> want</c><00:00:58.710><c> to</c><00:00:58.800><c> just</c><00:00:58.859><c> press</c>

00:00:59.180 --> 00:00:59.190 align:start position:0%
time you'll probably want to just press
 

00:00:59.190 --> 00:01:01.700 align:start position:0%
time you'll probably want to just press
it<00:00:59.370><c> once</c><00:00:59.670><c> to</c><00:01:00.149><c> lock</c><00:01:00.329><c> both</c><00:01:00.719><c> the</c><00:01:00.989><c> row</c><00:01:01.199><c> and</c><00:01:01.500><c> the</c>

00:01:01.700 --> 00:01:01.710 align:start position:0%
it once to lock both the row and the
 

00:01:01.710 --> 00:01:04.939 align:start position:0%
it once to lock both the row and the
column<00:01:02.359><c> now</c><00:01:03.359><c> on</c><00:01:03.600><c> some</c><00:01:03.989><c> keyboards</c><00:01:04.470><c> you</c><00:01:04.650><c> may</c>

00:01:04.939 --> 00:01:04.949 align:start position:0%
column now on some keyboards you may
 

00:01:04.949 --> 00:01:06.590 align:start position:0%
column now on some keyboards you may
have<00:01:05.129><c> to</c><00:01:05.250><c> hold</c><00:01:05.339><c> down</c><00:01:05.580><c> the</c><00:01:05.640><c> function</c><00:01:05.970><c> key</c><00:01:06.420><c> and</c>

00:01:06.590 --> 00:01:06.600 align:start position:0%
have to hold down the function key and
 

00:01:06.600 --> 00:01:09.380 align:start position:0%
have to hold down the function key and
then<00:01:06.990><c> press</c><00:01:07.260><c> f4</c><00:01:07.710><c> and</c><00:01:07.920><c> this</c><00:01:08.520><c> because</c><00:01:08.820><c> the</c><00:01:08.939><c> f4</c>

00:01:09.380 --> 00:01:09.390 align:start position:0%
then press f4 and this because the f4
 

00:01:09.390 --> 00:01:11.090 align:start position:0%
then press f4 and this because the f4
key<00:01:09.420><c> sometimes</c><00:01:10.080><c> controls</c><00:01:10.500><c> your</c><00:01:10.680><c> computer's</c>

00:01:11.090 --> 00:01:11.100 align:start position:0%
key sometimes controls your computer's
 

00:01:11.100 --> 00:01:13.990 align:start position:0%
key sometimes controls your computer's
volume<00:01:11.580><c> or</c><00:01:11.760><c> screen</c><00:01:12.270><c> brightness</c><00:01:12.510><c> by</c><00:01:12.810><c> default</c>

00:01:13.990 --> 00:01:14.000 align:start position:0%
volume or screen brightness by default
 

00:01:14.000 --> 00:01:17.060 align:start position:0%
volume or screen brightness by default
so<00:01:15.000><c> now</c><00:01:15.270><c> that</c><00:01:15.330><c> our</c><00:01:15.570><c> formula</c><00:01:15.840><c> is</c><00:01:16.020><c> done</c><00:01:16.350><c> we</c><00:01:16.860><c> can</c>

00:01:17.060 --> 00:01:17.070 align:start position:0%
so now that our formula is done we can
 

00:01:17.070 --> 00:01:18.649 align:start position:0%
so now that our formula is done we can
double<00:01:17.490><c> click</c><00:01:17.520><c> the</c><00:01:17.850><c> fill</c><00:01:18.090><c> handle</c><00:01:18.270><c> to</c><00:01:18.509><c> copy</c>

00:01:18.649 --> 00:01:18.659 align:start position:0%
double click the fill handle to copy
 

00:01:18.659 --> 00:01:22.219 align:start position:0%
double click the fill handle to copy
this<00:01:19.110><c> formula</c><00:01:19.380><c> to</c><00:01:19.619><c> the</c><00:01:19.830><c> empty</c><00:01:20.220><c> cells</c><00:01:20.520><c> and</c><00:01:21.229><c> if</c>

00:01:22.219 --> 00:01:22.229 align:start position:0%
this formula to the empty cells and if
 

00:01:22.229 --> 00:01:23.899 align:start position:0%
this formula to the empty cells and if
you<00:01:22.320><c> look</c><00:01:22.500><c> in</c><00:01:22.619><c> the</c><00:01:22.710><c> formula</c><00:01:23.189><c> bar</c><00:01:23.369><c> you</c><00:01:23.729><c> can</c><00:01:23.850><c> see</c>

00:01:23.899 --> 00:01:23.909 align:start position:0%
you look in the formula bar you can see
 

00:01:23.909 --> 00:01:26.600 align:start position:0%
you look in the formula bar you can see
that<00:01:24.150><c> the</c><00:01:24.479><c> d2</c><00:01:24.990><c> reference</c><00:01:25.470><c> stays</c><00:01:25.860><c> the</c><00:01:26.100><c> same</c><00:01:26.130><c> in</c>

00:01:26.600 --> 00:01:26.610 align:start position:0%
that the d2 reference stays the same in
 

00:01:26.610 --> 00:01:28.789 align:start position:0%
that the d2 reference stays the same in
all<00:01:26.939><c> of</c><00:01:26.970><c> the</c><00:01:27.270><c> copied</c><00:01:27.600><c> formulas</c><00:01:28.140><c> which</c><00:01:28.590><c> is</c>

00:01:28.789 --> 00:01:28.799 align:start position:0%
all of the copied formulas which is
 

00:01:28.799 --> 00:01:33.870 align:start position:0%
all of the copied formulas which is
exactly<00:01:29.369><c> what</c><00:01:29.700><c> we</c><00:01:29.790><c> want</c>

00:01:33.870 --> 00:01:33.880 align:start position:0%
 
 

00:01:33.880 --> 00:01:36.240 align:start position:0%
 
Goodwill<00:01:34.659><c> Community</c><00:01:35.110><c> Foundation</c><00:01:35.770><c> creating</c>

00:01:36.240 --> 00:01:36.250 align:start position:0%
Goodwill Community Foundation creating
 

00:01:36.250 --> 00:01:39.479 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:01:36.820><c> for</c><00:01:36.850><c> a</c><00:01:37.119><c> better</c><00:01:37.270><c> life</c>