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.550><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.640 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:07.640 --> 00:00:07.650 align:start position:0%
 
 

00:00:07.650 --> 00:00:10.410 align:start position:0%
 
I've<00:00:08.650><c> been</c><00:00:08.950><c> working</c><00:00:09.310><c> on</c><00:00:09.400><c> my</c><00:00:09.550><c> monthly</c><00:00:09.970><c> budgets</c>

00:00:10.410 --> 00:00:10.420 align:start position:0%
I've been working on my monthly budgets
 

00:00:10.420 --> 00:00:12.420 align:start position:0%
I've been working on my monthly budgets
and<00:00:10.630><c> finally</c><00:00:11.290><c> things</c><00:00:11.650><c> look</c><00:00:11.920><c> the</c><00:00:12.040><c> way</c><00:00:12.190><c> that</c><00:00:12.370><c> I</c>

00:00:12.420 --> 00:00:12.430 align:start position:0%
and finally things look the way that I
 

00:00:12.430 --> 00:00:15.449 align:start position:0%
and finally things look the way that I
want<00:00:12.700><c> them</c><00:00:12.850><c> to</c><00:00:13.260><c> making</c><00:00:14.260><c> formatting</c><00:00:14.889><c> decisions</c>

00:00:15.449 --> 00:00:15.459 align:start position:0%
want them to making formatting decisions
 

00:00:15.459 --> 00:00:17.970 align:start position:0%
want them to making formatting decisions
such<00:00:15.940><c> as</c><00:00:16.120><c> what</c><00:00:16.299><c> columns</c><00:00:16.720><c> to</c><00:00:16.840><c> include</c><00:00:17.230><c> what</c>

00:00:17.970 --> 00:00:17.980 align:start position:0%
such as what columns to include what
 

00:00:17.980 --> 00:00:21.029 align:start position:0%
such as what columns to include what
text<00:00:18.490><c> to</c><00:00:18.580><c> include</c><00:00:18.730><c> and</c><00:00:19.270><c> the</c><00:00:19.869><c> text</c><00:00:20.289><c> style</c><00:00:20.680><c> and</c>

00:00:21.029 --> 00:00:21.039 align:start position:0%
text to include and the text style and
 

00:00:21.039 --> 00:00:24.600 align:start position:0%
text to include and the text style and
size<00:00:21.430><c> can</c><00:00:22.000><c> be</c><00:00:22.240><c> difficult</c><00:00:23.070><c> I've</c><00:00:24.070><c> already</c>

00:00:24.600 --> 00:00:24.610 align:start position:0%
size can be difficult I've already
 

00:00:24.610 --> 00:00:27.270 align:start position:0%
size can be difficult I've already
listed<00:00:24.940><c> all</c><00:00:25.390><c> my</c><00:00:25.660><c> bills</c><00:00:25.990><c> but</c><00:00:26.530><c> now</c><00:00:26.770><c> I</c><00:00:26.800><c> need</c><00:00:27.130><c> to</c>

00:00:27.270 --> 00:00:27.280 align:start position:0%
listed all my bills but now I need to
 

00:00:27.280 --> 00:00:29.790 align:start position:0%
listed all my bills but now I need to
include<00:00:27.520><c> my</c><00:00:27.730><c> income</c><00:00:28.180><c> information</c><00:00:28.440><c> so</c><00:00:29.440><c> I</c><00:00:29.470><c> can</c>

00:00:29.790 --> 00:00:29.800 align:start position:0%
include my income information so I can
 

00:00:29.800 --> 00:00:39.090 align:start position:0%
include my income information so I can
do<00:00:29.890><c> a</c><00:00:29.920><c> couple</c><00:00:30.160><c> of</c><00:00:30.370><c> calculations</c><00:00:38.100><c> calculating</c>

00:00:39.090 --> 00:00:39.100 align:start position:0%
do a couple of calculations calculating
 

00:00:39.100 --> 00:00:41.610 align:start position:0%
do a couple of calculations calculating
and<00:00:39.370><c> analyzing</c><00:00:40.180><c> numerical</c><00:00:40.810><c> information</c><00:00:41.410><c> is</c>

00:00:41.610 --> 00:00:41.620 align:start position:0%
and analyzing numerical information is
 

00:00:41.620 --> 00:00:43.680 align:start position:0%
and analyzing numerical information is
really<00:00:42.070><c> what</c><00:00:42.370><c> Excel</c><00:00:42.730><c> is</c><00:00:42.760><c> intended</c><00:00:43.390><c> to</c><00:00:43.510><c> be</c><00:00:43.660><c> used</c>

00:00:43.680 --> 00:00:43.690 align:start position:0%
really what Excel is intended to be used
 

00:00:43.690 --> 00:00:46.530 align:start position:0%
really what Excel is intended to be used
for<00:00:44.320><c> you</c><00:00:45.310><c> can</c><00:00:45.340><c> use</c><00:00:45.700><c> it</c><00:00:45.850><c> at</c><00:00:45.970><c> home</c><00:00:46.000><c> to</c><00:00:46.420><c> create</c>

00:00:46.530 --> 00:00:46.540 align:start position:0%
for you can use it at home to create
 

00:00:46.540 --> 00:00:49.710 align:start position:0%
for you can use it at home to create
budgets<00:00:47.200><c> like</c><00:00:47.320><c> this</c><00:00:47.650><c> one</c><00:00:48.060><c> or</c><00:00:49.060><c> in</c><00:00:49.630><c> the</c>

00:00:49.710 --> 00:00:49.720 align:start position:0%
budgets like this one or in the
 

00:00:49.720 --> 00:00:51.690 align:start position:0%
budgets like this one or in the
workplace<00:00:49.960><c> to</c><00:00:50.440><c> create</c><00:00:50.739><c> complex</c><00:00:51.489><c> spreadsheets</c>

00:00:51.690 --> 00:00:51.700 align:start position:0%
workplace to create complex spreadsheets
 

00:00:51.700 --> 00:00:56.270 align:start position:0%
workplace to create complex spreadsheets
that<00:00:52.210><c> keep</c><00:00:52.480><c> track</c><00:00:52.660><c> of</c><00:00:52.899><c> company</c><00:00:53.350><c> finances</c>

00:00:56.270 --> 00:00:56.280 align:start position:0%
 
 

00:00:56.280 --> 00:00:58.810 align:start position:0%
 
inventory

00:00:58.810 --> 00:00:58.820 align:start position:0%
inventory
 

00:00:58.820 --> 00:01:03.400 align:start position:0%
inventory
and<00:00:59.500><c> more</c><00:01:00.850><c> to</c><00:01:01.850><c> be</c><00:01:02.000><c> able</c><00:01:02.390><c> to</c><00:01:02.570><c> use</c><00:01:02.810><c> Excel</c><00:01:03.230><c> to</c>

00:01:03.400 --> 00:01:03.410 align:start position:0%
and more to be able to use Excel to
 

00:01:03.410 --> 00:01:05.980 align:start position:0%
and more to be able to use Excel to
accomplish<00:01:03.950><c> these</c><00:01:04.280><c> tasks</c><00:01:04.670><c> it's</c><00:01:05.360><c> important</c>

00:01:05.980 --> 00:01:05.990 align:start position:0%
accomplish these tasks it's important
 

00:01:05.990 --> 00:01:09.700 align:start position:0%
accomplish these tasks it's important
that<00:01:06.020><c> you</c><00:01:06.290><c> understand</c><00:01:06.800><c> formulas</c><00:01:07.430><c> in</c><00:01:08.710><c> school</c>

00:01:09.700 --> 00:01:09.710 align:start position:0%
that you understand formulas in school
 

00:01:09.710 --> 00:01:12.370 align:start position:0%
that you understand formulas in school
you<00:01:10.460><c> use</c><00:01:10.729><c> formulas</c><00:01:11.420><c> to</c><00:01:11.600><c> calculate</c><00:01:11.780><c> math</c>

00:01:12.370 --> 00:01:12.380 align:start position:0%
you use formulas to calculate math
 

00:01:12.380 --> 00:01:14.469 align:start position:0%
you use formulas to calculate math
problems<00:01:13.010><c> like</c><00:01:13.369><c> two</c><00:01:13.640><c> plus</c><00:01:13.880><c> two</c><00:01:14.090><c> equals</c><00:01:14.420><c> four</c>

