WEBVTT
Kind: captions
Language: en

00:00:00.909 --> 00:00:03.120 align:start position:0%
 
remember<00:00:01.839><c> using</c><00:00:02.080><c> formulas</c><00:00:02.740><c> to</c><00:00:02.980><c> calculate</c>

00:00:03.120 --> 00:00:03.130 align:start position:0%
remember using formulas to calculate
 

00:00:03.130 --> 00:00:05.760 align:start position:0%
remember using formulas to calculate
simple<00:00:03.909><c> math</c><00:00:04.090><c> problems</c><00:00:04.660><c> like</c><00:00:04.930><c> two</c><00:00:05.290><c> plus</c><00:00:05.560><c> two</c>

00:00:05.760 --> 00:00:05.770 align:start position:0%
simple math problems like two plus two
 

00:00:05.770 --> 00:00:08.490 align:start position:0%
simple math problems like two plus two
equals<00:00:06.160><c> four</c><00:00:06.220><c> or</c><00:00:06.759><c> two</c><00:00:07.390><c> pizzas</c><00:00:07.750><c> times</c><00:00:08.139><c> ten</c>

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

00:00:08.500 --> 00:00:11.280 align:start position:0%
equals four or two pizzas times ten
dollars<00:00:08.860><c> equals</c><00:00:09.100><c> $20</c><00:00:10.030><c> you</c><00:00:10.750><c> can</c><00:00:10.900><c> use</c><00:00:11.080><c> these</c>

00:00:11.280 --> 00:00:11.290 align:start position:0%
dollars equals $20 you can use these
 

00:00:11.290 --> 00:00:12.750 align:start position:0%
dollars equals $20 you can use these
same<00:00:11.349><c> formulas</c><00:00:12.160><c> to</c><00:00:12.370><c> work</c><00:00:12.400><c> with</c><00:00:12.580><c> numerical</c>

00:00:12.750 --> 00:00:12.760 align:start position:0%
same formulas to work with numerical
 

00:00:12.760 --> 00:00:15.570 align:start position:0%
same formulas to work with numerical
data<00:00:13.330><c> in</c><00:00:13.690><c> your</c><00:00:14.019><c> spreadsheets</c><00:00:14.650><c> just</c><00:00:15.280><c> like</c><00:00:15.429><c> you</c>

00:00:15.570 --> 00:00:15.580 align:start position:0%
data in your spreadsheets just like you
 

00:00:15.580 --> 00:00:17.849 align:start position:0%
data in your spreadsheets just like you
would<00:00:15.700><c> use</c><00:00:15.849><c> a</c><00:00:15.880><c> calculator</c><00:00:16.560><c> Google</c><00:00:17.560><c> sheets</c>

00:00:17.849 --> 00:00:17.859 align:start position:0%
would use a calculator Google sheets
 

00:00:17.859 --> 00:00:19.800 align:start position:0%
would use a calculator Google sheets
uses<00:00:18.310><c> standard</c><00:00:18.609><c> operators</c><00:00:19.390><c> for</c><00:00:19.630><c> math</c>

00:00:19.800 --> 00:00:19.810 align:start position:0%
uses standard operators for math
 

00:00:19.810 --> 00:00:21.870 align:start position:0%
uses standard operators for math
equations<00:00:20.380><c> like</c><00:00:20.829><c> a</c><00:00:20.859><c> plus</c><00:00:21.159><c> sign</c><00:00:21.429><c> for</c><00:00:21.460><c> addition</c>

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

00:00:21.880 --> 00:00:25.109 align:start position:0%
equations like a plus sign for addition
a<00:00:22.390><c> minus</c><00:00:22.989><c> sign</c><00:00:23.230><c> for</c><00:00:23.529><c> subtraction</c><00:00:23.679><c> an</c><00:00:24.369><c> asterisk</c>

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

