WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.550><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.110 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.629><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.110 --> 00:00:10.120 align:start position:0%
 
 

00:00:10.120 --> 00:00:12.249 align:start position:0%
 
remember<00:00:11.120><c> using</c><00:00:11.299><c> formulas</c><00:00:11.990><c> to</c><00:00:12.139><c> calculate</c>

00:00:12.249 --> 00:00:12.259 align:start position:0%
remember using formulas to calculate
 

00:00:12.259 --> 00:00:14.890 align:start position:0%
remember using formulas to calculate
math<00:00:12.799><c> problems</c><00:00:13.309><c> in</c><00:00:13.490><c> school</c><00:00:13.789><c> like</c><00:00:14.330><c> two</c><00:00:14.660><c> plus</c>

00:00:14.890 --> 00:00:14.900 align:start position:0%
math problems in school like two plus
 

00:00:14.900 --> 00:00:17.620 align:start position:0%
math problems in school like two plus
two<00:00:15.109><c> equals</c><00:00:15.500><c> four</c><00:00:15.559><c> or</c><00:00:15.980><c> two</c><00:00:16.670><c> pizzas</c><00:00:16.939><c> times</c><00:00:17.360><c> ten</c>

00:00:17.620 --> 00:00:17.630 align:start position:0%
two equals four or two pizzas times ten
 

00:00:17.630 --> 00:00:20.499 align:start position:0%
two equals four or two pizzas times ten
dollars<00:00:17.930><c> equals</c><00:00:18.140><c> twenty</c><00:00:18.710><c> dollars</c><00:00:19.300><c> Excel</c><00:00:20.300><c> can</c>

00:00:20.499 --> 00:00:20.509 align:start position:0%
dollars equals twenty dollars Excel can
 

00:00:20.509 --> 00:00:22.029 align:start position:0%
dollars equals twenty dollars Excel can
use<00:00:20.660><c> these</c><00:00:20.869><c> same</c><00:00:21.140><c> formulas</c><00:00:21.710><c> to</c><00:00:21.860><c> work</c><00:00:21.890><c> with</c>

00:00:22.029 --> 00:00:22.039 align:start position:0%
use these same formulas to work with
 

00:00:22.039 --> 00:00:23.859 align:start position:0%
use these same formulas to work with
numerical<00:00:22.189><c> data</c><00:00:22.880><c> in</c><00:00:22.970><c> your</c><00:00:23.180><c> spreadsheets</c><00:00:23.689><c> just</c>

00:00:23.859 --> 00:00:23.869 align:start position:0%
numerical data in your spreadsheets just
 

00:00:23.869 --> 00:00:27.099 align:start position:0%
numerical data in your spreadsheets just
like<00:00:24.169><c> a</c><00:00:24.199><c> calculator</c><00:00:25.359><c> Excel</c><00:00:26.359><c> uses</c><00:00:26.720><c> standard</c>

00:00:27.099 --> 00:00:27.109 align:start position:0%
like a calculator Excel uses standard
 

00:00:27.109 --> 00:00:29.200 align:start position:0%
like a calculator Excel uses standard
operators<00:00:27.500><c> for</c><00:00:27.800><c> its</c><00:00:27.890><c> math</c><00:00:28.070><c> equations</c><00:00:28.580><c> like</c><00:00:29.150><c> a</c>

00:00:29.200 --> 00:00:29.210 align:start position:0%
operators for its math equations like a
 

00:00:29.210 --> 00:00:31.779 align:start position:0%
operators for its math equations like a
plus<00:00:29.599><c> sign</c><00:00:29.869><c> for</c><00:00:30.080><c> addition</c><00:00:30.140><c> a</c><00:00:30.619><c> minus</c><00:00:31.400><c> sign</c><00:00:31.609><c> for</c>

00:00:31.779 --> 00:00:31.789 align:start position:0%
plus sign for addition a minus sign for
 

