WEBVTT
Kind: captions
Language: en

00:00:08.929 --> 00:00:11.209 align:start position:0%
 
remember<00:00:09.929><c> using</c><00:00:10.170><c> formulas</c><00:00:10.830><c> to</c><00:00:11.040><c> calculate</c>

00:00:11.209 --> 00:00:11.219 align:start position:0%
remember using formulas to calculate
 

00:00:11.219 --> 00:00:13.700 align:start position:0%
remember using formulas to calculate
math<00:00:11.759><c> problems</c><00:00:12.269><c> in</c><00:00:12.450><c> school</c><00:00:12.750><c> like</c><00:00:13.200><c> two</c><00:00:13.440><c> plus</c>

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

00:00:13.710 --> 00:00:16.490 align:start position:0%
math problems in school like two plus
two<00:00:13.950><c> equals</c><00:00:14.370><c> four</c><00:00:14.460><c> or</c><00:00:14.910><c> two</c><00:00:15.420><c> pizzas</c><00:00:15.870><c> times</c><00:00:16.199><c> ten</c>

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

00:00:16.500 --> 00:00:19.849 align:start position:0%
two equals four or two pizzas times ten
dollars<00:00:16.859><c> equals</c><00:00:17.220><c> twenty</c><00:00:17.520><c> dollars</c><00:00:18.619><c> Excel</c><00:00:19.619><c> can</c>

00:00:19.849 --> 00:00:19.859 align:start position:0%
dollars equals twenty dollars Excel can
 

00:00:19.859 --> 00:00:21.740 align:start position:0%
dollars equals twenty dollars Excel can
use<00:00:20.100><c> these</c><00:00:20.369><c> same</c><00:00:20.670><c> formulas</c><00:00:21.330><c> to</c><00:00:21.539><c> work</c><00:00:21.570><c> with</c>

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

00:00:21.750 --> 00:00:23.810 align:start position:0%
use these same formulas to work with
numerical<00:00:21.930><c> data</c><00:00:22.500><c> in</c><00:00:22.949><c> your</c><00:00:23.070><c> spreadsheets</c><00:00:23.609><c> just</c>

00:00:23.810 --> 00:00:23.820 align:start position:0%
numerical data in your spreadsheets just
 

00:00:23.820 --> 00:00:27.859 align:start position:0%
numerical data in your spreadsheets just
like<00:00:24.300><c> a</c><00:00:24.330><c> calculator</c><00:00:26.000><c> Excel</c><00:00:27.000><c> uses</c><00:00:27.420><c> standard</c>

00:00:27.859 --> 00:00:27.869 align:start position:0%
like a calculator Excel uses standard
 

00:00:27.869 --> 00:00:29.990 align:start position:0%
like a calculator Excel uses standard
operators<00:00:28.410><c> for</c><00:00:28.710><c> its</c><00:00:28.830><c> math</c><00:00:29.010><c> equations</c><00:00:29.550><c> like</c><00:00:29.939><c> a</c>

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

00:00:30.000 --> 00:00:32.900 align:start position:0%
operators for its math equations like a
plus<00:00:30.420><c> sign</c><00:00:30.689><c> for</c><00:00:30.720><c> addition</c><00:00:31.080><c> and</c><00:00:31.590><c> a</c><00:00:32.340><c> minus</c><00:00:32.669><c> sign</c>

00:00:32.900 --> 00:00:32.910 align:start position:0%
plus sign for addition and a minus sign
 

00:00:32.910 --> 00:00:35.750 align:start position:0%
plus sign for addition and a minus sign
for<00:00:33.149><c> subtraction</c><00:00:33.329><c> an</c><00:00:34.520><c> asterisk</c><00:00:35.520><c> for</c>

00:00:35.750 --> 00:00:35.760 align:start position:0%
for subtraction an asterisk for
 

00:00:35.760 --> 00:00:38.450 align:start position:0%
for subtraction an asterisk for
multiplication<00:00:35.820><c> and</c><00:00:36.690><c> a</c><00:00:37.440><c> forward</c><00:00:37.739><c> slash</c><00:00:38.040><c> for</c>