00:00:25.119 --> 00:00:27.359 align:start position:0%
a minus sign for subtraction an asterisk
for<00:00:25.269><c> multiplication</c><00:00:25.329><c> a</c><00:00:26.230><c> forward</c><00:00:26.800><c> slash</c><00:00:26.949><c> for</c>

00:00:27.359 --> 00:00:27.369 align:start position:0%
for multiplication a forward slash for
 

00:00:27.369 --> 00:00:29.550 align:start position:0%
for multiplication a forward slash for
division<00:00:27.399><c> and</c><00:00:28.060><c> a</c><00:00:28.329><c> carrot</c><00:00:28.720><c> for</c><00:00:28.929><c> exponents</c>

00:00:29.550 --> 00:00:29.560 align:start position:0%
division and a carrot for exponents
 

00:00:29.560 --> 00:00:32.130 align:start position:0%
division and a carrot for exponents
you're<00:00:30.369><c> probably</c><00:00:30.699><c> used</c><00:00:31.089><c> to</c><00:00:31.210><c> seeing</c><00:00:31.300><c> equations</c>

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

00:00:32.140 --> 00:00:35.340 align:start position:0%
you're probably used to seeing equations
like<00:00:32.349><c> five</c><00:00:32.770><c> plus</c><00:00:33.160><c> five</c><00:00:33.460><c> equals</c><00:00:33.750><c> but</c><00:00:34.750><c> in</c><00:00:34.930><c> Google</c>

00:00:35.340 --> 00:00:35.350 align:start position:0%
like five plus five equals but in Google
 

00:00:35.350 --> 00:00:37.710 align:start position:0%
like five plus five equals but in Google
sheets<00:00:35.620><c> the</c><00:00:36.040><c> equal</c><00:00:36.430><c> sign</c><00:00:36.700><c> comes</c><00:00:37.090><c> first</c>

00:00:37.710 --> 00:00:37.720 align:start position:0%
sheets the equal sign comes first
 

00:00:37.720 --> 00:00:40.500 align:start position:0%
sheets the equal sign comes first
that's<00:00:38.440><c> because</c><00:00:38.890><c> the</c><00:00:39.130><c> cell</c><00:00:39.370><c> itself</c><00:00:39.820><c> contains</c>

00:00:40.500 --> 00:00:40.510 align:start position:0%
that's because the cell itself contains
 

00:00:40.510 --> 00:00:44.779 align:start position:0%
that's because the cell itself contains
or<00:00:40.810><c> is</c><00:00:41.200><c> equal</c><00:00:41.620><c> to</c><00:00:41.830><c> the</c><00:00:42.220><c> formula</c><00:00:42.520><c> and</c><00:00:43.030><c> its</c><00:00:43.300><c> value</c>

00:00:44.779 --> 00:00:44.789 align:start position:0%
or is equal to the formula and its value
 

00:00:44.789 --> 00:00:46.910 align:start position:0%
or is equal to the formula and its value
we'll<00:00:45.449><c> start</c><00:00:45.719><c> things</c><00:00:45.989><c> off</c><00:00:46.170><c> slow</c><00:00:46.530><c> with</c><00:00:46.890><c> a</c>

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

00:00:46.920 --> 00:00:48.799 align:start position:0%
we'll start things off slow with a
simple<00:00:47.399><c> addition</c><00:00:47.640><c> formula</c><00:00:48.300><c> to</c><00:00:48.629><c> help</c>

00:00:48.799 --> 00:00:48.809 align:start position:0%
simple addition formula to help
 

00:00:48.809 --> 00:00:51.619 align:start position:0%
simple addition formula to help
calculate<00:00:49.140><c> a</c><00:00:49.440><c> budget</c><00:00:49.920><c> as</c><00:00:50.070><c> you</c><00:00:50.789><c> can</c><00:00:51.149><c> see</c><00:00:51.390><c> I've</c>

00:00:51.619 --> 00:00:51.629 align:start position:0%
calculate a budget as you can see I've
 

