WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:09.579 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:08.589><c> remember</c>

00:00:09.579 --> 00:00:09.589 align:start position:0%
opportunities for a better life remember
 

00:00:09.589 --> 00:00:11.199 align:start position:0%
opportunities for a better life remember
using<00:00:09.769><c> formulas</c><00:00:10.400><c> to</c><00:00:10.549><c> calculate</c><00:00:10.700><c> math</c>

00:00:11.199 --> 00:00:11.209 align:start position:0%
using formulas to calculate math
 

00:00:11.209 --> 00:00:13.539 align:start position:0%
using formulas to calculate math
problems<00:00:11.719><c> in</c><00:00:11.900><c> school</c><00:00:12.169><c> like</c><00:00:12.799><c> two</c><00:00:13.039><c> plus</c><00:00:13.309><c> two</c>

00:00:13.539 --> 00:00:13.549 align:start position:0%
problems in school like two plus two
 

00:00:13.549 --> 00:00:16.090 align:start position:0%
problems in school like two plus two
equals<00:00:13.940><c> four</c><00:00:14.179><c> or</c><00:00:14.419><c> two</c><00:00:15.079><c> pizzas</c><00:00:15.499><c> times</c><00:00:15.829><c> ten</c>

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

00:00:16.100 --> 00:00:18.550 align:start position:0%
equals four or two pizzas times ten
dollars<00:00:16.429><c> equals</c><00:00:16.609><c> twenty</c><00:00:17.060><c> dollars</c><00:00:17.380><c> you</c><00:00:18.380><c> can</c>

00:00:18.550 --> 00:00:18.560 align:start position:0%
dollars equals twenty dollars you can
 

00:00:18.560 --> 00:00:20.109 align:start position:0%
dollars equals twenty dollars you can
use<00:00:18.740><c> these</c><00:00:18.920><c> same</c><00:00:19.189><c> formulas</c><00:00:19.759><c> to</c><00:00:19.939><c> work</c><00:00:19.970><c> with</c>

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

00:00:20.119 --> 00:00:22.089 align:start position:0%
use these same formulas to work with
numerical<00:00:20.300><c> data</c><00:00:20.840><c> in</c><00:00:21.230><c> your</c><00:00:21.349><c> spreadsheets</c><00:00:21.890><c> just</c>

00:00:22.089 --> 00:00:22.099 align:start position:0%
numerical data in your spreadsheets just
 

00:00:22.099 --> 00:00:26.650 align:start position:0%
numerical data in your spreadsheets just
like<00:00:22.730><c> you</c><00:00:22.849><c> would</c><00:00:22.970><c> use</c><00:00:23.089><c> a</c><00:00:23.150><c> calculator</c><00:00:25.660><c> Excel</c>

00:00:26.650 --> 00:00:26.660 align:start position:0%
like you would use a calculator Excel
 

00:00:26.660 --> 00:00:28.390 align:start position:0%
like you would use a calculator Excel
uses<00:00:27.080><c> standard</c><00:00:27.320><c> operators</c><00:00:28.039><c> for</c><00:00:28.250><c> math</c>

00:00:28.390 --> 00:00:28.400 align:start position:0%
uses standard operators for math
 

00:00:28.400 --> 00:00:30.519 align:start position:0%
uses standard operators for math
equations<00:00:28.939><c> like</c><00:00:29.599><c> a</c><00:00:29.660><c> plus</c><00:00:29.960><c> sign</c><00:00:30.230><c> for</c><00:00:30.439><c> addition</c>

00:00:30.519 --> 00:00:30.529 align:start position:0%
equations like a plus sign for addition
 

00:00:30.529 --> 00:00:34.360 align:start position:0%
equations like a plus sign for addition
a<00:00:31.009><c> minus</c><00:00:31.910><c> sign</c><00:00:32.119><c> for</c><00:00:32.300><c> subtraction</c><00:00:32.480><c> an</c><00:00:33.370><c> asterisk</c>

00:00:34.360 --> 00:00:34.370 align:start position:0%
a minus sign for subtraction an asterisk
 