00:00:38.450 --> 00:00:38.460 align:start position:0%
multiplication and a forward slash for
 

00:00:38.460 --> 00:00:41.979 align:start position:0%
multiplication and a forward slash for
division<00:00:38.489><c> and</c><00:00:39.230><c> a</c><00:00:40.230><c> carat</c><00:00:40.680><c> for</c><00:00:40.890><c> exponents</c>

00:00:41.979 --> 00:00:41.989 align:start position:0%
division and a carat for exponents
 

00:00:41.989 --> 00:00:44.630 align:start position:0%
division and a carat for exponents
you're<00:00:42.989><c> probably</c><00:00:43.260><c> used</c><00:00:43.680><c> to</c><00:00:43.829><c> seeing</c><00:00:44.100><c> equations</c>

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

00:00:44.640 --> 00:00:47.660 align:start position:0%
you're probably used to seeing equations
like<00:00:44.910><c> five</c><00:00:45.270><c> plus</c><00:00:45.629><c> five</c><00:00:45.930><c> equals</c><00:00:46.230><c> but</c><00:00:47.010><c> in</c><00:00:47.250><c> excel</c>

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

00:00:47.670 --> 00:00:50.299 align:start position:0%
like five plus five equals but in excel
the<00:00:48.030><c> equal</c><00:00:48.420><c> sign</c><00:00:48.660><c> comes</c><00:00:48.989><c> first</c><00:00:49.320><c> this</c><00:00:50.070><c> is</c>

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

00:00:50.309 --> 00:00:52.819 align:start position:0%
the equal sign comes first this is
because<00:00:50.700><c> the</c><00:00:50.940><c> cell</c><00:00:51.180><c> itself</c><00:00:51.629><c> contains</c><00:00:52.320><c> or</c><00:00:52.680><c> is</c>

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

00:00:52.829 --> 00:00:56.500 align:start position:0%
because the cell itself contains or is
equal<00:00:53.219><c> to</c><00:00:53.430><c> the</c><00:00:53.760><c> formula</c><00:00:54.059><c> and</c><00:00:54.480><c> its</c><00:00:54.660><c> value</c>

00:00:56.500 --> 00:00:56.510 align:start position:0%
equal to the formula and its value
 

00:00:56.510 --> 00:00:58.450 align:start position:0%
equal to the formula and its value
we'll<00:00:57.140><c> start</c><00:00:57.380><c> things</c><00:00:57.620><c> off</c><00:00:57.800><c> slow</c><00:00:58.130><c> with</c><00:00:58.430><c> a</c>

00:00:58.450 --> 00:00:58.460 align:start position:0%
we'll start things off slow with a
 

00:00:58.460 --> 00:01:00.819 align:start position:0%
we'll start things off slow with a
simple<00:00:58.940><c> multiplication</c><00:00:59.390><c> formula</c><00:01:00.260><c> to</c><00:01:00.530><c> figure</c>

00:01:00.819 --> 00:01:00.829 align:start position:0%
simple multiplication formula to figure
 

00:01:00.829 --> 00:01:02.740 align:start position:0%
simple multiplication formula to figure
out<00:01:01.010><c> the</c><00:01:01.160><c> total</c><00:01:01.370><c> cost</c><00:01:01.730><c> of</c><00:01:01.880><c> paint</c><00:01:02.180><c> for</c><00:01:02.450><c> a</c><00:01:02.510><c> list</c>

00:01:02.740 --> 00:01:02.750 align:start position:0%
out the total cost of paint for a list
 

00:01:02.750 --> 00:01:05.439 align:start position:0%
out the total cost of paint for a list
of<00:01:02.870><c> remodeling</c><00:01:03.379><c> projects</c><00:01:03.920><c> as</c><00:01:04.040><c> you</c><00:01:04.850><c> can</c><00:01:05.210><c> see</c>

00:01:05.439 --> 00:01:05.449 align:start position:0%
of remodeling projects as you can see
 