00:00:31.789 --> 00:00:33.759 align:start position:0%
plus sign for addition a minus sign for
subtraction<00:00:31.970><c> an</c><00:00:32.599><c> asterisk</c><00:00:33.589><c> for</c>

00:00:33.759 --> 00:00:33.769 align:start position:0%
subtraction an asterisk for
 

00:00:33.769 --> 00:00:36.040 align:start position:0%
subtraction an asterisk for
multiplication<00:00:33.830><c> a</c><00:00:34.550><c> forward</c><00:00:35.480><c> slash</c><00:00:35.660><c> for</c>

00:00:36.040 --> 00:00:36.050 align:start position:0%
multiplication a forward slash for
 

00:00:36.050 --> 00:00:38.819 align:start position:0%
multiplication a forward slash for
division<00:00:36.079><c> and</c><00:00:36.650><c> a</c><00:00:37.400><c> carrot</c><00:00:37.790><c> for</c><00:00:37.820><c> exponents</c>

00:00:38.819 --> 00:00:38.829 align:start position:0%
division and a carrot for exponents
 

00:00:38.829 --> 00:00:41.290 align:start position:0%
division and a carrot for exponents
you're<00:00:39.829><c> probably</c><00:00:40.070><c> used</c><00:00:40.460><c> to</c><00:00:40.550><c> seeing</c><00:00:40.640><c> equations</c>

00:00:41.290 --> 00:00:41.300 align:start position:0%
you're probably used to seeing equations
 

00:00:41.300 --> 00:00:44.260 align:start position:0%
you're probably used to seeing equations
like<00:00:41.510><c> five</c><00:00:41.870><c> plus</c><00:00:42.230><c> five</c><00:00:42.500><c> equals</c><00:00:42.770><c> but</c><00:00:43.699><c> in</c><00:00:43.879><c> excel</c>

00:00:44.260 --> 00:00:44.270 align:start position:0%
like five plus five equals but in excel
 

00:00:44.270 --> 00:00:46.810 align:start position:0%
like five plus five equals but in excel
the<00:00:44.510><c> equal</c><00:00:44.840><c> sign</c><00:00:45.079><c> comes</c><00:00:45.410><c> first</c><00:00:45.770><c> this</c><00:00:46.670><c> is</c>

00:00:46.810 --> 00:00:46.820 align:start position:0%
the equal sign comes first this is
 

00:00:46.820 --> 00:00:49.209 align:start position:0%
the equal sign comes first this is
because<00:00:47.149><c> the</c><00:00:47.359><c> cell</c><00:00:47.570><c> itself</c><00:00:47.989><c> contains</c><00:00:48.590><c> or</c><00:00:48.890><c> is</c>

00:00:49.209 --> 00:00:49.219 align:start position:0%
because the cell itself contains or is
 

00:00:49.219 --> 00:00:53.680 align:start position:0%
because the cell itself contains or is
equal<00:00:49.609><c> to</c><00:00:49.820><c> the</c><00:00:50.149><c> formula</c><00:00:50.449><c> and</c><00:00:50.809><c> its</c><00:00:50.930><c> value</c><00:00:52.690><c> let's</c>

00:00:53.680 --> 00:00:53.690 align:start position:0%
equal to the formula and its value let's
 

00:00:53.690 --> 00:00:55.450 align:start position:0%
equal to the formula and its value let's
create<00:00:53.960><c> a</c><00:00:54.050><c> simple</c><00:00:54.350><c> formula</c><00:00:54.920><c> to</c><00:00:54.949><c> add</c><00:00:55.190><c> up</c><00:00:55.340><c> the</c>

00:00:55.450 --> 00:00:55.460 align:start position:0%
create a simple formula to add up the
 

00:00:55.460 --> 00:00:57.939 align:start position:0%
create a simple formula to add up the
budgets<00:00:55.789><c> for</c><00:00:55.940><c> June</c><00:00:56.210><c> and</c><00:00:56.480><c> July</c><00:00:56.620><c> I've</c><00:00:57.620><c> already</c>