00:00:34.370 --> 00:00:37.060 align:start position:0%
a minus sign for subtraction an asterisk
for<00:00:34.610><c> multiplication</c><00:00:34.670><c> a</c><00:00:35.559><c> forward</c><00:00:36.559><c> slash</c><00:00:36.680><c> for</c>

00:00:37.060 --> 00:00:37.070 align:start position:0%
for multiplication a forward slash for
 

00:00:37.070 --> 00:00:40.110 align:start position:0%
for multiplication a forward slash for
division<00:00:37.100><c> and</c><00:00:37.640><c> a</c><00:00:38.480><c> carrot</c><00:00:38.870><c> for</c><00:00:39.110><c> exponents</c>

00:00:40.110 --> 00:00:40.120 align:start position:0%
division and a carrot for exponents
 

00:00:40.120 --> 00:00:42.700 align:start position:0%
division and a carrot for exponents
you're<00:00:41.120><c> probably</c><00:00:41.360><c> used</c><00:00:41.780><c> to</c><00:00:41.870><c> seeing</c><00:00:42.140><c> equations</c>

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

00:00:42.710 --> 00:00:45.580 align:start position:0%
you're probably used to seeing equations
like<00:00:42.920><c> five</c><00:00:43.309><c> plus</c><00:00:43.640><c> five</c><00:00:43.879><c> equals</c><00:00:44.149><c> but</c><00:00:44.989><c> in</c><00:00:45.170><c> excel</c>

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

00:00:45.590 --> 00:00:48.130 align:start position:0%
like five plus five equals but in excel
the<00:00:45.949><c> equal</c><00:00:46.309><c> sign</c><00:00:46.550><c> comes</c><00:00:46.910><c> first</c><00:00:47.180><c> that's</c>

00:00:48.130 --> 00:00:48.140 align:start position:0%
the equal sign comes first that's
 

00:00:48.140 --> 00:00:50.529 align:start position:0%
the equal sign comes first that's
because<00:00:48.649><c> the</c><00:00:48.829><c> cell</c><00:00:49.070><c> itself</c><00:00:49.489><c> contains</c><00:00:50.000><c> or</c><00:00:50.300><c> is</c>

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

00:00:50.539 --> 00:00:55.689 align:start position:0%
because the cell itself contains or is
equal<00:00:50.930><c> to</c><00:00:51.140><c> the</c><00:00:51.500><c> formula</c><00:00:51.769><c> and</c><00:00:52.190><c> its</c><00:00:52.340><c> value</c><00:00:54.699><c> let's</c>

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

00:00:55.699 --> 00:00:57.700 align:start position:0%
equal to the formula and its value let's
start<00:00:56.000><c> off</c><00:00:56.149><c> with</c><00:00:56.390><c> a</c><00:00:56.449><c> simple</c><00:00:56.719><c> addition</c><00:00:57.260><c> formula</c>

00:00:57.700 --> 00:00:57.710 align:start position:0%
start off with a simple addition formula
 

00:00:57.710 --> 00:00:59.680 align:start position:0%
start off with a simple addition formula
we're<00:00:58.489><c> going</c><00:00:58.670><c> to</c><00:00:58.760><c> calculate</c><00:00:58.969><c> the</c><00:00:59.269><c> total</c>

00:00:59.680 --> 00:00:59.690 align:start position:0%
we're going to calculate the total
 

00:00:59.690 --> 00:01:03.130 align:start position:0%
we're going to calculate the total
budget<00:00:59.840><c> for</c><00:01:00.050><c> June</c><00:01:00.530><c> and</c><00:01:00.769><c> July</c><00:01:01.719><c> however</c><00:01:02.719><c> instead</c>

00:01:03.130 --> 00:01:03.140 align:start position:0%
budget for June and July however instead
 

00:01:03.140 --> 00:01:05.170 align:start position:0%
budget for June and July however instead
of<00:01:03.350><c> entering</c><00:01:03.530><c> these</c><00:01:03.920><c> numbers</c><00:01:04.339><c> in</c><00:01:04.580><c> other</c><00:01:04.909><c> words</c>