00:01:14.469 --> 00:01:14.479 align:start position:0%
problems like two plus two equals four
 

00:01:14.479 --> 00:01:18.030 align:start position:0%
problems like two plus two equals four
or<00:01:15.200><c> 20%</c><00:01:15.979><c> off</c><00:01:16.550><c> of</c><00:01:16.729><c> one</c><00:01:16.910><c> hundred</c><00:01:17.030><c> dollars</c>

00:01:18.030 --> 00:01:18.040 align:start position:0%
or 20% off of one hundred dollars
 

00:01:18.040 --> 00:01:21.790 align:start position:0%
or 20% off of one hundred dollars
Microsoft<00:01:19.040><c> Excel</c><00:01:19.460><c> uses</c><00:01:20.360><c> these</c><00:01:20.570><c> same</c><00:01:20.800><c> formulas</c>

00:01:21.790 --> 00:01:21.800 align:start position:0%
Microsoft Excel uses these same formulas
 

00:01:21.800 --> 00:01:24.960 align:start position:0%
Microsoft Excel uses these same formulas
to<00:01:22.009><c> perform</c><00:01:22.369><c> spreadsheet</c><00:01:22.940><c> calculations</c><00:01:23.450><c> a</c>

00:01:24.960 --> 00:01:24.970 align:start position:0%
to perform spreadsheet calculations a
 

00:01:24.970 --> 00:01:27.670 align:start position:0%
to perform spreadsheet calculations a
formula<00:01:25.970><c> is</c><00:01:26.119><c> an</c><00:01:26.270><c> equation</c><00:01:26.660><c> that</c><00:01:26.900><c> performs</c><00:01:27.530><c> a</c>

00:01:27.670 --> 00:01:27.680 align:start position:0%
formula is an equation that performs a
 

00:01:27.680 --> 00:01:30.280 align:start position:0%
formula is an equation that performs a
calculation<00:01:28.119><c> using</c><00:01:29.119><c> values</c><00:01:29.930><c> in</c><00:01:30.170><c> the</c>

00:01:30.280 --> 00:01:30.290 align:start position:0%
calculation using values in the
 

00:01:30.290 --> 00:01:32.980 align:start position:0%
calculation using values in the
worksheets<00:01:31.000><c> you're</c><00:01:32.000><c> probably</c><00:01:32.390><c> used</c><00:01:32.899><c> to</c>

00:01:32.980 --> 00:01:32.990 align:start position:0%
worksheets you're probably used to
 

00:01:32.990 --> 00:01:35.800 align:start position:0%
worksheets you're probably used to
seeing<00:01:33.350><c> equations</c><00:01:33.920><c> like</c><00:01:34.130><c> two</c><00:01:34.640><c> plus</c><00:01:34.820><c> two</c><00:01:35.119><c> with</c>

00:01:35.800 --> 00:01:35.810 align:start position:0%
seeing equations like two plus two with
 

00:01:35.810 --> 00:01:38.520 align:start position:0%
seeing equations like two plus two with
an<00:01:35.960><c> equal</c><00:01:36.289><c> sign</c><00:01:36.320><c> after</c><00:01:36.830><c> it</c><00:01:37.130><c> but</c><00:01:37.700><c> in</c><00:01:37.940><c> Excel</c>

00:01:38.520 --> 00:01:38.530 align:start position:0%
an equal sign after it but in Excel
 

00:01:38.530 --> 00:01:44.070 align:start position:0%
an equal sign after it but in Excel
every<00:01:39.530><c> formula</c><00:01:40.130><c> starts</c><00:01:40.580><c> with</c><00:01:41.000><c> the</c><00:01:41.090><c> equal</c><00:01:41.360><c> sign</c>

00:01:44.070 --> 00:01:44.080 align:start position:0%
 
 

00:01:44.080 --> 00:01:46.960 align:start position:0%
 
this<00:01:45.080><c> may</c><00:01:45.350><c> be</c><00:01:45.410><c> a</c><00:01:45.560><c> little</c><00:01:45.950><c> confusing</c><00:01:46.399><c> but</c><00:01:46.700><c> I</c>

00:01:46.960 --> 00:01:46.970 align:start position:0%
this may be a little confusing but I
 

00:01:46.970 --> 00:01:51.550 align:start position:0%
this may be a little confusing but I
promise<00:01:47.720><c> it</c><00:01:47.990><c> will</c><00:01:48.229><c> make</c><00:01:48.590><c> sense</c><00:01:48.890><c> in</c><00:01:49.750><c> C</c><00:01:50.750><c> 3</c><00:01:51.259><c> you</c>

00:01:51.550 --> 00:01:51.560 align:start position:0%
promise it will make sense in C 3 you
 

00:01:51.560 --> 00:01:54.279 align:start position:0%
promise it will make sense in C 3 you
can<00:01:52.190><c> see</c><00:01:52.220><c> I</c><00:01:52.430><c> have</c><00:01:52.789><c> my</c><00:01:52.940><c> net</c><00:01:53.210><c> pay</c><00:01:53.509><c> of</c><00:01:53.840><c> fifteen</c>

00:01:54.279 --> 00:01:54.289 align:start position:0%
can see I have my net pay of fifteen
 

00:01:54.289 --> 00:01:57.460 align:start position:0%
can see I have my net pay of fifteen
hundred<00:01:54.440><c> dollars</c><00:01:55.039><c> listed</c><00:01:56.030><c> and</c><00:01:56.240><c> it's</c><00:01:56.869><c> C</c><00:01:57.080><c> for</c>

00:01:57.460 --> 00:01:57.470 align:start position:0%
hundred dollars listed and it's C for
 

00:01:57.470 --> 00:02:00.070 align:start position:0%
hundred dollars listed and it's C for
the<00:01:57.860><c> money</c><00:01:58.190><c> I</c><00:01:58.310><c> made</c><00:01:58.670><c> from</c><00:01:58.940><c> my</c><00:01:59.000><c> extra</c><00:01:59.600><c> job</c><00:01:59.810><c> that</c>

00:02:00.070 --> 00:02:00.080 align:start position:0%
the money I made from my extra job that
 

00:02:00.080 --> 00:02:03.280 align:start position:0%
the money I made from my extra job that
month<00:02:00.550><c> let's</c><00:02:01.550><c> say</c><00:02:01.759><c> I</c><00:02:01.880><c> want</c><00:02:02.300><c> to</c><00:02:02.360><c> add</c><00:02:02.570><c> those</c><00:02:02.990><c> two</c>

00:02:03.280 --> 00:02:03.290 align:start position:0%
month let's say I want to add those two
 

00:02:03.290 --> 00:02:05.920 align:start position:0%
month let's say I want to add those two
numbers<00:02:03.320><c> together</c><00:02:03.950><c> so</c><00:02:04.909><c> the</c><00:02:05.030><c> total</c><00:02:05.390><c> income</c><00:02:05.750><c> for</c>

00:02:05.920 --> 00:02:05.930 align:start position:0%
numbers together so the total income for
 

00:02:05.930 --> 00:02:09.219 align:start position:0%
numbers together so the total income for
the<00:02:06.020><c> month</c><00:02:06.049><c> appears</c><00:02:06.710><c> in</c><00:02:06.979><c> C</c><00:02:07.280><c> 5</c><00:02:07.810><c> let's</c><00:02:08.810><c> select</c>

00:02:09.219 --> 00:02:09.229 align:start position:0%
the month appears in C 5 let's select
 

00:02:09.229 --> 00:02:11.770 align:start position:0%
the month appears in C 5 let's select
cell<00:02:09.679><c> c5</c><00:02:10.250><c> since</c><00:02:10.820><c> that</c><00:02:11.000><c> is</c><00:02:11.180><c> where</c><00:02:11.330><c> I</c><00:02:11.390><c> want</c><00:02:11.690><c> the</c>

00:02:11.770 --> 00:02:11.780 align:start position:0%
cell c5 since that is where I want the
 

00:02:11.780 --> 00:02:16.539 align:start position:0%
cell c5 since that is where I want the
total<00:02:11.959><c> income</c><00:02:12.410><c> for</c><00:02:12.620><c> January</c><00:02:13.160><c> to</c><00:02:13.400><c> appear</c><00:02:15.549><c> since</c>