00:00:57.939 --> 00:00:57.949 align:start position:0%
budgets for June and July I've already
 

00:00:57.949 --> 00:00:59.950 align:start position:0%
budgets for June and July I've already
typed<00:00:58.100><c> in</c><00:00:58.309><c> those</c><00:00:58.460><c> values</c><00:00:58.760><c> and</c><00:00:59.120><c> the</c><00:00:59.570><c> total</c><00:00:59.899><c> is</c>

00:00:59.950 --> 00:00:59.960 align:start position:0%
typed in those values and the total is
 

00:00:59.960 --> 00:01:04.270 align:start position:0%
typed in those values and the total is
going<00:01:00.050><c> to</c><00:01:00.260><c> be</c><00:01:00.379><c> $1200</c><00:01:01.309><c> plus</c><00:01:02.140><c> $1500</c><00:01:03.140><c> but</c><00:01:03.920><c> instead</c>

00:01:04.270 --> 00:01:04.280 align:start position:0%
going to be $1200 plus $1500 but instead
 

00:01:04.280 --> 00:01:05.950 align:start position:0%
going to be $1200 plus $1500 but instead
of<00:01:04.429><c> typing</c><00:01:04.820><c> in</c><00:01:04.910><c> those</c><00:01:05.089><c> numbers</c><00:01:05.300><c> we're</c><00:01:05.780><c> going</c>

00:01:05.950 --> 00:01:05.960 align:start position:0%
of typing in those numbers we're going
 

00:01:05.960 --> 00:01:09.070 align:start position:0%
of typing in those numbers we're going
to<00:01:06.080><c> use</c><00:01:06.259><c> cell</c><00:01:06.619><c> references</c><00:01:07.690><c> start</c><00:01:08.690><c> by</c><00:01:08.840><c> clicking</c>

00:01:09.070 --> 00:01:09.080 align:start position:0%
to use cell references start by clicking
 

00:01:09.080 --> 00:01:10.600 align:start position:0%
to use cell references start by clicking
on<00:01:09.289><c> the</c><00:01:09.440><c> cell</c><00:01:09.649><c> where</c><00:01:09.800><c> you</c><00:01:09.920><c> want</c><00:01:10.100><c> the</c><00:01:10.220><c> total</c><00:01:10.490><c> to</c>

00:01:10.600 --> 00:01:10.610 align:start position:0%
on the cell where you want the total to
 

00:01:10.610 --> 00:01:13.120 align:start position:0%
on the cell where you want the total to
appear<00:01:10.970><c> and</c><00:01:11.090><c> then</c><00:01:11.840><c> type</c><00:01:12.110><c> an</c><00:01:12.259><c> equal</c><00:01:12.590><c> sign</c><00:01:12.619><c> which</c>

00:01:13.120 --> 00:01:13.130 align:start position:0%
appear and then type an equal sign which
 

00:01:13.130 --> 00:01:14.760 align:start position:0%
appear and then type an equal sign which
is<00:01:13.280><c> how</c><00:01:13.399><c> you'll</c><00:01:13.550><c> always</c><00:01:13.789><c> start</c><00:01:14.119><c> a</c><00:01:14.240><c> formula</c>

00:01:14.760 --> 00:01:14.770 align:start position:0%
is how you'll always start a formula
 

00:01:14.770 --> 00:01:17.410 align:start position:0%
is how you'll always start a formula
then<00:01:15.770><c> type</c><00:01:16.099><c> the</c><00:01:16.280><c> address</c><00:01:16.369><c> of</c><00:01:16.819><c> the</c><00:01:16.940><c> first</c><00:01:17.119><c> cell</c>

00:01:17.410 --> 00:01:17.420 align:start position:0%
then type the address of the first cell
 

