WEBVTT
Kind: captions
Language: en

00:00:06.779 --> 00:00:10.110 align:start position:0%
 
the<00:00:07.779><c> real</c><00:00:08.080><c> power</c><00:00:08.440><c> in</c><00:00:08.710><c> Excel</c><00:00:09.100><c> comes</c><00:00:09.760><c> in</c><00:00:09.969><c> its</c>

00:00:10.110 --> 00:00:10.120 align:start position:0%
the real power in Excel comes in its
 

00:00:10.120 --> 00:00:12.750 align:start position:0%
the real power in Excel comes in its
ability<00:00:10.420><c> to</c><00:00:10.719><c> perform</c><00:00:11.350><c> multiple</c><00:00:11.799><c> mathematical</c>

00:00:12.750 --> 00:00:12.760 align:start position:0%
ability to perform multiple mathematical
 

00:00:12.760 --> 00:00:15.900 align:start position:0%
ability to perform multiple mathematical
calculations<00:00:13.420><c> for</c><00:00:13.930><c> you</c><00:00:14.200><c> one</c><00:00:15.160><c> of</c><00:00:15.190><c> the</c><00:00:15.400><c> tools</c><00:00:15.699><c> in</c>

00:00:15.900 --> 00:00:15.910 align:start position:0%
calculations for you one of the tools in
 

00:00:15.910 --> 00:00:18.150 align:start position:0%
calculations for you one of the tools in
Excel<00:00:16.000><c> that</c><00:00:16.869><c> you</c><00:00:17.109><c> can</c><00:00:17.289><c> use</c><00:00:17.440><c> to</c><00:00:17.590><c> perform</c><00:00:17.770><c> these</c>

00:00:18.150 --> 00:00:18.160 align:start position:0%
Excel that you can use to perform these
 

00:00:18.160 --> 00:00:20.340 align:start position:0%
Excel that you can use to perform these
calculations<00:00:18.369><c> is</c><00:00:19.210><c> a</c><00:00:19.270><c> data</c><00:00:19.660><c> tool</c><00:00:19.960><c> called</c>

00:00:20.340 --> 00:00:20.350 align:start position:0%
calculations is a data tool called
 

00:00:20.350 --> 00:00:24.570 align:start position:0%
calculations is a data tool called
what-if<00:00:21.189><c> analysis</c><00:00:22.349><c> what-if</c><00:00:23.349><c> analysis</c><00:00:24.070><c> allows</c>

00:00:24.570 --> 00:00:24.580 align:start position:0%
what-if analysis what-if analysis allows
 

00:00:24.580 --> 00:00:26.460 align:start position:0%
what-if analysis what-if analysis allows
you<00:00:24.789><c> to</c><00:00:24.939><c> see</c><00:00:25.179><c> the</c><00:00:25.210><c> effect</c><00:00:25.449><c> that</c><00:00:25.900><c> different</c>

00:00:26.460 --> 00:00:26.470 align:start position:0%
you to see the effect that different
 

00:00:26.470 --> 00:00:29.460 align:start position:0%
you to see the effect that different
values<00:00:26.919><c> have</c><00:00:27.249><c> in</c><00:00:27.550><c> formulas</c><00:00:28.150><c> it</c><00:00:28.470><c> sounds</c>

00:00:29.460 --> 00:00:29.470 align:start position:0%
values have in formulas it sounds
 

00:00:29.470 --> 00:00:32.010 align:start position:0%
values have in formulas it sounds
complicated<00:00:29.650><c> I</c><00:00:30.429><c> know</c><00:00:30.550><c> but</c><00:00:31.419><c> let's</c><00:00:31.570><c> think</c><00:00:31.810><c> about</c>

00:00:32.010 --> 00:00:32.020 align:start position:0%
complicated I know but let's think about
 

00:00:32.020 --> 00:00:35.220 align:start position:0%
complicated I know but let's think about
it<00:00:32.290><c> in</c><00:00:32.349><c> real-life</c><00:00:32.980><c> scenarios</c><00:00:33.960><c> maybe</c><00:00:34.960><c> you've</c>

00:00:35.220 --> 00:00:35.230 align:start position:0%
it in real-life scenarios maybe you've
 

00:00:35.230 --> 00:00:38.130 align:start position:0%
it in real-life scenarios maybe you've
wondered<00:00:35.470><c> what</c><00:00:36.340><c> interest</c><00:00:37.060><c> rate</c><00:00:37.329><c> do</c><00:00:37.600><c> I</c><00:00:37.660><c> need</c><00:00:37.960><c> to</c>

00:00:38.130 --> 00:00:38.140 align:start position:0%
wondered what interest rate do I need to
 

00:00:38.140 --> 00:00:40.849 align:start position:0%
wondered what interest rate do I need to
qualify<00:00:38.380><c> for</c><00:00:38.739><c> to</c><00:00:39.609><c> have</c><00:00:39.789><c> a</c><00:00:39.820><c> car</c><00:00:40.239><c> payment</c><00:00:40.510><c> of</c>

00:00:40.849 --> 00:00:40.859 align:start position:0%
qualify for to have a car payment of
 

00:00:40.859 --> 00:00:46.349 align:start position:0%
qualify for to have a car payment of
$400<00:00:41.859><c> on</c><00:00:42.160><c> the</c><00:00:42.640><c> car</c><00:00:42.879><c> I</c><00:00:42.910><c> want</c><00:00:44.940><c> let's</c><00:00:45.940><c> say</c><00:00:46.180><c> you</c>

