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:10.560 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.629><c> a</c><00:00:03.870><c> better</c><00:00:04.020><c> life</c>

00:00:10.560 --> 00:00:10.570 align:start position:0%
 
 

00:00:10.570 --> 00:00:12.450 align:start position:0%
 
you<00:00:11.440><c> may</c><00:00:11.590><c> already</c><00:00:11.770><c> have</c><00:00:12.010><c> some</c><00:00:12.340><c> experience</c>

00:00:12.450 --> 00:00:12.460 align:start position:0%
you may already have some experience
 

00:00:12.460 --> 00:00:15.000 align:start position:0%
you may already have some experience
creating<00:00:13.420><c> simple</c><00:00:13.809><c> formulas</c><00:00:14.290><c> that</c><00:00:14.320><c> have</c><00:00:14.620><c> only</c>

00:00:15.000 --> 00:00:15.010 align:start position:0%
creating simple formulas that have only
 

00:00:15.010 --> 00:00:18.179 align:start position:0%
creating simple formulas that have only
one<00:00:15.309><c> type</c><00:00:15.580><c> of</c><00:00:15.610><c> operation</c><00:00:16.500><c> but</c><00:00:17.500><c> sometimes</c><00:00:18.040><c> you</c>

00:00:18.179 --> 00:00:18.189 align:start position:0%
one type of operation but sometimes you
 

00:00:18.189 --> 00:00:19.980 align:start position:0%
one type of operation but sometimes you
have<00:00:18.220><c> to</c><00:00:18.460><c> create</c><00:00:18.670><c> more</c><00:00:19.000><c> complex</c><00:00:19.210><c> formulas</c>

00:00:19.980 --> 00:00:19.990 align:start position:0%
have to create more complex formulas
 

00:00:19.990 --> 00:00:22.050 align:start position:0%
have to create more complex formulas
that<00:00:20.200><c> do</c><00:00:20.500><c> have</c><00:00:20.680><c> more</c><00:00:20.860><c> than</c><00:00:20.950><c> one</c><00:00:21.130><c> Operator</c><00:00:21.580><c> for</c>

00:00:22.050 --> 00:00:22.060 align:start position:0%
that do have more than one Operator for
 

00:00:22.060 --> 00:00:25.440 align:start position:0%
that do have more than one Operator for
example<00:00:22.480><c> addition</c><00:00:23.050><c> and</c><00:00:23.230><c> multiplication</c><00:00:24.450><c> to</c>

00:00:25.440 --> 00:00:25.450 align:start position:0%
example addition and multiplication to
 

00:00:25.450 --> 00:00:27.150 align:start position:0%
example addition and multiplication to
do<00:00:25.599><c> this</c><00:00:25.779><c> you'll</c><00:00:26.200><c> need</c><00:00:26.349><c> to</c><00:00:26.410><c> understand</c><00:00:26.980><c> how</c>

00:00:27.150 --> 00:00:27.160 align:start position:0%
do this you'll need to understand how
 

00:00:27.160 --> 00:00:32.519 align:start position:0%
do this you'll need to understand how
Excel<00:00:27.550><c> is</c><00:00:27.730><c> calculating</c><00:00:28.390><c> the</c><00:00:28.509><c> answer</c><00:00:31.529><c> Excel</c>

00:00:32.519 --> 00:00:32.529 align:start position:0%
Excel is calculating the answer Excel
 

00:00:32.529 --> 00:00:34.560 align:start position:0%
Excel is calculating the answer Excel
uses<00:00:32.950><c> a</c><00:00:32.980><c> set</c><00:00:33.250><c> of</c><00:00:33.280><c> rules</c><00:00:33.370><c> called</c><00:00:33.940><c> the</c><00:00:34.090><c> order</c><00:00:34.420><c> of</c>

00:00:34.560 --> 00:00:34.570 align:start position:0%
uses a set of rules called the order of
 

00:00:34.570 --> 00:00:36.299 align:start position:0%
uses a set of rules called the order of
operations<00:00:35.230><c> which</c><00:00:35.620><c> you</c><00:00:35.739><c> might</c><00:00:35.920><c> remember</c><00:00:36.070><c> from</c>

00:00:36.299 --> 00:00:36.309 align:start position:0%
operations which you might remember from
 

00:00:36.309 --> 00:00:38.819 align:start position:0%
operations which you might remember from
math<00:00:36.610><c> class</c><00:00:36.970><c> the</c><00:00:37.780><c> order</c><00:00:38.079><c> of</c><00:00:38.200><c> operations</c>

00:00:38.819 --> 00:00:38.829 align:start position:0%
math class the order of operations
 

00:00:38.829 --> 00:00:40.830 align:start position:0%
math class the order of operations
determines<00:00:39.430><c> which</c><00:00:39.610><c> parts</c><00:00:40.000><c> of</c><00:00:40.090><c> the</c><00:00:40.149><c> formula</c><00:00:40.239><c> to</c>

00:00:40.830 --> 00:00:40.840 align:start position:0%
determines which parts of the formula to
 

00:00:40.840 --> 00:00:43.590 align:start position:0%
determines which parts of the formula to
calculate<00:00:40.870><c> first</c><00:00:41.880><c> the</c><00:00:42.880><c> very</c><00:00:43.120><c> first</c><00:00:43.390><c> thing</c>

00:00:43.590 --> 00:00:43.600 align:start position:0%
calculate first the very first thing
 

