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.520><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:07.130 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.570><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:04.020><c> life</c>

00:00:07.130 --> 00:00:07.140 align:start position:0%
 
 

00:00:07.140 --> 00:00:09.630 align:start position:0%
 
sometimes<00:00:08.140><c> trying</c><00:00:08.710><c> to</c><00:00:08.800><c> write</c><00:00:08.980><c> a</c><00:00:09.010><c> formula</c><00:00:09.280><c> can</c>

00:00:09.630 --> 00:00:09.640 align:start position:0%
sometimes trying to write a formula can
 

00:00:09.640 --> 00:00:11.370 align:start position:0%
sometimes trying to write a formula can
be<00:00:09.760><c> a</c><00:00:09.790><c> bit</c><00:00:10.000><c> like</c><00:00:10.240><c> traveling</c><00:00:10.840><c> without</c><00:00:10.960><c> a</c><00:00:11.139><c> map</c>

00:00:11.370 --> 00:00:11.380 align:start position:0%
be a bit like traveling without a map
 

00:00:11.380 --> 00:00:13.770 align:start position:0%
be a bit like traveling without a map
how<00:00:12.190><c> exactly</c><00:00:12.670><c> do</c><00:00:12.850><c> you</c><00:00:12.910><c> take</c><00:00:13.120><c> a</c><00:00:13.150><c> problem</c><00:00:13.420><c> from</c>

00:00:13.770 --> 00:00:13.780 align:start position:0%
how exactly do you take a problem from
 

00:00:13.780 --> 00:00:15.539 align:start position:0%
how exactly do you take a problem from
real<00:00:14.020><c> life</c><00:00:14.080><c> and</c><00:00:14.620><c> turn</c><00:00:14.980><c> it</c><00:00:15.100><c> into</c><00:00:15.250><c> something</c>

00:00:15.539 --> 00:00:15.549 align:start position:0%
real life and turn it into something
 

00:00:15.549 --> 00:00:18.210 align:start position:0%
real life and turn it into something
that<00:00:15.700><c> Excel</c><00:00:16.120><c> can</c><00:00:16.150><c> solve</c><00:00:16.800><c> what</c><00:00:17.800><c> you</c><00:00:17.920><c> might</c><00:00:18.100><c> not</c>

00:00:18.210 --> 00:00:18.220 align:start position:0%
that Excel can solve what you might not
 

00:00:18.220 --> 00:00:20.040 align:start position:0%
that Excel can solve what you might not
realize<00:00:18.280><c> is</c><00:00:18.940><c> that</c><00:00:19.000><c> you</c><00:00:19.300><c> already</c><00:00:19.539><c> have</c><00:00:19.930><c> the</c>

00:00:20.040 --> 00:00:20.050 align:start position:0%
realize is that you already have the
 

00:00:20.050 --> 00:00:22.350 align:start position:0%
realize is that you already have the
skills<00:00:20.320><c> you</c><00:00:20.470><c> need</c><00:00:20.619><c> to</c><00:00:20.680><c> get</c><00:00:20.920><c> there</c><00:00:21.190><c> with</c><00:00:22.090><c> some</c>

00:00:22.350 --> 00:00:22.360 align:start position:0%
skills you need to get there with some
 

00:00:22.360 --> 00:00:25.140 align:start position:0%
skills you need to get there with some
planning<00:00:22.630><c> some</c><00:00:23.440><c> basic</c><00:00:23.800><c> math</c><00:00:24.070><c> and</c><00:00:24.370><c> a</c><00:00:24.910><c> little</c>

00:00:25.140 --> 00:00:25.150 align:start position:0%
planning some basic math and a little
 

00:00:25.150 --> 00:00:27.330 align:start position:0%
planning some basic math and a little
knowledge<00:00:25.300><c> of</c><00:00:25.570><c> how</c><00:00:25.750><c> formulas</c><00:00:26.230><c> work</c><00:00:26.470><c> you</c><00:00:27.160><c> can</c>

00:00:27.330 --> 00:00:27.340 align:start position:0%
knowledge of how formulas work you can
 

00:00:27.340 --> 00:00:30.290 align:start position:0%
knowledge of how formulas work you can
get<00:00:27.460><c> a</c><00:00:27.520><c> lot</c><00:00:27.760><c> farther</c><00:00:27.970><c> than</c><00:00:28.180><c> you</c><00:00:28.390><c> might</c><00:00:28.540><c> think</c>

00:00:30.290 --> 00:00:30.300 align:start position:0%
get a lot farther than you might think
 

00:00:30.300 --> 00:00:32.940 align:start position:0%
get a lot farther than you might think
say<00:00:31.300><c> you're</c><00:00:31.540><c> at</c><00:00:31.660><c> work</c><00:00:31.840><c> and</c><00:00:32.110><c> your</c><00:00:32.439><c> boss</c><00:00:32.469><c> comes</c>

00:00:32.940 --> 00:00:32.950 align:start position:0%
say you're at work and your boss comes
 

00:00:32.950 --> 00:00:35.100 align:start position:0%
say you're at work and your boss comes
to<00:00:33.040><c> you</c><00:00:33.219><c> with</c><00:00:33.309><c> a</c><00:00:33.370><c> problem</c><00:00:33.690><c> apparently</c><00:00:34.690><c> there's</c>

00:00:35.100 --> 00:00:35.110 align:start position:0%
to you with a problem apparently there's
 