00:00:51.629 --> 00:00:54.399 align:start position:0%
calculate a budget as you can see I've
already<00:00:51.960><c> entered</c><00:00:52.469><c> the</c><00:00:52.620><c> initial</c><00:00:53.010><c> amounts</c>

00:00:54.399 --> 00:00:54.409 align:start position:0%
already entered the initial amounts
 

00:00:54.409 --> 00:00:59.810 align:start position:0%
already entered the initial amounts
$1,200<00:00:55.409><c> for</c><00:00:55.710><c> June</c><00:00:55.949><c> and</c><00:00:57.260><c> $1500</c><00:00:58.260><c> for</c><00:00:58.559><c> July</c><00:00:58.859><c> to</c>

00:00:59.810 --> 00:00:59.820 align:start position:0%
$1,200 for June and $1500 for July to
 

00:00:59.820 --> 00:01:02.090 align:start position:0%
$1,200 for June and $1500 for July to
create<00:01:00.149><c> a</c><00:01:00.180><c> formula</c><00:01:00.570><c> select</c><00:01:01.379><c> the</c><00:01:01.589><c> cell</c><00:01:01.829><c> where</c>

00:01:02.090 --> 00:01:02.100 align:start position:0%
create a formula select the cell where
 

00:01:02.100 --> 00:01:04.549 align:start position:0%
create a formula select the cell where
you<00:01:02.129><c> want</c><00:01:02.250><c> the</c><00:01:02.489><c> total</c><00:01:02.760><c> to</c><00:01:03.000><c> appear</c><00:01:03.420><c> then</c><00:01:04.199><c> type</c>

00:01:04.549 --> 00:01:04.559 align:start position:0%
you want the total to appear then type
 

00:01:04.559 --> 00:01:08.320 align:start position:0%
you want the total to appear then type
an<00:01:04.769><c> equal</c><00:01:05.190><c> sign</c><00:01:05.600><c> but</c><00:01:06.600><c> instead</c><00:01:07.170><c> of</c><00:01:07.289><c> entering</c>

00:01:08.320 --> 00:01:08.330 align:start position:0%
an equal sign but instead of entering
 

00:01:08.330 --> 00:01:12.710 align:start position:0%
an equal sign but instead of entering
1200<00:01:09.330><c> plus</c><00:01:10.190><c> 1500</c><00:01:11.190><c> we're</c><00:01:11.549><c> going</c><00:01:11.580><c> to</c><00:01:11.880><c> use</c><00:01:12.210><c> cell</c>

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

00:01:12.720 --> 00:01:15.620 align:start position:0%
1200 plus 1500 we're going to use cell
references<00:01:12.990><c> to</c><00:01:13.619><c> create</c><00:01:13.950><c> our</c><00:01:14.130><c> formula</c><00:01:14.640><c> a</c><00:01:14.820><c> cell</c>

00:01:15.620 --> 00:01:15.630 align:start position:0%
references to create our formula a cell
 

00:01:15.630 --> 00:01:17.779 align:start position:0%
references to create our formula a cell
reference<00:01:15.899><c> is</c><00:01:16.320><c> when</c><00:01:16.590><c> your</c><00:01:16.770><c> formula</c><00:01:17.340><c> contains</c>

00:01:17.779 --> 00:01:17.789 align:start position:0%
reference is when your formula contains
 

00:01:17.789 --> 00:01:20.210 align:start position:0%
reference is when your formula contains
cell<00:01:18.330><c> addresses</c><00:01:18.720><c> instead</c><00:01:19.440><c> of</c><00:01:19.560><c> the</c><00:01:19.679><c> numbers</c><00:01:20.009><c> in</c>

00:01:20.210 --> 00:01:20.220 align:start position:0%
cell addresses instead of the numbers in
 

00:01:20.220 --> 00:01:22.880 align:start position:0%
cell addresses instead of the numbers in
those<00:01:20.520><c> cells</c><00:01:20.940><c> they're</c><00:01:21.690><c> useful</c><00:01:21.990><c> because</c><00:01:22.679><c> they</c>