00:02:16.539 --> 00:02:16.549 align:start position:0%
total income for January to appear since
 

00:02:16.549 --> 00:02:19.030 align:start position:0%
total income for January to appear since
Excel<00:02:17.000><c> formulas</c><00:02:17.690><c> all</c><00:02:17.870><c> began</c><00:02:18.470><c> with</c><00:02:18.620><c> an</c><00:02:18.709><c> equal</c>

00:02:19.030 --> 00:02:19.040 align:start position:0%
Excel formulas all began with an equal
 

00:02:19.040 --> 00:02:21.550 align:start position:0%
Excel formulas all began with an equal
sign<00:02:19.250><c> use</c><00:02:20.209><c> your</c><00:02:20.390><c> keyboard</c><00:02:20.630><c> to</c><00:02:21.019><c> insert</c><00:02:21.230><c> an</c>

00:02:21.550 --> 00:02:21.560 align:start position:0%
sign use your keyboard to insert an
 

00:02:21.560 --> 00:02:27.310 align:start position:0%
sign use your keyboard to insert an
equal<00:02:21.860><c> sign</c><00:02:22.070><c> in</c><00:02:22.370><c> the</c><00:02:22.519><c> cell</c><00:02:23.980><c> as</c><00:02:25.750><c> you</c><00:02:26.750><c> insert</c><00:02:27.170><c> the</c>

00:02:27.310 --> 00:02:27.320 align:start position:0%
equal sign in the cell as you insert the
 

00:02:27.320 --> 00:02:28.150 align:start position:0%
equal sign in the cell as you insert the
equal<00:02:27.620><c> sign</c>

00:02:28.150 --> 00:02:28.160 align:start position:0%
equal sign
 

00:02:28.160 --> 00:02:31.690 align:start position:0%
equal sign
notice<00:02:28.730><c> how</c><00:02:28.880><c> the</c><00:02:28.940><c> formula</c><00:02:29.540><c> bar</c><00:02:29.720><c> changes</c><00:02:30.700><c> you</c>

00:02:31.690 --> 00:02:31.700 align:start position:0%
notice how the formula bar changes you
 

00:02:31.700 --> 00:02:34.449 align:start position:0%
notice how the formula bar changes you
see<00:02:31.900><c> entering</c><00:02:32.900><c> the</c><00:02:33.049><c> equal</c><00:02:33.410><c> sign</c><00:02:33.709><c> makes</c><00:02:34.340><c> a</c>

00:02:34.449 --> 00:02:34.459 align:start position:0%
see entering the equal sign makes a
 

00:02:34.459 --> 00:02:37.720 align:start position:0%
see entering the equal sign makes a
formula<00:02:34.940><c> bar</c><00:02:35.150><c> active</c><00:02:35.980><c> you</c><00:02:36.980><c> can</c><00:02:37.190><c> now</c><00:02:37.430><c> see</c><00:02:37.700><c> the</c>

00:02:37.720 --> 00:02:37.730 align:start position:0%
formula bar active you can now see the
 

00:02:37.730 --> 00:02:40.539 align:start position:0%
formula bar active you can now see the
cancel<00:02:38.299><c> icon</c><00:02:38.750><c> which</c><00:02:39.320><c> removes</c><00:02:39.739><c> information</c>

00:02:40.539 --> 00:02:40.549 align:start position:0%
cancel icon which removes information
 

00:02:40.549 --> 00:02:42.850 align:start position:0%
cancel icon which removes information
from<00:02:40.700><c> the</c><00:02:40.820><c> formula</c><00:02:41.299><c> bar</c><00:02:41.510><c> the</c><00:02:42.200><c> insert</c><00:02:42.680><c> icon</c>

00:02:42.850 --> 00:02:42.860 align:start position:0%
from the formula bar the insert icon
 

00:02:42.860 --> 00:02:46.000 align:start position:0%
from the formula bar the insert icon
which<00:02:43.579><c> will</c><00:02:43.610><c> accept</c><00:02:44.239><c> what</c><00:02:44.630><c> you</c><00:02:44.810><c> type</c><00:02:45.079><c> and</c><00:02:45.470><c> the</c>

00:02:46.000 --> 00:02:46.010 align:start position:0%
which will accept what you type and the
 

00:02:46.010 --> 00:02:48.160 align:start position:0%
which will accept what you type and the
function<00:02:46.549><c> icon</c><00:02:46.760><c> that</c><00:02:47.420><c> provides</c><00:02:47.840><c> you</c><00:02:48.049><c> with</c>

00:02:48.160 --> 00:02:48.170 align:start position:0%
function icon that provides you with
 

00:02:48.170 --> 00:02:51.819 align:start position:0%
function icon that provides you with
some<00:02:48.410><c> other</c><00:02:48.590><c> mathematical</c><00:02:49.160><c> options</c><00:02:50.590><c> let's</c><00:02:51.590><c> go</c>

00:02:51.819 --> 00:02:51.829 align:start position:0%
some other mathematical options let's go
 

00:02:51.829 --> 00:02:55.960 align:start position:0%
some other mathematical options let's go
back<00:02:52.100><c> to</c><00:02:52.310><c> c5</c><00:02:52.880><c> and</c><00:02:52.910><c> finish</c><00:02:53.720><c> our</c><00:02:53.900><c> formula</c><00:02:54.970><c> we</c>

00:02:55.960 --> 00:02:55.970 align:start position:0%
back to c5 and finish our formula we
 

00:02:55.970 --> 00:03:01.150 align:start position:0%
back to c5 and finish our formula we
want<00:02:56.239><c> to</c><00:02:56.420><c> add</c><00:02:56.600><c> my</c><00:02:57.190><c> $1,500</c><00:02:58.190><c> and</c><00:02:59.019><c> $200</c><00:03:00.019><c> so</c><00:03:00.980><c> we'll</c>

00:03:01.150 --> 00:03:01.160 align:start position:0%
want to add my $1,500 and $200 so we'll
 

00:03:01.160 --> 00:03:04.270 align:start position:0%
want to add my $1,500 and $200 so we'll
just<00:03:01.400><c> type</c><00:03:01.640><c> the</c><00:03:01.850><c> first</c><00:03:02.090><c> number</c><00:03:02.690><c> and</c><00:03:03.010><c> then</c><00:03:04.010><c> use</c>

00:03:04.270 --> 00:03:04.280 align:start position:0%
just type the first number and then use
 

00:03:04.280 --> 00:03:06.340 align:start position:0%
just type the first number and then use
the<00:03:04.430><c> keyboard</c><00:03:04.670><c> to</c><00:03:04.940><c> insert</c><00:03:05.450><c> the</c><00:03:05.600><c> addition</c><00:03:06.079><c> sign</c>

00:03:06.340 --> 00:03:06.350 align:start position:0%
the keyboard to insert the addition sign
 

00:03:06.350 --> 00:03:13.010 align:start position:0%
the keyboard to insert the addition sign
and<00:03:07.930><c> nail</c><00:03:08.930><c> type</c><00:03:09.260><c> the</c><00:03:09.440><c> second</c><00:03:09.859><c> number</c>

00:03:13.010 --> 00:03:13.020 align:start position:0%
 
 

00:03:13.020 --> 00:03:16.650 align:start position:0%
 
the<00:03:14.020><c> addition</c><00:03:14.500><c> sign</c><00:03:14.740><c> lets</c><00:03:15.340><c> Excel</c><00:03:15.790><c> know</c><00:03:16.150><c> that</c>

00:03:16.650 --> 00:03:16.660 align:start position:0%
the addition sign lets Excel know that
 

00:03:16.660 --> 00:03:20.640 align:start position:0%
the addition sign lets Excel know that
an<00:03:16.810><c> ADD</c><00:03:17.020><c> operation</c><00:03:17.290><c> is</c><00:03:17.920><c> to</c><00:03:18.100><c> be</c><00:03:18.130><c> performed</c><00:03:19.650><c> okay</c>

00:03:20.640 --> 00:03:20.650 align:start position:0%
an ADD operation is to be performed okay
 