00:00:35.110 --> 00:00:37.830 align:start position:0%
to you with a problem apparently there's
an<00:00:35.230><c> event</c><00:00:35.410><c> coming</c><00:00:35.559><c> up</c><00:00:35.920><c> and</c><00:00:36.329><c> 614</c><00:00:37.329><c> people</c><00:00:37.690><c> have</c>

00:00:37.830 --> 00:00:37.840 align:start position:0%
an event coming up and 614 people have
 

00:00:37.840 --> 00:00:39.560 align:start position:0%
an event coming up and 614 people have
already<00:00:38.290><c> RSVP'd</c>

00:00:39.560 --> 00:00:39.570 align:start position:0%
already RSVP'd
 

00:00:39.570 --> 00:00:42.780 align:start position:0%
already RSVP'd
unfortunately<00:00:40.570><c> the</c><00:00:40.750><c> venue</c><00:00:41.079><c> only</c><00:00:41.380><c> seats</c><00:00:41.790><c> 550</c>

00:00:42.780 --> 00:00:42.790 align:start position:0%
unfortunately the venue only seats 550
 

00:00:42.790 --> 00:00:44.970 align:start position:0%
unfortunately the venue only seats 550
so<00:00:43.600><c> how</c><00:00:43.810><c> many</c><00:00:43.870><c> folding</c><00:00:44.380><c> chairs</c><00:00:44.590><c> are</c><00:00:44.739><c> we</c><00:00:44.829><c> going</c>

00:00:44.970 --> 00:00:44.980 align:start position:0%
so how many folding chairs are we going
 

00:00:44.980 --> 00:00:47.120 align:start position:0%
so how many folding chairs are we going
to<00:00:45.070><c> need</c><00:00:45.220><c> to</c><00:00:45.400><c> seat</c><00:00:45.610><c> all</c><00:00:45.790><c> the</c><00:00:45.850><c> extra</c><00:00:46.390><c> guests</c>

00:00:47.120 --> 00:00:47.130 align:start position:0%
to need to seat all the extra guests
 

00:00:47.130 --> 00:00:49.770 align:start position:0%
to need to seat all the extra guests
like<00:00:48.130><c> a</c><00:00:48.160><c> lot</c><00:00:48.430><c> of</c><00:00:48.550><c> real</c><00:00:48.730><c> life</c><00:00:48.880><c> problems</c><00:00:49.390><c> there's</c>

00:00:49.770 --> 00:00:49.780 align:start position:0%
like a lot of real life problems there's
 

00:00:49.780 --> 00:00:51.510 align:start position:0%
like a lot of real life problems there's
actually<00:00:50.170><c> enough</c><00:00:50.410><c> data</c><00:00:50.680><c> here</c><00:00:51.010><c> to</c><00:00:51.190><c> turn</c><00:00:51.370><c> this</c>

00:00:51.510 --> 00:00:51.520 align:start position:0%
actually enough data here to turn this
 

00:00:51.520 --> 00:00:54.120 align:start position:0%
actually enough data here to turn this
into<00:00:51.760><c> a</c><00:00:51.910><c> math</c><00:00:52.270><c> problem</c><00:00:52.720><c> you</c><00:00:52.899><c> could</c><00:00:53.649><c> even</c><00:00:53.860><c> think</c>

00:00:54.120 --> 00:00:54.130 align:start position:0%
into a math problem you could even think
 

00:00:54.130 --> 00:00:56.400 align:start position:0%
into a math problem you could even think
of<00:00:54.250><c> it</c><00:00:54.370><c> as</c><00:00:54.520><c> a</c><00:00:54.550><c> word</c><00:00:54.790><c> problem</c><00:00:55.170><c> remember</c><00:00:56.170><c> doing</c>

00:00:56.400 --> 00:00:56.410 align:start position:0%
of it as a word problem remember doing
 

00:00:56.410 --> 00:00:59.160 align:start position:0%
of it as a word problem remember doing
those<00:00:56.560><c> in</c><00:00:56.739><c> school</c><00:00:57.040><c> so-and-so</c><00:00:57.940><c> has</c><00:00:58.420><c> 14</c><00:00:58.809><c> apples</c>

00:00:59.160 --> 00:00:59.170 align:start position:0%
those in school so-and-so has 14 apples
 

00:00:59.170 --> 00:01:01.200 align:start position:0%
those in school so-and-so has 14 apples
she<00:00:59.440><c> gives</c><00:00:59.680><c> five</c><00:01:00.010><c> of</c><00:01:00.190><c> them</c><00:01:00.309><c> away</c><00:01:00.550><c> you</c><00:01:00.790><c> know</c><00:01:01.120><c> the</c>

00:01:01.200 --> 00:01:01.210 align:start position:0%
she gives five of them away you know the
 

00:01:01.210 --> 00:01:04.259 align:start position:0%
she gives five of them away you know the
rest<00:01:01.800><c> when</c><00:01:02.800><c> it</c><00:01:02.829><c> comes</c><00:01:03.100><c> down</c><00:01:03.309><c> to</c><00:01:03.370><c> it</c><00:01:03.640><c> all</c><00:01:03.880><c> we</c>

00:01:04.259 --> 00:01:04.269 align:start position:0%
rest when it comes down to it all we
 

00:01:04.269 --> 00:01:05.550 align:start position:0%
rest when it comes down to it all we
have<00:01:04.479><c> here</c><00:01:04.719><c> is</c><00:01:04.780><c> a</c><00:01:04.960><c> simple</c><00:01:05.259><c> subtraction</c>