00:01:05.170 --> 00:01:05.180 align:start position:0%
of entering these numbers in other words
 

00:01:05.180 --> 00:01:08.230 align:start position:0%
of entering these numbers in other words
1200<00:01:05.900><c> plus</c><00:01:06.020><c> 1500</c><00:01:06.860><c> we're</c><00:01:07.430><c> going</c><00:01:07.460><c> to</c><00:01:07.790><c> use</c><00:01:07.939><c> cell</c>

00:01:08.230 --> 00:01:08.240 align:start position:0%
1200 plus 1500 we're going to use cell
 

00:01:08.240 --> 00:01:11.710 align:start position:0%
1200 plus 1500 we're going to use cell
references<00:01:08.680><c> here's</c><00:01:09.680><c> how</c><00:01:09.950><c> it</c><00:01:10.100><c> works</c><00:01:10.720><c> first</c>

00:01:11.710 --> 00:01:11.720 align:start position:0%
references here's how it works first
 

00:01:11.720 --> 00:01:13.840 align:start position:0%
references here's how it works first
select<00:01:12.530><c> the</c><00:01:12.710><c> cell</c><00:01:12.740><c> where</c><00:01:13.130><c> you</c><00:01:13.159><c> want</c><00:01:13.250><c> the</c><00:01:13.490><c> total</c>

00:01:13.840 --> 00:01:13.850 align:start position:0%
select the cell where you want the total
 

00:01:13.850 --> 00:01:16.539 align:start position:0%
select the cell where you want the total
to<00:01:13.970><c> appear</c><00:01:14.360><c> then</c><00:01:15.049><c> type</c><00:01:15.350><c> an</c><00:01:15.500><c> equal</c><00:01:15.829><c> sign</c><00:01:15.860><c> which</c>

00:01:16.539 --> 00:01:16.549 align:start position:0%
to appear then type an equal sign which
 

00:01:16.549 --> 00:01:19.390 align:start position:0%
to appear then type an equal sign which
is<00:01:16.700><c> how</c><00:01:16.850><c> you</c><00:01:16.909><c> always</c><00:01:17.210><c> start</c><00:01:17.570><c> a</c><00:01:17.630><c> formula</c><00:01:18.400><c> next</c>

00:01:19.390 --> 00:01:19.400 align:start position:0%
is how you always start a formula next
 

00:01:19.400 --> 00:01:21.340 align:start position:0%
is how you always start a formula next
type<00:01:19.970><c> the</c><00:01:20.000><c> addresses</c><00:01:20.630><c> of</c><00:01:20.659><c> the</c><00:01:20.930><c> cells</c><00:01:21.170><c> you</c><00:01:21.320><c> want</c>

00:01:21.340 --> 00:01:21.350 align:start position:0%
type the addresses of the cells you want
 

00:01:21.350 --> 00:01:27.300 align:start position:0%
type the addresses of the cells you want
to<00:01:21.560><c> add</c><00:01:21.680><c> in</c><00:01:21.950><c> this</c><00:01:22.640><c> example</c><00:01:23.030><c> D</c><00:01:23.720><c> 10</c><00:01:24.130><c> plus</c><00:01:25.150><c> D</c><00:01:26.150><c> 11</c>

00:01:27.300 --> 00:01:27.310 align:start position:0%
to add in this example D 10 plus D 11
 

00:01:27.310 --> 00:01:29.410 align:start position:0%
to add in this example D 10 plus D 11
notice<00:01:28.310><c> how</c><00:01:28.430><c> the</c><00:01:28.490><c> cells</c><00:01:28.790><c> you've</c><00:01:28.939><c> entered</c><00:01:29.270><c> are</c>

00:01:29.410 --> 00:01:29.420 align:start position:0%
notice how the cells you've entered are
 

00:01:29.420 --> 00:01:31.149 align:start position:0%
notice how the cells you've entered are
actually<00:01:29.960><c> highlighted</c><00:01:30.530><c> in</c><00:01:30.649><c> your</c><00:01:30.740><c> worksheet</c>