00:00:43.600 --> 00:00:45.330 align:start position:0%
calculate first the very first thing
that<00:00:43.630><c> you</c><00:00:43.780><c> calculate</c><00:00:44.350><c> are</c><00:00:44.560><c> the</c><00:00:44.830><c> items</c><00:00:45.160><c> in</c>

00:00:45.330 --> 00:00:45.340 align:start position:0%
that you calculate are the items in
 

00:00:45.340 --> 00:00:48.240 align:start position:0%
that you calculate are the items in
parentheses<00:00:46.470><c> then</c><00:00:47.470><c> if</c><00:00:47.740><c> you</c><00:00:47.860><c> have</c><00:00:48.070><c> any</c>

00:00:48.240 --> 00:00:48.250 align:start position:0%
parentheses then if you have any
 

00:00:48.250 --> 00:00:52.110 align:start position:0%
parentheses then if you have any
exponents<00:00:48.700><c> you'll</c><00:00:49.270><c> calculate</c><00:00:49.480><c> those</c><00:00:50.940><c> next</c><00:00:51.940><c> is</c>

00:00:52.110 --> 00:00:52.120 align:start position:0%
exponents you'll calculate those next is
 

00:00:52.120 --> 00:00:55.620 align:start position:0%
exponents you'll calculate those next is
multiplication<00:00:52.300><c> and</c><00:00:53.170><c> division</c><00:00:53.680><c> and</c><00:00:54.630><c> finally</c>

00:00:55.620 --> 00:00:55.630 align:start position:0%
multiplication and division and finally
 

00:00:55.630 --> 00:00:59.640 align:start position:0%
multiplication and division and finally
addition<00:00:56.110><c> and</c><00:00:56.440><c> subtraction</c><00:00:58.200><c> Excel</c><00:00:59.200><c> knows</c><00:00:59.410><c> to</c>

00:00:59.640 --> 00:00:59.650 align:start position:0%
addition and subtraction Excel knows to
 

00:00:59.650 --> 00:01:01.680 align:start position:0%
addition and subtraction Excel knows to
use<00:00:59.680><c> the</c><00:01:00.070><c> order</c><00:01:00.250><c> of</c><00:01:00.370><c> operations</c><00:01:00.550><c> whenever</c><00:01:01.510><c> it</c>

00:01:01.680 --> 00:01:01.690 align:start position:0%
use the order of operations whenever it
 

00:01:01.690 --> 00:01:04.140 align:start position:0%
use the order of operations whenever it
calculates<00:01:02.200><c> a</c><00:01:02.320><c> complex</c><00:01:02.739><c> formula</c><00:01:03.160><c> it's</c>

00:01:04.140 --> 00:01:04.150 align:start position:0%
calculates a complex formula it's
 

00:01:04.150 --> 00:01:05.819 align:start position:0%
calculates a complex formula it's
important<00:01:04.600><c> that</c><00:01:04.629><c> you</c><00:01:04.900><c> remember</c><00:01:05.049><c> it</c><00:01:05.409><c> so</c><00:01:05.770><c> you</c>

00:01:05.819 --> 00:01:05.829 align:start position:0%
important that you remember it so you
 

00:01:05.829 --> 00:01:07.469 align:start position:0%
important that you remember it so you
can<00:01:06.070><c> create</c><00:01:06.280><c> formulas</c><00:01:06.939><c> that</c><00:01:06.970><c> will</c><00:01:07.210><c> give</c><00:01:07.390><c> you</c>

00:01:07.469 --> 00:01:07.479 align:start position:0%
can create formulas that will give you
 

00:01:07.479 --> 00:01:08.660 align:start position:0%
can create formulas that will give you
the<00:01:07.600><c> correct</c><00:01:07.840><c> answer</c>

00:01:08.660 --> 00:01:08.670 align:start position:0%
the correct answer
 

00:01:08.670 --> 00:01:11.340 align:start position:0%
the correct answer
to<00:01:09.670><c> remember</c><00:01:10.060><c> the</c><00:01:10.180><c> order</c><00:01:10.299><c> you</c><00:01:10.750><c> can</c><00:01:10.780><c> just</c><00:01:11.170><c> use</c>

00:01:11.340 --> 00:01:11.350 align:start position:0%
to remember the order you can just use
 

00:01:11.350 --> 00:01:14.460 align:start position:0%
to remember the order you can just use
the<00:01:11.530><c> acronym</c><00:01:11.710><c> PEMDAS</c><00:01:12.610><c> or</c><00:01:13.079><c> to</c><00:01:14.079><c> make</c><00:01:14.229><c> it</c><00:01:14.350><c> even</c>

00:01:14.460 --> 00:01:14.470 align:start position:0%
the acronym PEMDAS or to make it even
 

00:01:14.470 --> 00:01:17.190 align:start position:0%
the acronym PEMDAS or to make it even
easier<00:01:14.770><c> remember</c><00:01:15.670><c> the</c><00:01:15.760><c> phrase</c><00:01:15.970><c> please</c><00:01:16.570><c> excuse</c>

00:01:17.190 --> 00:01:17.200 align:start position:0%
easier remember the phrase please excuse
 

00:01:17.200 --> 00:01:21.030 align:start position:0%
easier remember the phrase please excuse
my<00:01:17.470><c> dear</c><00:01:17.500><c> Aunt</c><00:01:18.010><c> Sally</c><00:01:19.380><c> let's</c><00:01:20.380><c> go</c><00:01:20.590><c> over</c><00:01:20.830><c> each</c><00:01:21.010><c> of</c>