00:01:05.550 --> 00:01:05.560 align:start position:0%
have here is a simple subtraction
 

00:01:05.560 --> 00:01:08.010 align:start position:0%
have here is a simple subtraction
problem<00:01:06.369><c> one</c><00:01:06.969><c> that</c><00:01:07.119><c> you</c><00:01:07.240><c> might</c><00:01:07.479><c> even</c><00:01:07.509><c> be</c><00:01:07.930><c> able</c>

00:01:08.010 --> 00:01:08.020 align:start position:0%
problem one that you might even be able
 

00:01:08.020 --> 00:01:10.320 align:start position:0%
problem one that you might even be able
to<00:01:08.200><c> solve</c><00:01:08.439><c> in</c><00:01:08.619><c> your</c><00:01:08.770><c> head</c><00:01:08.950><c> just</c><00:01:09.210><c> take</c><00:01:10.210><c> the</c>

00:01:10.320 --> 00:01:10.330 align:start position:0%
to solve in your head just take the
 

00:01:10.330 --> 00:01:12.600 align:start position:0%
to solve in your head just take the
number<00:01:10.600><c> of</c><00:01:10.720><c> people</c><00:01:10.900><c> coming</c><00:01:11.400><c> subtract</c><00:01:12.400><c> the</c>

00:01:12.600 --> 00:01:12.610 align:start position:0%
number of people coming subtract the
 

00:01:12.610 --> 00:01:14.789 align:start position:0%
number of people coming subtract the
number<00:01:12.850><c> of</c><00:01:12.880><c> seats</c><00:01:13.180><c> at</c><00:01:13.360><c> the</c><00:01:13.450><c> venue</c><00:01:13.750><c> and</c><00:01:13.990><c> that</c>

00:01:14.789 --> 00:01:14.799 align:start position:0%
number of seats at the venue and that
 

00:01:14.799 --> 00:01:18.899 align:start position:0%
number of seats at the venue and that
will<00:01:14.890><c> give</c><00:01:15.010><c> us</c><00:01:15.130><c> our</c><00:01:15.250><c> answer</c><00:01:16.200><c> now</c><00:01:17.200><c> watch</c><00:01:17.909><c> we're</c>

00:01:18.899 --> 00:01:18.909 align:start position:0%
will give us our answer now watch we're
 

00:01:18.909 --> 00:01:20.460 align:start position:0%
will give us our answer now watch we're
going<00:01:19.060><c> to</c><00:01:19.150><c> move</c><00:01:19.299><c> the</c><00:01:19.479><c> equal</c><00:01:19.870><c> sign</c><00:01:20.110><c> to</c><00:01:20.320><c> the</c>

00:01:20.460 --> 00:01:20.470 align:start position:0%
going to move the equal sign to the
 

00:01:20.470 --> 00:01:22.770 align:start position:0%
going to move the equal sign to the
beginning<00:01:20.890><c> and</c><00:01:21.040><c> with</c><00:01:21.850><c> this</c><00:01:22.030><c> one</c><00:01:22.330><c> tiny</c><00:01:22.630><c> change</c>

00:01:22.770 --> 00:01:22.780 align:start position:0%
beginning and with this one tiny change
 

00:01:22.780 --> 00:01:25.020 align:start position:0%
beginning and with this one tiny change
it's<00:01:23.409><c> now</c><00:01:23.680><c> in</c><00:01:23.890><c> a</c><00:01:23.950><c> format</c><00:01:24.340><c> that</c><00:01:24.400><c> Excel</c><00:01:24.850><c> can</c>

00:01:25.020 --> 00:01:25.030 align:start position:0%
it's now in a format that Excel can
 

00:01:25.030 --> 00:01:27.630 align:start position:0%
it's now in a format that Excel can
understand<00:01:25.590><c> for</c><00:01:26.590><c> bonus</c><00:01:26.920><c> points</c><00:01:26.950><c> you</c><00:01:27.520><c> could</c>

00:01:27.630 --> 00:01:27.640 align:start position:0%
understand for bonus points you could
 

00:01:27.640 --> 00:01:29.039 align:start position:0%
understand for bonus points you could
even<00:01:27.820><c> change</c><00:01:28.060><c> the</c><00:01:28.330><c> numbers</c><00:01:28.630><c> to</c><00:01:28.659><c> cell</c>

00:01:29.039 --> 00:01:29.049 align:start position:0%
even change the numbers to cell
 

00:01:29.049 --> 00:01:32.760 align:start position:0%
even change the numbers to cell
references<00:01:29.590><c> see</c><00:01:30.400><c> how</c><00:01:30.520><c> it</c><00:01:30.670><c> works</c><00:01:31.530><c> let's</c><00:01:32.530><c> take</c><00:01:32.619><c> a</c>

00:01:32.760 --> 00:01:32.770 align:start position:0%
references see how it works let's take a
 

00:01:32.770 --> 00:01:35.880 align:start position:0%
references see how it works let's take a
look<00:01:32.950><c> at</c><00:01:33.040><c> the</c><00:01:33.130><c> answer</c><00:01:34.530><c> looks</c><00:01:35.530><c> like</c><00:01:35.710><c> we're</c>

00:01:35.880 --> 00:01:35.890 align:start position:0%
look at the answer looks like we're
 