00:00:46.349 --> 00:00:46.359 align:start position:0%
$400 on the car I want let's say you
 

00:00:46.359 --> 00:00:49.380 align:start position:0%
$400 on the car I want let's say you
need<00:00:46.660><c> a</c><00:00:46.719><c> loan</c><00:00:47.079><c> to</c><00:00:47.379><c> buy</c><00:00:47.500><c> a</c><00:00:47.530><c> new</c><00:00:47.769><c> car</c><00:00:48.239><c> you</c><00:00:49.239><c> know</c>

00:00:49.380 --> 00:00:49.390 align:start position:0%
need a loan to buy a new car you know
 

00:00:49.390 --> 00:00:52.380 align:start position:0%
need a loan to buy a new car you know
how<00:00:49.570><c> much</c><00:00:49.750><c> money</c><00:00:49.989><c> you</c><00:00:50.199><c> want</c><00:00:50.379><c> to</c><00:00:50.500><c> borrow</c><00:00:51.390><c> how</c>

00:00:52.380 --> 00:00:52.390 align:start position:0%
how much money you want to borrow how
 

00:00:52.390 --> 00:00:54.660 align:start position:0%
how much money you want to borrow how
long<00:00:52.719><c> the</c><00:00:52.989><c> period</c><00:00:53.590><c> you</c><00:00:53.739><c> want</c><00:00:53.949><c> to</c><00:00:54.070><c> take</c><00:00:54.340><c> to</c><00:00:54.489><c> pay</c>

00:00:54.660 --> 00:00:54.670 align:start position:0%
long the period you want to take to pay
 

00:00:54.670 --> 00:00:58.169 align:start position:0%
long the period you want to take to pay
off<00:00:54.699><c> the</c><00:00:55.149><c> loan</c><00:00:55.179><c> and</c><00:00:56.280><c> how</c><00:00:57.280><c> much</c><00:00:57.519><c> money</c><00:00:57.850><c> you</c><00:00:58.030><c> can</c>

00:00:58.169 --> 00:00:58.179 align:start position:0%
off the loan and how much money you can
 

00:00:58.179 --> 00:01:02.400 align:start position:0%
off the loan and how much money you can
afford<00:00:58.449><c> to</c><00:00:58.660><c> pay</c><00:00:58.809><c> each</c><00:00:59.019><c> month</c><00:01:00.989><c> but</c><00:01:01.989><c> what</c><00:01:02.260><c> you</c>

00:01:02.400 --> 00:01:02.410 align:start position:0%
afford to pay each month but what you
 

00:01:02.410 --> 00:01:04.259 align:start position:0%
afford to pay each month but what you
need<00:01:02.620><c> to</c><00:01:02.800><c> know</c><00:01:02.949><c> is</c><00:01:03.129><c> what</c><00:01:03.339><c> interest</c><00:01:03.760><c> rate</c><00:01:04.000><c> I</c>

00:01:04.259 --> 00:01:04.269 align:start position:0%
need to know is what interest rate I
 

00:01:04.269 --> 00:01:08.720 align:start position:0%
need to know is what interest rate I
need<00:01:04.890><c> to</c><00:01:05.890><c> make</c><00:01:06.370><c> my</c><00:01:07.000><c> payment</c><00:01:07.510><c> $400</c><00:01:08.290><c> a</c><00:01:08.320><c> month</c>

00:01:08.720 --> 00:01:08.730 align:start position:0%
need to make my payment $400 a month
 

00:01:08.730 --> 00:01:11.910 align:start position:0%
need to make my payment $400 a month
right<00:01:09.730><c> now</c><00:01:10.090><c> I</c><00:01:10.450><c> can</c><00:01:10.869><c> see</c><00:01:11.049><c> that</c><00:01:11.170><c> if</c><00:01:11.290><c> I</c><00:01:11.409><c> didn't</c>

00:01:11.910 --> 00:01:11.920 align:start position:0%
right now I can see that if I didn't
 

00:01:11.920 --> 00:01:13.880 align:start position:0%
right now I can see that if I didn't
have<00:01:12.100><c> interest</c><00:01:12.670><c> and</c><00:01:12.970><c> just</c><00:01:13.000><c> broke</c><00:01:13.509><c> this</c>

00:01:13.880 --> 00:01:13.890 align:start position:0%
have interest and just broke this
 

00:01:13.890 --> 00:01:17.580 align:start position:0%
have interest and just broke this
$20,000<00:01:14.890><c> into</c><00:01:15.100><c> 60</c><00:01:15.700><c> monthly</c><00:01:16.060><c> payments</c><00:01:16.630><c> I'd</c><00:01:17.290><c> be</c>

00:01:17.580 --> 00:01:17.590 align:start position:0%
$20,000 into 60 monthly payments I'd be
 

00:01:17.590 --> 00:01:19.710 align:start position:0%
$20,000 into 60 monthly payments I'd be
paying<00:01:17.860><c> about</c><00:01:18.130><c> three</c><00:01:18.939><c> hundred</c><00:01:19.360><c> and</c><00:01:19.450><c> thirty</c>

00:01:19.710 --> 00:01:19.720 align:start position:0%
paying about three hundred and thirty
 