00:01:31.149 --> 00:01:31.159 align:start position:0%
actually highlighted in your worksheet
 

00:01:31.159 --> 00:01:32.980 align:start position:0%
actually highlighted in your worksheet
so<00:01:31.610><c> you</c><00:01:31.670><c> can</c><00:01:31.909><c> easily</c><00:01:32.149><c> confirm</c><00:01:32.689><c> the</c><00:01:32.840><c> contents</c>

00:01:32.980 --> 00:01:32.990 align:start position:0%
so you can easily confirm the contents
 

00:01:32.990 --> 00:01:35.770 align:start position:0%
so you can easily confirm the contents
of<00:01:33.380><c> your</c><00:01:33.439><c> formula</c><00:01:34.000><c> when</c><00:01:35.000><c> you're</c><00:01:35.149><c> ready</c><00:01:35.329><c> press</c>

00:01:35.770 --> 00:01:35.780 align:start position:0%
of your formula when you're ready press
 

00:01:35.780 --> 00:01:38.560 align:start position:0%
of your formula when you're ready press
ENTER<00:01:36.229><c> on</c><00:01:36.259><c> your</c><00:01:36.439><c> keyboard</c><00:01:36.590><c> and</c><00:01:37.450><c> Excel</c><00:01:38.450><c> will</c>

00:01:38.560 --> 00:01:38.570 align:start position:0%
ENTER on your keyboard and Excel will
 

00:01:38.570 --> 00:01:41.380 align:start position:0%
ENTER on your keyboard and Excel will
display<00:01:38.869><c> the</c><00:01:39.020><c> answer</c><00:01:39.880><c> now</c><00:01:40.880><c> you</c><00:01:40.939><c> may</c><00:01:41.360><c> be</c>

00:01:41.380 --> 00:01:41.390 align:start position:0%
display the answer now you may be
 

00:01:41.390 --> 00:01:43.359 align:start position:0%
display the answer now you may be
wondering<00:01:41.540><c> why</c><00:01:42.049><c> we</c><00:01:42.229><c> use</c><00:01:42.439><c> two</c><00:01:42.619><c> cell</c><00:01:42.829><c> references</c>

00:01:43.359 --> 00:01:43.369 align:start position:0%
wondering why we use two cell references
 

00:01:43.369 --> 00:01:45.730 align:start position:0%
wondering why we use two cell references
instead<00:01:43.850><c> of</c><00:01:43.969><c> numbers</c><00:01:44.299><c> it's</c><00:01:45.170><c> because</c><00:01:45.590><c> they</c>

00:01:45.730 --> 00:01:45.740 align:start position:0%
instead of numbers it's because they
 

00:01:45.740 --> 00:01:47.139 align:start position:0%
instead of numbers it's because they
give<00:01:45.920><c> you</c><00:01:46.009><c> the</c><00:01:46.159><c> ability</c><00:01:46.250><c> to</c><00:01:46.579><c> change</c><00:01:46.969><c> your</c>

00:01:47.139 --> 00:01:47.149 align:start position:0%
give you the ability to change your
 

00:01:47.149 --> 00:01:50.050 align:start position:0%
give you the ability to change your
original<00:01:47.689><c> values</c><00:01:48.219><c> without</c><00:01:49.219><c> having</c><00:01:49.549><c> to</c><00:01:49.670><c> retype</c>

00:01:50.050 --> 00:01:50.060 align:start position:0%
original values without having to retype
 

00:01:50.060 --> 00:01:52.480 align:start position:0%
original values without having to retype
your<00:01:50.119><c> formula</c><00:01:50.860><c> Excel</c><00:01:51.860><c> automatically</c>

00:01:52.480 --> 00:01:52.490 align:start position:0%
your formula Excel automatically
 

00:01:52.490 --> 00:01:54.370 align:start position:0%
your formula Excel automatically
recalculates<00:01:53.240><c> the</c><00:01:53.329><c> answer</c><00:01:53.719><c> so</c><00:01:53.990><c> it's</c><00:01:54.170><c> always</c>