00:01:35.890 --> 00:01:38.130 align:start position:0%
look at the answer looks like we're
going<00:01:36.010><c> to</c><00:01:36.070><c> need</c><00:01:36.220><c> 64</c><00:01:36.820><c> extra</c><00:01:37.479><c> folding</c><00:01:37.869><c> chairs</c>

00:01:38.130 --> 00:01:38.140 align:start position:0%
going to need 64 extra folding chairs
 

00:01:38.140 --> 00:01:40.950 align:start position:0%
going to need 64 extra folding chairs
and<00:01:38.409><c> because</c><00:01:39.280><c> we</c><00:01:39.430><c> used</c><00:01:39.640><c> cell</c><00:01:39.970><c> references</c><00:01:40.540><c> we</c>

00:01:40.950 --> 00:01:40.960 align:start position:0%
and because we used cell references we
 

00:01:40.960 --> 00:01:42.179 align:start position:0%
and because we used cell references we
can<00:01:41.110><c> change</c><00:01:41.320><c> the</c><00:01:41.530><c> number</c><00:01:41.799><c> of</c><00:01:41.830><c> people</c>

00:01:42.179 --> 00:01:42.189 align:start position:0%
can change the number of people
 

00:01:42.189 --> 00:01:44.580 align:start position:0%
can change the number of people
attending<00:01:42.310><c> and</c><00:01:42.930><c> the</c><00:01:43.930><c> answer</c><00:01:44.260><c> will</c><00:01:44.409><c> update</c>

00:01:44.580 --> 00:01:44.590 align:start position:0%
attending and the answer will update
 

00:01:44.590 --> 00:01:49.230 align:start position:0%
attending and the answer will update
automatically<00:01:47.700><c> sometimes</c><00:01:48.700><c> getting</c><00:01:48.970><c> from</c>

00:01:49.230 --> 00:01:49.240 align:start position:0%
automatically sometimes getting from
 

00:01:49.240 --> 00:01:51.270 align:start position:0%
automatically sometimes getting from
problem<00:01:49.720><c> to</c><00:01:49.750><c> formula</c><00:01:50.409><c> is</c><00:01:50.590><c> easier</c><00:01:51.100><c> than</c><00:01:51.220><c> you</c>

00:01:51.270 --> 00:01:51.280 align:start position:0%
problem to formula is easier than you
 

00:01:51.280 --> 00:01:52.999 align:start position:0%
problem to formula is easier than you
thought<00:01:51.520><c> it</c><00:01:51.670><c> would</c><00:01:51.700><c> be</c><00:01:51.820><c> like</c><00:01:52.450><c> you</c><00:01:52.570><c> just</c><00:01:52.750><c> saw</c>

00:01:52.999 --> 00:01:53.009 align:start position:0%
thought it would be like you just saw
 

00:01:53.009 --> 00:01:55.530 align:start position:0%
thought it would be like you just saw
then<00:01:54.009><c> there</c><00:01:54.250><c> are</c><00:01:54.369><c> times</c><00:01:54.610><c> when</c><00:01:54.850><c> you</c><00:01:54.970><c> get</c><00:01:55.150><c> stuck</c>

00:01:55.530 --> 00:01:55.540 align:start position:0%
then there are times when you get stuck
 

00:01:55.540 --> 00:01:57.149 align:start position:0%
then there are times when you get stuck
somewhere<00:01:55.780><c> in</c><00:01:55.930><c> the</c><00:01:56.080><c> process</c><00:01:56.259><c> and</c><00:01:56.770><c> you're</c><00:01:57.009><c> not</c>

00:01:57.149 --> 00:01:57.159 align:start position:0%
somewhere in the process and you're not
 

00:01:57.159 --> 00:01:59.880 align:start position:0%
somewhere in the process and you're not
sure<00:01:57.430><c> how</c><00:01:57.610><c> to</c><00:01:57.670><c> continue</c><00:01:58.229><c> the</c><00:01:59.229><c> important</c><00:01:59.740><c> thing</c>

00:01:59.880 --> 00:01:59.890 align:start position:0%
sure how to continue the important thing
 

00:01:59.890 --> 00:02:01.710 align:start position:0%
sure how to continue the important thing
to<00:01:59.920><c> remember</c><00:02:00.189><c> is</c><00:02:00.520><c> that</c><00:02:00.729><c> you're</c><00:02:00.880><c> still</c><00:02:01.210><c> most</c><00:02:01.540><c> of</c>

00:02:01.710 --> 00:02:01.720 align:start position:0%
to remember is that you're still most of
 

00:02:01.720 --> 00:02:03.390 align:start position:0%
to remember is that you're still most of
the<00:02:01.810><c> way</c><00:02:01.930><c> there</c><00:02:01.960><c> even</c><00:02:02.799><c> if</c><00:02:02.920><c> you're</c><00:02:03.040><c> feeling</c>

00:02:03.390 --> 00:02:03.400 align:start position:0%
the way there even if you're feeling
 

00:02:03.400 --> 00:02:05.490 align:start position:0%
the way there even if you're feeling
unsure<00:02:03.759><c> you</c><00:02:04.030><c> just</c><00:02:04.900><c> have</c><00:02:05.049><c> to</c><00:02:05.170><c> break</c><00:02:05.320><c> the</c>

00:02:05.490 --> 00:02:05.500 align:start position:0%
unsure you just have to break the
 