00:01:19.720 --> 00:01:23.100 align:start position:0%
paying about three hundred and thirty
three<00:01:20.049><c> dollars</c><00:01:20.079><c> and</c><00:01:20.439><c> 33</c><00:01:20.770><c> cents</c><00:01:21.549><c> a</c><00:01:21.700><c> month</c><00:01:22.049><c> but</c><00:01:23.049><c> I</c>

00:01:23.100 --> 00:01:23.110 align:start position:0%
three dollars and 33 cents a month but I
 

00:01:23.110 --> 00:01:25.139 align:start position:0%
three dollars and 33 cents a month but I
need<00:01:23.350><c> to</c><00:01:23.500><c> find</c><00:01:23.770><c> the</c><00:01:24.040><c> interest</c><00:01:24.490><c> rate</c><00:01:24.790><c> that</c><00:01:24.820><c> will</c>

00:01:25.139 --> 00:01:25.149 align:start position:0%
need to find the interest rate that will
 

00:01:25.149 --> 00:01:29.039 align:start position:0%
need to find the interest rate that will
give<00:01:25.479><c> me</c><00:01:25.750><c> a</c><00:01:25.950><c> $400</c><00:01:26.950><c> a</c><00:01:27.040><c> month</c><00:01:27.130><c> payment</c><00:01:28.049><c> rather</c>

00:01:29.039 --> 00:01:29.049 align:start position:0%
give me a $400 a month payment rather
 

00:01:29.049 --> 00:01:30.569 align:start position:0%
give me a $400 a month payment rather
than<00:01:29.380><c> performing</c><00:01:29.920><c> all</c><00:01:30.130><c> these</c><00:01:30.310><c> calculations</c>

00:01:30.569 --> 00:01:30.579 align:start position:0%
than performing all these calculations
 

00:01:30.579 --> 00:01:33.539 align:start position:0%
than performing all these calculations
on<00:01:31.119><c> your</c><00:01:31.270><c> own</c><00:01:31.479><c> you</c><00:01:32.350><c> can</c><00:01:32.560><c> use</c><00:01:32.799><c> the</c><00:01:32.979><c> what-if</c>

00:01:33.539 --> 00:01:33.549 align:start position:0%
on your own you can use the what-if
 

00:01:33.549 --> 00:01:38.580 align:start position:0%
on your own you can use the what-if
analysis<00:01:33.820><c> tool</c><00:01:36.450><c> before</c><00:01:37.450><c> we</c><00:01:37.899><c> get</c><00:01:38.079><c> into</c><00:01:38.380><c> that</c>

00:01:38.580 --> 00:01:38.590 align:start position:0%
analysis tool before we get into that
 

00:01:38.590 --> 00:01:40.530 align:start position:0%
analysis tool before we get into that
you<00:01:38.979><c> may</c><00:01:39.219><c> be</c><00:01:39.280><c> wondering</c><00:01:39.850><c> about</c><00:01:40.060><c> this</c><00:01:40.210><c> function</c>

00:01:40.530 --> 00:01:40.540 align:start position:0%
you may be wondering about this function
 

00:01:40.540 --> 00:01:44.880 align:start position:0%
you may be wondering about this function
you<00:01:40.750><c> see</c><00:01:40.780><c> in</c><00:01:41.170><c> b5</c><00:01:42.810><c> I've</c><00:01:43.810><c> already</c><00:01:44.350><c> inserted</c><00:01:44.710><c> a</c>

00:01:44.880 --> 00:01:44.890 align:start position:0%
you see in b5 I've already inserted a
 

00:01:44.890 --> 00:01:46.740 align:start position:0%
you see in b5 I've already inserted a
function<00:01:45.369><c> to</c><00:01:45.549><c> this</c><00:01:45.700><c> cell</c><00:01:46.030><c> that</c><00:01:46.600><c> will</c>

00:01:46.740 --> 00:01:46.750 align:start position:0%
function to this cell that will
 

00:01:46.750 --> 00:01:49.950 align:start position:0%
function to this cell that will
calculate<00:01:46.990><c> this</c><00:01:47.469><c> for</c><00:01:47.799><c> me</c><00:01:48.009><c> this</c><00:01:49.000><c> isn't</c><00:01:49.329><c> part</c><00:01:49.810><c> of</c>

00:01:49.950 --> 00:01:49.960 align:start position:0%
calculate this for me this isn't part of
 

00:01:49.960 --> 00:01:51.990 align:start position:0%
calculate this for me this isn't part of
the<00:01:50.110><c> what-if</c><00:01:50.500><c> analysis</c><00:01:51.250><c> but</c><00:01:51.460><c> let</c><00:01:51.670><c> me</c><00:01:51.820><c> just</c>

00:01:51.990 --> 00:01:52.000 align:start position:0%
the what-if analysis but let me just
 

00:01:52.000 --> 00:01:56.300 align:start position:0%
the what-if analysis but let me just
really<00:01:52.240><c> quickly</c><00:01:52.329><c> show</c><00:01:52.689><c> you</c><00:01:52.960><c> what</c><00:01:53.229><c> I</c><00:01:53.259><c> did</c><00:01:53.590><c> I</c>

00:01:56.300 --> 00:01:56.310 align:start position:0%
 
 

00:01:56.310 --> 00:01:59.130 align:start position:0%
 
needed<00:01:57.310><c> a</c><00:01:57.430><c> formula</c><00:01:58.119><c> that</c><00:01:58.479><c> would</c><00:01:58.570><c> calculate</c>

00:01:59.130 --> 00:01:59.140 align:start position:0%
needed a formula that would calculate
 