00:01:05.449 --> 00:01:07.690 align:start position:0%
of remodeling projects as you can see
I've<00:01:05.690><c> done</c><00:01:05.900><c> some</c><00:01:06.110><c> research</c><00:01:06.320><c> on</c><00:01:06.530><c> price</c><00:01:07.100><c> and</c><00:01:07.400><c> the</c>

00:01:07.690 --> 00:01:07.700 align:start position:0%
I've done some research on price and the
 

00:01:07.700 --> 00:01:10.210 align:start position:0%
I've done some research on price and the
amount<00:01:07.970><c> of</c><00:01:08.030><c> pain</c><00:01:08.240><c> I'm</c><00:01:08.450><c> going</c><00:01:08.690><c> to</c><00:01:08.840><c> need</c><00:01:09.220><c> $30</c>

00:01:10.210 --> 00:01:10.220 align:start position:0%
amount of pain I'm going to need $30
 

00:01:10.220 --> 00:01:13.660 align:start position:0%
amount of pain I'm going to need $30
times<00:01:10.729><c> 6</c><00:01:11.270><c> gallons</c><00:01:11.720><c> of</c><00:01:11.840><c> paint</c><00:01:12.280><c> to</c><00:01:13.280><c> create</c><00:01:13.430><c> a</c>

00:01:13.660 --> 00:01:13.670 align:start position:0%
times 6 gallons of paint to create a
 

00:01:13.670 --> 00:01:15.460 align:start position:0%
times 6 gallons of paint to create a
formula<00:01:14.060><c> just</c><00:01:14.390><c> click</c><00:01:14.869><c> where</c><00:01:15.050><c> you</c><00:01:15.080><c> want</c><00:01:15.170><c> the</c>

00:01:15.460 --> 00:01:15.470 align:start position:0%
formula just click where you want the
 

00:01:15.470 --> 00:01:17.650 align:start position:0%
formula just click where you want the
total<00:01:15.800><c> to</c><00:01:15.920><c> appear</c><00:01:16.340><c> and</c><00:01:16.490><c> begin</c><00:01:17.000><c> with</c><00:01:17.180><c> an</c><00:01:17.330><c> equal</c>

00:01:17.650 --> 00:01:17.660 align:start position:0%
total to appear and begin with an equal
 

00:01:17.660 --> 00:01:22.390 align:start position:0%
total to appear and begin with an equal
sign<00:01:17.800><c> we</c><00:01:18.800><c> are</c><00:01:18.830><c> going</c><00:01:19.100><c> to</c><00:01:19.220><c> do</c><00:01:19.400><c> 30</c><00:01:19.790><c> times</c><00:01:20.600><c> 6</c><00:01:21.500><c> using</c>

00:01:22.390 --> 00:01:22.400 align:start position:0%
sign we are going to do 30 times 6 using
 

00:01:22.400 --> 00:01:25.060 align:start position:0%
sign we are going to do 30 times 6 using
the<00:01:22.520><c> asterisk</c><00:01:22.940><c> for</c><00:01:23.330><c> multiplication</c><00:01:24.070><c> now</c>

00:01:25.060 --> 00:01:25.070 align:start position:0%
the asterisk for multiplication now
 

00:01:25.070 --> 00:01:27.580 align:start position:0%
the asterisk for multiplication now
press<00:01:25.400><c> ENTER</c><00:01:25.850><c> on</c><00:01:25.880><c> your</c><00:01:26.090><c> keyboard</c><00:01:26.240><c> and</c><00:01:26.750><c> Excel</c>

00:01:27.580 --> 00:01:27.590 align:start position:0%
press ENTER on your keyboard and Excel
 

00:01:27.590 --> 00:01:30.460 align:start position:0%
press ENTER on your keyboard and Excel
displays<00:01:27.770><c> the</c><00:01:28.220><c> value</c><00:01:28.550><c> in</c><00:01:28.729><c> the</c><00:01:28.880><c> cell</c><00:01:29.470><c> another</c>