00:03:20.650 --> 00:03:23.070 align:start position:0%
an ADD operation is to be performed okay
now<00:03:21.340><c> that</c><00:03:21.580><c> I</c><00:03:21.640><c> have</c><00:03:21.880><c> my</c><00:03:22.030><c> formula</c><00:03:22.390><c> entered</c><00:03:22.990><c> in</c>

00:03:23.070 --> 00:03:23.080 align:start position:0%
now that I have my formula entered in
 

00:03:23.080 --> 00:03:25.740 align:start position:0%
now that I have my formula entered in
the<00:03:23.200><c> cell</c><00:03:23.470><c> I</c><00:03:23.800><c> can</c><00:03:24.490><c> press</c><00:03:24.730><c> the</c><00:03:24.940><c> Enter</c><00:03:25.270><c> key</c><00:03:25.300><c> on</c><00:03:25.510><c> my</c>

00:03:25.740 --> 00:03:25.750 align:start position:0%
the cell I can press the Enter key on my
 

00:03:25.750 --> 00:03:28.380 align:start position:0%
the cell I can press the Enter key on my
keyboard<00:03:25.990><c> or</c><00:03:26.560><c> click</c><00:03:27.280><c> the</c><00:03:27.400><c> insert</c><00:03:27.760><c> command</c><00:03:27.880><c> on</c>

00:03:28.380 --> 00:03:28.390 align:start position:0%
keyboard or click the insert command on
 

00:03:28.390 --> 00:03:33.420 align:start position:0%
keyboard or click the insert command on
the<00:03:28.510><c> formula</c><00:03:28.960><c> bar</c><00:03:29.110><c> and</c><00:03:31.560><c> now</c><00:03:32.560><c> I</c><00:03:32.620><c> can</c><00:03:32.980><c> see</c><00:03:33.190><c> that</c>

00:03:33.420 --> 00:03:33.430 align:start position:0%
the formula bar and now I can see that
 

00:03:33.430 --> 00:03:36.150 align:start position:0%
the formula bar and now I can see that
Excel<00:03:33.580><c> edit</c><00:03:34.240><c> fifteen</c><00:03:34.780><c> hundred</c><00:03:35.260><c> and</c><00:03:35.350><c> two</c>

00:03:36.150 --> 00:03:36.160 align:start position:0%
Excel edit fifteen hundred and two
 

00:03:36.160 --> 00:03:39.450 align:start position:0%
Excel edit fifteen hundred and two
hundred<00:03:36.190><c> and</c><00:03:36.820><c> placed</c><00:03:37.540><c> the</c><00:03:37.900><c> answer</c><00:03:38.350><c> in</c><00:03:38.530><c> cell</c><00:03:38.740><c> c5</c>

00:03:39.450 --> 00:03:39.460 align:start position:0%
hundred and placed the answer in cell c5
 

00:03:39.460 --> 00:03:42.900 align:start position:0%
hundred and placed the answer in cell c5
where<00:03:40.330><c> I</c><00:03:40.360><c> typed</c><00:03:40.780><c> the</c><00:03:41.050><c> formula</c><00:03:41.670><c> another</c><00:03:42.670><c> way</c>

00:03:42.900 --> 00:03:42.910 align:start position:0%
where I typed the formula another way
 

00:03:42.910 --> 00:03:45.300 align:start position:0%
where I typed the formula another way
you<00:03:42.970><c> can</c><00:03:43.240><c> create</c><00:03:43.540><c> formulas</c><00:03:44.200><c> is</c><00:03:44.410><c> by</c><00:03:44.620><c> using</c><00:03:44.920><c> cell</c>

00:03:45.300 --> 00:03:45.310 align:start position:0%
you can create formulas is by using cell
 

00:03:45.310 --> 00:03:49.280 align:start position:0%
you can create formulas is by using cell
references<00:03:47.430><c> instead</c><00:03:48.430><c> of</c><00:03:48.550><c> typing</c><00:03:49.060><c> equals</c>

00:03:49.280 --> 00:03:49.290 align:start position:0%
references instead of typing equals
 

00:03:49.290 --> 00:03:52.200 align:start position:0%
references instead of typing equals
fifteen<00:03:50.290><c> hundred</c><00:03:50.770><c> plus</c><00:03:51.220><c> two</c><00:03:51.610><c> hundred</c><00:03:51.790><c> and</c>

00:03:52.200 --> 00:03:52.210 align:start position:0%
fifteen hundred plus two hundred and
 

00:03:52.210 --> 00:03:55.800 align:start position:0%
fifteen hundred plus two hundred and
cell<00:03:52.930><c> c5</c><00:03:53.740><c> to</c><00:03:54.310><c> calculate</c><00:03:54.880><c> my</c><00:03:55.060><c> total</c><00:03:55.570><c> income</c>

00:03:55.800 --> 00:03:55.810 align:start position:0%
cell c5 to calculate my total income
 

00:03:55.810 --> 00:03:58.980 align:start position:0%
cell c5 to calculate my total income
that<00:03:56.230><c> month</c><00:03:56.500><c> I</c><00:03:56.770><c> can</c><00:03:57.550><c> use</c><00:03:57.730><c> a</c><00:03:57.760><c> cell</c><00:03:58.150><c> reference</c><00:03:58.480><c> in</c>

00:03:58.980 --> 00:03:58.990 align:start position:0%
that month I can use a cell reference in
 

00:03:58.990 --> 00:04:02.070 align:start position:0%
that month I can use a cell reference in
the<00:03:59.080><c> formula</c><00:03:59.590><c> a</c><00:03:59.800><c> cell</c><00:04:00.790><c> reference</c><00:04:01.180><c> is</c><00:04:01.660><c> when</c><00:04:01.930><c> you</c>

00:04:02.070 --> 00:04:02.080 align:start position:0%
the formula a cell reference is when you
 

00:04:02.080 --> 00:04:04.830 align:start position:0%
the formula a cell reference is when you
use<00:04:02.350><c> a</c><00:04:02.380><c> cell</c><00:04:02.770><c> address</c><00:04:03.490><c> in</c><00:04:03.760><c> a</c><00:04:03.910><c> formula</c><00:04:04.570><c> and</c>

00:04:04.830 --> 00:04:04.840 align:start position:0%
use a cell address in a formula and
 

00:04:04.840 --> 00:04:09.630 align:start position:0%
use a cell address in a formula and
refer<00:04:05.800><c> to</c><00:04:05.830><c> that</c><00:04:06.310><c> specific</c><00:04:06.910><c> cell</c><00:04:07.180><c> by</c><00:04:07.720><c> name</c><00:04:08.640><c> for</c>

00:04:09.630 --> 00:04:09.640 align:start position:0%
refer to that specific cell by name for
 

00:04:09.640 --> 00:04:13.320 align:start position:0%
refer to that specific cell by name for
example<00:04:10.050><c> the</c><00:04:11.050><c> cell</c><00:04:11.350><c> address</c><00:04:11.680><c> of</c><00:04:12.190><c> this</c><00:04:12.460><c> cell</c><00:04:12.910><c> is</c>

00:04:13.320 --> 00:04:13.330 align:start position:0%
example the cell address of this cell is
 

00:04:13.330 --> 00:04:18.630 align:start position:0%
example the cell address of this cell is
c3<00:04:14.370><c> this</c><00:04:15.370><c> cell</c><00:04:15.910><c> is</c><00:04:16.299><c> where</c><00:04:16.600><c> column</c><00:04:17.109><c> C</c><00:04:17.470><c> and</c><00:04:17.770><c> Row</c>

00:04:18.630 --> 00:04:18.640 align:start position:0%
c3 this cell is where column C and Row
 

00:04:18.640 --> 00:04:22.320 align:start position:0%
c3 this cell is where column C and Row
three<00:04:19.120><c> intersect</c><00:04:20.130><c> now</c><00:04:21.130><c> let's</c><00:04:22.030><c> write</c><00:04:22.270><c> a</c>

00:04:22.320 --> 00:04:22.330 align:start position:0%
three intersect now let's write a
 

00:04:22.330 --> 00:04:26.850 align:start position:0%
three intersect now let's write a
formula<00:04:22.780><c> using</c><00:04:23.350><c> cell</c><00:04:23.620><c> references</c><00:04:25.590><c> select</c><00:04:26.590><c> the</c>