00:01:21.030 --> 00:01:21.040 align:start position:0%
my dear Aunt Sally let's go over each of
 

00:01:21.040 --> 00:01:25.320 align:start position:0%
my dear Aunt Sally let's go over each of
these<00:01:21.310><c> in</c><00:01:21.580><c> a</c><00:01:21.670><c> little</c><00:01:21.790><c> more</c><00:01:21.940><c> detail</c><00:01:22.510><c> in</c><00:01:24.330><c> this</c>

00:01:25.320 --> 00:01:25.330 align:start position:0%
these in a little more detail in this
 

00:01:25.330 --> 00:01:28.110 align:start position:0%
these in a little more detail in this
formula<00:01:25.840><c> five</c><00:01:26.350><c> plus</c><00:01:26.710><c> two</c><00:01:27.010><c> is</c><00:01:27.250><c> in</c><00:01:27.490><c> parentheses</c>

00:01:28.110 --> 00:01:28.120 align:start position:0%
formula five plus two is in parentheses
 

00:01:28.120 --> 00:01:30.690 align:start position:0%
formula five plus two is in parentheses
so<00:01:29.080><c> we'll</c><00:01:29.229><c> calculate</c><00:01:29.440><c> that</c><00:01:29.950><c> first</c><00:01:30.250><c> to</c><00:01:30.549><c> get</c>

00:01:30.690 --> 00:01:30.700 align:start position:0%
so we'll calculate that first to get
 

00:01:30.700 --> 00:01:32.969 align:start position:0%
so we'll calculate that first to get
seven<00:01:31.150><c> and</c><00:01:31.360><c> then</c><00:01:32.350><c> we</c><00:01:32.470><c> can</c><00:01:32.650><c> just</c><00:01:32.860><c> multiply</c>

00:01:32.969 --> 00:01:32.979 align:start position:0%
seven and then we can just multiply
 

00:01:32.979 --> 00:01:38.640 align:start position:0%
seven and then we can just multiply
three<00:01:33.880><c> times</c><00:01:33.909><c> seven</c><00:01:34.600><c> to</c><00:01:35.140><c> get</c><00:01:35.320><c> 21</c>

00:01:38.640 --> 00:01:38.650 align:start position:0%
 
 

00:01:38.650 --> 00:01:42.740 align:start position:0%
 
this<00:01:39.340><c> formula</c><00:01:39.850><c> contains</c><00:01:40.060><c> an</c><00:01:40.450><c> exponent</c><00:01:40.840><c> 3</c><00:01:41.590><c> ^</c><00:01:41.800><c> 2</c>

00:01:42.740 --> 00:01:42.750 align:start position:0%
this formula contains an exponent 3 ^ 2
 

00:01:42.750 --> 00:01:45.420 align:start position:0%
this formula contains an exponent 3 ^ 2
we'll<00:01:43.750><c> need</c><00:01:43.930><c> to</c><00:01:44.080><c> calculate</c><00:01:44.560><c> that</c><00:01:44.710><c> first</c><00:01:45.100><c> and</c>

00:01:45.420 --> 00:01:45.430 align:start position:0%
we'll need to calculate that first and
 

00:01:45.430 --> 00:01:51.359 align:start position:0%
we'll need to calculate that first and
then<00:01:45.490><c> we</c><00:01:46.120><c> can</c><00:01:46.150><c> do</c><00:01:46.420><c> the</c><00:01:46.570><c> addition</c>

00:01:51.359 --> 00:01:51.369 align:start position:0%
 
 

00:01:51.369 --> 00:01:53.459 align:start position:0%
 
if<00:01:51.490><c> you</c><00:01:52.210><c> have</c><00:01:52.420><c> multiplication</c><00:01:52.869><c> or</c><00:01:53.439><c> division</c>

00:01:53.459 --> 00:01:53.469 align:start position:0%
if you have multiplication or division
 

00:01:53.469 --> 00:01:57.149 align:start position:0%
if you have multiplication or division
that<00:01:54.340><c> will</c><00:01:54.490><c> come</c><00:01:54.700><c> next</c><00:01:55.170><c> here</c><00:01:56.170><c> we</c><00:01:56.200><c> multiply</c><00:01:56.799><c> 2</c>

00:01:57.149 --> 00:01:57.159 align:start position:0%
that will come next here we multiply 2
 

00:01:57.159 --> 00:02:03.139 align:start position:0%
that will come next here we multiply 2
times<00:01:57.189><c> 4</c><00:01:57.939><c> to</c><00:01:58.240><c> get</c><00:01:58.390><c> 8</c><00:01:58.659><c> and</c><00:01:59.009><c> 9</c><00:02:00.009><c> minus</c><00:02:00.340><c> 8</c><00:02:00.729><c> equals</c><00:02:00.939><c> 1</c>

00:02:03.139 --> 00:02:03.149 align:start position:0%
times 4 to get 8 and 9 minus 8 equals 1
 

00:02:03.149 --> 00:02:05.730 align:start position:0%
times 4 to get 8 and 9 minus 8 equals 1
now<00:02:04.149><c> multiplication</c><00:02:04.990><c> and</c><00:02:05.140><c> division</c><00:02:05.590><c> are</c>

00:02:05.730 --> 00:02:05.740 align:start position:0%
now multiplication and division are
 