00:01:59.140 --> 00:02:02.130 align:start position:0%
needed a formula that would calculate
the<00:01:59.259><c> monthly</c><00:01:59.500><c> payment</c><00:02:00.479><c> instead</c><00:02:01.479><c> of</c><00:02:01.659><c> writing</c><00:02:01.930><c> a</c>

00:02:02.130 --> 00:02:02.140 align:start position:0%
the monthly payment instead of writing a
 

00:02:02.140 --> 00:02:05.039 align:start position:0%
the monthly payment instead of writing a
big<00:02:02.439><c> formula</c><00:02:02.799><c> myself</c><00:02:03.460><c> I</c><00:02:03.759><c> inserted</c><00:02:04.299><c> a</c><00:02:04.479><c> function</c>

00:02:05.039 --> 00:02:05.049 align:start position:0%
big formula myself I inserted a function
 

00:02:05.049 --> 00:02:08.490 align:start position:0%
big formula myself I inserted a function
to<00:02:05.859><c> do</c><00:02:06.070><c> this</c><00:02:06.369><c> just</c><00:02:07.030><c> select</c><00:02:07.180><c> the</c><00:02:07.750><c> formula</c><00:02:08.050><c> tab</c>

00:02:08.490 --> 00:02:08.500 align:start position:0%
to do this just select the formula tab
 

00:02:08.500 --> 00:02:12.230 align:start position:0%
to do this just select the formula tab
and<00:02:09.300><c> click</c><00:02:10.300><c> the</c><00:02:10.450><c> insert</c><00:02:10.869><c> function</c><00:02:11.200><c> command</c>

00:02:12.230 --> 00:02:12.240 align:start position:0%
and click the insert function command
 

00:02:12.240 --> 00:02:15.860 align:start position:0%
and click the insert function command
from<00:02:13.240><c> the</c><00:02:13.390><c> dialog</c><00:02:13.930><c> box</c><00:02:14.290><c> that</c><00:02:14.440><c> appears</c><00:02:14.620><c> select</c>

00:02:15.860 --> 00:02:15.870 align:start position:0%
from the dialog box that appears select
 

00:02:15.870 --> 00:02:20.360 align:start position:0%
from the dialog box that appears select
PMT<00:02:16.870><c> short</c><00:02:17.530><c> for</c><00:02:17.680><c> payment</c><00:02:18.099><c> and</c><00:02:18.340><c> then</c><00:02:19.030><c> click</c><00:02:19.330><c> OK</c>

00:02:20.360 --> 00:02:20.370 align:start position:0%
PMT short for payment and then click OK
 

00:02:20.370 --> 00:02:24.059 align:start position:0%
PMT short for payment and then click OK
you're<00:02:21.370><c> then</c><00:02:21.670><c> asked</c><00:02:22.420><c> to</c><00:02:22.720><c> select</c><00:02:22.930><c> cells</c><00:02:23.590><c> that</c>

00:02:24.059 --> 00:02:24.069 align:start position:0%
you're then asked to select cells that
 

00:02:24.069 --> 00:02:25.949 align:start position:0%
you're then asked to select cells that
will<00:02:24.220><c> give</c><00:02:24.490><c> the</c><00:02:24.670><c> function</c><00:02:25.000><c> the</c><00:02:25.510><c> needed</c>

00:02:25.949 --> 00:02:25.959 align:start position:0%
will give the function the needed
 

00:02:25.959 --> 00:02:30.300 align:start position:0%
will give the function the needed
information<00:02:27.630><c> this</c><00:02:28.630><c> dialog</c><00:02:29.290><c> box</c><00:02:29.319><c> looks</c><00:02:29.860><c> really</c>

00:02:30.300 --> 00:02:30.310 align:start position:0%
information this dialog box looks really
 

00:02:30.310 --> 00:02:33.510 align:start position:0%
information this dialog box looks really
confusing<00:02:30.940><c> but</c><00:02:31.240><c> it</c><00:02:31.390><c> really</c><00:02:31.780><c> is</c><00:02:31.990><c> very</c><00:02:32.200><c> easy</c><00:02:32.890><c> as</c>

00:02:33.510 --> 00:02:33.520 align:start position:0%
confusing but it really is very easy as
 

00:02:33.520 --> 00:02:35.760 align:start position:0%
confusing but it really is very easy as
you<00:02:34.000><c> select</c><00:02:34.150><c> a</c><00:02:34.420><c> field</c><00:02:34.750><c> a</c><00:02:35.050><c> description</c><00:02:35.500><c> is</c>

00:02:35.760 --> 00:02:35.770 align:start position:0%
you select a field a description is
 

00:02:35.770 --> 00:02:37.920 align:start position:0%
you select a field a description is
displayed<00:02:36.130><c> below</c><00:02:36.370><c> that</c><00:02:37.090><c> basically</c><00:02:37.570><c> tells</c><00:02:37.810><c> you</c>

00:02:37.920 --> 00:02:37.930 align:start position:0%
displayed below that basically tells you
 

00:02:37.930 --> 00:02:40.770 align:start position:0%
displayed below that basically tells you
what's<00:02:38.320><c> information</c><00:02:39.070><c> and</c><00:02:39.340><c> cell</c><00:02:39.940><c> you</c><00:02:40.450><c> need</c><00:02:40.600><c> to</c>

00:02:40.770 --> 00:02:40.780 align:start position:0%
what's information and cell you need to
 