00:04:26.850 --> 00:04:26.860 align:start position:0%
formula using cell references select the
 

00:04:26.860 --> 00:04:31.220 align:start position:0%
formula using cell references select the
cell<00:04:27.130><c> where</c><00:04:27.640><c> you</c><00:04:27.669><c> want</c><00:04:27.820><c> the</c><00:04:28.090><c> answer</c><00:04:28.540><c> to</c><00:04:28.570><c> appear</c>

00:04:31.220 --> 00:04:31.230 align:start position:0%
 
 

00:04:31.230 --> 00:04:33.870 align:start position:0%
 
type<00:04:32.230><c> the</c><00:04:32.410><c> equal</c><00:04:32.770><c> sign</c><00:04:32.980><c> to</c><00:04:33.250><c> let</c><00:04:33.460><c> Excel</c><00:04:33.580><c> know</c>

00:04:33.870 --> 00:04:33.880 align:start position:0%
type the equal sign to let Excel know
 

00:04:33.880 --> 00:04:38.760 align:start position:0%
type the equal sign to let Excel know
that<00:04:34.419><c> we're</c><00:04:34.540><c> writing</c><00:04:34.750><c> a</c><00:04:34.960><c> formula</c><00:04:37.560><c> type</c><00:04:38.560><c> the</c>

00:04:38.760 --> 00:04:38.770 align:start position:0%
that we're writing a formula type the
 

00:04:38.770 --> 00:04:41.040 align:start position:0%
that we're writing a formula type the
cell<00:04:39.010><c> number</c><00:04:39.610><c> that</c><00:04:39.970><c> contains</c><00:04:40.419><c> the</c><00:04:40.750><c> first</c>

00:04:41.040 --> 00:04:41.050 align:start position:0%
cell number that contains the first
 

00:04:41.050 --> 00:04:45.000 align:start position:0%
cell number that contains the first
number<00:04:41.800><c> to</c><00:04:42.070><c> be</c><00:04:42.190><c> added</c><00:04:42.370><c> and</c><00:04:43.650><c> then</c><00:04:44.650><c> type</c><00:04:44.980><c> the</c>

00:04:45.000 --> 00:04:45.010 align:start position:0%
number to be added and then type the
 

00:04:45.010 --> 00:04:48.900 align:start position:0%
number to be added and then type the
addition<00:04:45.490><c> sign</c><00:04:46.620><c> nails</c><00:04:47.620><c> type</c><00:04:47.950><c> the</c><00:04:48.130><c> cell</c><00:04:48.370><c> number</c>

00:04:48.900 --> 00:04:48.910 align:start position:0%
addition sign nails type the cell number
 

00:04:48.910 --> 00:04:51.330 align:start position:0%
addition sign nails type the cell number
that<00:04:49.210><c> contains</c><00:04:49.630><c> the</c><00:04:49.840><c> second</c><00:04:50.440><c> number</c><00:04:51.070><c> to</c><00:04:51.100><c> be</c>

00:04:51.330 --> 00:04:51.340 align:start position:0%
that contains the second number to be
 

00:04:51.340 --> 00:04:54.690 align:start position:0%
that contains the second number to be
added<00:04:52.050><c> press</c><00:04:53.050><c> ENTER</c><00:04:53.530><c> on</c><00:04:53.560><c> your</c><00:04:53.740><c> keyboard</c><00:04:53.919><c> or</c>

00:04:54.690 --> 00:04:54.700 align:start position:0%
added press ENTER on your keyboard or
 

00:04:54.700 --> 00:04:56.610 align:start position:0%
added press ENTER on your keyboard or
click<00:04:54.790><c> the</c><00:04:55.270><c> insert</c><00:04:55.630><c> button</c><00:04:55.660><c> on</c><00:04:56.080><c> the</c><00:04:56.200><c> formula</c>

00:04:56.610 --> 00:04:56.620 align:start position:0%
click the insert button on the formula
 

00:04:56.620 --> 00:05:01.530 align:start position:0%
click the insert button on the formula
bar<00:04:58.110><c> so</c><00:04:59.110><c> you're</c><00:04:59.830><c> probably</c><00:05:00.220><c> wondering</c><00:05:01.090><c> why</c><00:05:01.360><c> we</c>

00:05:01.530 --> 00:05:01.540 align:start position:0%
bar so you're probably wondering why we
 

00:05:01.540 --> 00:05:03.990 align:start position:0%
bar so you're probably wondering why we
might<00:05:01.750><c> want</c><00:05:01.810><c> to</c><00:05:02.140><c> use</c><00:05:02.260><c> cell</c><00:05:02.710><c> references</c><00:05:03.520><c> it</c>

00:05:03.990 --> 00:05:04.000 align:start position:0%
might want to use cell references it
 

00:05:04.000 --> 00:05:06.120 align:start position:0%
might want to use cell references it
doesn't<00:05:04.450><c> seem</c><00:05:04.660><c> any</c><00:05:04.840><c> easier</c><00:05:05.410><c> to</c><00:05:05.530><c> type</c><00:05:05.740><c> the</c><00:05:05.919><c> cell</c>

00:05:06.120 --> 00:05:06.130 align:start position:0%
doesn't seem any easier to type the cell
 

00:05:06.130 --> 00:05:08.480 align:start position:0%
doesn't seem any easier to type the cell
address<00:05:06.669><c> rather</c><00:05:06.940><c> than</c><00:05:07.210><c> the</c><00:05:07.300><c> numbers</c><00:05:07.690><c> does</c><00:05:07.900><c> it</c>

00:05:08.480 --> 00:05:08.490 align:start position:0%
address rather than the numbers does it
 

00:05:08.490 --> 00:05:12.030 align:start position:0%
address rather than the numbers does it
well<00:05:09.490><c> let's</c><00:05:10.240><c> say</c><00:05:10.600><c> that</c><00:05:10.630><c> I</c><00:05:10.840><c> realized</c><00:05:11.410><c> I</c><00:05:11.680><c> entered</c>

00:05:12.030 --> 00:05:12.040 align:start position:0%
well let's say that I realized I entered
 

00:05:12.040 --> 00:05:15.480 align:start position:0%
well let's say that I realized I entered
my<00:05:12.070><c> net</c><00:05:12.460><c> pay</c><00:05:12.790><c> incorrectly</c><00:05:13.570><c> all</c><00:05:14.470><c> I</c><00:05:14.680><c> have</c><00:05:15.070><c> to</c><00:05:15.250><c> do</c>

00:05:15.480 --> 00:05:15.490 align:start position:0%
my net pay incorrectly all I have to do
 

00:05:15.490 --> 00:05:21.870 align:start position:0%
my net pay incorrectly all I have to do
is<00:05:15.790><c> change</c><00:05:16.120><c> the</c><00:05:16.390><c> numbers</c><00:05:16.870><c> and</c><00:05:17.169><c> cell</c><00:05:17.560><c> c3</c><00:05:19.470><c> and</c><00:05:20.880><c> as</c>

00:05:21.870 --> 00:05:21.880 align:start position:0%
is change the numbers and cell c3 and as
 

00:05:21.880 --> 00:05:26.140 align:start position:0%
is change the numbers and cell c3 and as
I<00:05:22.030><c> change</c><00:05:22.390><c> it</c><00:05:22.630><c> my</c><00:05:22.900><c> total</c><00:05:23.380><c> income</c><00:05:23.650><c> in</c><00:05:24.250><c> cell</c><00:05:24.539><c> d5</c>

00:05:26.140 --> 00:05:26.150 align:start position:0%
I change it my total income in cell d5
 

00:05:26.150 --> 00:05:29.660 align:start position:0%
I change it my total income in cell d5
automatically<00:05:27.150><c> changes</c><00:05:27.780><c> if</c><00:05:28.080><c> I</c><00:05:28.890><c> change</c><00:05:29.310><c> the</c>

00:05:29.660 --> 00:05:29.670 align:start position:0%
automatically changes if I change the
 

00:05:29.670 --> 00:05:33.170 align:start position:0%
automatically changes if I change the
amount<00:05:30.120><c> since</c><00:05:30.480><c> III</c><00:05:31.410><c> I</c><00:05:31.740><c> would</c><00:05:32.520><c> not</c><00:05:32.790><c> see</c><00:05:33.150><c> a</c>