00:02:05.740 --> 00:02:07.729 align:start position:0%
now multiplication and division are
considered<00:02:06.250><c> to</c><00:02:06.399><c> be</c><00:02:06.429><c> on</c><00:02:06.579><c> the</c><00:02:06.909><c> same</c><00:02:07.119><c> level</c><00:02:07.509><c> that</c>

00:02:07.729 --> 00:02:07.739 align:start position:0%
considered to be on the same level that
 

00:02:07.739 --> 00:02:09.960 align:start position:0%
considered to be on the same level that
means<00:02:08.739><c> if</c><00:02:08.920><c> you</c><00:02:09.039><c> have</c><00:02:09.250><c> both</c><00:02:09.429><c> of</c><00:02:09.670><c> them</c><00:02:09.819><c> in</c><00:02:09.940><c> your</c>

00:02:09.960 --> 00:02:09.970 align:start position:0%
means if you have both of them in your
 

00:02:09.970 --> 00:02:12.000 align:start position:0%
means if you have both of them in your
formula<00:02:10.539><c> they're</c><00:02:10.869><c> calculated</c><00:02:11.530><c> from</c><00:02:11.709><c> left</c><00:02:11.950><c> to</c>

00:02:12.000 --> 00:02:12.010 align:start position:0%
formula they're calculated from left to
 

00:02:12.010 --> 00:02:12.449 align:start position:0%
formula they're calculated from left to
right

00:02:12.449 --> 00:02:12.459 align:start position:0%
right
 

00:02:12.459 --> 00:02:15.089 align:start position:0%
right
in<00:02:12.690><c> this</c><00:02:13.690><c> example</c><00:02:14.110><c> we'll</c><00:02:14.500><c> do</c><00:02:14.709><c> the</c><00:02:14.830><c> division</c>

00:02:15.089 --> 00:02:15.099 align:start position:0%
in this example we'll do the division
 

00:02:15.099 --> 00:02:20.369 align:start position:0%
in this example we'll do the division
first<00:02:15.580><c> and</c><00:02:16.200><c> then</c><00:02:17.200><c> the</c><00:02:17.379><c> multiplication</c><00:02:17.819><c> if</c><00:02:19.379><c> we</c>

00:02:20.369 --> 00:02:20.379 align:start position:0%
first and then the multiplication if we
 

00:02:20.379 --> 00:02:21.960 align:start position:0%
first and then the multiplication if we
wanted<00:02:20.680><c> the</c><00:02:20.769><c> multiplication</c><00:02:20.799><c> to</c><00:02:21.640><c> happen</c>

00:02:21.960 --> 00:02:21.970 align:start position:0%
wanted the multiplication to happen
 

00:02:21.970 --> 00:02:23.490 align:start position:0%
wanted the multiplication to happen
first<00:02:22.239><c> we</c><00:02:22.720><c> could</c><00:02:22.870><c> just</c><00:02:23.049><c> put</c><00:02:23.260><c> it</c><00:02:23.380><c> in</c>

00:02:23.490 --> 00:02:23.500 align:start position:0%
first we could just put it in
 

00:02:23.500 --> 00:02:25.530 align:start position:0%
first we could just put it in
parentheses<00:02:24.069><c> or</c><00:02:24.310><c> we</c><00:02:24.819><c> could</c><00:02:25.000><c> rearrange</c><00:02:25.269><c> the</c>

00:02:25.530 --> 00:02:25.540 align:start position:0%
parentheses or we could rearrange the
 

00:02:25.540 --> 00:02:27.630 align:start position:0%
parentheses or we could rearrange the
formula<00:02:25.810><c> so</c><00:02:26.290><c> the</c><00:02:26.410><c> multiplication</c><00:02:26.980><c> was</c><00:02:27.370><c> on</c><00:02:27.519><c> the</c>

00:02:27.630 --> 00:02:27.640 align:start position:0%
formula so the multiplication was on the
 

00:02:27.640 --> 00:02:31.740 align:start position:0%
formula so the multiplication was on the
left<00:02:29.760><c> finally</c><00:02:30.760><c> we</c><00:02:31.030><c> have</c><00:02:31.180><c> addition</c><00:02:31.569><c> and</c>

00:02:31.740 --> 00:02:31.750 align:start position:0%
left finally we have addition and
 

00:02:31.750 --> 00:02:34.680 align:start position:0%
left finally we have addition and
subtraction<00:02:32.380><c> just</c><00:02:32.730><c> like</c><00:02:33.730><c> multiplication</c><00:02:34.180><c> and</c>

00:02:34.680 --> 00:02:34.690 align:start position:0%
subtraction just like multiplication and
 

00:02:34.690 --> 00:02:36.990 align:start position:0%
subtraction just like multiplication and
division<00:02:35.140><c> these</c><00:02:35.290><c> are</c><00:02:35.739><c> on</c><00:02:35.860><c> the</c><00:02:36.010><c> same</c><00:02:36.220><c> level</c><00:02:36.459><c> so</c>

00:02:36.990 --> 00:02:37.000 align:start position:0%
division these are on the same level so
 

00:02:37.000 --> 00:02:42.350 align:start position:0%
division these are on the same level so
we'll<00:02:37.180><c> calculate</c><00:02:37.420><c> them</c><00:02:37.930><c> from</c><00:02:38.230><c> left</c><00:02:38.470><c> to</c><00:02:38.590><c> right</c>

00:02:42.350 --> 00:02:42.360 align:start position:0%
 
 

00:02:42.360 --> 00:02:46.740 align:start position:0%
 