00:02:40.780 --> 00:02:44.460 align:start position:0%
what's information and cell you need to
choose<00:02:41.970><c> once</c><00:02:42.970><c> you've</c><00:02:43.180><c> entered</c><00:02:43.360><c> all</c><00:02:43.750><c> the</c><00:02:43.810><c> info</c>

00:02:44.460 --> 00:02:44.470 align:start position:0%
choose once you've entered all the info
 

00:02:44.470 --> 00:02:48.090 align:start position:0%
choose once you've entered all the info
you'll<00:02:45.040><c> just</c><00:02:45.250><c> click</c><00:02:45.520><c> OK</c><00:02:46.440><c> right</c><00:02:47.440><c> now</c><00:02:47.709><c> I'll</c><00:02:48.040><c> just</c>

00:02:48.090 --> 00:02:48.100 align:start position:0%
you'll just click OK right now I'll just
 

00:02:48.100 --> 00:02:50.370 align:start position:0%
you'll just click OK right now I'll just
close<00:02:48.640><c> this</c><00:02:48.910><c> if</c><00:02:49.209><c> you're</c><00:02:49.959><c> still</c><00:02:50.230><c> how</c>

00:02:50.370 --> 00:02:50.380 align:start position:0%
close this if you're still how
 

00:02:50.380 --> 00:02:51.960 align:start position:0%
close this if you're still how
comfortable<00:02:50.920><c> with</c><00:02:51.040><c> functions</c><00:02:51.550><c> you</c><00:02:51.940><c> should</c>

00:02:51.960 --> 00:02:51.970 align:start position:0%
comfortable with functions you should
 

00:02:51.970 --> 00:02:54.240 align:start position:0%
comfortable with functions you should
watch<00:02:52.330><c> our</c><00:02:52.540><c> video</c><00:02:52.959><c> lesson</c><00:02:53.260><c> about</c><00:02:53.650><c> functions</c>

00:02:54.240 --> 00:02:54.250 align:start position:0%
watch our video lesson about functions
 

00:02:54.250 --> 00:02:55.830 align:start position:0%
watch our video lesson about functions
which<00:02:54.880><c> will</c><00:02:55.030><c> give</c><00:02:55.270><c> you</c><00:02:55.360><c> some</c><00:02:55.570><c> more</c>

00:02:55.830 --> 00:02:55.840 align:start position:0%
which will give you some more
 

00:02:55.840 --> 00:03:01.259 align:start position:0%
which will give you some more
information<00:02:58.440><c> ok</c><00:02:59.440><c> let's</c><00:03:00.220><c> go</c><00:03:00.489><c> on</c><00:03:00.519><c> to</c><00:03:00.790><c> the</c>

00:03:01.259 --> 00:03:01.269 align:start position:0%
information ok let's go on to the
 

00:03:01.269 --> 00:03:05.820 align:start position:0%
information ok let's go on to the
what-if<00:03:01.750><c> analysis</c><00:03:01.930><c> tool</c><00:03:04.290><c> there</c><00:03:05.290><c> are</c><00:03:05.440><c> actually</c>

00:03:05.820 --> 00:03:05.830 align:start position:0%
what-if analysis tool there are actually
 

00:03:05.830 --> 00:03:08.460 align:start position:0%
what-if analysis tool there are actually
three<00:03:06.130><c> types</c><00:03:06.519><c> of</c><00:03:06.820><c> what-if</c><00:03:07.360><c> analysis</c><00:03:08.170><c> that</c><00:03:08.320><c> you</c>

00:03:08.460 --> 00:03:08.470 align:start position:0%
three types of what-if analysis that you
 

00:03:08.470 --> 00:03:12.180 align:start position:0%
three types of what-if analysis that you
can<00:03:08.500><c> use</c><00:03:09.030><c> to</c><00:03:10.030><c> see</c><00:03:10.300><c> these</c><00:03:10.570><c> select</c><00:03:11.320><c> the</c><00:03:11.620><c> data</c><00:03:11.860><c> tab</c>

00:03:12.180 --> 00:03:12.190 align:start position:0%
can use to see these select the data tab
 

00:03:12.190 --> 00:03:16.350 align:start position:0%
can use to see these select the data tab
and<00:03:12.580><c> locate</c><00:03:13.450><c> the</c><00:03:13.810><c> data</c><00:03:14.050><c> tools</c><00:03:14.320><c> group</c><00:03:15.360><c> click</c>

00:03:16.350 --> 00:03:16.360 align:start position:0%
and locate the data tools group click
 

00:03:16.360 --> 00:03:19.199 align:start position:0%
and locate the data tools group click
the<00:03:16.420><c> what-if</c><00:03:17.140><c> analysis</c><00:03:17.890><c> command</c><00:03:18.430><c> and</c><00:03:18.730><c> the</c>

00:03:19.199 --> 00:03:19.209 align:start position:0%
the what-if analysis command and the
 

00:03:19.209 --> 00:03:21.780 align:start position:0%
the what-if analysis command and the
list<00:03:19.570><c> with</c><00:03:19.780><c> the</c><00:03:19.810><c> three</c><00:03:20.140><c> options</c><00:03:20.590><c> appear</c><00:03:21.070><c> all</c>

00:03:21.780 --> 00:03:21.790 align:start position:0%
list with the three options appear all
 