00:05:33.170 --> 00:05:33.180 align:start position:0%
amount since III I would not see a
 

00:05:33.180 --> 00:05:38.360 align:start position:0%
amount since III I would not see a
change<00:05:33.300><c> in</c><00:05:34.700><c> c5</c><00:05:36.140><c> because</c><00:05:37.140><c> I</c><00:05:37.170><c> didn't</c><00:05:37.680><c> use</c><00:05:37.920><c> a</c><00:05:37.950><c> cell</c>

00:05:38.360 --> 00:05:38.370 align:start position:0%
change in c5 because I didn't use a cell
 

00:05:38.370 --> 00:05:41.150 align:start position:0%
change in c5 because I didn't use a cell
reference<00:05:38.760><c> but</c><00:05:39.510><c> instead</c><00:05:39.960><c> types</c><00:05:40.470><c> the</c><00:05:40.770><c> numbers</c>

00:05:41.150 --> 00:05:41.160 align:start position:0%
reference but instead types the numbers
 

00:05:41.160 --> 00:05:47.390 align:start position:0%
reference but instead types the numbers
in<00:05:41.400><c> the</c><00:05:41.610><c> formula</c><00:05:45.680><c> cell</c><00:05:46.680><c> references</c><00:05:47.370><c> are</c>

00:05:47.390 --> 00:05:47.400 align:start position:0%
in the formula cell references are
 

00:05:47.400 --> 00:05:49.760 align:start position:0%
in the formula cell references are
especially<00:05:47.940><c> important</c><00:05:48.630><c> to</c><00:05:48.720><c> know</c><00:05:48.930><c> about</c><00:05:49.260><c> when</c>

00:05:49.760 --> 00:05:49.770 align:start position:0%
especially important to know about when
 

00:05:49.770 --> 00:05:51.590 align:start position:0%
especially important to know about when
working<00:05:50.040><c> with</c><00:05:50.280><c> columns</c><00:05:50.760><c> that</c><00:05:50.880><c> contain</c><00:05:51.030><c> many</c>

00:05:51.590 --> 00:05:51.600 align:start position:0%
working with columns that contain many
 

00:05:51.600 --> 00:05:54.560 align:start position:0%
working with columns that contain many
numbers<00:05:52.140><c> that</c><00:05:52.350><c> change</c><00:05:52.410><c> regularly</c><00:05:53.190><c> as</c><00:05:53.580><c> you've</c>

00:05:54.560 --> 00:05:54.570 align:start position:0%
numbers that change regularly as you've
 

00:05:54.570 --> 00:05:56.930 align:start position:0%
numbers that change regularly as you've
probably<00:05:54.870><c> noticed</c><00:05:55.410><c> in</c><00:05:55.830><c> most</c><00:05:56.190><c> Microsoft</c>

00:05:56.930 --> 00:05:56.940 align:start position:0%
probably noticed in most Microsoft
 

00:05:56.940 --> 00:05:59.060 align:start position:0%
probably noticed in most Microsoft
Office<00:05:57.300><c> applications</c><00:05:57.960><c> there</c><00:05:58.590><c> is</c><00:05:58.620><c> usually</c>

00:05:59.060 --> 00:05:59.070 align:start position:0%
Office applications there is usually
 

00:05:59.070 --> 00:06:00.860 align:start position:0%
Office applications there is usually
more<00:05:59.370><c> than</c><00:05:59.430><c> one</c><00:05:59.610><c> way</c><00:06:00.030><c> to</c><00:06:00.060><c> accomplish</c><00:06:00.720><c> a</c><00:06:00.750><c> task</c>

00:06:00.860 --> 00:06:00.870 align:start position:0%
more than one way to accomplish a task
 

00:06:00.870 --> 00:06:06.260 align:start position:0%
more than one way to accomplish a task
in<00:06:02.030><c> this</c><00:06:03.030><c> formula</c><00:06:03.660><c> I</c><00:06:04.730><c> typed</c><00:06:05.730><c> in</c><00:06:05.940><c> the</c><00:06:06.030><c> cell</c>

00:06:06.260 --> 00:06:06.270 align:start position:0%
in this formula I typed in the cell
 

00:06:06.270 --> 00:06:08.660 align:start position:0%
in this formula I typed in the cell
reference<00:06:06.840><c> as</c><00:06:06.990><c> I</c><00:06:07.260><c> wrote</c><00:06:07.440><c> the</c><00:06:07.590><c> formula</c><00:06:08.070><c> but</c><00:06:08.490><c> you</c>

00:06:08.660 --> 00:06:08.670 align:start position:0%
reference as I wrote the formula but you
 

00:06:08.670 --> 00:06:10.610 align:start position:0%
reference as I wrote the formula but you
can<00:06:08.820><c> also</c><00:06:09.030><c> use</c><00:06:09.270><c> the</c><00:06:09.630><c> points</c><00:06:10.020><c> and</c><00:06:10.140><c> click</c><00:06:10.380><c> method</c>

00:06:10.610 --> 00:06:10.620 align:start position:0%
can also use the points and click method
 

00:06:10.620 --> 00:06:13.040 align:start position:0%
can also use the points and click method
to<00:06:10.980><c> select</c><00:06:11.340><c> cells</c><00:06:11.640><c> so</c><00:06:12.300><c> that</c><00:06:12.330><c> you</c><00:06:12.600><c> don't</c><00:06:12.810><c> have</c>

00:06:13.040 --> 00:06:13.050 align:start position:0%
to select cells so that you don't have
 

00:06:13.050 --> 00:06:17.770 align:start position:0%
to select cells so that you don't have
to<00:06:13.200><c> type</c><00:06:13.440><c> two</c><00:06:13.560><c> cell</c><00:06:13.770><c> references</c><00:06:14.070><c> each</c><00:06:14.550><c> time</c>

00:06:17.770 --> 00:06:17.780 align:start position:0%
 
 

00:06:17.780 --> 00:06:20.030 align:start position:0%
 
let's<00:06:18.780><c> see</c><00:06:19.140><c> how</c><00:06:19.350><c> the</c><00:06:19.410><c> point</c><00:06:19.740><c> and</c><00:06:19.860><c> click</c><00:06:19.920><c> method</c>

00:06:20.030 --> 00:06:20.040 align:start position:0%
let's see how the point and click method
 

00:06:20.040 --> 00:06:22.010 align:start position:0%
let's see how the point and click method
works<00:06:20.760><c> while</c><00:06:21.090><c> creating</c><00:06:21.660><c> a</c><00:06:21.750><c> simple</c>

00:06:22.010 --> 00:06:22.020 align:start position:0%
works while creating a simple
 

00:06:22.020 --> 00:06:25.280 align:start position:0%
works while creating a simple
subtraction<00:06:22.290><c> formula</c><00:06:23.040><c> I</c><00:06:23.630><c> have</c><00:06:24.630><c> entered</c><00:06:25.170><c> the</c>

00:06:25.280 --> 00:06:25.290 align:start position:0%
subtraction formula I have entered the
 

00:06:25.290 --> 00:06:28.100 align:start position:0%
subtraction formula I have entered the
total<00:06:25.320><c> amounts</c><00:06:26.310><c> of</c><00:06:26.430><c> my</c><00:06:26.580><c> January</c><00:06:26.910><c> expenses</c><00:06:27.390><c> in</c>

00:06:28.100 --> 00:06:28.110 align:start position:0%
total amounts of my January expenses in
 

00:06:28.110 --> 00:06:33.650 align:start position:0%
total amounts of my January expenses in
C<00:06:28.380><c> 29</c><00:06:30.080><c> now</c><00:06:31.080><c> to</c><00:06:31.140><c> calculate</c><00:06:31.620><c> how</c><00:06:32.280><c> much</c><00:06:32.610><c> money</c><00:06:32.670><c> I</c>

00:06:33.650 --> 00:06:33.660 align:start position:0%
C 29 now to calculate how much money I
 