ok<00:02:43.360><c> now</c><00:02:43.720><c> let's</c><00:02:43.959><c> put</c><00:02:44.019><c> them</c><00:02:44.230><c> all</c><00:02:44.470><c> together</c><00:02:45.750><c> this</c>

00:02:46.740 --> 00:02:46.750 align:start position:0%
ok now let's put them all together this
 

00:02:46.750 --> 00:02:48.809 align:start position:0%
ok now let's put them all together this
formula<00:02:47.290><c> may</c><00:02:47.440><c> look</c><00:02:47.650><c> really</c><00:02:47.950><c> complicated</c><00:02:48.099><c> but</c>

00:02:48.809 --> 00:02:48.819 align:start position:0%
formula may look really complicated but
 

00:02:48.819 --> 00:02:49.979 align:start position:0%
formula may look really complicated but
we're<00:02:49.030><c> just</c><00:02:49.239><c> going</c><00:02:49.450><c> to</c><00:02:49.510><c> go</c><00:02:49.660><c> step-by-step</c>

00:02:49.979 --> 00:02:49.989 align:start position:0%
we're just going to go step-by-step
 

00:02:49.989 --> 00:02:52.080 align:start position:0%
we're just going to go step-by-step
through<00:02:50.500><c> the</c><00:02:50.829><c> order</c><00:02:51.099><c> of</c><00:02:51.220><c> operations</c><00:02:51.910><c> and</c>

00:02:52.080 --> 00:02:52.090 align:start position:0%
through the order of operations and
 

00:02:52.090 --> 00:02:53.930 align:start position:0%
through the order of operations and
you'll<00:02:52.450><c> see</c><00:02:52.629><c> that</c><00:02:52.780><c> it's</c><00:02:52.930><c> really</c><00:02:52.989><c> not</c><00:02:53.349><c> that</c><00:02:53.530><c> bad</c>

00:02:53.930 --> 00:02:53.940 align:start position:0%
you'll see that it's really not that bad
 

00:02:53.940 --> 00:02:56.970 align:start position:0%
you'll see that it's really not that bad
we'll<00:02:54.940><c> start</c><00:02:55.239><c> with</c><00:02:55.359><c> the</c><00:02:55.480><c> parentheses</c><00:02:55.980><c> we'll</c>

00:02:56.970 --> 00:02:56.980 align:start position:0%
we'll start with the parentheses we'll
 

00:02:56.980 --> 00:02:59.460 align:start position:0%
we'll start with the parentheses we'll
calculate<00:02:57.190><c> each</c><00:02:57.700><c> of</c><00:02:57.880><c> these</c><00:02:58.030><c> to</c><00:02:58.329><c> get</c><00:02:58.480><c> 2</c><00:02:58.780><c> and</c><00:02:59.079><c> 3</c>

00:02:59.460 --> 00:02:59.470 align:start position:0%
calculate each of these to get 2 and 3
 

00:02:59.470 --> 00:03:01.920 align:start position:0%
calculate each of these to get 2 and 3
and<00:02:59.739><c> as</c><00:03:00.549><c> you</c><00:03:00.700><c> can</c><00:03:00.850><c> see</c><00:03:00.910><c> the</c><00:03:01.239><c> formulas</c><00:03:01.690><c> already</c>

00:03:01.920 --> 00:03:01.930 align:start position:0%
and as you can see the formulas already
 

00:03:01.930 --> 00:03:04.920 align:start position:0%
and as you can see the formulas already
starting<00:03:02.560><c> to</c><00:03:02.590><c> look</c><00:03:02.709><c> a</c><00:03:02.920><c> bit</c><00:03:02.950><c> simpler</c><00:03:03.930><c> next</c>

00:03:04.920 --> 00:03:04.930 align:start position:0%
starting to look a bit simpler next
 

00:03:04.930 --> 00:03:05.970 align:start position:0%
starting to look a bit simpler next
we'll<00:03:05.079><c> look</c><00:03:05.170><c> to</c><00:03:05.319><c> see</c><00:03:05.350><c> if</c><00:03:05.650><c> there</c><00:03:05.859><c> are</c><00:03:05.889><c> any</c>

00:03:05.970 --> 00:03:05.980 align:start position:0%
we'll look to see if there are any
 

00:03:05.980 --> 00:03:09.390 align:start position:0%
we'll look to see if there are any
exponents<00:03:06.760><c> in</c><00:03:06.880><c> this</c><00:03:07.000><c> formula</c><00:03:07.480><c> there</c><00:03:08.260><c> is</c><00:03:08.290><c> 1</c><00:03:08.709><c> 2</c>

00:03:09.390 --> 00:03:09.400 align:start position:0%
exponents in this formula there is 1 2
 

00:03:09.400 --> 00:03:12.390 align:start position:0%
exponents in this formula there is 1 2
to<00:03:09.639><c> the</c><00:03:09.760><c> 2nd</c><00:03:10.120><c> power</c><00:03:10.410><c> when</c><00:03:11.410><c> we</c><00:03:11.530><c> calculate</c><00:03:12.069><c> it</c><00:03:12.190><c> it</c>

00:03:12.390 --> 00:03:12.400 align:start position:0%
to the 2nd power when we calculate it it
 

00:03:12.400 --> 00:03:15.720 align:start position:0%
to the 2nd power when we calculate it it
becomes<00:03:12.880><c> 4</c><00:03:14.370><c> next</c><00:03:15.370><c> we'll</c><00:03:15.519><c> do</c><00:03:15.700><c> the</c>