00:01:17.420 --> 00:01:20.740 align:start position:0%
then type the address of the first cell
you<00:01:17.539><c> want</c><00:01:17.660><c> to</c><00:01:17.750><c> add</c><00:01:17.959><c> which</c><00:01:18.349><c> is</c><00:01:18.380><c> b2</c><00:01:19.539><c> plus</c><00:01:20.539><c> the</c>

00:01:20.740 --> 00:01:20.750 align:start position:0%
you want to add which is b2 plus the
 

00:01:20.750 --> 00:01:24.370 align:start position:0%
you want to add which is b2 plus the
second<00:01:21.170><c> cell</c><00:01:21.380><c> b3</c><00:01:22.810><c> when</c><00:01:23.810><c> you're</c><00:01:23.929><c> done</c><00:01:24.080><c> press</c>

00:01:24.370 --> 00:01:24.380 align:start position:0%
second cell b3 when you're done press
 

00:01:24.380 --> 00:01:26.380 align:start position:0%
second cell b3 when you're done press
ENTER<00:01:24.890><c> on</c><00:01:24.920><c> your</c><00:01:25.099><c> keyboard</c><00:01:25.250><c> and</c><00:01:25.759><c> Excel</c>

00:01:26.380 --> 00:01:26.390 align:start position:0%
ENTER on your keyboard and Excel
 

00:01:26.390 --> 00:01:29.440 align:start position:0%
ENTER on your keyboard and Excel
displays<00:01:26.539><c> the</c><00:01:26.989><c> value</c><00:01:27.319><c> in</c><00:01:27.500><c> the</c><00:01:27.619><c> cell</c><00:01:28.390><c> now</c><00:01:29.390><c> you</c>

00:01:29.440 --> 00:01:29.450 align:start position:0%
displays the value in the cell now you
 

00:01:29.450 --> 00:01:31.240 align:start position:0%
displays the value in the cell now you
may<00:01:29.630><c> be</c><00:01:29.660><c> wondering</c><00:01:29.780><c> why</c><00:01:30.410><c> we</c><00:01:30.590><c> used</c><00:01:30.830><c> cell</c>

00:01:31.240 --> 00:01:31.250 align:start position:0%
may be wondering why we used cell
 

00:01:31.250 --> 00:01:33.999 align:start position:0%
may be wondering why we used cell
references<00:01:31.880><c> instead</c><00:01:32.360><c> of</c><00:01:32.450><c> numbers</c><00:01:32.830><c> the</c><00:01:33.830><c> main</c>

00:01:33.999 --> 00:01:34.009 align:start position:0%
references instead of numbers the main
 

00:01:34.009 --> 00:01:35.770 align:start position:0%
references instead of numbers the main
reason<00:01:34.399><c> is</c><00:01:34.550><c> that</c><00:01:34.610><c> if</c><00:01:34.910><c> you</c><00:01:35.000><c> ever</c><00:01:35.179><c> change</c><00:01:35.509><c> the</c>

00:01:35.770 --> 00:01:35.780 align:start position:0%
reason is that if you ever change the
 

00:01:35.780 --> 00:01:37.870 align:start position:0%
reason is that if you ever change the
values<00:01:36.170><c> in</c><00:01:36.349><c> these</c><00:01:36.440><c> cells</c><00:01:36.830><c> you</c><00:01:37.069><c> won't</c><00:01:37.580><c> have</c><00:01:37.729><c> to</c>

00:01:37.870 --> 00:01:37.880 align:start position:0%
values in these cells you won't have to
 

00:01:37.880 --> 00:01:39.699 align:start position:0%
values in these cells you won't have to
retype<00:01:38.209><c> the</c><00:01:38.270><c> formula</c><00:01:38.840><c> Excel</c><00:01:39.530><c> will</c>

00:01:39.699 --> 00:01:39.709 align:start position:0%
retype the formula Excel will
 