00:06:33.660 --> 00:06:36.620 align:start position:0%
C 29 now to calculate how much money I
have<00:06:34.050><c> after</c><00:06:34.440><c> paying</c><00:06:34.710><c> all</c><00:06:34.980><c> my</c><00:06:35.040><c> January</c><00:06:35.610><c> bills</c><00:06:36.210><c> I</c>

00:06:36.620 --> 00:06:36.630 align:start position:0%
have after paying all my January bills I
 

00:06:36.630 --> 00:06:39.200 align:start position:0%
have after paying all my January bills I
just<00:06:37.290><c> need</c><00:06:37.470><c> to</c><00:06:37.620><c> write</c><00:06:37.800><c> a</c><00:06:37.830><c> formula</c><00:06:38.280><c> in</c><00:06:38.460><c> C</c><00:06:38.850><c> 30</c>

00:06:39.200 --> 00:06:39.210 align:start position:0%
just need to write a formula in C 30
 

00:06:39.210 --> 00:06:42.620 align:start position:0%
just need to write a formula in C 30
that<00:06:40.020><c> subtracts</c><00:06:40.680><c> my</c><00:06:40.800><c> January</c><00:06:41.160><c> expenses</c><00:06:41.670><c> from</c>

00:06:42.620 --> 00:06:42.630 align:start position:0%
that subtracts my January expenses from
 

00:06:42.630 --> 00:06:48.200 align:start position:0%
that subtracts my January expenses from
my<00:06:42.840><c> January</c><00:06:43.200><c> income</c><00:06:46.280><c> so</c><00:06:47.280><c> we'll</c><00:06:47.640><c> select</c><00:06:47.880><c> the</c>

00:06:48.200 --> 00:06:48.210 align:start position:0%
my January income so we'll select the
 

00:06:48.210 --> 00:06:50.090 align:start position:0%
my January income so we'll select the
cell<00:06:48.480><c> where</c><00:06:48.840><c> we</c><00:06:48.960><c> want</c><00:06:49.320><c> the</c><00:06:49.500><c> answer</c><00:06:49.920><c> to</c><00:06:49.950><c> appear</c>

00:06:50.090 --> 00:06:50.100 align:start position:0%
cell where we want the answer to appear
 

00:06:50.100 --> 00:06:56.150 align:start position:0%
cell where we want the answer to appear
and<00:06:50.760><c> then</c><00:06:51.570><c> insert</c><00:06:52.140><c> the</c><00:06:52.290><c> equal</c><00:06:52.650><c> sign</c><00:06:54.140><c> now</c><00:06:55.140><c> all</c><00:06:56.100><c> I</c>

00:06:56.150 --> 00:06:56.160 align:start position:0%
and then insert the equal sign now all I
 

00:06:56.160 --> 00:06:59.240 align:start position:0%
and then insert the equal sign now all I
need<00:06:56.610><c> to</c><00:06:56.760><c> do</c><00:06:56.940><c> is</c><00:06:57.120><c> left-click</c><00:06:57.690><c> the</c><00:06:58.350><c> first</c><00:06:58.710><c> cell</c>

00:06:59.240 --> 00:06:59.250 align:start position:0%
need to do is left-click the first cell
 

00:06:59.250 --> 00:07:05.390 align:start position:0%
need to do is left-click the first cell
that<00:07:00.120><c> is</c><00:07:00.240><c> included</c><00:07:00.960><c> in</c><00:07:01.140><c> the</c><00:07:01.320><c> formula</c><00:07:04.400><c> the</c>

00:07:05.390 --> 00:07:05.400 align:start position:0%
that is included in the formula the
 

00:07:05.400 --> 00:07:07.160 align:start position:0%
that is included in the formula the
border<00:07:05.850><c> of</c><00:07:05.880><c> the</c><00:07:06.090><c> cell</c><00:07:06.330><c> changes</c><00:07:06.720><c> to</c><00:07:07.050><c> the</c>

00:07:07.160 --> 00:07:07.170 align:start position:0%
border of the cell changes to the
 

00:07:07.170 --> 00:07:10.490 align:start position:0%
border of the cell changes to the
marching<00:07:07.620><c> ants</c><00:07:07.920><c> and</c><00:07:08.340><c> the</c><00:07:08.760><c> cell</c><00:07:09.030><c> reference</c><00:07:09.690><c> c5</c>

00:07:10.490 --> 00:07:10.500 align:start position:0%
marching ants and the cell reference c5
 

00:07:10.500 --> 00:07:15.590 align:start position:0%
marching ants and the cell reference c5
appears<00:07:11.370><c> in</c><00:07:11.610><c> the</c><00:07:11.730><c> formula</c><00:07:12.270><c> here</c><00:07:14.240><c> you</c><00:07:15.240><c> can</c><00:07:15.420><c> see</c>

00:07:15.590 --> 00:07:15.600 align:start position:0%
appears in the formula here you can see
 

00:07:15.600 --> 00:07:19.640 align:start position:0%
appears in the formula here you can see
the<00:07:15.750><c> cursor</c><00:07:16.020><c> is</c><00:07:16.470><c> in</c><00:07:16.650><c> C</c><00:07:17.010><c> 30</c><00:07:17.640><c> so</c><00:07:18.540><c> now</c><00:07:18.870><c> I</c><00:07:18.900><c> can</c><00:07:19.290><c> enter</c>

00:07:19.640 --> 00:07:19.650 align:start position:0%
the cursor is in C 30 so now I can enter
 

00:07:19.650 --> 00:07:22.160 align:start position:0%
the cursor is in C 30 so now I can enter
the<00:07:19.680><c> subtraction</c><00:07:20.280><c> sign</c><00:07:20.600><c> to</c><00:07:21.600><c> let</c><00:07:21.750><c> Excel</c><00:07:21.900><c> know</c>

00:07:22.160 --> 00:07:22.170 align:start position:0%
the subtraction sign to let Excel know
 

00:07:22.170 --> 00:07:25.160 align:start position:0%
the subtraction sign to let Excel know
that<00:07:22.920><c> a</c><00:07:22.950><c> subtraction</c><00:07:23.640><c> operation</c><00:07:24.330><c> needs</c><00:07:24.990><c> to</c><00:07:25.110><c> be</c>

00:07:25.160 --> 00:07:25.170 align:start position:0%
that a subtraction operation needs to be
 

00:07:25.170 --> 00:07:26.230 align:start position:0%
that a subtraction operation needs to be
performed

00:07:26.230 --> 00:07:26.240 align:start position:0%
performed
 

00:07:26.240 --> 00:07:30.200 align:start position:0%
performed
now<00:07:27.240><c> just</c><00:07:28.110><c> left-click</c><00:07:28.680><c> the</c><00:07:29.070><c> next</c><00:07:29.550><c> cell</c><00:07:29.880><c> in</c><00:07:29.910><c> the</c>

00:07:30.200 --> 00:07:30.210 align:start position:0%
now just left-click the next cell in the
 

00:07:30.210 --> 00:07:34.370 align:start position:0%
now just left-click the next cell in the
formula<00:07:32.060><c> since</c><00:07:33.060><c> we</c><00:07:33.240><c> want</c><00:07:33.540><c> to</c><00:07:33.660><c> subtract</c><00:07:34.140><c> our</c>

00:07:34.370 --> 00:07:34.380 align:start position:0%
formula since we want to subtract our
 

00:07:34.380 --> 00:07:39.610 align:start position:0%
formula since we want to subtract our
January<00:07:34.890><c> expenses</c><00:07:35.720><c> we'll</c><00:07:36.720><c> select</c><00:07:36.990><c> C</c><00:07:37.680><c> 29</c>

00:07:39.610 --> 00:07:39.620 align:start position:0%
January expenses we'll select C 29
 

00:07:39.620 --> 00:07:43.030 align:start position:0%
January expenses we'll select C 29
now<00:07:40.430><c> it</c><00:07:40.640><c> appears</c><00:07:40.970><c> in</c><00:07:41.120><c> my</c><00:07:41.240><c> formula</c><00:07:41.750><c> if</c><00:07:42.080><c> we</c><00:07:42.680><c> have</c>

00:07:43.030 --> 00:07:43.040 align:start position:0%
now it appears in my formula if we have
 