00:01:22.880 --> 00:01:22.890 align:start position:0%
those cells they're useful because they
 

00:01:22.890 --> 00:01:24.529 align:start position:0%
those cells they're useful because they
make<00:01:23.100><c> it</c><00:01:23.250><c> possible</c><00:01:23.460><c> to</c><00:01:23.759><c> update</c><00:01:24.149><c> your</c>

00:01:24.529 --> 00:01:24.539 align:start position:0%
make it possible to update your
 

00:01:24.539 --> 00:01:26.359 align:start position:0%
make it possible to update your
spreadsheet<00:01:25.080><c> without</c><00:01:25.560><c> ever</c><00:01:25.890><c> having</c><00:01:26.159><c> to</c>

00:01:26.359 --> 00:01:26.369 align:start position:0%
spreadsheet without ever having to
 

00:01:26.369 --> 00:01:29.510 align:start position:0%
spreadsheet without ever having to
rewrite<00:01:26.909><c> your</c><00:01:27.090><c> formulas</c><00:01:27.659><c> the</c><00:01:28.470><c> values</c><00:01:28.920><c> we</c><00:01:29.250><c> want</c>

00:01:29.510 --> 00:01:29.520 align:start position:0%
rewrite your formulas the values we want
 

00:01:29.520 --> 00:01:33.109 align:start position:0%
rewrite your formulas the values we want
are<00:01:29.729><c> in</c><00:01:29.789><c> cells</c><00:01:30.270><c> D</c><00:01:30.780><c> 10</c><00:01:31.140><c> and</c><00:01:31.440><c> D</c><00:01:31.860><c> 11</c><00:01:32.340><c> so</c><00:01:32.909><c> we'll</c>

00:01:33.109 --> 00:01:33.119 align:start position:0%
are in cells D 10 and D 11 so we'll
 

00:01:33.119 --> 00:01:36.980 align:start position:0%
are in cells D 10 and D 11 so we'll
write<00:01:33.360><c> the</c><00:01:33.420><c> formula</c><00:01:34.020><c> this</c><00:01:34.229><c> way</c><00:01:34.470><c> D</c><00:01:35.220><c> 10</c><00:01:35.580><c> plus</c><00:01:36.299><c> D</c>

00:01:36.980 --> 00:01:36.990 align:start position:0%
write the formula this way D 10 plus D
 

00:01:36.990 --> 00:01:40.850 align:start position:0%
write the formula this way D 10 plus D
11<00:01:37.789><c> press</c><00:01:38.789><c> ENTER</c><00:01:39.179><c> on</c><00:01:39.209><c> your</c><00:01:39.360><c> keyboard</c><00:01:39.539><c> and</c><00:01:40.110><c> the</c>

00:01:40.850 --> 00:01:40.860 align:start position:0%
11 press ENTER on your keyboard and the
 

00:01:40.860 --> 00:01:43.789 align:start position:0%
11 press ENTER on your keyboard and the
formula<00:01:41.340><c> totals</c><00:01:41.759><c> the</c><00:01:41.970><c> numbers</c><00:01:42.299><c> in</c><00:01:42.539><c> D</c><00:01:42.869><c> 10</c><00:01:43.170><c> and</c><00:01:43.470><c> D</c>

00:01:43.789 --> 00:01:43.799 align:start position:0%
formula totals the numbers in D 10 and D
 

00:01:43.799 --> 00:01:45.980 align:start position:0%
formula totals the numbers in D 10 and D
11<00:01:44.159><c> whether</c><00:01:44.940><c> we</c><00:01:45.149><c> leave</c><00:01:45.360><c> them</c><00:01:45.539><c> the</c><00:01:45.690><c> way</c><00:01:45.810><c> they</c>

00:01:45.980 --> 00:01:45.990 align:start position:0%
11 whether we leave them the way they
 