00:01:39.709 --> 00:01:41.800 align:start position:0%
retype the formula Excel will
automatically<00:01:40.250><c> recalculate</c><00:01:41.119><c> the</c><00:01:41.270><c> answer</c><00:01:41.569><c> so</c>

00:01:41.800 --> 00:01:41.810 align:start position:0%
automatically recalculate the answer so
 

00:01:41.810 --> 00:01:44.290 align:start position:0%
automatically recalculate the answer so
it<00:01:41.929><c> stays</c><00:01:42.140><c> up</c><00:01:42.319><c> to</c><00:01:42.349><c> date</c><00:01:42.640><c> you</c><00:01:43.640><c> should</c><00:01:43.849><c> generally</c>

00:01:44.290 --> 00:01:44.300 align:start position:0%
it stays up to date you should generally
 

00:01:44.300 --> 00:01:46.059 align:start position:0%
it stays up to date you should generally
use<00:01:44.509><c> cell</c><00:01:44.810><c> references</c><00:01:45.349><c> and</c><00:01:45.530><c> your</c><00:01:45.619><c> formulas</c>

00:01:46.059 --> 00:01:46.069 align:start position:0%
use cell references and your formulas
 

00:01:46.069 --> 00:01:49.300 align:start position:0%
use cell references and your formulas
whenever<00:01:46.489><c> you</c><00:01:46.640><c> can</c><00:01:47.470><c> to</c><00:01:48.470><c> edit</c><00:01:48.649><c> your</c><00:01:48.770><c> formula</c>

00:01:49.300 --> 00:01:49.310 align:start position:0%
whenever you can to edit your formula
 

00:01:49.310 --> 00:01:51.840 align:start position:0%
whenever you can to edit your formula
you<00:01:49.489><c> can</c><00:01:49.670><c> double</c><00:01:50.000><c> click</c><00:01:50.030><c> the</c><00:01:50.390><c> cell</c>

00:01:51.840 --> 00:01:51.850 align:start position:0%
you can double click the cell
 

00:01:51.850 --> 00:01:53.910 align:start position:0%
you can double click the cell
if<00:01:51.909><c> you</c><00:01:52.659><c> make</c><00:01:52.840><c> a</c><00:01:52.869><c> mistake</c><00:01:53.049><c> or</c><00:01:53.500><c> change</c><00:01:53.799><c> your</c>

00:01:53.910 --> 00:01:53.920 align:start position:0%
if you make a mistake or change your
 

00:01:53.920 --> 00:01:55.469 align:start position:0%
if you make a mistake or change your
mind<00:01:54.159><c> you</c><00:01:54.400><c> can</c><00:01:54.610><c> press</c><00:01:54.820><c> escape</c><00:01:55.270><c> on</c><00:01:55.420><c> your</c>

00:01:55.469 --> 00:01:55.479 align:start position:0%
mind you can press escape on your
 

00:01:55.479 --> 00:01:57.210 align:start position:0%
mind you can press escape on your
keyboard<00:01:55.600><c> and</c><00:01:56.049><c> it</c><00:01:56.439><c> will</c><00:01:56.470><c> go</c><00:01:56.710><c> back</c><00:01:56.890><c> to</c><00:01:57.040><c> the</c><00:01:57.130><c> way</c>

00:01:57.210 --> 00:01:57.220 align:start position:0%
keyboard and it will go back to the way
 

00:01:57.220 --> 00:02:00.870 align:start position:0%
keyboard and it will go back to the way
it<00:01:57.250><c> was</c><00:01:58.619><c> let's</c><00:01:59.619><c> try</c><00:01:59.830><c> another</c><00:02:00.070><c> example</c><00:02:00.670><c> this</c>

00:02:00.870 --> 00:02:00.880 align:start position:0%
it was let's try another example this
 

00:02:00.880 --> 00:02:03.420 align:start position:0%
it was let's try another example this
time<00:02:00.940><c> with</c><00:02:01.390><c> multiplication</c><00:02:01.840><c> I</c><00:02:02.440><c> want</c><00:02:03.340><c> to</c>