00:01:30.460 --> 00:01:30.470 align:start position:0%
displays the value in the cell another
 

00:01:30.470 --> 00:01:32.650 align:start position:0%
displays the value in the cell another
way<00:01:30.740><c> to</c><00:01:30.800><c> create</c><00:01:31.039><c> formulas</c><00:01:31.759><c> is</c><00:01:32.000><c> to</c><00:01:32.149><c> use</c><00:01:32.360><c> cell</c>

00:01:32.650 --> 00:01:32.660 align:start position:0%
way to create formulas is to use cell
 

00:01:32.660 --> 00:01:35.320 align:start position:0%
way to create formulas is to use cell
references<00:01:32.899><c> a</c><00:01:33.530><c> cell</c><00:01:34.220><c> reference</c><00:01:34.430><c> is</c><00:01:34.880><c> when</c><00:01:35.180><c> your</c>

00:01:35.320 --> 00:01:35.330 align:start position:0%
references a cell reference is when your
 

00:01:35.330 --> 00:01:38.050 align:start position:0%
references a cell reference is when your
formula<00:01:35.810><c> contains</c><00:01:36.229><c> cell</c><00:01:36.560><c> addresses</c><00:01:37.160><c> like</c><00:01:37.430><c> f8</c>

00:01:38.050 --> 00:01:38.060 align:start position:0%
formula contains cell addresses like f8
 

00:01:38.060 --> 00:01:40.270 align:start position:0%
formula contains cell addresses like f8
or<00:01:38.240><c> F</c><00:01:38.479><c> time</c><00:01:38.750><c> instead</c><00:01:39.470><c> of</c><00:01:39.619><c> the</c><00:01:39.710><c> numbers</c><00:01:40.039><c> in</c>

00:01:40.270 --> 00:01:40.280 align:start position:0%
or F time instead of the numbers in
 

00:01:40.280 --> 00:01:42.940 align:start position:0%
or F time instead of the numbers in
those<00:01:40.520><c> cells</c><00:01:40.820><c> let's</c><00:01:41.720><c> give</c><00:01:41.990><c> it</c><00:01:42.020><c> a</c><00:01:42.200><c> try</c><00:01:42.380><c> on</c><00:01:42.740><c> the</c>

00:01:42.940 --> 00:01:42.950 align:start position:0%
those cells let's give it a try on the
 

00:01:42.950 --> 00:01:45.190 align:start position:0%
those cells let's give it a try on the
total<00:01:43.280><c> estimated</c><00:01:43.490><c> budget</c><00:01:44.030><c> rather</c><00:01:44.930><c> than</c>

00:01:45.190 --> 00:01:45.200 align:start position:0%
total estimated budget rather than
 

00:01:45.200 --> 00:01:49.690 align:start position:0%
total estimated budget rather than
calculating<00:01:45.740><c> 700</c><00:01:46.610><c> +</c><00:01:47.470><c> 550</c><00:01:48.470><c> the</c><00:01:49.130><c> values</c><00:01:49.520><c> in</c>

00:01:49.690 --> 00:01:49.700 align:start position:0%
calculating 700 + 550 the values in
 

00:01:49.700 --> 00:01:52.719 align:start position:0%
calculating 700 + 550 the values in
cells<00:01:49.970><c> f8</c><00:01:50.479><c> and</c><00:01:50.690><c> f9</c><00:01:50.950><c> will</c><00:01:51.950><c> write</c><00:01:52.160><c> the</c><00:01:52.280><c> formula</c>

00:01:52.719 --> 00:01:52.729 align:start position:0%
cells f8 and f9 will write the formula
 

00:01:52.729 --> 00:01:59.200 align:start position:0%
cells f8 and f9 will write the formula
this<00:01:52.910><c> way</c><00:01:53.560><c> f8</c><00:01:54.560><c> +</c><00:01:55.660><c> f9</c><00:01:57.190><c> that</c><00:01:58.190><c> totals</c><00:01:58.729><c> the</c><00:01:58.880><c> numbers</c>