00:01:45.990 --> 00:01:48.529 align:start position:0%
11 whether we leave them the way they
are<00:01:46.020><c> or</c><00:01:46.470><c> change</c><00:01:46.950><c> them</c><00:01:47.190><c> to</c><00:01:47.369><c> something</c><00:01:47.729><c> else</c><00:01:47.909><c> say</c>

00:01:48.529 --> 00:01:48.539 align:start position:0%
are or change them to something else say
 

00:01:48.539 --> 00:01:53.900 align:start position:0%
are or change them to something else say
500<00:01:49.500><c> and</c><00:01:50.239><c> 900</c><00:01:51.619><c> the</c><00:01:52.619><c> total</c><00:01:52.979><c> recalculates</c>

00:01:53.900 --> 00:01:53.910 align:start position:0%
500 and 900 the total recalculates
 

00:01:53.910 --> 00:01:56.960 align:start position:0%
500 and 900 the total recalculates
automatically<00:01:54.920><c> there's</c><00:01:55.920><c> an</c><00:01:56.129><c> even</c><00:01:56.459><c> easier</c><00:01:56.580><c> way</c>

00:01:56.960 --> 00:01:56.970 align:start position:0%
automatically there's an even easier way
 

00:01:56.970 --> 00:01:59.150 align:start position:0%
automatically there's an even easier way
to<00:01:57.149><c> make</c><00:01:57.300><c> cell</c><00:01:57.629><c> references</c><00:01:58.229><c> you'll</c><00:01:58.800><c> need</c><00:01:59.009><c> to</c>

00:01:59.150 --> 00:01:59.160 align:start position:0%
to make cell references you'll need to
 

00:01:59.160 --> 00:02:00.919 align:start position:0%
to make cell references you'll need to
use<00:01:59.190><c> something</c><00:01:59.819><c> called</c><00:01:59.849><c> the</c><00:02:00.209><c> point</c><00:02:00.479><c> and</c><00:02:00.660><c> click</c>

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

00:02:00.929 --> 00:02:02.719 align:start position:0%
use something called the point and click
method<00:02:01.050><c> why</c><00:02:01.950><c> don't</c><00:02:02.099><c> we</c><00:02:02.190><c> give</c><00:02:02.340><c> it</c><00:02:02.369><c> a</c><00:02:02.489><c> try</c><00:02:02.700><c> on</c>

00:02:02.719 --> 00:02:02.729 align:start position:0%
method why don't we give it a try on
 

00:02:02.729 --> 00:02:05.449 align:start position:0%
method why don't we give it a try on
this<00:02:03.269><c> formula</c><00:02:03.810><c> here</c><00:02:04.619><c> I</c><00:02:04.679><c> want</c><00:02:05.129><c> to</c><00:02:05.250><c> calculate</c>

00:02:05.449 --> 00:02:05.459 align:start position:0%
this formula here I want to calculate
 

00:02:05.459 --> 00:02:07.999 align:start position:0%
this formula here I want to calculate
the<00:02:05.910><c> cost</c><00:02:06.090><c> of</c><00:02:06.390><c> supplies</c><00:02:06.750><c> that</c><00:02:07.140><c> means</c><00:02:07.709><c> I'll</c>

00:02:07.999 --> 00:02:08.009 align:start position:0%
the cost of supplies that means I'll
 

00:02:08.009 --> 00:02:09.949 align:start position:0%
the cost of supplies that means I'll
need<00:02:08.190><c> to</c><00:02:08.369><c> multiply</c><00:02:08.489><c> the</c><00:02:08.879><c> two</c><00:02:09.209><c> numbers</c><00:02:09.390><c> you</c><00:02:09.720><c> see</c>

00:02:09.949 --> 00:02:09.959 align:start position:0%
need to multiply the two numbers you see
 

00:02:09.959 --> 00:02:14.030 align:start position:0%
need to multiply the two numbers you see
here<00:02:10.349><c> 15</c><00:02:11.250><c> times</c><00:02:11.819><c> eight</c><00:02:12.060><c> point</c><00:02:12.540><c> seven</c><00:02:12.840><c> five</c><00:02:13.260><c> so</c>