00:02:03.420 --> 00:02:03.430 align:start position:0%
time with multiplication I want to
 

00:02:03.430 --> 00:02:04.889 align:start position:0%
time with multiplication I want to
calculate<00:02:03.610><c> the</c><00:02:03.909><c> total</c><00:02:04.330><c> price</c><00:02:04.570><c> for</c><00:02:04.840><c> the</c>

00:02:04.889 --> 00:02:04.899 align:start position:0%
calculate the total price for the
 

00:02:04.899 --> 00:02:07.410 align:start position:0%
calculate the total price for the
plastic<00:02:05.140><c> silverware</c><00:02:05.850><c> so</c><00:02:06.850><c> I'll</c><00:02:07.119><c> need</c><00:02:07.270><c> to</c>

00:02:07.410 --> 00:02:07.420 align:start position:0%
plastic silverware so I'll need to
 

00:02:07.420 --> 00:02:11.910 align:start position:0%
plastic silverware so I'll need to
multiply<00:02:07.509><c> cell</c><00:02:08.200><c> e4</c><00:02:08.890><c> by</c><00:02:09.489><c> f4</c><00:02:10.350><c> the</c><00:02:11.350><c> formula</c><00:02:11.800><c> is</c>

00:02:11.910 --> 00:02:11.920 align:start position:0%
multiply cell e4 by f4 the formula is
 

00:02:11.920 --> 00:02:14.550 align:start position:0%
multiply cell e4 by f4 the formula is
going<00:02:12.250><c> in</c><00:02:12.370><c> cell</c><00:02:12.610><c> g4</c><00:02:13.239><c> so</c><00:02:13.690><c> I'll</c><00:02:13.810><c> click</c><00:02:14.080><c> there</c><00:02:14.319><c> and</c>

00:02:14.550 --> 00:02:14.560 align:start position:0%
going in cell g4 so I'll click there and
 

00:02:14.560 --> 00:02:17.580 align:start position:0%
going in cell g4 so I'll click there and
type<00:02:14.680><c> an</c><00:02:14.830><c> equal</c><00:02:15.100><c> sign</c><00:02:15.870><c> this</c><00:02:16.870><c> time</c><00:02:17.110><c> instead</c><00:02:17.440><c> of</c>

00:02:17.580 --> 00:02:17.590 align:start position:0%
type an equal sign this time instead of
 

00:02:17.590 --> 00:02:19.470 align:start position:0%
type an equal sign this time instead of
typing<00:02:17.920><c> the</c><00:02:18.130><c> cell</c><00:02:18.370><c> references</c><00:02:18.880><c> I'm</c><00:02:19.060><c> going</c><00:02:19.420><c> to</c>

00:02:19.470 --> 00:02:19.480 align:start position:0%
typing the cell references I'm going to
 

00:02:19.480 --> 00:02:20.970 align:start position:0%
typing the cell references I'm going to
use<00:02:19.660><c> something</c><00:02:19.959><c> called</c><00:02:20.110><c> the</c><00:02:20.380><c> point</c><00:02:20.739><c> and</c><00:02:20.920><c> click</c>

00:02:20.970 --> 00:02:20.980 align:start position:0%
use something called the point and click
 

00:02:20.980 --> 00:02:23.490 align:start position:0%
use something called the point and click
method<00:02:21.390><c> you</c><00:02:22.390><c> may</c><00:02:22.510><c> find</c><00:02:22.750><c> that</c><00:02:22.840><c> this</c><00:02:22.959><c> is</c><00:02:23.140><c> easier</c>

00:02:23.490 --> 00:02:23.500 align:start position:0%
method you may find that this is easier
 