00:01:54.370 --> 00:01:54.380 align:start position:0%
recalculates the answer so it's always
 

00:01:54.380 --> 00:01:56.709 align:start position:0%
recalculates the answer so it's always
up<00:01:54.649><c> to</c><00:01:54.680><c> date</c><00:01:54.850><c> for</c><00:01:55.850><c> that</c><00:01:55.969><c> reason</c><00:01:56.360><c> you</c><00:01:56.689><c> should</c>

00:01:56.709 --> 00:01:56.719 align:start position:0%
up to date for that reason you should
 

00:01:56.719 --> 00:01:58.480 align:start position:0%
up to date for that reason you should
try<00:01:57.049><c> to</c><00:01:57.110><c> use</c><00:01:57.200><c> cell</c><00:01:57.500><c> references</c><00:01:58.009><c> whenever</c><00:01:58.340><c> you</c>

00:01:58.480 --> 00:01:58.490 align:start position:0%
try to use cell references whenever you
 

00:01:58.490 --> 00:02:02.109 align:start position:0%
try to use cell references whenever you
can<00:01:59.140><c> to</c><00:02:00.140><c> edit</c><00:02:00.320><c> your</c><00:02:00.469><c> formula</c><00:02:01.070><c> all</c><00:02:01.610><c> you</c><00:02:01.820><c> have</c><00:02:02.000><c> to</c>

00:02:02.109 --> 00:02:02.119 align:start position:0%
can to edit your formula all you have to
 

00:02:02.119 --> 00:02:04.899 align:start position:0%
can to edit your formula all you have to
do<00:02:02.270><c> is</c><00:02:02.479><c> double</c><00:02:02.869><c> click</c><00:02:02.899><c> the</c><00:02:03.289><c> cell</c><00:02:03.530><c> if</c><00:02:04.159><c> you</c><00:02:04.610><c> make</c>

00:02:04.899 --> 00:02:04.909 align:start position:0%
do is double click the cell if you make
 

00:02:04.909 --> 00:02:06.490 align:start position:0%
do is double click the cell if you make
a<00:02:04.939><c> mistake</c><00:02:05.149><c> or</c><00:02:05.630><c> change</c><00:02:05.960><c> your</c><00:02:06.079><c> mind</c>

00:02:06.490 --> 00:02:06.500 align:start position:0%
a mistake or change your mind
 

00:02:06.500 --> 00:02:07.959 align:start position:0%
a mistake or change your mind
you<00:02:06.710><c> can</c><00:02:06.890><c> press</c><00:02:07.130><c> escape</c><00:02:07.340><c> on</c><00:02:07.789><c> your</c><00:02:07.820><c> keyboard</c>

00:02:07.959 --> 00:02:07.969 align:start position:0%
you can press escape on your keyboard
 

00:02:07.969 --> 00:02:13.199 align:start position:0%
you can press escape on your keyboard
and<00:02:08.620><c> it'll</c><00:02:09.620><c> go</c><00:02:09.740><c> back</c><00:02:09.950><c> to</c><00:02:10.100><c> the</c><00:02:10.190><c> way</c><00:02:10.280><c> it</c><00:02:10.310><c> was</c>

00:02:13.199 --> 00:02:13.209 align:start position:0%
 
 

00:02:13.209 --> 00:02:16.050 align:start position:0%
 
let's<00:02:14.140><c> try</c><00:02:14.439><c> another</c><00:02:14.590><c> example</c><00:02:14.829><c> this</c><00:02:15.730><c> time</c><00:02:15.790><c> with</c>

00:02:16.050 --> 00:02:16.060 align:start position:0%
let's try another example this time with
 

00:02:16.060 --> 00:02:18.599 align:start position:0%
let's try another example this time with
multiplication<00:02:16.629><c> I</c><00:02:17.170><c> want</c><00:02:18.040><c> to</c><00:02:18.129><c> calculate</c><00:02:18.280><c> the</c>

00:02:18.599 --> 00:02:18.609 align:start position:0%
multiplication I want to calculate the
 