00:02:05.500 --> 00:02:08.490 align:start position:0%
unsure you just have to break the
problem<00:02:05.710><c> down</c><00:02:05.920><c> into</c><00:02:06.400><c> more</c><00:02:06.670><c> manageable</c><00:02:06.729><c> chunks</c>

00:02:08.490 --> 00:02:08.500 align:start position:0%
problem down into more manageable chunks
 

00:02:08.500 --> 00:02:11.670 align:start position:0%
problem down into more manageable chunks
say<00:02:09.310><c> you're</c><00:02:09.670><c> this</c><00:02:10.240><c> guy</c><00:02:10.450><c> and</c><00:02:10.810><c> you've</c><00:02:11.500><c> been</c>

00:02:11.670 --> 00:02:11.680 align:start position:0%
say you're this guy and you've been
 

00:02:11.680 --> 00:02:12.990 align:start position:0%
say you're this guy and you've been
thinking<00:02:11.860><c> a</c><00:02:12.100><c> lot</c><00:02:12.130><c> about</c><00:02:12.310><c> your</c><00:02:12.610><c> finances</c>

00:02:12.990 --> 00:02:13.000 align:start position:0%
thinking a lot about your finances
 

00:02:13.000 --> 00:02:15.330 align:start position:0%
thinking a lot about your finances
lately<00:02:13.510><c> you</c><00:02:14.290><c> want</c><00:02:14.500><c> to</c><00:02:14.560><c> save</c><00:02:14.740><c> up</c><00:02:14.890><c> enough</c><00:02:14.980><c> money</c>

00:02:15.330 --> 00:02:15.340 align:start position:0%
lately you want to save up enough money
 

00:02:15.340 --> 00:02:18.390 align:start position:0%
lately you want to save up enough money
to<00:02:15.490><c> buy</c><00:02:15.790><c> a</c><00:02:15.820><c> brand-new</c><00:02:16.390><c> totally</c><00:02:17.020><c> awesome</c><00:02:17.440><c> jet</c>

00:02:18.390 --> 00:02:18.400 align:start position:0%
to buy a brand-new totally awesome jet
 

00:02:18.400 --> 00:02:23.120 align:start position:0%
to buy a brand-new totally awesome jet
ski<00:02:19.740><c> here's</c><00:02:20.740><c> the</c><00:02:20.980><c> problem</c><00:02:21.370><c> the</c><00:02:22.300><c> jet</c><00:02:22.540><c> ski</c><00:02:22.750><c> cost</c>

00:02:23.120 --> 00:02:23.130 align:start position:0%
ski here's the problem the jet ski cost
 

00:02:23.130 --> 00:02:25.650 align:start position:0%
ski here's the problem the jet ski cost
$6,000<00:02:24.130><c> you're</c><00:02:24.760><c> planning</c><00:02:25.120><c> to</c><00:02:25.150><c> raise</c><00:02:25.420><c> the</c>

00:02:25.650 --> 00:02:25.660 align:start position:0%
$6,000 you're planning to raise the
 

00:02:25.660 --> 00:02:27.750 align:start position:0%
$6,000 you're planning to raise the
money<00:02:25.840><c> over</c><00:02:26.050><c> time</c><00:02:26.410><c> by</c><00:02:26.830><c> saving</c><00:02:27.100><c> a</c><00:02:27.280><c> hundred</c><00:02:27.610><c> and</c>

00:02:27.750 --> 00:02:27.760 align:start position:0%
money over time by saving a hundred and
 

00:02:27.760 --> 00:02:30.090 align:start position:0%
money over time by saving a hundred and
ten<00:02:27.910><c> dollars</c><00:02:28.300><c> each</c><00:02:28.480><c> month</c><00:02:28.590><c> how</c><00:02:29.590><c> many</c><00:02:29.800><c> years</c>

00:02:30.090 --> 00:02:30.100 align:start position:0%
ten dollars each month how many years
 

00:02:30.100 --> 00:02:32.180 align:start position:0%
ten dollars each month how many years
will<00:02:30.280><c> it</c><00:02:30.310><c> take</c><00:02:30.610><c> to</c><00:02:30.790><c> save</c><00:02:31.000><c> the</c><00:02:31.150><c> full</c><00:02:31.330><c> amount</c>

00:02:32.180 --> 00:02:32.190 align:start position:0%
will it take to save the full amount
 

00:02:32.190 --> 00:02:34.410 align:start position:0%
will it take to save the full amount
even<00:02:33.190><c> at</c><00:02:33.310><c> a</c><00:02:33.340><c> glance</c><00:02:33.520><c> you</c><00:02:33.790><c> can</c><00:02:33.940><c> tell</c><00:02:34.270><c> this</c>

00:02:34.410 --> 00:02:34.420 align:start position:0%
even at a glance you can tell this
 

00:02:34.420 --> 00:02:35.910 align:start position:0%
even at a glance you can tell this
problem<00:02:34.810><c> is</c><00:02:34.930><c> a</c><00:02:34.960><c> little</c><00:02:35.290><c> different</c><00:02:35.650><c> from</c><00:02:35.740><c> the</c>

00:02:35.910 --> 00:02:35.920 align:start position:0%
problem is a little different from the
 

00:02:35.920 --> 00:02:38.520 align:start position:0%
problem is a little different from the
last<00:02:36.070><c> example</c><00:02:36.310><c> for</c><00:02:36.850><c> one</c><00:02:37.600><c> it's</c><00:02:38.050><c> going</c><00:02:38.260><c> to</c><00:02:38.320><c> take</c>