00:01:59.200 --> 00:01:59.210 align:start position:0%
this way f8 + f9 that totals the numbers
 

00:01:59.210 --> 00:02:01.779 align:start position:0%
this way f8 + f9 that totals the numbers
in<00:01:59.420><c> f8</c><00:02:00.050><c> and</c><00:02:00.289><c> f9</c><00:02:00.410><c> whether</c><00:02:01.190><c> you</c><00:02:01.399><c> leave</c><00:02:01.580><c> the</c>

00:02:01.779 --> 00:02:01.789 align:start position:0%
in f8 and f9 whether you leave the
 

00:02:01.789 --> 00:02:04.930 align:start position:0%
in f8 and f9 whether you leave the
budget<00:02:02.149><c> at</c><00:02:02.500><c> 705</c><00:02:03.500><c> 50</c><00:02:03.979><c> or</c><00:02:04.160><c> change</c><00:02:04.700><c> it</c><00:02:04.819><c> to</c>

00:02:04.930 --> 00:02:04.940 align:start position:0%
budget at 705 50 or change it to
 

00:02:04.940 --> 00:02:10.690 align:start position:0%
budget at 705 50 or change it to
something<00:02:05.149><c> else</c><00:02:05.420><c> say</c><00:02:06.069><c> 800</c><00:02:07.069><c> +</c><00:02:08.110><c> 650</c><00:02:09.310><c> the</c><00:02:10.310><c> total</c>

00:02:10.690 --> 00:02:10.700 align:start position:0%
something else say 800 + 650 the total
 

00:02:10.700 --> 00:02:12.970 align:start position:0%
something else say 800 + 650 the total
recalculates<00:02:11.330><c> automatically</c><00:02:12.110><c> that's</c><00:02:12.709><c> why</c>

00:02:12.970 --> 00:02:12.980 align:start position:0%
recalculates automatically that's why
 

00:02:12.980 --> 00:02:15.430 align:start position:0%
recalculates automatically that's why
cell<00:02:13.280><c> references</c><00:02:13.819><c> are</c><00:02:13.849><c> so</c><00:02:14.209><c> convenient</c><00:02:14.690><c> they</c>

00:02:15.430 --> 00:02:15.440 align:start position:0%
cell references are so convenient they
 

00:02:15.440 --> 00:02:16.839 align:start position:0%
cell references are so convenient they
make<00:02:15.650><c> it</c><00:02:15.770><c> possible</c><00:02:15.980><c> to</c><00:02:16.280><c> update</c><00:02:16.520><c> your</c>

00:02:16.839 --> 00:02:16.849 align:start position:0%
make it possible to update your
 

00:02:16.849 --> 00:02:18.880 align:start position:0%
make it possible to update your
worksheet<00:02:17.300><c> without</c><00:02:17.720><c> ever</c><00:02:17.959><c> having</c><00:02:18.230><c> to</c><00:02:18.410><c> rewrite</c>

00:02:18.880 --> 00:02:18.890 align:start position:0%
worksheet without ever having to rewrite
 

00:02:18.890 --> 00:02:22.210 align:start position:0%
worksheet without ever having to rewrite
the<00:02:19.099><c> values</c><00:02:19.489><c> in</c><00:02:19.730><c> your</c><00:02:19.849><c> formulas</c><00:02:20.860><c> you</c><00:02:21.860><c> can</c><00:02:21.890><c> also</c>

00:02:22.210 --> 00:02:22.220 align:start position:0%
the values in your formulas you can also
 

00:02:22.220 --> 00:02:23.860 align:start position:0%
the values in your formulas you can also
use<00:02:22.580><c> something</c><00:02:22.849><c> called</c><00:02:23.030><c> the</c><00:02:23.270><c> point</c><00:02:23.390><c> and</c><00:02:23.780><c> click</c>

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

00:02:23.870 --> 00:02:26.320 align:start position:0%
use something called the point and click
method<00:02:24.050><c> to</c><00:02:24.590><c> make</c><00:02:24.709><c> cell</c><00:02:24.980><c> references</c><00:02:25.550><c> this</c><00:02:26.090><c> one</c>