00:03:15.720 --> 00:03:15.730 align:start position:0%
becomes 4 next we'll do the
 

00:03:15.730 --> 00:03:18.089 align:start position:0%
becomes 4 next we'll do the
multiplication<00:03:15.880><c> and</c><00:03:16.720><c> division</c><00:03:17.230><c> going</c><00:03:17.769><c> from</c>

00:03:18.089 --> 00:03:18.099 align:start position:0%
multiplication and division going from
 

00:03:18.099 --> 00:03:22.620 align:start position:0%
multiplication and division going from
left<00:03:18.310><c> to</c><00:03:18.430><c> right</c><00:03:18.700><c> and</c><00:03:20.819><c> now</c><00:03:21.819><c> all</c><00:03:22.030><c> that's</c><00:03:22.180><c> left</c><00:03:22.480><c> is</c>

00:03:22.620 --> 00:03:22.630 align:start position:0%
left to right and now all that's left is
 

00:03:22.630 --> 00:03:24.599 align:start position:0%
left to right and now all that's left is
addition<00:03:23.079><c> and</c><00:03:23.260><c> that</c><00:03:24.010><c> gives</c><00:03:24.250><c> us</c><00:03:24.370><c> our</c><00:03:24.579><c> answer</c>

00:03:24.599 --> 00:03:24.609 align:start position:0%
addition and that gives us our answer
 

00:03:24.609 --> 00:03:28.229 align:start position:0%
addition and that gives us our answer
which<00:03:25.329><c> is</c><00:03:25.359><c> 8</c><00:03:25.780><c> point</c><00:03:26.109><c> 7</c><00:03:26.319><c> 5</c><00:03:26.680><c> and</c><00:03:27.069><c> that's</c><00:03:27.790><c> the</c><00:03:28.060><c> same</c>

00:03:28.229 --> 00:03:28.239 align:start position:0%
which is 8 point 7 5 and that's the same
 

00:03:28.239 --> 00:03:29.640 align:start position:0%
which is 8 point 7 5 and that's the same
answer<00:03:28.480><c> Excel</c><00:03:28.959><c> would</c><00:03:29.079><c> give</c><00:03:29.290><c> you</c><00:03:29.410><c> if</c><00:03:29.620><c> you</c>

00:03:29.640 --> 00:03:29.650 align:start position:0%
answer Excel would give you if you
 

00:03:29.650 --> 00:03:33.710 align:start position:0%
answer Excel would give you if you
entered<00:03:30.069><c> that</c><00:03:30.190><c> formula</c><00:03:30.250><c> in</c><00:03:30.819><c> your</c><00:03:30.849><c> worksheet</c>

00:03:33.710 --> 00:03:33.720 align:start position:0%
 
 

00:03:33.720 --> 00:03:35.849 align:start position:0%
 
now<00:03:34.720><c> I'm</c><00:03:34.900><c> going</c><00:03:35.049><c> to</c><00:03:35.139><c> show</c><00:03:35.319><c> you</c><00:03:35.349><c> why</c><00:03:35.590><c> it's</c><00:03:35.769><c> so</c>

00:03:35.849 --> 00:03:35.859 align:start position:0%
now I'm going to show you why it's so
 

00:03:35.859 --> 00:03:37.530 align:start position:0%
now I'm going to show you why it's so
important<00:03:36.430><c> that</c><00:03:36.489><c> you</c><00:03:36.669><c> follow</c><00:03:36.940><c> the</c><00:03:37.150><c> order</c><00:03:37.419><c> of</c>

00:03:37.530 --> 00:03:37.540 align:start position:0%
important that you follow the order of
 

00:03:37.540 --> 00:03:40.319 align:start position:0%
important that you follow the order of
operations<00:03:38.139><c> every</c><00:03:38.650><c> time</c><00:03:38.889><c> if</c><00:03:39.160><c> you</c><00:03:39.669><c> don't</c><00:03:39.940><c> your</c>

00:03:40.319 --> 00:03:40.329 align:start position:0%
operations every time if you don't your
 

00:03:40.329 --> 00:03:41.670 align:start position:0%
operations every time if you don't your
formulas<00:03:40.810><c> won't</c><00:03:41.049><c> give</c><00:03:41.230><c> you</c><00:03:41.319><c> the</c><00:03:41.440><c> correct</c>

00:03:41.670 --> 00:03:41.680 align:start position:0%
formulas won't give you the correct
 

00:03:41.680 --> 00:03:44.610 align:start position:0%
formulas won't give you the correct
answer<00:03:41.919><c> in</c><00:03:42.389><c> this</c><00:03:43.389><c> example</c><00:03:43.810><c> I'd</c><00:03:44.169><c> like</c><00:03:44.200><c> to</c><00:03:44.500><c> add</c>

00:03:44.610 --> 00:03:44.620 align:start position:0%
answer in this example I'd like to add
 

00:03:44.620 --> 00:03:47.159 align:start position:0%
answer in this example I'd like to add
these<00:03:45.130><c> three</c><00:03:45.459><c> values</c><00:03:45.760><c> and</c><00:03:46.299><c> find</c><00:03:46.569><c> out</c><00:03:46.780><c> how</c><00:03:46.989><c> much</c>

00:03:47.159 --> 00:03:47.169 align:start position:0%
these three values and find out how much
 