00:02:38.520 --> 00:02:38.530 align:start position:0%
last example for one it's going to take
 

00:02:38.530 --> 00:02:40.230 align:start position:0%
last example for one it's going to take
more<00:02:38.770><c> than</c><00:02:38.950><c> a</c><00:02:39.040><c> simple</c><00:02:39.370><c> subtraction</c><00:02:39.580><c> formula</c>

00:02:40.230 --> 00:02:40.240 align:start position:0%
more than a simple subtraction formula
 

00:02:40.240 --> 00:02:41.900 align:start position:0%
more than a simple subtraction formula
to<00:02:40.570><c> figure</c><00:02:40.720><c> it</c><00:02:40.959><c> out</c>

00:02:41.900 --> 00:02:41.910 align:start position:0%
to figure it out
 

00:02:41.910 --> 00:02:45.840 align:start position:0%
to figure it out
let's<00:02:42.910><c> try</c><00:02:43.180><c> breaking</c><00:02:43.600><c> it</c><00:02:43.720><c> down</c><00:02:43.870><c> instead</c><00:02:44.850><c> we</c>

00:02:45.840 --> 00:02:45.850 align:start position:0%
let's try breaking it down instead we
 

00:02:45.850 --> 00:02:47.880 align:start position:0%
let's try breaking it down instead we
are<00:02:46.090><c> talking</c><00:02:46.600><c> about</c><00:02:46.810><c> how</c><00:02:47.020><c> many</c><00:02:47.080><c> years</c><00:02:47.470><c> this</c><00:02:47.740><c> is</c>

00:02:47.880 --> 00:02:47.890 align:start position:0%
are talking about how many years this is
 

00:02:47.890 --> 00:02:49.830 align:start position:0%
are talking about how many years this is
going<00:02:48.040><c> to</c><00:02:48.130><c> take</c><00:02:48.340><c> maybe</c><00:02:49.150><c> we</c><00:02:49.360><c> should</c><00:02:49.570><c> figure</c><00:02:49.720><c> out</c>

00:02:49.830 --> 00:02:49.840 align:start position:0%
going to take maybe we should figure out
 

00:02:49.840 --> 00:02:51.810 align:start position:0%
going to take maybe we should figure out
how<00:02:50.080><c> much</c><00:02:50.200><c> we</c><00:02:50.410><c> can</c><00:02:50.560><c> save</c><00:02:50.830><c> in</c><00:02:50.980><c> a</c><00:02:51.070><c> year</c><00:02:51.310><c> based</c><00:02:51.640><c> on</c>

00:02:51.810 --> 00:02:51.820 align:start position:0%
how much we can save in a year based on
 

00:02:51.820 --> 00:02:54.300 align:start position:0%
how much we can save in a year based on
what<00:02:52.030><c> we're</c><00:02:52.150><c> setting</c><00:02:52.450><c> aside</c><00:02:52.690><c> each</c><00:02:52.900><c> month</c><00:02:53.310><c> the</c>

00:02:54.300 --> 00:02:54.310 align:start position:0%
what we're setting aside each month the
 

00:02:54.310 --> 00:02:56.120 align:start position:0%
what we're setting aside each month the
formula<00:02:54.790><c> might</c><00:02:54.970><c> look</c><00:02:55.120><c> something</c><00:02:55.330><c> like</c><00:02:55.540><c> this</c>

00:02:56.120 --> 00:02:56.130 align:start position:0%
formula might look something like this
 

00:02:56.130 --> 00:02:58.590 align:start position:0%
formula might look something like this
monthly<00:02:57.130><c> savings</c><00:02:57.490><c> times</c><00:02:58.090><c> the</c><00:02:58.300><c> number</c><00:02:58.570><c> of</c>

00:02:58.590 --> 00:02:58.600 align:start position:0%
monthly savings times the number of
 

00:02:58.600 --> 00:03:00.630 align:start position:0%
monthly savings times the number of
months<00:02:58.840><c> in</c><00:02:59.110><c> a</c><00:02:59.200><c> year</c><00:02:59.230><c> a</c><00:02:59.590><c> simple</c><00:03:00.280><c> multiplication</c>

00:03:00.630 --> 00:03:00.640 align:start position:0%
months in a year a simple multiplication
 

00:03:00.640 --> 00:03:04.830 align:start position:0%
months in a year a simple multiplication
problem<00:03:01.360><c> and</c><00:03:01.540><c> the</c><00:03:02.380><c> answer</c><00:03:02.410><c> is</c><00:03:03.360><c> but</c><00:03:04.360><c> not</c><00:03:04.690><c> too</c>

00:03:04.830 --> 00:03:04.840 align:start position:0%
problem and the answer is but not too
 

00:03:04.840 --> 00:03:06.840 align:start position:0%
problem and the answer is but not too
bad<00:03:05.020><c> one</c><00:03:05.800><c> thousand</c><00:03:06.310><c> three</c><00:03:06.459><c> hundred</c><00:03:06.580><c> and</c>

00:03:06.840 --> 00:03:06.850 align:start position:0%
bad one thousand three hundred and
 

00:03:06.850 --> 00:03:09.690 align:start position:0%
bad one thousand three hundred and
twenty<00:03:07.120><c> dollars</c><00:03:07.270><c> per</c><00:03:07.690><c> year</c><00:03:08.190><c> now</c><00:03:09.190><c> that</c><00:03:09.220><c> we</c><00:03:09.490><c> have</c>