00:03:21.790 --> 00:03:24.090 align:start position:0%
list with the three options appear all
three<00:03:22.660><c> of</c><00:03:22.780><c> these</c><00:03:22.959><c> are</c><00:03:23.019><c> different</c><00:03:23.650><c> types</c><00:03:23.890><c> of</c>

00:03:24.090 --> 00:03:24.100 align:start position:0%
three of these are different types of
 

00:03:24.100 --> 00:03:28.440 align:start position:0%
three of these are different types of
what-if<00:03:24.549><c> analysis</c><00:03:26.010><c> one</c><00:03:27.010><c> of</c><00:03:27.160><c> the</c><00:03:27.280><c> tools</c><00:03:27.549><c> goal</c>

00:03:28.440 --> 00:03:28.450 align:start position:0%
what-if analysis one of the tools goal
 

00:03:28.450 --> 00:03:31.530 align:start position:0%
what-if analysis one of the tools goal
seek<00:03:28.900><c> is</c><00:03:29.200><c> the</c><00:03:30.190><c> perfect</c><00:03:30.790><c> tool</c><00:03:31.000><c> to</c><00:03:31.030><c> help</c><00:03:31.329><c> you</c>

00:03:31.530 --> 00:03:31.540 align:start position:0%
seek is the perfect tool to help you
 

00:03:31.540 --> 00:03:33.180 align:start position:0%
seek is the perfect tool to help you
determine<00:03:31.690><c> the</c><00:03:32.200><c> interest</c><00:03:32.530><c> rate</c><00:03:32.799><c> you</c><00:03:32.950><c> must</c>

00:03:33.180 --> 00:03:33.190 align:start position:0%
determine the interest rate you must
 

00:03:33.190 --> 00:03:35.449 align:start position:0%
determine the interest rate you must
qualify<00:03:33.519><c> for</c><00:03:33.880><c> to</c><00:03:34.420><c> meet</c><00:03:34.630><c> your</c><00:03:34.810><c> needs</c>

00:03:35.449 --> 00:03:35.459 align:start position:0%
qualify for to meet your needs
 

00:03:35.459 --> 00:03:38.520 align:start position:0%
qualify for to meet your needs
once<00:03:36.459><c> you</c><00:03:36.610><c> select</c><00:03:36.820><c> goal</c><00:03:37.450><c> seek</c><00:03:37.810><c> from</c><00:03:37.989><c> the</c><00:03:38.049><c> menu</c>

00:03:38.520 --> 00:03:38.530 align:start position:0%
once you select goal seek from the menu
 

00:03:38.530 --> 00:03:43.410 align:start position:0%
once you select goal seek from the menu
a<00:03:38.769><c> small</c><00:03:39.549><c> dialog</c><00:03:40.090><c> box</c><00:03:40.150><c> appears</c><00:03:41.760><c> here</c><00:03:42.760><c> we</c><00:03:43.269><c> have</c>

00:03:43.410 --> 00:03:43.420 align:start position:0%
a small dialog box appears here we have
 

00:03:43.420 --> 00:03:45.810 align:start position:0%
a small dialog box appears here we have
to<00:03:43.570><c> set</c><00:03:43.780><c> a</c><00:03:43.810><c> specific</c><00:03:44.049><c> cell</c><00:03:44.799><c> to</c><00:03:45.250><c> a</c><00:03:45.280><c> specific</c>

00:03:45.810 --> 00:03:45.820 align:start position:0%
to set a specific cell to a specific
 

00:03:45.820 --> 00:03:49.890 align:start position:0%
to set a specific cell to a specific
value<00:03:46.110><c> by</c><00:03:47.110><c> changing</c><00:03:47.620><c> another</c><00:03:47.950><c> cell</c><00:03:48.310><c> in</c><00:03:48.900><c> this</c>

00:03:49.890 --> 00:03:49.900 align:start position:0%
value by changing another cell in this
 

00:03:49.900 --> 00:03:52.979 align:start position:0%
value by changing another cell in this
situation<00:03:50.680><c> we</c><00:03:51.100><c> want</c><00:03:51.370><c> to</c><00:03:51.489><c> set</c><00:03:51.730><c> to</c><00:03:51.760><c> be</c><00:03:52.120><c> 5</c><00:03:52.480><c> our</c>

00:03:52.979 --> 00:03:52.989 align:start position:0%
situation we want to set to be 5 our
 

00:03:52.989 --> 00:03:57.390 align:start position:0%
situation we want to set to be 5 our
payment<00:03:53.650><c> cell</c><00:03:55.200><c> it</c><00:03:56.200><c> already</c><00:03:56.590><c> appears</c><00:03:56.860><c> in</c><00:03:57.280><c> the</c>

00:03:57.390 --> 00:03:57.400 align:start position:0%
payment cell it already appears in the
 

00:03:57.400 --> 00:03:59.720 align:start position:0%
payment cell it already appears in the
dialog<00:03:57.880><c> box</c><00:03:57.940><c> because</c><00:03:58.540><c> the</c><00:03:58.630><c> cell</c><00:03:58.870><c> is</c><00:03:58.900><c> selected</c>

00:03:59.720 --> 00:03:59.730 align:start position:0%
dialog box because the cell is selected
 

00:03:59.730 --> 00:04:03.530 align:start position:0%
dialog box because the cell is selected
we<00:04:00.730><c> want</c><00:04:00.970><c> to</c><00:04:01.120><c> see</c><00:04:01.390><c> it</c><00:04:01.480><c> at</c><00:04:01.600><c> a</c><00:04:01.630><c> value</c><00:04:02.079><c> of</c><00:04:02.220><c> $400</c>