00:02:14.030 --> 00:02:14.040 align:start position:0%
here 15 times eight point seven five so
 

00:02:14.040 --> 00:02:16.850 align:start position:0%
here 15 times eight point seven five so
I'll<00:02:14.250><c> start</c><00:02:14.580><c> my</c><00:02:14.700><c> equation</c><00:02:15.269><c> then</c><00:02:16.140><c> just</c><00:02:16.530><c> click</c>

00:02:16.850 --> 00:02:16.860 align:start position:0%
I'll start my equation then just click
 

00:02:16.860 --> 00:02:19.430 align:start position:0%
I'll start my equation then just click
this<00:02:17.069><c> cell</c><00:02:17.370><c> to</c><00:02:17.700><c> make</c><00:02:17.879><c> reference</c><00:02:18.090><c> to</c><00:02:18.390><c> it</c><00:02:18.540><c> now</c>

00:02:19.430 --> 00:02:19.440 align:start position:0%
this cell to make reference to it now
 

00:02:19.440 --> 00:02:21.800 align:start position:0%
this cell to make reference to it now
type<00:02:19.800><c> your</c><00:02:19.980><c> operator</c><00:02:20.489><c> in</c><00:02:20.790><c> my</c><00:02:21.300><c> case</c><00:02:21.569><c> an</c>

00:02:21.800 --> 00:02:21.810 align:start position:0%
type your operator in my case an
 

00:02:21.810 --> 00:02:24.800 align:start position:0%
type your operator in my case an
asterisk<00:02:22.560><c> and</c><00:02:22.910><c> click</c><00:02:23.910><c> the</c><00:02:24.060><c> next</c><00:02:24.390><c> cell</c><00:02:24.569><c> you</c>

00:02:24.800 --> 00:02:24.810 align:start position:0%
asterisk and click the next cell you
 

00:02:24.810 --> 00:02:28.009 align:start position:0%
asterisk and click the next cell you
want<00:02:25.019><c> your</c><00:02:25.200><c> formula</c><00:02:25.709><c> press</c><00:02:26.550><c> ENTER</c><00:02:27.000><c> and</c><00:02:27.239><c> the</c>

00:02:28.009 --> 00:02:28.019 align:start position:0%
want your formula press ENTER and the
 

00:02:28.019 --> 00:02:31.070 align:start position:0%
want your formula press ENTER and the
total<00:02:28.349><c> appears</c><00:02:28.940><c> editing</c><00:02:29.940><c> formulas</c><00:02:30.510><c> is</c><00:02:30.690><c> also</c>

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

00:02:31.080 --> 00:02:33.110 align:start position:0%
total appears editing formulas is also
just<00:02:31.319><c> a</c><00:02:31.440><c> click</c><00:02:31.650><c> away</c><00:02:31.680><c> if</c><00:02:32.190><c> you</c><00:02:32.700><c> have</c><00:02:32.940><c> any</c>

00:02:33.110 --> 00:02:33.120 align:start position:0%
just a click away if you have any
 

00:02:33.120 --> 00:02:35.420 align:start position:0%
just a click away if you have any
formulas<00:02:33.659><c> that</c><00:02:33.690><c> you</c><00:02:33.870><c> want</c><00:02:34.170><c> to</c><00:02:34.319><c> fix</c><00:02:34.590><c> or</c><00:02:34.890><c> modify</c>

00:02:35.420 --> 00:02:35.430 align:start position:0%
formulas that you want to fix or modify
 

00:02:35.430 --> 00:02:37.640 align:start position:0%
formulas that you want to fix or modify
all<00:02:35.730><c> you</c><00:02:36.060><c> have</c><00:02:36.239><c> to</c><00:02:36.390><c> do</c><00:02:36.540><c> is</c><00:02:36.780><c> double</c><00:02:37.230><c> click</c><00:02:37.260><c> the</c>

00:02:37.640 --> 00:02:37.650 align:start position:0%
all you have to do is double click the
 