00:03:09.690 --> 00:03:09.700 align:start position:0%
twenty dollars per year now that we have
 

00:03:09.700 --> 00:03:11.430 align:start position:0%
twenty dollars per year now that we have
this<00:03:09.850><c> number</c><00:03:10.060><c> we're</c><00:03:10.600><c> just</c><00:03:10.810><c> one</c><00:03:11.080><c> step</c><00:03:11.380><c> away</c>

00:03:11.430 --> 00:03:11.440 align:start position:0%
this number we're just one step away
 

00:03:11.440 --> 00:03:14.040 align:start position:0%
this number we're just one step away
from<00:03:11.650><c> solving</c><00:03:12.220><c> the</c><00:03:12.310><c> problem</c><00:03:12.700><c> all</c><00:03:13.060><c> we</c><00:03:13.780><c> have</c><00:03:13.900><c> to</c>

00:03:14.040 --> 00:03:14.050 align:start position:0%
from solving the problem all we have to
 

00:03:14.050 --> 00:03:15.930 align:start position:0%
from solving the problem all we have to
do<00:03:14.200><c> is</c><00:03:14.440><c> create</c><00:03:14.769><c> a</c><00:03:14.800><c> second</c><00:03:15.220><c> formula</c><00:03:15.640><c> that</c>

00:03:15.930 --> 00:03:15.940 align:start position:0%
do is create a second formula that
 

00:03:15.940 --> 00:03:17.670 align:start position:0%
do is create a second formula that
divides<00:03:16.300><c> our</c><00:03:16.480><c> goal</c><00:03:16.750><c> by</c><00:03:17.200><c> the</c><00:03:17.260><c> amount</c><00:03:17.620><c> that</c>

00:03:17.670 --> 00:03:17.680 align:start position:0%
divides our goal by the amount that
 

00:03:17.680 --> 00:03:20.880 align:start position:0%
divides our goal by the amount that
we'll<00:03:17.890><c> be</c><00:03:18.010><c> saving</c><00:03:18.250><c> each</c><00:03:18.580><c> year</c><00:03:19.739><c> before</c><00:03:20.739><c> we</c>

00:03:20.880 --> 00:03:20.890 align:start position:0%
we'll be saving each year before we
 

00:03:20.890 --> 00:03:22.800 align:start position:0%
we'll be saving each year before we
continue<00:03:21.070><c> notice</c><00:03:21.970><c> how</c><00:03:22.090><c> we've</c><00:03:22.269><c> really</c><00:03:22.780><c> thought</c>

00:03:22.800 --> 00:03:22.810 align:start position:0%
continue notice how we've really thought
 

00:03:22.810 --> 00:03:23.670 align:start position:0%
continue notice how we've really thought
this<00:03:23.140><c> through</c>

00:03:23.670 --> 00:03:23.680 align:start position:0%
this through
 

00:03:23.680 --> 00:03:26.130 align:start position:0%
this through
instead<00:03:24.489><c> of</c><00:03:24.610><c> writing</c><00:03:24.910><c> one</c><00:03:25.120><c> big</c><00:03:25.330><c> formula</c><00:03:25.840><c> we</c>

00:03:26.130 --> 00:03:26.140 align:start position:0%
instead of writing one big formula we
 

00:03:26.140 --> 00:03:28.199 align:start position:0%
instead of writing one big formula we
wrote<00:03:26.170><c> two</c><00:03:26.590><c> smaller</c><00:03:26.920><c> formulas</c><00:03:27.489><c> and</c><00:03:27.700><c> that</c>

00:03:28.199 --> 00:03:28.209 align:start position:0%
wrote two smaller formulas and that
 

00:03:28.209 --> 00:03:31.220 align:start position:0%
wrote two smaller formulas and that
makes<00:03:28.390><c> the</c><00:03:28.540><c> problem</c><00:03:28.959><c> much</c><00:03:29.110><c> easier</c><00:03:29.170><c> to</c><00:03:29.739><c> handle</c>

00:03:31.220 --> 00:03:31.230 align:start position:0%
makes the problem much easier to handle
 

00:03:31.230 --> 00:03:35.309 align:start position:0%
makes the problem much easier to handle
okay<00:03:32.230><c> it's</c><00:03:32.470><c> the</c><00:03:32.950><c> moment</c><00:03:33.280><c> of</c><00:03:33.310><c> truth</c>

00:03:35.309 --> 00:03:35.319 align:start position:0%
okay it's the moment of truth
 

00:03:35.319 --> 00:03:37.830 align:start position:0%
okay it's the moment of truth
looks<00:03:36.099><c> like</c><00:03:36.310><c> it'll</c><00:03:36.519><c> take</c><00:03:36.730><c> about</c><00:03:37.000><c> four</c><00:03:37.569><c> and</c><00:03:37.750><c> a</c>

00:03:37.830 --> 00:03:37.840 align:start position:0%
looks like it'll take about four and a
 

00:03:37.840 --> 00:03:39.690 align:start position:0%
looks like it'll take about four and a
half<00:03:37.870><c> years</c><00:03:38.469><c> to</c><00:03:38.560><c> save</c><00:03:38.980><c> enough</c><00:03:39.219><c> money</c><00:03:39.250><c> for</c><00:03:39.640><c> the</c>