00:02:23.500 --> 00:02:26.729 align:start position:0%
method you may find that this is easier
than<00:02:23.590><c> typing</c><00:02:24.100><c> them</c><00:02:24.900><c> press</c><00:02:25.900><c> the</c><00:02:26.080><c> Enter</c><00:02:26.350><c> key</c><00:02:26.380><c> and</c>

00:02:26.729 --> 00:02:26.739 align:start position:0%
than typing them press the Enter key and
 

00:02:26.739 --> 00:02:30.479 align:start position:0%
than typing them press the Enter key and
it<00:02:27.430><c> calculates</c><00:02:27.640><c> the</c><00:02:28.120><c> answer</c><00:02:29.190><c> finally</c><00:02:30.190><c> I</c><00:02:30.220><c> want</c>

00:02:30.479 --> 00:02:30.489 align:start position:0%
it calculates the answer finally I want
 

00:02:30.489 --> 00:02:32.040 align:start position:0%
it calculates the answer finally I want
to<00:02:30.550><c> show</c><00:02:30.670><c> you</c><00:02:30.730><c> a</c><00:02:30.819><c> quick</c><00:02:31.180><c> way</c><00:02:31.209><c> to</c><00:02:31.390><c> add</c><00:02:31.630><c> a</c><00:02:31.660><c> formula</c>

00:02:32.040 --> 00:02:32.050 align:start position:0%
to show you a quick way to add a formula
 

00:02:32.050 --> 00:02:34.800 align:start position:0%
to show you a quick way to add a formula
to<00:02:32.200><c> several</c><00:02:32.739><c> cells</c><00:02:32.980><c> at</c><00:02:33.190><c> once</c><00:02:33.690><c> instead</c><00:02:34.690><c> of</c>

00:02:34.800 --> 00:02:34.810 align:start position:0%
to several cells at once instead of
 

00:02:34.810 --> 00:02:36.630 align:start position:0%
to several cells at once instead of
typing<00:02:34.989><c> formulas</c><00:02:35.620><c> for</c><00:02:35.830><c> each</c><00:02:35.980><c> of</c><00:02:36.160><c> these</c><00:02:36.280><c> three</c>

00:02:36.630 --> 00:02:36.640 align:start position:0%
typing formulas for each of these three
 

00:02:36.640 --> 00:02:38.790 align:start position:0%
typing formulas for each of these three
cells<00:02:36.940><c> you</c><00:02:37.540><c> can</c><00:02:37.690><c> select</c><00:02:37.930><c> the</c><00:02:38.260><c> first</c><00:02:38.470><c> one</c><00:02:38.650><c> and</c>

00:02:38.790 --> 00:02:38.800 align:start position:0%
cells you can select the first one and
 

00:02:38.800 --> 00:02:41.370 align:start position:0%
cells you can select the first one and
then<00:02:39.670><c> locate</c><00:02:40.030><c> the</c><00:02:40.239><c> fill</c><00:02:40.480><c> handle</c><00:02:40.720><c> in</c><00:02:41.080><c> the</c><00:02:41.170><c> lower</c>

00:02:41.370 --> 00:02:41.380 align:start position:0%
then locate the fill handle in the lower
 

00:02:41.380 --> 00:02:43.690 align:start position:0%
then locate the fill handle in the lower
right<00:02:41.650><c> corner</c><00:02:41.680><c> of</c><00:02:42.069><c> the</c><00:02:42.190><c> cell</c>

00:02:43.690 --> 00:02:43.700 align:start position:0%
right corner of the cell
 

00:02:43.700 --> 00:02:46.260 align:start position:0%
right corner of the cell
click<00:02:44.569><c> and</c><00:02:44.750><c> drag</c><00:02:44.990><c> the</c><00:02:45.140><c> fill</c><00:02:45.349><c> handle</c><00:02:45.380><c> down</c><00:02:45.890><c> and</c>

00:02:46.260 --> 00:02:46.270 align:start position:0%
click and drag the fill handle down and
 