00:02:26.320 --> 00:02:26.330 align:start position:0%
method to make cell references this one
 

00:02:26.330 --> 00:02:28.479 align:start position:0%
method to make cell references this one
is<00:02:26.450><c> a</c><00:02:26.480><c> great</c><00:02:26.690><c> time-saver</c><00:02:27.190><c> now</c><00:02:28.190><c> that</c><00:02:28.400><c> I've</c>

00:02:28.479 --> 00:02:28.489 align:start position:0%
is a great time-saver now that I've
 

00:02:28.489 --> 00:02:30.790 align:start position:0%
is a great time-saver now that I've
calculated<00:02:28.910><c> my</c><00:02:29.270><c> estimated</c><00:02:29.750><c> budget</c><00:02:30.050><c> why</c><00:02:30.620><c> don't</c>

00:02:30.790 --> 00:02:30.800 align:start position:0%
calculated my estimated budget why don't
 

00:02:30.800 --> 00:02:32.380 align:start position:0%
calculated my estimated budget why don't
we<00:02:30.890><c> find</c><00:02:31.069><c> out</c><00:02:31.250><c> how</c><00:02:31.430><c> much</c><00:02:31.580><c> is</c><00:02:31.760><c> left</c><00:02:31.790><c> after</c>

00:02:32.380 --> 00:02:32.390 align:start position:0%
we find out how much is left after
 

00:02:32.390 --> 00:02:34.690 align:start position:0%
we find out how much is left after
taking<00:02:32.630><c> my</c><00:02:32.900><c> wishlist</c><00:02:33.349><c> into</c><00:02:33.709><c> account</c><00:02:34.040><c> that</c>

00:02:34.690 --> 00:02:34.700 align:start position:0%
taking my wishlist into account that
 

00:02:34.700 --> 00:02:36.580 align:start position:0%
taking my wishlist into account that
means<00:02:35.000><c> I'll</c><00:02:35.180><c> need</c><00:02:35.360><c> to</c><00:02:35.480><c> subtract</c><00:02:35.930><c> my</c><00:02:36.140><c> wishlist</c>

00:02:36.580 --> 00:02:36.590 align:start position:0%
means I'll need to subtract my wishlist
 

00:02:36.590 --> 00:02:39.040 align:start position:0%
means I'll need to subtract my wishlist
total<00:02:37.010><c> from</c><00:02:37.310><c> my</c><00:02:37.430><c> estimated</c><00:02:38.060><c> budget</c><00:02:38.209><c> so</c><00:02:38.810><c> I'm</c>

00:02:39.040 --> 00:02:39.050 align:start position:0%
total from my estimated budget so I'm
 

00:02:39.050 --> 00:02:42.160 align:start position:0%
total from my estimated budget so I'm
going<00:02:39.680><c> to</c><00:02:39.860><c> start</c><00:02:40.190><c> my</c><00:02:40.340><c> equation</c><00:02:40.819><c> then</c><00:02:41.720><c> just</c>

00:02:42.160 --> 00:02:42.170 align:start position:0%
going to start my equation then just
 

00:02:42.170 --> 00:02:44.440 align:start position:0%
going to start my equation then just
click<00:02:42.620><c> this</c><00:02:42.890><c> cell</c><00:02:43.190><c> to</c><00:02:43.489><c> make</c><00:02:43.640><c> reference</c><00:02:43.879><c> to</c><00:02:44.180><c> it</c>

00:02:44.440 --> 00:02:44.450 align:start position:0%
click this cell to make reference to it
 

00:02:44.450 --> 00:02:47.500 align:start position:0%
click this cell to make reference to it
now<00:02:45.440><c> type</c><00:02:45.800><c> your</c><00:02:45.950><c> operator</c><00:02:46.489><c> in</c><00:02:46.730><c> my</c><00:02:47.000><c> case</c><00:02:47.300><c> a</c>