00:03:39.690 --> 00:03:39.700 align:start position:0%
half years to save enough money for the
 

00:03:39.700 --> 00:03:42.780 align:start position:0%
half years to save enough money for the
jet<00:03:39.879><c> ski</c><00:03:40.230><c> man</c><00:03:41.230><c> that's</c><00:03:41.739><c> a</c><00:03:41.829><c> lot</c><00:03:42.099><c> longer</c><00:03:42.400><c> than</c><00:03:42.730><c> I</c>

00:03:42.780 --> 00:03:42.790 align:start position:0%
jet ski man that's a lot longer than I
 

00:03:42.790 --> 00:03:45.030 align:start position:0%
jet ski man that's a lot longer than I
thought<00:03:42.819><c> it</c><00:03:43.000><c> would</c><00:03:43.180><c> take</c><00:03:43.420><c> maybe</c><00:03:44.379><c> you</c><00:03:44.709><c> can</c><00:03:44.890><c> buy</c>

00:03:45.030 --> 00:03:45.040 align:start position:0%
thought it would take maybe you can buy
 

00:03:45.040 --> 00:03:50.280 align:start position:0%
thought it would take maybe you can buy
a<00:03:45.069><c> used</c><00:03:45.189><c> jet</c><00:03:45.700><c> ski</c><00:03:48.209><c> the</c><00:03:49.209><c> truth</c><00:03:49.450><c> is</c><00:03:49.689><c> there's</c><00:03:50.079><c> no</c>

00:03:50.280 --> 00:03:50.290 align:start position:0%
a used jet ski the truth is there's no
 

00:03:50.290 --> 00:03:52.830 align:start position:0%
a used jet ski the truth is there's no
formula<00:03:50.739><c> for</c><00:03:51.159><c> writing</c><00:03:51.280><c> formulas</c><00:03:51.939><c> but</c><00:03:52.629><c> that's</c>

00:03:52.830 --> 00:03:52.840 align:start position:0%
formula for writing formulas but that's
 

00:03:52.840 --> 00:03:53.429 align:start position:0%
formula for writing formulas but that's
okay

00:03:53.429 --> 00:03:53.439 align:start position:0%
okay
 

00:03:53.439 --> 00:03:55.830 align:start position:0%
okay
the<00:03:53.950><c> journey</c><00:03:54.250><c> from</c><00:03:54.549><c> point</c><00:03:54.819><c> A</c><00:03:55.000><c> to</c><00:03:55.030><c> point</c><00:03:55.180><c> B</c><00:03:55.480><c> is</c>

00:03:55.830 --> 00:03:55.840 align:start position:0%
the journey from point A to point B is
 

00:03:55.840 --> 00:03:58.800 align:start position:0%
the journey from point A to point B is
rarely<00:03:56.379><c> as</c><00:03:56.500><c> treacherous</c><00:03:56.769><c> as</c><00:03:57.159><c> it</c><00:03:57.280><c> seems</c><00:03:57.810><c> sure</c>

00:03:58.800 --> 00:03:58.810 align:start position:0%
rarely as treacherous as it seems sure
 

00:03:58.810 --> 00:04:00.300 align:start position:0%
rarely as treacherous as it seems sure
there<00:03:59.049><c> might</c><00:03:59.170><c> be</c><00:03:59.230><c> some</c><00:03:59.530><c> issues</c><00:03:59.859><c> along</c><00:04:00.129><c> the</c><00:04:00.189><c> way</c>

00:04:00.300 --> 00:04:00.310 align:start position:0%
there might be some issues along the way
 

00:04:00.310 --> 00:04:02.369 align:start position:0%
there might be some issues along the way
you<00:04:01.060><c> might</c><00:04:01.239><c> run</c><00:04:01.389><c> into</c><00:04:01.540><c> a</c><00:04:01.659><c> problem</c><00:04:01.959><c> that</c><00:04:02.139><c> you're</c>

00:04:02.369 --> 00:04:02.379 align:start position:0%
you might run into a problem that you're
 

00:04:02.379 --> 00:04:05.099 align:start position:0%
you might run into a problem that you're
not<00:04:02.500><c> sure</c><00:04:02.709><c> how</c><00:04:02.829><c> to</c><00:04:02.859><c> solve</c><00:04:03.239><c> but</c><00:04:04.239><c> remember</c><00:04:04.689><c> you</c>

00:04:05.099 --> 00:04:05.109 align:start position:0%
not sure how to solve but remember you
 

00:04:05.109 --> 00:04:06.899 align:start position:0%
not sure how to solve but remember you
already<00:04:05.379><c> know</c><00:04:05.859><c> more</c><00:04:06.159><c> than</c><00:04:06.310><c> you</c><00:04:06.400><c> think</c><00:04:06.579><c> you</c><00:04:06.670><c> do</c>

00:04:06.899 --> 00:04:06.909 align:start position:0%
already know more than you think you do
 

00:04:06.909 --> 00:04:09.210 align:start position:0%
already know more than you think you do
that's<00:04:07.810><c> the</c><00:04:08.079><c> key</c><00:04:08.290><c> to</c><00:04:08.319><c> solving</c><00:04:08.620><c> real-life</c>

00:04:09.210 --> 00:04:09.220 align:start position:0%
that's the key to solving real-life
 

00:04:09.220 --> 00:04:12.239 align:start position:0%
that's the key to solving real-life
problems<00:04:09.700><c> in</c><00:04:09.879><c> Excel</c>