00:02:46.270 --> 00:02:48.370 align:start position:0%
click and drag the fill handle down and
when<00:02:47.270><c> you</c><00:02:47.360><c> release</c><00:02:47.660><c> the</c><00:02:47.690><c> mouse</c><00:02:47.989><c> it</c><00:02:48.260><c> will</c>

00:02:48.370 --> 00:02:48.380 align:start position:0%
when you release the mouse it will
 

00:02:48.380 --> 00:02:50.080 align:start position:0%
when you release the mouse it will
automatically<00:02:48.920><c> enter</c><00:02:49.280><c> the</c><00:02:49.400><c> formula</c><00:02:49.670><c> into</c>

00:02:50.080 --> 00:02:50.090 align:start position:0%
automatically enter the formula into
 

00:02:50.090 --> 00:02:52.390 align:start position:0%
automatically enter the formula into
these<00:02:50.239><c> cells</c><00:02:50.569><c> now</c><00:02:50.840><c> we</c><00:02:51.530><c> can</c><00:02:51.800><c> see</c><00:02:51.950><c> the</c><00:02:52.069><c> total</c>

00:02:52.390 --> 00:02:52.400 align:start position:0%
these cells now we can see the total
 

00:02:52.400 --> 00:02:55.120 align:start position:0%
these cells now we can see the total
cost<00:02:52.640><c> for</c><00:02:52.940><c> each</c><00:02:52.970><c> item</c><00:02:53.560><c> this</c><00:02:54.560><c> is</c><00:02:54.620><c> a</c><00:02:54.770><c> great</c>

00:02:55.120 --> 00:02:55.130 align:start position:0%
cost for each item this is a great
 

00:02:55.130 --> 00:02:56.470 align:start position:0%
cost for each item this is a great
shortcut<00:02:55.459><c> to</c><00:02:55.700><c> use</c><00:02:55.880><c> when</c><00:02:56.090><c> you</c><00:02:56.180><c> want</c><00:02:56.209><c> to</c><00:02:56.390><c> have</c>

00:02:56.470 --> 00:02:56.480 align:start position:0%
shortcut to use when you want to have
 

00:02:56.480 --> 00:02:59.770 align:start position:0%
shortcut to use when you want to have
similar<00:02:56.900><c> formulas</c><00:02:57.380><c> on</c><00:02:57.530><c> each</c><00:02:57.709><c> row</c><00:02:58.630><c> once</c><00:02:59.630><c> you're</c>

00:02:59.770 --> 00:02:59.780 align:start position:0%
similar formulas on each row once you're
 

00:02:59.780 --> 00:03:01.510 align:start position:0%
similar formulas on each row once you're
comfortable<00:02:59.959><c> creating</c><00:03:00.440><c> formulas</c><00:03:01.100><c> you'll</c><00:03:01.310><c> use</c>

00:03:01.510 --> 00:03:01.520 align:start position:0%
comfortable creating formulas you'll use
 

00:03:01.520 --> 00:03:03.460 align:start position:0%
comfortable creating formulas you'll use
them<00:03:01.730><c> all</c><00:03:02.000><c> the</c><00:03:02.030><c> time</c><00:03:02.180><c> because</c><00:03:02.930><c> they</c><00:03:03.200><c> really</c>

00:03:03.460 --> 00:03:03.470 align:start position:0%
them all the time because they really
 

00:03:03.470 --> 00:03:04.960 align:start position:0%
them all the time because they really
are<00:03:03.500><c> one</c><00:03:03.890><c> of</c><00:03:04.010><c> the</c><00:03:04.100><c> most</c><00:03:04.220><c> powerful</c><00:03:04.760><c> and</c>

00:03:04.960 --> 00:03:04.970 align:start position:0%
are one of the most powerful and
 

00:03:04.970 --> 00:03:08.709 align:start position:0%
are one of the most powerful and
convenient<00:03:05.750><c> features</c><00:03:06.080><c> of</c><00:03:06.319><c> Excel</c>