00:02:47.500 --> 00:02:47.510 align:start position:0%
now type your operator in my case a
 

00:02:47.510 --> 00:02:49.960 align:start position:0%
now type your operator in my case a
minus<00:02:47.930><c> sign</c><00:02:48.170><c> and</c><00:02:48.379><c> click</c><00:02:49.190><c> the</c><00:02:49.370><c> next</c><00:02:49.640><c> cell</c><00:02:49.819><c> you</c>

00:02:49.960 --> 00:02:49.970 align:start position:0%
minus sign and click the next cell you
 

00:02:49.970 --> 00:02:52.839 align:start position:0%
minus sign and click the next cell you
want<00:02:50.180><c> in</c><00:02:50.330><c> your</c><00:02:50.420><c> formula</c><00:02:51.040><c> press</c><00:02:52.040><c> ENTER</c><00:02:52.459><c> and</c><00:02:52.670><c> the</c>

00:02:52.839 --> 00:02:52.849 align:start position:0%
want in your formula press ENTER and the
 

00:02:52.849 --> 00:02:56.199 align:start position:0%
want in your formula press ENTER and the
total<00:02:53.150><c> appears</c><00:02:54.190><c> editing</c><00:02:55.190><c> formulas</c><00:02:55.670><c> is</c><00:02:55.819><c> also</c>

00:02:56.199 --> 00:02:56.209 align:start position:0%
total appears editing formulas is also
 

00:02:56.209 --> 00:02:58.420 align:start position:0%
total appears editing formulas is also
just<00:02:56.420><c> a</c><00:02:56.599><c> click</c><00:02:56.810><c> away</c><00:02:56.920><c> click</c><00:02:57.920><c> the</c><00:02:58.069><c> cell</c><00:02:58.280><c> you</c>

00:02:58.420 --> 00:02:58.430 align:start position:0%
just a click away click the cell you
 

00:02:58.430 --> 00:03:00.670 align:start position:0%
just a click away click the cell you
want<00:02:58.580><c> to</c><00:02:58.700><c> edit</c><00:02:59.060><c> and</c><00:02:59.180><c> then</c><00:02:59.599><c> come</c><00:03:00.020><c> up</c><00:03:00.230><c> here</c><00:03:00.560><c> to</c>

00:03:00.670 --> 00:03:00.680 align:start position:0%
want to edit and then come up here to
 

00:03:00.680 --> 00:03:03.180 align:start position:0%
want to edit and then come up here to
make<00:03:00.800><c> your</c><00:03:00.950><c> changes</c><00:03:01.340><c> in</c><00:03:01.400><c> the</c><00:03:01.610><c> formula</c><00:03:02.030><c> bar</c><00:03:02.180><c> if</c>

00:03:03.180 --> 00:03:03.190 align:start position:0%
make your changes in the formula bar if
 

00:03:03.190 --> 00:03:05.740 align:start position:0%
make your changes in the formula bar if
you<00:03:04.190><c> make</c><00:03:04.370><c> a</c><00:03:04.400><c> mistake</c><00:03:04.849><c> or</c><00:03:05.120><c> change</c><00:03:05.390><c> your</c><00:03:05.510><c> mind</c>

00:03:05.740 --> 00:03:05.750 align:start position:0%
you make a mistake or change your mind
 

00:03:05.750 --> 00:03:07.869 align:start position:0%
you make a mistake or change your mind
just<00:03:05.989><c> use</c><00:03:06.469><c> the</c><00:03:06.650><c> cancel</c><00:03:06.890><c> command</c><00:03:07.400><c> and</c><00:03:07.609><c> you'll</c>

00:03:07.869 --> 00:03:07.879 align:start position:0%
just use the cancel command and you'll
 

00:03:07.879 --> 00:03:10.360 align:start position:0%
just use the cancel command and you'll
avoid<00:03:08.120><c> making</c><00:03:08.359><c> any</c><00:03:08.569><c> unwanted</c><00:03:09.019><c> changes</c>