00:04:03.530 --> 00:04:03.540 align:start position:0%
we want to see it at a value of $400
 

00:04:03.540 --> 00:04:05.819 align:start position:0%
we want to see it at a value of $400
since<00:04:04.540><c> we're</c><00:04:04.750><c> making</c><00:04:04.870><c> a</c><00:04:05.110><c> payment</c><00:04:05.140><c> that</c><00:04:05.680><c> will</c>

00:04:05.819 --> 00:04:05.829 align:start position:0%
since we're making a payment that will
 

00:04:05.829 --> 00:04:08.340 align:start position:0%
since we're making a payment that will
be<00:04:05.920><c> subtracted</c><00:04:06.610><c> from</c><00:04:06.640><c> our</c><00:04:07.000><c> loan</c><00:04:07.299><c> amounts</c><00:04:07.900><c> we</c>

00:04:08.340 --> 00:04:08.350 align:start position:0%
be subtracted from our loan amounts we
 

00:04:08.350 --> 00:04:10.910 align:start position:0%
be subtracted from our loan amounts we
have<00:04:08.560><c> to</c><00:04:08.739><c> enter</c><00:04:09.100><c> that</c><00:04:09.280><c> as</c><00:04:09.489><c> a</c><00:04:09.519><c> negative</c><00:04:10.239><c> number</c>

00:04:10.910 --> 00:04:10.920 align:start position:0%
have to enter that as a negative number
 

00:04:10.920 --> 00:04:15.690 align:start position:0%
have to enter that as a negative number
we'll<00:04:11.920><c> move</c><00:04:12.130><c> down</c><00:04:12.430><c> to</c><00:04:12.489><c> the</c><00:04:12.820><c> next</c><00:04:13.269><c> field</c><00:04:14.700><c> then</c>

00:04:15.690 --> 00:04:15.700 align:start position:0%
we'll move down to the next field then
 

00:04:15.700 --> 00:04:17.729 align:start position:0%
we'll move down to the next field then
we<00:04:15.910><c> need</c><00:04:16.120><c> to</c><00:04:16.359><c> set</c><00:04:16.660><c> the</c><00:04:16.780><c> cell</c><00:04:17.079><c> that</c><00:04:17.289><c> we</c><00:04:17.410><c> want</c><00:04:17.680><c> to</c>

00:04:17.729 --> 00:04:17.739 align:start position:0%
we need to set the cell that we want to
 

00:04:17.739 --> 00:04:20.069 align:start position:0%
we need to set the cell that we want to
change<00:04:18.190><c> that</c><00:04:18.669><c> will</c><00:04:18.820><c> give</c><00:04:19.090><c> us</c><00:04:19.120><c> that</c><00:04:19.329><c> payment</c>

00:04:20.069 --> 00:04:20.079 align:start position:0%
change that will give us that payment
 

00:04:20.079 --> 00:04:25.820 align:start position:0%
change that will give us that payment
amount

00:04:25.820 --> 00:04:25.830 align:start position:0%
 
 

00:04:25.830 --> 00:04:29.400 align:start position:0%
 
so<00:04:26.830><c> we'll</c><00:04:27.010><c> select</c><00:04:27.250><c> cell</c><00:04:27.790><c> b4</c><00:04:28.450><c> which</c><00:04:29.139><c> is</c><00:04:29.290><c> the</c>

00:04:29.400 --> 00:04:29.410 align:start position:0%
so we'll select cell b4 which is the
 

00:04:29.410 --> 00:04:32.150 align:start position:0%
so we'll select cell b4 which is the
interest<00:04:29.800><c> rate</c>

00:04:32.150 --> 00:04:32.160 align:start position:0%
 
 

00:04:32.160 --> 00:04:35.909 align:start position:0%
 
let's<00:04:33.160><c> click</c><00:04:33.460><c> a</c><00:04:33.490><c> cell</c><00:04:33.850><c> to</c><00:04:34.030><c> select</c><00:04:34.180><c> it</c><00:04:34.630><c> and</c><00:04:34.919><c> it</c>

00:04:35.909 --> 00:04:35.919 align:start position:0%
let's click a cell to select it and it
 

00:04:35.919 --> 00:04:40.170 align:start position:0%
let's click a cell to select it and it
will<00:04:35.980><c> appear</c><00:04:36.100><c> in</c><00:04:36.520><c> the</c><00:04:36.669><c> dialogue</c><00:04:37.240><c> box</c><00:04:39.180><c> now</c>

00:04:40.170 --> 00:04:40.180 align:start position:0%
will appear in the dialogue box now
 

00:04:40.180 --> 00:04:46.470 align:start position:0%
will appear in the dialogue box now
click<00:04:40.930><c> OK</c><00:04:41.290><c> and</c><00:04:41.700><c> then</c><00:04:42.700><c> ok</c><00:04:44.730><c> now</c><00:04:45.730><c> we</c><00:04:45.790><c> can</c><00:04:46.090><c> see</c><00:04:46.330><c> that</c>

00:04:46.470 --> 00:04:46.480 align:start position:0%
click OK and then ok now we can see that
 

00:04:46.480 --> 00:04:48.300 align:start position:0%
click OK and then ok now we can see that
the<00:04:46.600><c> interest</c><00:04:47.050><c> rate</c><00:04:47.290><c> appears</c><00:04:47.680><c> in</c><00:04:47.950><c> the</c><00:04:48.040><c> cell</c>