00:02:37.650 --> 00:02:41.030 align:start position:0%
all you have to do is double click the
cell<00:02:38.269><c> for</c><00:02:39.269><c> example</c><00:02:39.840><c> this</c><00:02:40.260><c> one</c><00:02:40.470><c> is</c><00:02:40.500><c> using</c><00:02:40.800><c> the</c>

00:02:41.030 --> 00:02:41.040 align:start position:0%
cell for example this one is using the
 

00:02:41.040 --> 00:02:43.399 align:start position:0%
cell for example this one is using the
wrong<00:02:41.250><c> cell</c><00:02:41.700><c> reference</c><00:02:42.150><c> we'll</c><00:02:42.780><c> just</c><00:02:43.050><c> make</c><00:02:43.260><c> the</c>

00:02:43.399 --> 00:02:43.409 align:start position:0%
wrong cell reference we'll just make the
 

00:02:43.409 --> 00:02:46.869 align:start position:0%
wrong cell reference we'll just make the
change<00:02:44.030><c> then</c><00:02:45.030><c> press</c><00:02:45.300><c> ENTER</c><00:02:45.720><c> to</c><00:02:45.989><c> recalculate</c>

00:02:46.869 --> 00:02:46.879 align:start position:0%
change then press ENTER to recalculate
 

00:02:46.879 --> 00:02:49.250 align:start position:0%
change then press ENTER to recalculate
now<00:02:47.879><c> we're</c><00:02:48.060><c> getting</c><00:02:48.300><c> the</c><00:02:48.420><c> correct</c><00:02:48.629><c> answer</c><00:02:49.050><c> as</c>

00:02:49.250 --> 00:02:49.260 align:start position:0%
now we're getting the correct answer as
 

00:02:49.260 --> 00:02:52.309 align:start position:0%
now we're getting the correct answer as
you<00:02:49.890><c> can</c><00:02:50.220><c> see</c><00:02:50.459><c> simple</c><00:02:51.030><c> formulas</c><00:02:51.659><c> are</c><00:02:51.900><c> really</c>

00:02:52.309 --> 00:02:52.319 align:start position:0%
you can see simple formulas are really
 

00:02:52.319 --> 00:02:54.319 align:start position:0%
you can see simple formulas are really
pretty<00:02:52.530><c> simple</c><00:02:52.799><c> once</c><00:02:53.489><c> you</c><00:02:53.579><c> know</c><00:02:53.700><c> how</c><00:02:54.030><c> to</c><00:02:54.090><c> use</c>

00:02:54.319 --> 00:02:54.329 align:start position:0%
pretty simple once you know how to use
 

00:02:54.329 --> 00:02:56.119 align:start position:0%
pretty simple once you know how to use
them<00:02:54.599><c> they</c><00:02:54.930><c> can</c><00:02:55.109><c> help</c><00:02:55.230><c> you</c><00:02:55.409><c> calculate</c><00:02:55.950><c> all</c>

00:02:56.119 --> 00:02:56.129 align:start position:0%
them they can help you calculate all
 

00:02:56.129 --> 00:03:02.310 align:start position:0%
them they can help you calculate all
kinds<00:02:56.609><c> of</c><00:02:56.700><c> data</c><00:02:56.879><c> in</c><00:02:57.150><c> your</c><00:02:57.299><c> spreadsheets</c>

00:03:02.310 --> 00:03:02.320 align:start position:0%
 
 

00:03:02.320 --> 00:03:06.040 align:start position:0%
 
GCF<00:03:03.320><c> global</c><00:03:04.000><c> creating</c><00:03:05.000><c> opportunities</c><00:03:05.690><c> for</c><00:03:05.720><c> a</c>

00:03:06.040 --> 00:03:06.050 align:start position:0%
GCF global creating opportunities for a
 

00:03:06.050 --> 00:03:08.380 align:start position:0%
GCF global creating opportunities for a
better<00:03:06.140><c> life</c>