00:07:43.040 --> 00:07:45.340 align:start position:0%
now it appears in my formula if we have
more<00:07:43.340><c> sales</c><00:07:43.640><c> to</c><00:07:43.850><c> subtract</c><00:07:44.300><c> we</c><00:07:44.990><c> would</c><00:07:45.170><c> just</c>

00:07:45.340 --> 00:07:45.350 align:start position:0%
more sales to subtract we would just
 

00:07:45.350 --> 00:07:47.410 align:start position:0%
more sales to subtract we would just
repeat<00:07:45.650><c> these</c><00:07:45.950><c> steps</c><00:07:46.160><c> until</c><00:07:46.580><c> the</c><00:07:46.820><c> formula</c><00:07:47.270><c> is</c>

00:07:47.410 --> 00:07:47.420 align:start position:0%
repeat these steps until the formula is
 

00:07:47.420 --> 00:07:51.600 align:start position:0%
repeat these steps until the formula is
complete<00:07:47.840><c> I'm</c><00:07:48.640><c> ready</c><00:07:49.640><c> to</c><00:07:49.850><c> click</c><00:07:50.060><c> enter</c><00:07:50.330><c> and</c>

00:07:51.600 --> 00:07:51.610 align:start position:0%
complete I'm ready to click enter and
 

00:07:51.610 --> 00:07:54.460 align:start position:0%
complete I'm ready to click enter and
now<00:07:52.610><c> the</c><00:07:52.670><c> formula</c><00:07:53.120><c> shows</c><00:07:53.540><c> me</c><00:07:53.780><c> how</c><00:07:54.020><c> much</c><00:07:54.170><c> money</c>

00:07:54.460 --> 00:07:54.470 align:start position:0%
now the formula shows me how much money
 

00:07:54.470 --> 00:07:56.980 align:start position:0%
now the formula shows me how much money
I<00:07:54.650><c> have</c><00:07:54.950><c> remaining</c><00:07:55.430><c> after</c><00:07:56.420><c> paying</c><00:07:56.660><c> all</c><00:07:56.930><c> my</c>

00:07:56.980 --> 00:07:56.990 align:start position:0%
I have remaining after paying all my
 

00:07:56.990 --> 00:08:01.240 align:start position:0%
I have remaining after paying all my
bills<00:07:58.900><c> you'll</c><00:07:59.900><c> find</c><00:08:00.230><c> the</c><00:08:00.470><c> points</c><00:08:00.890><c> and</c><00:08:01.040><c> click</c>

00:08:01.240 --> 00:08:01.250 align:start position:0%
bills you'll find the points and click
 

00:08:01.250 --> 00:08:03.130 align:start position:0%
bills you'll find the points and click
method<00:08:01.490><c> of</c><00:08:01.760><c> selecting</c><00:08:02.090><c> sales</c><00:08:02.510><c> is</c><00:08:02.810><c> really</c>

00:08:03.130 --> 00:08:03.140 align:start position:0%
method of selecting sales is really
 

00:08:03.140 --> 00:08:05.500 align:start position:0%
method of selecting sales is really
helpful<00:08:03.440><c> because</c><00:08:04.100><c> often</c><00:08:04.610><c> it's</c><00:08:04.790><c> just</c><00:08:04.850><c> easier</c>

00:08:05.500 --> 00:08:05.510 align:start position:0%
helpful because often it's just easier
 

00:08:05.510 --> 00:08:07.750 align:start position:0%
helpful because often it's just easier
and<00:08:05.570><c> faster</c><00:08:06.050><c> to</c><00:08:06.380><c> use</c><00:08:06.590><c> the</c><00:08:06.830><c> mouse</c><00:08:07.190><c> instead</c><00:08:07.550><c> of</c>

00:08:07.750 --> 00:08:07.760 align:start position:0%
and faster to use the mouse instead of
 

00:08:07.760 --> 00:08:13.120 align:start position:0%
and faster to use the mouse instead of
the<00:08:07.880><c> keyboard</c><00:08:11.080><c> we've</c><00:08:12.080><c> created</c><00:08:12.380><c> formulas</c>

00:08:13.120 --> 00:08:13.130 align:start position:0%
the keyboard we've created formulas
 

00:08:13.130 --> 00:08:15.550 align:start position:0%
the keyboard we've created formulas
using<00:08:13.550><c> the</c><00:08:13.760><c> addition</c><00:08:14.330><c> and</c><00:08:14.360><c> subtraction</c><00:08:15.260><c> signs</c>

00:08:15.550 --> 00:08:15.560 align:start position:0%
using the addition and subtraction signs
 

00:08:15.560 --> 00:08:18.010 align:start position:0%
using the addition and subtraction signs
but<00:08:16.220><c> you</c><00:08:16.340><c> can</c><00:08:16.490><c> also</c><00:08:16.730><c> use</c><00:08:16.940><c> a</c><00:08:17.150><c> multiplication</c>

00:08:18.010 --> 00:08:18.020 align:start position:0%
but you can also use a multiplication
 

00:08:18.020 --> 00:08:20.790 align:start position:0%
but you can also use a multiplication
and<00:08:18.170><c> division</c><00:08:18.590><c> signs</c><00:08:18.830><c> in</c><00:08:19.040><c> your</c><00:08:19.130><c> formulas</c><00:08:19.670><c> all</c>

00:08:20.790 --> 00:08:20.800 align:start position:0%
and division signs in your formulas all
 

00:08:20.800 --> 00:08:23.650 align:start position:0%
and division signs in your formulas all
four<00:08:21.800><c> of</c><00:08:21.830><c> these</c><00:08:22.040><c> math</c><00:08:22.370><c> medical</c><00:08:22.940><c> signs</c><00:08:23.240><c> or</c>

00:08:23.650 --> 00:08:23.660 align:start position:0%
four of these math medical signs or
 

00:08:23.660 --> 00:08:25.990 align:start position:0%
four of these math medical signs or
symbols<00:08:23.960><c> are</c><00:08:24.470><c> called</c><00:08:24.980><c> operators</c><00:08:25.760><c> because</c>

00:08:25.990 --> 00:08:26.000 align:start position:0%
symbols are called operators because
 

00:08:26.000 --> 00:08:27.760 align:start position:0%
symbols are called operators because
they<00:08:26.210><c> tell</c><00:08:26.480><c> Excel</c><00:08:26.870><c> what</c><00:08:26.900><c> type</c><00:08:27.590><c> of</c>

00:08:27.760 --> 00:08:27.770 align:start position:0%
they tell Excel what type of
 

00:08:27.770 --> 00:08:30.160 align:start position:0%
they tell Excel what type of
mathematical<00:08:28.550><c> operation</c><00:08:29.180><c> needs</c><00:08:29.960><c> to</c><00:08:30.080><c> be</c>

00:08:30.160 --> 00:08:30.170 align:start position:0%
mathematical operation needs to be
 

00:08:30.170 --> 00:08:34.120 align:start position:0%
mathematical operation needs to be
performed<00:08:31.960><c> you</c><00:08:32.960><c> need</c><00:08:33.200><c> to</c><00:08:33.380><c> know</c><00:08:33.590><c> this</c><00:08:33.800><c> term</c>

00:08:34.120 --> 00:08:34.130 align:start position:0%
performed you need to know this term
 

00:08:34.130 --> 00:08:36.370 align:start position:0%
performed you need to know this term
because<00:08:34.820><c> if</c><00:08:34.970><c> you</c><00:08:35.060><c> have</c><00:08:35.300><c> to</c><00:08:35.540><c> use</c><00:08:35.750><c> the</c><00:08:35.960><c> Excel</c>

00:08:36.370 --> 00:08:36.380 align:start position:0%
because if you have to use the Excel
 

00:08:36.380 --> 00:08:39.550 align:start position:0%
because if you have to use the Excel
help<00:08:36.830><c> tool</c><00:08:37.100><c> this</c><00:08:37.940><c> is</c><00:08:38.150><c> how</c><00:08:38.360><c> it</c><00:08:38.570><c> refers</c><00:08:39.020><c> to</c><00:08:39.050><c> these</c>

00:08:39.550 --> 00:08:39.560 align:start position:0%
help tool this is how it refers to these
 

00:08:39.560 --> 00:08:42.670 align:start position:0%
help tool this is how it refers to these
mathematical<00:08:40.340><c> signs</c>