00:02:18.609 --> 00:02:21.240 align:start position:0%
multiplication I want to calculate the
total<00:02:19.030><c> price</c><00:02:19.239><c> for</c><00:02:19.569><c> plastic</c><00:02:19.959><c> silverware</c><00:02:20.250><c> so</c>

00:02:21.240 --> 00:02:21.250 align:start position:0%
total price for plastic silverware so
 

00:02:21.250 --> 00:02:25.679 align:start position:0%
total price for plastic silverware so
we'll<00:02:21.400><c> need</c><00:02:21.519><c> to</c><00:02:21.579><c> multiply</c><00:02:21.849><c> b4</c><00:02:22.810><c> by</c><00:02:23.469><c> c4</c><00:02:24.689><c> once</c>

00:02:25.679 --> 00:02:25.689 align:start position:0%
we'll need to multiply b4 by c4 once
 

00:02:25.689 --> 00:02:28.770 align:start position:0%
we'll need to multiply b4 by c4 once
again<00:02:26.019><c> start</c><00:02:26.590><c> by</c><00:02:26.709><c> typing</c><00:02:26.950><c> an</c><00:02:27.219><c> equal</c><00:02:27.519><c> sign</c><00:02:27.780><c> but</c>

00:02:28.770 --> 00:02:28.780 align:start position:0%
again start by typing an equal sign but
 

00:02:28.780 --> 00:02:30.119 align:start position:0%
again start by typing an equal sign but
instead<00:02:29.079><c> of</c><00:02:29.140><c> entering</c><00:02:29.379><c> the</c><00:02:29.709><c> addresses</c>

00:02:30.119 --> 00:02:30.129 align:start position:0%
instead of entering the addresses
 

00:02:30.129 --> 00:02:31.709 align:start position:0%
instead of entering the addresses
manually<00:02:30.639><c> we're</c><00:02:31.060><c> going</c><00:02:31.239><c> to</c><00:02:31.299><c> use</c><00:02:31.450><c> something</c>

00:02:31.709 --> 00:02:31.719 align:start position:0%
manually we're going to use something
 

00:02:31.719 --> 00:02:34.289 align:start position:0%
manually we're going to use something
called<00:02:31.840><c> the</c><00:02:32.109><c> point</c><00:02:32.409><c> and</c><00:02:32.560><c> click</c><00:02:32.620><c> method</c><00:02:33.299><c> just</c>

00:02:34.289 --> 00:02:34.299 align:start position:0%
called the point and click method just
 

00:02:34.299 --> 00:02:36.780 align:start position:0%
called the point and click method just
click<00:02:34.569><c> the</c><00:02:34.719><c> cell</c><00:02:34.930><c> you</c><00:02:35.079><c> want</c><00:02:35.109><c> and</c><00:02:35.560><c> the</c><00:02:36.459><c> address</c>

00:02:36.780 --> 00:02:36.790 align:start position:0%
click the cell you want and the address
 

00:02:36.790 --> 00:02:39.509 align:start position:0%
click the cell you want and the address
instantly<00:02:37.389><c> appears</c><00:02:37.750><c> in</c><00:02:37.900><c> your</c><00:02:38.019><c> formula</c><00:02:38.519><c> most</c>

00:02:39.509 --> 00:02:39.519 align:start position:0%
instantly appears in your formula most
 

00:02:39.519 --> 00:02:41.280 align:start position:0%
instantly appears in your formula most
people<00:02:39.819><c> find</c><00:02:40.000><c> this</c><00:02:40.150><c> much</c><00:02:40.450><c> easier</c><00:02:40.719><c> than</c><00:02:41.139><c> typing</c>

00:02:41.280 --> 00:02:41.290 align:start position:0%
people find this much easier than typing
 

00:02:41.290 --> 00:02:44.069 align:start position:0%
people find this much easier than typing
out<00:02:41.560><c> the</c><00:02:41.709><c> cell</c><00:02:41.889><c> addresses</c><00:02:42.340><c> by</c><00:02:42.489><c> hand</c><00:02:43.079><c> when</c>

00:02:44.069 --> 00:02:44.079 align:start position:0%
out the cell addresses by hand when
 