00:04:48.300 --> 00:04:48.310 align:start position:0%
the interest rate appears in the cell
 

00:04:48.310 --> 00:04:52.080 align:start position:0%
the interest rate appears in the cell
and<00:04:48.669><c> we</c><00:04:49.419><c> know</c><00:04:49.720><c> that</c><00:04:49.900><c> a</c><00:04:50.040><c> 7%</c><00:04:51.040><c> interest</c><00:04:51.280><c> rate</c><00:04:51.730><c> will</c>

00:04:52.080 --> 00:04:52.090 align:start position:0%
and we know that a 7% interest rate will
 

00:04:52.090 --> 00:04:55.379 align:start position:0%
and we know that a 7% interest rate will
give<00:04:52.330><c> us</c><00:04:52.540><c> a</c><00:04:52.690><c> $400</c><00:04:53.560><c> a</c><00:04:53.680><c> month</c><00:04:53.770><c> payment</c><00:04:54.250><c> on</c><00:04:55.060><c> a</c>

00:04:55.379 --> 00:04:55.389 align:start position:0%
give us a $400 a month payment on a
 

00:04:55.389 --> 00:04:57.659 align:start position:0%
give us a $400 a month payment on a
twenty<00:04:55.810><c> thousand</c><00:04:56.200><c> dollar</c><00:04:56.230><c> loan</c><00:04:56.680><c> that</c><00:04:57.190><c> is</c><00:04:57.250><c> paid</c>

00:04:57.659 --> 00:04:57.669 align:start position:0%
twenty thousand dollar loan that is paid
 

00:04:57.669 --> 00:05:04.050 align:start position:0%
twenty thousand dollar loan that is paid
off<00:04:57.940><c> over</c><00:04:58.300><c> five</c><00:04:58.780><c> years</c><00:04:59.470><c> or</c><00:04:59.800><c> 60</c><00:05:00.370><c> months</c><00:05:01.530><c> as</c><00:05:03.060><c> you</c>

00:05:04.050 --> 00:05:04.060 align:start position:0%
off over five years or 60 months as you
 

00:05:04.060 --> 00:05:06.360 align:start position:0%
off over five years or 60 months as you
can<00:05:04.480><c> see</c><00:05:04.780><c> in</c><00:05:05.110><c> goal</c><00:05:05.650><c> seek</c>

00:05:06.360 --> 00:05:06.370 align:start position:0%
can see in goal seek
 

00:05:06.370 --> 00:05:08.460 align:start position:0%
can see in goal seek
we<00:05:06.490><c> gave</c><00:05:06.669><c> Excel</c><00:05:07.090><c> the</c><00:05:07.210><c> result</c><00:05:07.660><c> that</c><00:05:07.840><c> we</c><00:05:08.020><c> wanted</c>

00:05:08.460 --> 00:05:08.470 align:start position:0%
we gave Excel the result that we wanted
 

00:05:08.470 --> 00:05:12.090 align:start position:0%
we gave Excel the result that we wanted
a<00:05:08.680><c> payment</c><00:05:09.190><c> of</c><00:05:09.280><c> $400</c><00:05:09.940><c> a</c><00:05:09.970><c> month</c><00:05:10.230><c> over</c><00:05:11.230><c> 60</c><00:05:11.680><c> months</c>

00:05:12.090 --> 00:05:12.100 align:start position:0%
a payment of $400 a month over 60 months
 

00:05:12.100 --> 00:05:15.060 align:start position:0%
a payment of $400 a month over 60 months
and<00:05:12.280><c> it</c><00:05:12.820><c> gave</c><00:05:13.030><c> us</c><00:05:13.240><c> an</c><00:05:13.720><c> input</c><00:05:14.260><c> value</c><00:05:14.470><c> that</c><00:05:14.919><c> would</c>

00:05:15.060 --> 00:05:15.070 align:start position:0%
and it gave us an input value that would
 

00:05:15.070 --> 00:05:17.909 align:start position:0%
and it gave us an input value that would
give<00:05:15.280><c> us</c><00:05:15.460><c> that</c><00:05:15.669><c> result</c><00:05:16.470><c> spend</c><00:05:17.470><c> some</c><00:05:17.680><c> time</c>

00:05:17.909 --> 00:05:17.919 align:start position:0%
give us that result spend some time
 

00:05:17.919 --> 00:05:20.640 align:start position:0%
give us that result spend some time
exploring<00:05:18.370><c> goal</c><00:05:18.760><c> seek</c><00:05:19.150><c> and</c><00:05:19.450><c> practice</c><00:05:20.169><c> using</c>

00:05:20.640 --> 00:05:20.650 align:start position:0%
exploring goal seek and practice using
 

00:05:20.650 --> 00:05:22.440 align:start position:0%
exploring goal seek and practice using
it<00:05:20.770><c> so</c><00:05:21.160><c> you</c><00:05:21.220><c> can</c><00:05:21.610><c> see</c><00:05:21.790><c> what</c><00:05:21.940><c> a</c><00:05:21.970><c> powerful</c>

00:05:22.440 --> 00:05:22.450 align:start position:0%
it so you can see what a powerful
 

00:05:22.450 --> 00:05:25.320 align:start position:0%
it so you can see what a powerful
feature<00:05:22.810><c> it</c><00:05:23.140><c> is</c>