00:03:47.169 --> 00:03:50.190 align:start position:0%
these three values and find out how much
the<00:03:47.410><c> sales</c><00:03:47.650><c> tax</c><00:03:47.950><c> will</c><00:03:48.160><c> be</c><00:03:48.190><c> I'll</c><00:03:49.049><c> start</c><00:03:50.049><c> by</c>

00:03:50.190 --> 00:03:50.200 align:start position:0%
the sales tax will be I'll start by
 

00:03:50.200 --> 00:03:51.930 align:start position:0%
the sales tax will be I'll start by
typing<00:03:50.440><c> the</c><00:03:50.680><c> equal</c><00:03:50.829><c> sign</c><00:03:51.280><c> which</c><00:03:51.609><c> is</c><00:03:51.760><c> how</c><00:03:51.880><c> you</c>

00:03:51.930 --> 00:03:51.940 align:start position:0%
typing the equal sign which is how you
 

00:03:51.940 --> 00:03:54.960 align:start position:0%
typing the equal sign which is how you
always<00:03:52.060><c> start</c><00:03:52.599><c> a</c><00:03:52.660><c> formula</c><00:03:53.819><c> then</c><00:03:54.819><c> I'll</c>

00:03:54.960 --> 00:03:54.970 align:start position:0%
always start a formula then I'll
 

00:03:54.970 --> 00:04:03.120 align:start position:0%
always start a formula then I'll
calculate<00:03:55.180><c> D</c><00:03:55.750><c> 3</c><00:03:56.190><c> +</c><00:03:57.299><c> d</c><00:03:58.299><c> 4</c><00:03:58.329><c> +</c><00:04:00.000><c> D</c><00:04:01.000><c> 5</c>

00:04:03.120 --> 00:04:03.130 align:start position:0%
calculate D 3 + d 4 + D 5
 

00:04:03.130 --> 00:04:05.790 align:start position:0%
calculate D 3 + d 4 + D 5
next<00:04:03.700><c> I'll</c><00:04:03.880><c> multiply</c><00:04:04.120><c> by</c><00:04:04.750><c> point</c><00:04:05.050><c> zero</c><00:04:05.140><c> seven</c>

00:04:05.790 --> 00:04:05.800 align:start position:0%
next I'll multiply by point zero seven
 

00:04:05.800 --> 00:04:07.980 align:start position:0%
next I'll multiply by point zero seven
five<00:04:06.010><c> which</c><00:04:06.550><c> is</c><00:04:06.730><c> the</c><00:04:06.880><c> tax</c><00:04:07.120><c> rate</c><00:04:07.390><c> at</c><00:04:07.570><c> seven</c>

00:04:07.980 --> 00:04:07.990 align:start position:0%
five which is the tax rate at seven
 

00:04:07.990 --> 00:04:11.040 align:start position:0%
five which is the tax rate at seven
point<00:04:08.170><c> five</c><00:04:08.410><c> percent</c><00:04:09.510><c> now</c><00:04:10.510><c> this</c><00:04:10.840><c> may</c><00:04:11.020><c> look</c>

00:04:11.040 --> 00:04:11.050 align:start position:0%
point five percent now this may look
 

00:04:11.050 --> 00:04:12.540 align:start position:0%
point five percent now this may look
like<00:04:11.440><c> it's</c><00:04:11.620><c> going</c><00:04:11.800><c> to</c><00:04:11.950><c> give</c><00:04:12.070><c> us</c><00:04:12.190><c> the</c><00:04:12.340><c> correct</c>

00:04:12.540 --> 00:04:12.550 align:start position:0%
like it's going to give us the correct
 

00:04:12.550 --> 00:04:15.090 align:start position:0%
like it's going to give us the correct
answer<00:04:12.760><c> but</c><00:04:13.270><c> it's</c><00:04:13.450><c> not</c><00:04:13.660><c> that's</c><00:04:14.470><c> because</c><00:04:14.920><c> we</c>

00:04:15.090 --> 00:04:15.100 align:start position:0%
answer but it's not that's because we
 

00:04:15.100 --> 00:04:17.479 align:start position:0%
answer but it's not that's because we
didn't<00:04:15.400><c> follow</c><00:04:15.610><c> the</c><00:04:15.850><c> order</c><00:04:16.150><c> of</c><00:04:16.180><c> operations</c>

00:04:17.479 --> 00:04:17.489 align:start position:0%
didn't follow the order of operations
 

00:04:17.489 --> 00:04:20.010 align:start position:0%
didn't follow the order of operations
remember<00:04:18.489><c> multiplication</c><00:04:19.239><c> comes</c><00:04:19.870><c> before</c>

00:04:20.010 --> 00:04:20.020 align:start position:0%
remember multiplication comes before
 

00:04:20.020 --> 00:04:21.060 align:start position:0%
remember multiplication comes before
addition

00:04:21.060 --> 00:04:21.070 align:start position:0%
addition
 

00:04:21.070 --> 00:04:24.150 align:start position:0%
addition
so<00:04:21.730><c> excel</c><00:04:22.120><c> is</c><00:04:22.270><c> going</c><00:04:22.330><c> to</c><00:04:22.540><c> multiply</c><00:04:22.630><c> D</c><00:04:23.410><c> five</c><00:04:23.710><c> by</c>

00:04:24.150 --> 00:04:24.160 align:start position:0%
so excel is going to multiply D five by
 

00:04:24.160 --> 00:04:27.390 align:start position:0%
so excel is going to multiply D five by
point<00:04:24.520><c> zero</c><00:04:24.610><c> seven</c><00:04:25.270><c> five</c><00:04:25.480><c> first</c><00:04:26.100><c> then</c><00:04:27.100><c> it</c><00:04:27.310><c> will</c>