00:02:44.079 --> 00:02:46.740 align:start position:0%
out the cell addresses by hand when
you're<00:02:44.230><c> done</c><00:02:44.379><c> press</c><00:02:44.799><c> ENTER</c><00:02:45.280><c> and</c><00:02:45.510><c> the</c><00:02:46.510><c> answer</c>

00:02:46.740 --> 00:02:46.750 align:start position:0%
you're done press ENTER and the answer
 

00:02:46.750 --> 00:02:50.099 align:start position:0%
you're done press ENTER and the answer
appears<00:02:48.180><c> finally</c><00:02:49.180><c> I</c><00:02:49.329><c> want</c><00:02:49.750><c> to</c><00:02:49.810><c> show</c><00:02:49.959><c> you</c><00:02:50.019><c> a</c>

00:02:50.099 --> 00:02:50.109 align:start position:0%
appears finally I want to show you a
 

00:02:50.109 --> 00:02:52.319 align:start position:0%
appears finally I want to show you a
quick<00:02:50.439><c> way</c><00:02:50.470><c> to</c><00:02:50.680><c> add</c><00:02:51.069><c> a</c><00:02:51.099><c> formula</c><00:02:51.549><c> to</c><00:02:51.970><c> several</c>

00:02:52.319 --> 00:02:52.329 align:start position:0%
quick way to add a formula to several
 

00:02:52.329 --> 00:02:55.250 align:start position:0%
quick way to add a formula to several
cells<00:02:52.540><c> at</c><00:02:52.720><c> once</c><00:02:53.189><c> specifically</c><00:02:54.189><c> these</c><00:02:54.400><c> 3</c><00:02:54.760><c> cells</c>

00:02:55.250 --> 00:02:55.260 align:start position:0%
cells at once specifically these 3 cells
 

00:02:55.260 --> 00:02:57.720 align:start position:0%
cells at once specifically these 3 cells
instead<00:02:56.260><c> of</c><00:02:56.470><c> retyping</c><00:02:56.889><c> the</c><00:02:57.159><c> formula</c><00:02:57.579><c> above</c>

00:02:57.720 --> 00:02:57.730 align:start position:0%
instead of retyping the formula above
 

00:02:57.730 --> 00:02:59.640 align:start position:0%
instead of retyping the formula above
we're<00:02:58.419><c> just</c><00:02:58.659><c> going</c><00:02:58.810><c> to</c><00:02:58.840><c> select</c><00:02:59.169><c> the</c><00:02:59.409><c> first</c>

00:02:59.640 --> 00:02:59.650 align:start position:0%
we're just going to select the first
 

00:02:59.650 --> 00:03:02.190 align:start position:0%
we're just going to select the first
cell<00:02:59.889><c> then</c><00:03:00.819><c> locate</c><00:03:01.209><c> the</c><00:03:01.239><c> fill</c><00:03:01.569><c> handle</c><00:03:01.810><c> in</c><00:03:02.109><c> the</c>

00:03:02.190 --> 00:03:02.200 align:start position:0%
cell then locate the fill handle in the
 

00:03:02.200 --> 00:03:05.459 align:start position:0%
cell then locate the fill handle in the
bottom<00:03:02.500><c> right</c><00:03:02.680><c> corner</c><00:03:02.709><c> click</c><00:03:04.109><c> and</c><00:03:05.109><c> drag</c><00:03:05.290><c> the</c>

00:03:05.459 --> 00:03:05.469 align:start position:0%
bottom right corner click and drag the
 

00:03:05.469 --> 00:03:07.640 align:start position:0%
bottom right corner click and drag the
handle<00:03:05.769><c> down</c><00:03:05.950><c> and</c><00:03:06.280><c> when</c><00:03:06.669><c> you</c><00:03:06.790><c> let</c><00:03:06.969><c> go</c><00:03:07.000><c> the</c>

00:03:07.640 --> 00:03:07.650 align:start position:0%
handle down and when you let go the
 