00:03:10.360 --> 00:03:10.370 align:start position:0%
avoid making any unwanted changes
 

00:03:10.370 --> 00:03:13.040 align:start position:0%
avoid making any unwanted changes
you<00:03:11.370><c> can</c><00:03:11.550><c> also</c><00:03:11.700><c> double-click</c><00:03:12.240><c> the</c><00:03:12.600><c> cell</c><00:03:12.810><c> and</c>

00:03:13.040 --> 00:03:13.050 align:start position:0%
you can also double-click the cell and
 

00:03:13.050 --> 00:03:16.120 align:start position:0%
you can also double-click the cell and
make<00:03:13.320><c> your</c><00:03:13.470><c> changes</c><00:03:13.830><c> right</c><00:03:14.040><c> there</c>

00:03:16.120 --> 00:03:16.130 align:start position:0%
make your changes right there
 

00:03:16.130 --> 00:03:18.620 align:start position:0%
make your changes right there
simple<00:03:17.130><c> formulas</c><00:03:17.640><c> and</c><00:03:17.880><c> cell</c><00:03:18.090><c> references</c><00:03:18.600><c> are</c>

00:03:18.620 --> 00:03:18.630 align:start position:0%
simple formulas and cell references are
 

00:03:18.630 --> 00:03:21.230 align:start position:0%
simple formulas and cell references are
easy<00:03:19.110><c> to</c><00:03:19.350><c> use</c><00:03:19.560><c> why</c><00:03:20.130><c> not</c><00:03:20.340><c> give</c><00:03:20.550><c> them</c><00:03:20.670><c> a</c><00:03:20.790><c> try</c><00:03:21.000><c> and</c>

00:03:21.230 --> 00:03:21.240 align:start position:0%
easy to use why not give them a try and
 

00:03:21.240 --> 00:03:24.650 align:start position:0%
easy to use why not give them a try and
let<00:03:21.330><c> Excel</c><00:03:21.960><c> do</c><00:03:22.110><c> the</c><00:03:22.230><c> math</c><00:03:23.270><c> like</c><00:03:24.270><c> that</c><00:03:24.480><c> you</c><00:03:24.630><c> just</c>

00:03:24.650 --> 00:03:24.660 align:start position:0%
let Excel do the math like that you just
 

00:03:24.660 --> 00:03:28.760 align:start position:0%
let Excel do the math like that you just
saw<00:03:25.520><c> rate</c><00:03:26.520><c> it</c><00:03:26.700><c> at</c><00:03:27.210><c> a</c><00:03:27.270><c> comment</c><00:03:27.780><c> subscribe</c><00:03:28.320><c> to</c>

00:03:28.760 --> 00:03:28.770 align:start position:0%
saw rate it at a comment subscribe to
 

00:03:28.770 --> 00:03:30.080 align:start position:0%
saw rate it at a comment subscribe to
our<00:03:28.890><c> Channel</c>

00:03:30.080 --> 00:03:30.090 align:start position:0%
our Channel
 

00:03:30.090 --> 00:03:32.080 align:start position:0%
our Channel
the<00:03:30.360><c> freedom</c><00:03:30.780><c> to</c><00:03:30.930><c> learn</c>

00:03:32.080 --> 00:03:32.090 align:start position:0%
the freedom to learn
 

00:03:32.090 --> 00:03:37.360 align:start position:0%
the freedom to learn
what<00:03:32.720><c> you</c><00:03:32.930><c> want</c><00:03:33.430><c> when</c><00:03:34.430><c> you</c><00:03:34.640><c> want</c><00:03:36.370><c> absolutely</c>

00:03:37.360 --> 00:03:37.370 align:start position:0%
what you want when you want absolutely
 

00:03:37.370 --> 00:03:41.020 align:start position:0%
what you want when you want absolutely
free

00:03:41.020 --> 00:03:41.030 align:start position:0%
 
 

00:03:41.030 --> 00:03:44.629 align:start position:0%
 
GCF<00:03:42.030><c> learn</c><00:03:42.599><c> free.org</c>