00:04:27.390 --> 00:04:27.400 align:start position:0%
point zero seven five first then it will
 

00:04:27.400 --> 00:04:31.010 align:start position:0%
point zero seven five first then it will
add<00:04:27.580><c> d3</c><00:04:28.210><c> and</c><00:04:28.450><c> d4</c><00:04:28.720><c> which</c><00:04:29.380><c> isn't</c><00:04:29.650><c> what</c><00:04:29.980><c> we</c><00:04:30.100><c> want</c>

00:04:31.010 --> 00:04:31.020 align:start position:0%
add d3 and d4 which isn't what we want
 

00:04:31.020 --> 00:04:33.810 align:start position:0%
add d3 and d4 which isn't what we want
we<00:04:32.020><c> want</c><00:04:32.230><c> these</c><00:04:32.440><c> three</c><00:04:32.800><c> values</c><00:04:33.190><c> to</c><00:04:33.400><c> be</c><00:04:33.430><c> added</c>

00:04:33.810 --> 00:04:33.820 align:start position:0%
we want these three values to be added
 

00:04:33.820 --> 00:04:36.870 align:start position:0%
we want these three values to be added
first<00:04:34.230><c> so</c><00:04:35.230><c> to</c><00:04:35.290><c> do</c><00:04:35.590><c> that</c><00:04:35.620><c> we</c><00:04:36.220><c> just</c><00:04:36.250><c> need</c><00:04:36.490><c> to</c><00:04:36.700><c> put</c>

00:04:36.870 --> 00:04:36.880 align:start position:0%
first so to do that we just need to put
 

00:04:36.880 --> 00:04:40.320 align:start position:0%
first so to do that we just need to put
them<00:04:37.000><c> in</c><00:04:37.210><c> parentheses</c><00:04:38.670><c> parentheses</c><00:04:39.670><c> are</c>

00:04:40.320 --> 00:04:40.330 align:start position:0%
them in parentheses parentheses are
 

00:04:40.330 --> 00:04:42.090 align:start position:0%
them in parentheses parentheses are
often<00:04:40.690><c> the</c><00:04:40.810><c> best</c><00:04:40.840><c> way</c><00:04:41.230><c> of</c><00:04:41.260><c> controlling</c><00:04:41.800><c> which</c>

00:04:42.090 --> 00:04:42.100 align:start position:0%
often the best way of controlling which
 

00:04:42.100 --> 00:04:43.950 align:start position:0%
often the best way of controlling which
parts<00:04:42.460><c> of</c><00:04:42.550><c> the</c><00:04:42.610><c> formula</c><00:04:42.670><c> are</c><00:04:43.270><c> calculated</c>

00:04:43.950 --> 00:04:43.960 align:start position:0%
parts of the formula are calculated
 

00:04:43.960 --> 00:04:46.560 align:start position:0%
parts of the formula are calculated
first<00:04:44.170><c> and</c><00:04:44.820><c> when</c><00:04:45.820><c> this</c><00:04:46.000><c> formula</c><00:04:46.450><c> is</c>

00:04:46.560 --> 00:04:46.570 align:start position:0%
first and when this formula is
 

00:04:46.570 --> 00:04:49.410 align:start position:0%
first and when this formula is
calculated<00:04:47.400><c> we</c><00:04:48.400><c> can</c><00:04:48.550><c> see</c><00:04:48.730><c> that</c><00:04:48.880><c> the</c><00:04:49.000><c> answer</c><00:04:49.390><c> is</c>

00:04:49.410 --> 00:04:49.420 align:start position:0%
calculated we can see that the answer is
 

00:04:49.420 --> 00:04:53.760 align:start position:0%
calculated we can see that the answer is
20<00:04:50.050><c> dollars</c><00:04:50.170><c> and</c><00:04:50.590><c> 56</c><00:04:51.130><c> cents</c><00:04:52.590><c> so</c><00:04:53.590><c> whenever</c>

00:04:53.760 --> 00:04:53.770 align:start position:0%
20 dollars and 56 cents so whenever
 

00:04:53.770 --> 00:04:56.010 align:start position:0%
20 dollars and 56 cents so whenever
you're<00:04:54.100><c> doing</c><00:04:54.280><c> a</c><00:04:54.490><c> complex</c><00:04:54.520><c> formula</c><00:04:55.390><c> just</c>

00:04:56.010 --> 00:04:56.020 align:start position:0%
you're doing a complex formula just
 

00:04:56.020 --> 00:04:57.450 align:start position:0%
you're doing a complex formula just
remember<00:04:56.440><c> to</c><00:04:56.620><c> follow</c><00:04:56.650><c> the</c><00:04:57.040><c> order</c><00:04:57.340><c> of</c>

00:04:57.450 --> 00:04:57.460 align:start position:0%
remember to follow the order of
 

00:04:57.460 --> 00:04:59.610 align:start position:0%
remember to follow the order of
operations<00:04:58.060><c> then</c><00:04:58.990><c> you'll</c><00:04:59.170><c> get</c><00:04:59.290><c> the</c><00:04:59.470><c> correct</c>

00:04:59.610 --> 00:04:59.620 align:start position:0%
operations then you'll get the correct
 

00:04:59.620 --> 00:05:02.790 align:start position:0%
operations then you'll get the correct
answer<00:04:59.980><c> every</c><00:05:00.760><c> time</c>