00:03:07.650 --> 00:03:10.140 align:start position:0%
handle down and when you let go the
formula<00:03:08.650><c> appears</c><00:03:08.980><c> automatically</c><00:03:09.700><c> in</c><00:03:09.939><c> all</c>

00:03:10.140 --> 00:03:10.150 align:start position:0%
formula appears automatically in all
 

00:03:10.150 --> 00:03:12.690 align:start position:0%
formula appears automatically in all
three<00:03:10.450><c> cells</c><00:03:10.980><c> now</c><00:03:11.980><c> we</c><00:03:12.040><c> can</c><00:03:12.280><c> see</c><00:03:12.430><c> the</c><00:03:12.549><c> total</c>

00:03:12.690 --> 00:03:12.700 align:start position:0%
three cells now we can see the total
 

00:03:12.700 --> 00:03:15.209 align:start position:0%
three cells now we can see the total
cost<00:03:13.060><c> for</c><00:03:13.239><c> each</c><00:03:13.480><c> item</c><00:03:13.739><c> this</c><00:03:14.739><c> is</c><00:03:14.799><c> a</c><00:03:14.950><c> great</c>

00:03:15.209 --> 00:03:15.219 align:start position:0%
cost for each item this is a great
 

00:03:15.219 --> 00:03:17.309 align:start position:0%
cost for each item this is a great
shortcut<00:03:15.669><c> for</c><00:03:15.879><c> duplicating</c><00:03:16.450><c> formulas</c><00:03:16.930><c> if</c><00:03:17.109><c> you</c>

00:03:17.309 --> 00:03:17.319 align:start position:0%
shortcut for duplicating formulas if you
 

00:03:17.319 --> 00:03:19.939 align:start position:0%
shortcut for duplicating formulas if you
plan<00:03:17.560><c> to</c><00:03:17.590><c> use</c><00:03:17.709><c> the</c><00:03:17.979><c> same</c><00:03:18.129><c> one</c><00:03:18.370><c> more</c><00:03:18.549><c> than</c><00:03:18.699><c> once</c>

00:03:19.939 --> 00:03:19.949 align:start position:0%
plan to use the same one more than once
 

00:03:19.949 --> 00:03:22.050 align:start position:0%
plan to use the same one more than once
formulas<00:03:20.949><c> really</c><00:03:21.159><c> are</c><00:03:21.459><c> one</c><00:03:21.699><c> of</c><00:03:21.790><c> the</c><00:03:21.849><c> most</c>

00:03:22.050 --> 00:03:22.060 align:start position:0%
formulas really are one of the most
 

00:03:22.060 --> 00:03:23.849 align:start position:0%
formulas really are one of the most
powerful<00:03:22.299><c> and</c><00:03:22.810><c> convenient</c><00:03:23.349><c> features</c><00:03:23.650><c> in</c>

00:03:23.849 --> 00:03:23.859 align:start position:0%
powerful and convenient features in
 

00:03:23.859 --> 00:03:26.309 align:start position:0%
powerful and convenient features in
Excel<00:03:24.209><c> now</c><00:03:25.209><c> that</c><00:03:25.389><c> you</c><00:03:25.510><c> know</c><00:03:25.629><c> how</c><00:03:25.780><c> to</c><00:03:25.810><c> use</c><00:03:26.079><c> them</c>

00:03:26.309 --> 00:03:26.319 align:start position:0%
Excel now that you know how to use them
 

00:03:26.319 --> 00:03:28.349 align:start position:0%
Excel now that you know how to use them
they<00:03:26.650><c> can</c><00:03:26.829><c> help</c><00:03:26.979><c> you</c><00:03:27.129><c> calculate</c><00:03:27.370><c> all</c><00:03:27.819><c> kinds</c><00:03:28.269><c> of</c>

00:03:28.349 --> 00:03:28.359 align:start position:0%
they can help you calculate all kinds of
 

00:03:28.359 --> 00:03:33.309 align:start position:0%
they can help you calculate all kinds of
useful<00:03:28.569><c> data</c>

00:03:33.309 --> 00:03:33.319 align:start position:0%
 
 

00:03:33.319 --> 00:03:35.379 align:start position:0%
 
you