WEBVTT
Kind: captions
Language: en

00:00:01.159 --> 00:00:03.739 align:start position:0%
 
Goodwill<00:00:02.159><c> Community</c><00:00:02.639><c> Foundation</c><00:00:03.300><c> creating</c>

00:00:03.739 --> 00:00:03.749 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.749 --> 00:00:08.980 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.350><c> for</c><00:00:04.379><c> a</c><00:00:04.620><c> better</c><00:00:04.649><c> life</c>

00:00:08.980 --> 00:00:08.990 align:start position:0%
 
 

00:00:08.990 --> 00:00:10.540 align:start position:0%
 
you<00:00:09.620><c> may</c><00:00:09.740><c> already</c><00:00:09.920><c> have</c><00:00:10.160><c> some</c><00:00:10.520><c> experience</c>

00:00:10.540 --> 00:00:10.550 align:start position:0%
you may already have some experience
 

00:00:10.550 --> 00:00:13.150 align:start position:0%
you may already have some experience
creating<00:00:11.480><c> simple</c><00:00:11.960><c> formulas</c><00:00:12.440><c> that</c><00:00:12.470><c> have</c><00:00:12.770><c> only</c>

00:00:13.150 --> 00:00:13.160 align:start position:0%
creating simple formulas that have only
 

00:00:13.160 --> 00:00:16.330 align:start position:0%
creating simple formulas that have only
one<00:00:13.460><c> type</c><00:00:13.700><c> of</c><00:00:13.760><c> operation</c><00:00:14.680><c> but</c><00:00:15.680><c> sometimes</c><00:00:16.190><c> you</c>

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

00:00:16.340 --> 00:00:18.130 align:start position:0%
one type of operation but sometimes you
have<00:00:16.369><c> to</c><00:00:16.520><c> create</c><00:00:16.850><c> more</c><00:00:17.150><c> complex</c><00:00:17.360><c> formulas</c>

00:00:18.130 --> 00:00:18.140 align:start position:0%
have to create more complex formulas
 

00:00:18.140 --> 00:00:20.200 align:start position:0%
have to create more complex formulas
that<00:00:18.349><c> do</c><00:00:18.650><c> have</c><00:00:18.830><c> more</c><00:00:19.010><c> than</c><00:00:19.099><c> one</c><00:00:19.279><c> Operator</c><00:00:19.700><c> for</c>

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

00:00:20.210 --> 00:00:23.710 align:start position:0%
that do have more than one Operator for
example<00:00:20.630><c> addition</c><00:00:21.200><c> and</c><00:00:21.380><c> multiplication</c><00:00:22.720><c> to</c>

00:00:23.710 --> 00:00:23.720 align:start position:0%
example addition and multiplication to
 

00:00:23.720 --> 00:00:25.179 align:start position:0%
example addition and multiplication to
do<00:00:23.840><c> this</c><00:00:23.990><c> correctly</c><00:00:24.170><c> you'll</c><00:00:24.860><c> need</c><00:00:25.070><c> to</c>

00:00:25.179 --> 00:00:25.189 align:start position:0%
do this correctly you'll need to
 

00:00:25.189 --> 00:00:27.159 align:start position:0%
do this correctly you'll need to
understand<00:00:25.669><c> how</c><00:00:25.849><c> Excel</c><00:00:26.239><c> is</c><00:00:26.419><c> calculating</c><00:00:27.079><c> the</c>

00:00:27.159 --> 00:00:27.169 align:start position:0%
understand how Excel is calculating the
 

00:00:27.169 --> 00:00:32.920 align:start position:0%
understand how Excel is calculating the
answer<00:00:29.980><c> when</c><00:00:30.980><c> solving</c><00:00:31.279><c> formulas</c><00:00:31.910><c> Excel</c><00:00:32.540><c> uses</c>

00:00:32.920 --> 00:00:32.930 align:start position:0%
answer when solving formulas Excel uses
 

00:00:32.930 --> 00:00:34.450 align:start position:0%
answer when solving formulas Excel uses
a<00:00:32.960><c> set</c><00:00:33.260><c> of</c><00:00:33.290><c> rules</c><00:00:33.410><c> called</c><00:00:33.890><c> the</c><00:00:34.010><c> order</c><00:00:34.310><c> of</c>

00:00:34.450 --> 00:00:34.460 align:start position:0%
a set of rules called the order of
 

00:00:34.460 --> 00:00:36.250 align:start position:0%
a set of rules called the order of
operations<00:00:35.120><c> which</c><00:00:35.540><c> you</c><00:00:35.690><c> might</c><00:00:35.840><c> remember</c><00:00:36.110><c> from</c>

00:00:36.250 --> 00:00:36.260 align:start position:0%
operations which you might remember from
 

00:00:36.260 --> 00:00:38.889 align:start position:0%
operations which you might remember from
math<00:00:36.530><c> class</c><00:00:36.850><c> the</c><00:00:37.850><c> order</c><00:00:38.149><c> of</c><00:00:38.300><c> operations</c>

00:00:38.889 --> 00:00:38.899 align:start position:0%
math class the order of operations
 

00:00:38.899 --> 00:00:40.420 align:start position:0%
math class the order of operations
determines<00:00:39.440><c> the</c><00:00:39.559><c> order</c><00:00:39.860><c> in</c><00:00:40.010><c> which</c><00:00:40.070><c> the</c>

00:00:40.420 --> 00:00:40.430 align:start position:0%
determines the order in which the
 

00:00:40.430 --> 00:00:42.310 align:start position:0%
determines the order in which the
formula<00:00:40.820><c> will</c><00:00:41.000><c> be</c><00:00:41.030><c> calculated</c><00:00:41.690><c> so</c><00:00:42.079><c> you</c><00:00:42.140><c> know</c>

00:00:42.310 --> 00:00:42.320 align:start position:0%
formula will be calculated so you know
 

00:00:42.320 --> 00:00:45.069 align:start position:0%
formula will be calculated so you know
exactly<00:00:42.710><c> how</c><00:00:43.010><c> to</c><00:00:43.039><c> write</c><00:00:43.280><c> it</c><00:00:43.429><c> out</c><00:00:43.780><c> the</c><00:00:44.780><c> first</c>

00:00:45.069 --> 00:00:45.079 align:start position:0%
exactly how to write it out the first
 

00:00:45.079 --> 00:00:46.419 align:start position:0%
exactly how to write it out the first
thing<00:00:45.260><c> that's</c><00:00:45.379><c> calculated</c><00:00:46.039><c> are</c><00:00:46.160><c> any</c>

00:00:46.419 --> 00:00:46.429 align:start position:0%
thing that's calculated are any
 

00:00:46.429 --> 00:00:49.930 align:start position:0%
thing that's calculated are any
equations<00:00:46.969><c> in</c><00:00:47.179><c> parentheses</c><00:00:48.550><c> then</c><00:00:49.550><c> if</c><00:00:49.820><c> you</c>

00:00:49.930 --> 00:00:49.940 align:start position:0%
equations in parentheses then if you
 

00:00:49.940 --> 00:00:51.549 align:start position:0%
equations in parentheses then if you
have<00:00:50.149><c> any</c><00:00:50.329><c> exponents</c><00:00:51.019><c> you'll</c><00:00:51.350><c> calculate</c>

00:00:51.549 --> 00:00:51.559 align:start position:0%
have any exponents you'll calculate
 

00:00:51.559 --> 00:00:55.329 align:start position:0%
have any exponents you'll calculate
those<00:00:53.109><c> next</c><00:00:54.109><c> is</c><00:00:54.260><c> multiplication</c><00:00:54.440><c> and</c>

00:00:55.329 --> 00:00:55.339 align:start position:0%
those next is multiplication and
 

00:00:55.339 --> 00:00:58.569 align:start position:0%
those next is multiplication and
division<00:00:55.820><c> and</c><00:00:56.739><c> finally</c><00:00:57.739><c> addition</c><00:00:58.249><c> and</c>

00:00:58.569 --> 00:00:58.579 align:start position:0%
division and finally addition and
 

00:00:58.579 --> 00:01:02.470 align:start position:0%
division and finally addition and
subtraction<00:01:00.460><c> Excel</c><00:01:01.460><c> knows</c><00:01:01.670><c> to</c><00:01:01.879><c> use</c><00:01:01.909><c> the</c><00:01:02.329><c> order</c>

00:01:02.470 --> 00:01:02.480 align:start position:0%
subtraction Excel knows to use the order
 

00:01:02.480 --> 00:01:04.570 align:start position:0%
subtraction Excel knows to use the order
of<00:01:02.719><c> operations</c><00:01:03.320><c> whenever</c><00:01:03.620><c> it</c><00:01:03.949><c> calculates</c><00:01:04.460><c> a</c>

00:01:04.570 --> 00:01:04.580 align:start position:0%
of operations whenever it calculates a
 

00:01:04.580 --> 00:01:07.149 align:start position:0%
of operations whenever it calculates a
complex<00:01:04.970><c> formula</c><00:01:05.420><c> it's</c><00:01:06.380><c> important</c><00:01:06.860><c> that</c><00:01:06.890><c> you</c>

00:01:07.149 --> 00:01:07.159 align:start position:0%
complex formula it's important that you
 

00:01:07.159 --> 00:01:09.160 align:start position:0%
complex formula it's important that you
remember<00:01:07.310><c> it</c><00:01:07.640><c> so</c><00:01:08.000><c> you</c><00:01:08.030><c> can</c><00:01:08.330><c> create</c><00:01:08.540><c> formulas</c>

00:01:09.160 --> 00:01:09.170 align:start position:0%
remember it so you can create formulas
 

00:01:09.170 --> 00:01:11.890 align:start position:0%
remember it so you can create formulas
that<00:01:09.200><c> will</c><00:01:09.440><c> give</c><00:01:09.620><c> you</c><00:01:09.740><c> the</c><00:01:09.860><c> correct</c><00:01:10.070><c> answer</c><00:01:10.900><c> to</c>

00:01:11.890 --> 00:01:11.900 align:start position:0%
that will give you the correct answer to
 

00:01:11.900 --> 00:01:13.749 align:start position:0%
that will give you the correct answer to
remember<00:01:12.290><c> the</c><00:01:12.409><c> order</c><00:01:12.590><c> you</c><00:01:13.009><c> can</c><00:01:13.189><c> just</c><00:01:13.430><c> use</c><00:01:13.610><c> the</c>

00:01:13.749 --> 00:01:13.759 align:start position:0%
remember the order you can just use the
 

00:01:13.759 --> 00:01:16.990 align:start position:0%
remember the order you can just use the
acronym<00:01:13.939><c> PEMDAS</c><00:01:14.869><c> or</c><00:01:15.340><c> to</c><00:01:16.340><c> make</c><00:01:16.490><c> it</c><00:01:16.610><c> even</c><00:01:16.820><c> easier</c>

00:01:16.990 --> 00:01:17.000 align:start position:0%
acronym PEMDAS or to make it even easier
 

00:01:17.000 --> 00:01:19.690 align:start position:0%
acronym PEMDAS or to make it even easier
remember<00:01:17.899><c> the</c><00:01:17.990><c> phrase</c><00:01:18.229><c> please</c><00:01:18.799><c> excuse</c><00:01:19.430><c> my</c>

00:01:19.690 --> 00:01:19.700 align:start position:0%
remember the phrase please excuse my
 

00:01:19.700 --> 00:01:23.499 align:start position:0%
remember the phrase please excuse my
dear<00:01:19.729><c> Aunt</c><00:01:20.240><c> Sally</c><00:01:21.640><c> let's</c><00:01:22.640><c> take</c><00:01:22.880><c> a</c><00:01:22.909><c> closer</c><00:01:23.240><c> look</c>

00:01:23.499 --> 00:01:23.509 align:start position:0%
dear Aunt Sally let's take a closer look
 

00:01:23.509 --> 00:01:28.569 align:start position:0%
dear Aunt Sally let's take a closer look
at<00:01:23.659><c> some</c><00:01:23.689><c> examples</c><00:01:24.350><c> in</c><00:01:26.200><c> this</c><00:01:27.200><c> formula</c><00:01:27.710><c> 5</c><00:01:28.219><c> plus</c>

00:01:28.569 --> 00:01:28.579 align:start position:0%
at some examples in this formula 5 plus
 

00:01:28.579 --> 00:01:31.569 align:start position:0%
at some examples in this formula 5 plus
2<00:01:28.850><c> is</c><00:01:29.090><c> in</c><00:01:29.360><c> parentheses</c><00:01:29.960><c> so</c><00:01:30.920><c> we'll</c><00:01:31.070><c> calculate</c>

00:01:31.569 --> 00:01:31.579 align:start position:0%
2 is in parentheses so we'll calculate
 

00:01:31.579 --> 00:01:34.690 align:start position:0%
2 is in parentheses so we'll calculate
that<00:01:31.790><c> first</c><00:01:32.090><c> to</c><00:01:32.420><c> get</c><00:01:32.540><c> 7</c><00:01:33.020><c> and</c><00:01:33.200><c> then</c><00:01:34.189><c> we</c><00:01:34.340><c> can</c><00:01:34.490><c> just</c>

00:01:34.690 --> 00:01:34.700 align:start position:0%
that first to get 7 and then we can just
 

00:01:34.700 --> 00:01:41.109 align:start position:0%
that first to get 7 and then we can just
multiply<00:01:34.729><c> 3</c><00:01:35.719><c> times</c><00:01:36.140><c> 7</c><00:01:36.590><c> to</c><00:01:36.979><c> get</c><00:01:37.189><c> 21</c><00:01:40.119><c> this</c>

00:01:41.109 --> 00:01:41.119 align:start position:0%
multiply 3 times 7 to get 21 this
 

00:01:41.119 --> 00:01:41.880 align:start position:0%
multiply 3 times 7 to get 21 this
formula

00:01:41.880 --> 00:01:41.890 align:start position:0%
formula
 

00:01:41.890 --> 00:01:45.899 align:start position:0%
formula
contains<00:01:42.100><c> an</c><00:01:42.250><c> exponent</c><00:01:42.670><c> 3</c><00:01:43.420><c> ^</c><00:01:43.630><c> 2</c><00:01:44.550><c> we'll</c><00:01:45.550><c> need</c><00:01:45.729><c> to</c>

00:01:45.899 --> 00:01:45.909 align:start position:0%
contains an exponent 3 ^ 2 we'll need to
 

00:01:45.909 --> 00:01:48.240 align:start position:0%
contains an exponent 3 ^ 2 we'll need to
calculate<00:01:46.120><c> that</c><00:01:46.540><c> first</c><00:01:46.930><c> and</c><00:01:47.229><c> then</c><00:01:47.290><c> we</c><00:01:47.950><c> can</c><00:01:47.979><c> do</c>

00:01:48.240 --> 00:01:48.250 align:start position:0%
calculate that first and then we can do
 

00:01:48.250 --> 00:01:53.550 align:start position:0%
calculate that first and then we can do
the<00:01:48.400><c> addition</c><00:01:50.640><c> if</c><00:01:51.900><c> you</c><00:01:52.900><c> have</c><00:01:52.930><c> multiplication</c>

00:01:53.550 --> 00:01:53.560 align:start position:0%
the addition if you have multiplication
 

00:01:53.560 --> 00:01:57.000 align:start position:0%
the addition if you have multiplication
or<00:01:54.130><c> division</c><00:01:54.159><c> that</c><00:01:55.030><c> will</c><00:01:55.180><c> come</c><00:01:55.390><c> next</c><00:01:55.830><c> here</c><00:01:56.830><c> we</c>

00:01:57.000 --> 00:01:57.010 align:start position:0%
or division that will come next here we
 

00:01:57.010 --> 00:02:00.900 align:start position:0%
or division that will come next here we
multiply<00:01:57.490><c> 2</c><00:01:57.850><c> times</c><00:01:57.880><c> 4</c><00:01:58.630><c> to</c><00:01:58.930><c> get</c><00:01:59.080><c> 8</c><00:01:59.350><c> and</c><00:01:59.619><c> 9</c><00:02:00.580><c> minus</c>

00:02:00.900 --> 00:02:00.910 align:start position:0%
multiply 2 times 4 to get 8 and 9 minus
 

00:02:00.910 --> 00:02:05.700 align:start position:0%
multiply 2 times 4 to get 8 and 9 minus
8<00:02:01.300><c> equals</c><00:02:01.509><c> 1</c><00:02:03.720><c> now</c><00:02:04.720><c> multiplication</c><00:02:05.560><c> and</c>

00:02:05.700 --> 00:02:05.710 align:start position:0%
8 equals 1 now multiplication and
 

00:02:05.710 --> 00:02:07.469 align:start position:0%
8 equals 1 now multiplication and
division<00:02:06.159><c> are</c><00:02:06.310><c> considered</c><00:02:06.790><c> to</c><00:02:06.940><c> be</c><00:02:07.119><c> on</c><00:02:07.330><c> the</c>

00:02:07.469 --> 00:02:07.479 align:start position:0%
division are considered to be on the
 

00:02:07.479 --> 00:02:10.020 align:start position:0%
division are considered to be on the
same<00:02:07.690><c> level</c><00:02:08.070><c> that</c><00:02:09.070><c> means</c><00:02:09.310><c> if</c><00:02:09.489><c> you</c><00:02:09.580><c> have</c><00:02:09.789><c> both</c>

00:02:10.020 --> 00:02:10.030 align:start position:0%
same level that means if you have both
 

00:02:10.030 --> 00:02:11.430 align:start position:0%
same level that means if you have both
of<00:02:10.060><c> them</c><00:02:10.360><c> in</c><00:02:10.479><c> your</c><00:02:10.509><c> formula</c><00:02:10.929><c> they're</c>

00:02:11.430 --> 00:02:11.440 align:start position:0%
of them in your formula they're
 

00:02:11.440 --> 00:02:14.220 align:start position:0%
of them in your formula they're
calculated<00:02:12.069><c> from</c><00:02:12.280><c> left</c><00:02:12.489><c> to</c><00:02:12.580><c> right</c><00:02:12.819><c> in</c><00:02:13.230><c> this</c>

00:02:14.220 --> 00:02:14.230 align:start position:0%
calculated from left to right in this
 

00:02:14.230 --> 00:02:16.729 align:start position:0%
calculated from left to right in this
example<00:02:14.650><c> we'll</c><00:02:15.040><c> do</c><00:02:15.250><c> the</c><00:02:15.400><c> division</c><00:02:15.640><c> first</c><00:02:15.850><c> and</c>

00:02:16.729 --> 00:02:16.739 align:start position:0%
example we'll do the division first and
 

00:02:16.739 --> 00:02:21.060 align:start position:0%
example we'll do the division first and
then<00:02:17.739><c> the</c><00:02:17.920><c> multiplication</c><00:02:18.150><c> if</c><00:02:19.709><c> we</c><00:02:20.709><c> wanted</c><00:02:20.980><c> the</c>

00:02:21.060 --> 00:02:21.070 align:start position:0%
then the multiplication if we wanted the
 

00:02:21.070 --> 00:02:23.190 align:start position:0%
then the multiplication if we wanted the
multiplication<00:02:21.100><c> to</c><00:02:21.970><c> happen</c><00:02:22.300><c> first</c><00:02:22.540><c> we</c><00:02:23.019><c> could</c>

00:02:23.190 --> 00:02:23.200 align:start position:0%
multiplication to happen first we could
 

00:02:23.200 --> 00:02:25.290 align:start position:0%
multiplication to happen first we could
just<00:02:23.380><c> put</c><00:02:23.590><c> it</c><00:02:23.620><c> in</c><00:02:23.800><c> parentheses</c><00:02:24.370><c> or</c><00:02:24.610><c> we</c><00:02:25.150><c> could</c>

00:02:25.290 --> 00:02:25.300 align:start position:0%
just put it in parentheses or we could
 

00:02:25.300 --> 00:02:26.699 align:start position:0%
just put it in parentheses or we could
rearrange<00:02:25.600><c> the</c><00:02:25.840><c> formula</c><00:02:26.380><c> so</c><00:02:26.590><c> the</c>

00:02:26.699 --> 00:02:26.709 align:start position:0%
rearrange the formula so the
 

00:02:26.709 --> 00:02:31.440 align:start position:0%
rearrange the formula so the
multiplication<00:02:27.310><c> was</c><00:02:27.670><c> on</c><00:02:27.820><c> the</c><00:02:27.940><c> left</c><00:02:30.450><c> finally</c>

00:02:31.440 --> 00:02:31.450 align:start position:0%
multiplication was on the left finally
 

00:02:31.450 --> 00:02:34.259 align:start position:0%
multiplication was on the left finally
we<00:02:31.720><c> have</c><00:02:31.870><c> addition</c><00:02:32.290><c> and</c><00:02:32.410><c> subtraction</c><00:02:33.269><c> just</c>

00:02:34.259 --> 00:02:34.269 align:start position:0%
we have addition and subtraction just
 

00:02:34.269 --> 00:02:36.240 align:start position:0%
we have addition and subtraction just
like<00:02:34.450><c> multiplication</c><00:02:35.230><c> and</c><00:02:35.380><c> division</c><00:02:35.830><c> these</c>

00:02:36.240 --> 00:02:36.250 align:start position:0%
like multiplication and division these
 

00:02:36.250 --> 00:02:38.430 align:start position:0%
like multiplication and division these
are<00:02:36.430><c> on</c><00:02:36.580><c> the</c><00:02:36.700><c> same</c><00:02:36.940><c> level</c><00:02:37.150><c> so</c><00:02:37.480><c> we'll</c><00:02:37.870><c> calculate</c>

00:02:38.430 --> 00:02:38.440 align:start position:0%
are on the same level so we'll calculate
 

00:02:38.440 --> 00:02:44.430 align:start position:0%
are on the same level so we'll calculate
them<00:02:38.620><c> from</c><00:02:38.950><c> left</c><00:02:39.160><c> to</c><00:02:39.280><c> right</c><00:02:42.780><c> ok</c><00:02:43.780><c> now</c><00:02:44.140><c> let's</c><00:02:44.380><c> put</c>

00:02:44.430 --> 00:02:44.440 align:start position:0%
them from left to right ok now let's put
 

00:02:44.440 --> 00:02:48.060 align:start position:0%
them from left to right ok now let's put
them<00:02:44.650><c> all</c><00:02:44.860><c> together</c><00:02:46.200><c> this</c><00:02:47.200><c> formula</c><00:02:47.739><c> may</c><00:02:47.860><c> look</c>

00:02:48.060 --> 00:02:48.070 align:start position:0%
them all together this formula may look
 

00:02:48.070 --> 00:02:49.890 align:start position:0%
them all together this formula may look
really<00:02:48.400><c> complicated</c><00:02:48.519><c> but</c><00:02:49.239><c> we're</c><00:02:49.450><c> just</c><00:02:49.480><c> going</c>

00:02:49.890 --> 00:02:49.900 align:start position:0%
really complicated but we're just going
 

00:02:49.900 --> 00:02:51.660 align:start position:0%
really complicated but we're just going
to<00:02:49.930><c> go</c><00:02:50.079><c> step</c><00:02:50.410><c> by</c><00:02:50.440><c> step</c><00:02:50.890><c> through</c><00:02:50.920><c> the</c><00:02:51.190><c> order</c><00:02:51.519><c> of</c>

00:02:51.660 --> 00:02:51.670 align:start position:0%
to go step by step through the order of
 

00:02:51.670 --> 00:02:53.340 align:start position:0%
to go step by step through the order of
operations<00:02:52.329><c> and</c><00:02:52.510><c> you'll</c><00:02:52.870><c> see</c><00:02:53.049><c> that</c><00:02:53.200><c> it's</c>

00:02:53.340 --> 00:02:53.350 align:start position:0%
operations and you'll see that it's
 

00:02:53.350 --> 00:02:55.890 align:start position:0%
operations and you'll see that it's
really<00:02:53.410><c> not</c><00:02:53.769><c> that</c><00:02:53.950><c> bad</c><00:02:54.360><c> we'll</c><00:02:55.360><c> start</c><00:02:55.660><c> with</c><00:02:55.780><c> the</c>

00:02:55.890 --> 00:02:55.900 align:start position:0%
really not that bad we'll start with the
 

00:02:55.900 --> 00:02:58.110 align:start position:0%
really not that bad we'll start with the
parentheses<00:02:56.400><c> we'll</c><00:02:57.400><c> calculate</c><00:02:57.610><c> each</c><00:02:58.090><c> of</c>

00:02:58.110 --> 00:02:58.120 align:start position:0%
parentheses we'll calculate each of
 

00:02:58.120 --> 00:03:01.380 align:start position:0%
parentheses we'll calculate each of
these<00:02:58.480><c> to</c><00:02:58.750><c> get</c><00:02:58.870><c> 2</c><00:02:59.200><c> and</c><00:02:59.470><c> 3</c><00:02:59.890><c> and</c><00:03:00.130><c> as</c><00:03:01.030><c> you</c><00:03:01.209><c> can</c><00:03:01.329><c> see</c>

00:03:01.380 --> 00:03:01.390 align:start position:0%
these to get 2 and 3 and as you can see
 

00:03:01.390 --> 00:03:03.390 align:start position:0%
these to get 2 and 3 and as you can see
the<00:03:01.720><c> formulas</c><00:03:02.170><c> already</c><00:03:02.620><c> starting</c><00:03:03.040><c> to</c><00:03:03.070><c> look</c><00:03:03.190><c> a</c>

00:03:03.390 --> 00:03:03.400 align:start position:0%
the formulas already starting to look a
 

00:03:03.400 --> 00:03:06.150 align:start position:0%
the formulas already starting to look a
bit<00:03:03.430><c> simpler</c><00:03:04.410><c> next</c><00:03:05.410><c> we'll</c><00:03:05.560><c> look</c><00:03:05.650><c> to</c><00:03:05.829><c> see</c><00:03:05.860><c> if</c>

00:03:06.150 --> 00:03:06.160 align:start position:0%
bit simpler next we'll look to see if
 

00:03:06.160 --> 00:03:07.949 align:start position:0%
bit simpler next we'll look to see if
there<00:03:06.370><c> are</c><00:03:06.400><c> any</c><00:03:06.459><c> exponents</c><00:03:06.790><c> in</c><00:03:07.360><c> this</c><00:03:07.510><c> formula</c>

00:03:07.949 --> 00:03:07.959 align:start position:0%
there are any exponents in this formula
 

00:03:07.959 --> 00:03:12.000 align:start position:0%
there are any exponents in this formula
there<00:03:08.739><c> is</c><00:03:08.769><c> 1</c><00:03:09.190><c> 2</c><00:03:09.910><c> to</c><00:03:10.120><c> the</c><00:03:10.239><c> 2nd</c><00:03:10.600><c> power</c><00:03:10.890><c> when</c><00:03:11.890><c> we</c>

00:03:12.000 --> 00:03:12.010 align:start position:0%
there is 1 2 to the 2nd power when we
 

00:03:12.010 --> 00:03:16.170 align:start position:0%
there is 1 2 to the 2nd power when we
calculate<00:03:12.549><c> it</c><00:03:12.700><c> it</c><00:03:12.880><c> becomes</c><00:03:13.390><c> 4</c><00:03:14.850><c> next</c><00:03:15.850><c> we'll</c><00:03:16.000><c> do</c>

00:03:16.170 --> 00:03:16.180 align:start position:0%
calculate it it becomes 4 next we'll do
 

00:03:16.180 --> 00:03:18.210 align:start position:0%
calculate it it becomes 4 next we'll do
the<00:03:16.209><c> multiplication</c><00:03:16.329><c> and</c><00:03:17.230><c> division</c><00:03:17.709><c> going</c>

00:03:18.210 --> 00:03:18.220 align:start position:0%
the multiplication and division going
 

00:03:18.220 --> 00:03:22.990 align:start position:0%
the multiplication and division going
from<00:03:18.549><c> left</c><00:03:18.820><c> to</c><00:03:18.910><c> right</c><00:03:19.180><c> and</c><00:03:21.299><c> now</c><00:03:22.299><c> all</c><00:03:22.510><c> that's</c>

00:03:22.990 --> 00:03:23.000 align:start position:0%
from left to right and now all that's
 

00:03:23.000 --> 00:03:25.000 align:start position:0%
from left to right and now all that's
this<00:03:23.120><c> addition</c><00:03:23.540><c> and</c><00:03:23.720><c> that</c><00:03:23.780><c> gives</c><00:03:24.710><c> us</c><00:03:24.830><c> our</c>

00:03:25.000 --> 00:03:25.010 align:start position:0%
this addition and that gives us our
 

00:03:25.010 --> 00:03:27.190 align:start position:0%
this addition and that gives us our
answer<00:03:25.400><c> which</c><00:03:25.790><c> is</c><00:03:25.820><c> eight</c><00:03:26.240><c> point</c><00:03:26.570><c> seven</c><00:03:26.810><c> five</c>

00:03:27.190 --> 00:03:27.200 align:start position:0%
answer which is eight point seven five
 

00:03:27.200 --> 00:03:29.560 align:start position:0%
answer which is eight point seven five
and<00:03:27.470><c> that's</c><00:03:28.310><c> the</c><00:03:28.520><c> same</c><00:03:28.730><c> answer</c><00:03:28.940><c> Excel</c><00:03:29.420><c> would</c>

00:03:29.560 --> 00:03:29.570 align:start position:0%
and that's the same answer Excel would
 

00:03:29.570 --> 00:03:31.270 align:start position:0%
and that's the same answer Excel would
give<00:03:29.750><c> you</c><00:03:29.870><c> if</c><00:03:30.080><c> you</c><00:03:30.200><c> entered</c><00:03:30.530><c> that</c><00:03:30.650><c> formula</c><00:03:30.710><c> in</c>

00:03:31.270 --> 00:03:31.280 align:start position:0%
give you if you entered that formula in
 

00:03:31.280 --> 00:03:35.800 align:start position:0%
give you if you entered that formula in
your<00:03:31.310><c> worksheet</c><00:03:34.180><c> now</c><00:03:35.180><c> I'm</c><00:03:35.360><c> going</c><00:03:35.540><c> to</c><00:03:35.600><c> show</c><00:03:35.750><c> you</c>

00:03:35.800 --> 00:03:35.810 align:start position:0%
your worksheet now I'm going to show you
 

00:03:35.810 --> 00:03:37.390 align:start position:0%
your worksheet now I'm going to show you
why<00:03:36.050><c> it's</c><00:03:36.230><c> so</c><00:03:36.320><c> important</c><00:03:36.890><c> that</c><00:03:36.950><c> you</c><00:03:37.040><c> follow</c>

00:03:37.390 --> 00:03:37.400 align:start position:0%
why it's so important that you follow
 

00:03:37.400 --> 00:03:39.640 align:start position:0%
why it's so important that you follow
the<00:03:37.610><c> order</c><00:03:37.880><c> of</c><00:03:37.910><c> operations</c><00:03:38.600><c> every</c><00:03:39.110><c> time</c><00:03:39.350><c> if</c>

00:03:39.640 --> 00:03:39.650 align:start position:0%
the order of operations every time if
 

00:03:39.650 --> 00:03:41.770 align:start position:0%
the order of operations every time if
you<00:03:40.130><c> don't</c><00:03:40.400><c> your</c><00:03:40.760><c> formulas</c><00:03:41.270><c> won't</c><00:03:41.510><c> give</c><00:03:41.660><c> you</c>

00:03:41.770 --> 00:03:41.780 align:start position:0%
you don't your formulas won't give you
 

00:03:41.780 --> 00:03:44.590 align:start position:0%
you don't your formulas won't give you
the<00:03:41.900><c> correct</c><00:03:42.140><c> answer</c><00:03:42.380><c> in</c><00:03:42.890><c> this</c><00:03:43.850><c> example</c><00:03:44.270><c> I'd</c>

00:03:44.590 --> 00:03:44.600 align:start position:0%
the correct answer in this example I'd
 

00:03:44.600 --> 00:03:47.020 align:start position:0%
the correct answer in this example I'd
like<00:03:44.660><c> to</c><00:03:44.930><c> add</c><00:03:45.080><c> these</c><00:03:45.560><c> three</c><00:03:45.620><c> values</c><00:03:46.280><c> and</c><00:03:46.760><c> find</c>

00:03:47.020 --> 00:03:47.030 align:start position:0%
like to add these three values and find
 

00:03:47.030 --> 00:03:49.500 align:start position:0%
like to add these three values and find
out<00:03:47.240><c> how</c><00:03:47.450><c> much</c><00:03:47.600><c> the</c><00:03:47.870><c> sales</c><00:03:48.110><c> tax</c><00:03:48.410><c> will</c><00:03:48.620><c> be</c><00:03:48.650><c> I'll</c>

00:03:49.500 --> 00:03:49.510 align:start position:0%
out how much the sales tax will be I'll
 

00:03:49.510 --> 00:03:52.060 align:start position:0%
out how much the sales tax will be I'll
start<00:03:50.510><c> by</c><00:03:50.630><c> typing</c><00:03:51.020><c> the</c><00:03:51.140><c> equal</c><00:03:51.290><c> sign</c><00:03:51.709><c> which</c><00:03:52.040><c> is</c>

00:03:52.060 --> 00:03:52.070 align:start position:0%
start by typing the equal sign which is
 

00:03:52.070 --> 00:03:54.730 align:start position:0%
start by typing the equal sign which is
how<00:03:52.310><c> you</c><00:03:52.370><c> always</c><00:03:52.670><c> start</c><00:03:53.030><c> a</c><00:03:53.090><c> formula</c><00:03:53.590><c> then</c><00:03:54.590><c> I'll</c>

00:03:54.730 --> 00:03:54.740 align:start position:0%
how you always start a formula then I'll
 

00:03:54.740 --> 00:04:03.640 align:start position:0%
how you always start a formula then I'll
calculate<00:03:54.950><c> D</c><00:03:55.520><c> 3</c><00:03:56.020><c> +</c><00:03:57.070><c> d</c><00:03:58.070><c> 4</c><00:03:58.100><c> +</c><00:03:59.770><c> D</c><00:04:00.770><c> 5</c><00:04:02.320><c> next</c><00:04:03.320><c> I'll</c>

00:04:03.640 --> 00:04:03.650 align:start position:0%
calculate D 3 + d 4 + D 5 next I'll
 

00:04:03.650 --> 00:04:06.310 align:start position:0%
calculate D 3 + d 4 + D 5 next I'll
multiply<00:04:03.890><c> by</c><00:04:04.520><c> point</c><00:04:04.820><c> zero</c><00:04:05.120><c> seven</c><00:04:05.570><c> five</c><00:04:05.780><c> which</c>

00:04:06.310 --> 00:04:06.320 align:start position:0%
multiply by point zero seven five which
 

00:04:06.320 --> 00:04:08.140 align:start position:0%
multiply by point zero seven five which
is<00:04:06.500><c> the</c><00:04:06.650><c> tax</c><00:04:06.890><c> rate</c><00:04:07.010><c> at</c><00:04:07.340><c> seven</c><00:04:07.760><c> point</c><00:04:07.940><c> five</c>

00:04:08.140 --> 00:04:08.150 align:start position:0%
is the tax rate at seven point five
 

00:04:08.150 --> 00:04:11.380 align:start position:0%
is the tax rate at seven point five
percent<00:04:09.280><c> now</c><00:04:10.280><c> this</c><00:04:10.580><c> may</c><00:04:10.760><c> look</c><00:04:10.790><c> like</c><00:04:11.060><c> it's</c>

00:04:11.380 --> 00:04:11.390 align:start position:0%
percent now this may look like it's
 

00:04:11.390 --> 00:04:13.000 align:start position:0%
percent now this may look like it's
going<00:04:11.570><c> to</c><00:04:11.660><c> give</c><00:04:11.810><c> us</c><00:04:11.840><c> the</c><00:04:12.110><c> correct</c><00:04:12.320><c> answer</c><00:04:12.530><c> but</c>

00:04:13.000 --> 00:04:13.010 align:start position:0%
going to give us the correct answer but
 

00:04:13.010 --> 00:04:15.370 align:start position:0%
going to give us the correct answer but
it's<00:04:13.190><c> not</c><00:04:13.430><c> that's</c><00:04:14.239><c> because</c><00:04:14.690><c> we</c><00:04:14.840><c> didn't</c><00:04:15.170><c> follow</c>

00:04:15.370 --> 00:04:15.380 align:start position:0%
it's not that's because we didn't follow
 

00:04:15.380 --> 00:04:18.250 align:start position:0%
it's not that's because we didn't follow
the<00:04:15.620><c> order</c><00:04:15.920><c> of</c><00:04:16.040><c> operations</c><00:04:17.260><c> remember</c>

00:04:18.250 --> 00:04:18.260 align:start position:0%
the order of operations remember
 

00:04:18.260 --> 00:04:20.830 align:start position:0%
the order of operations remember
multiplication<00:04:18.980><c> comes</c><00:04:19.609><c> before</c><00:04:19.760><c> addition</c>

00:04:20.830 --> 00:04:20.840 align:start position:0%
multiplication comes before addition
 

00:04:20.840 --> 00:04:23.890 align:start position:0%
multiplication comes before addition
so<00:04:21.500><c> excel</c><00:04:21.859><c> is</c><00:04:22.010><c> going</c><00:04:22.070><c> to</c><00:04:22.280><c> multiply</c><00:04:22.370><c> D</c><00:04:23.150><c> five</c><00:04:23.450><c> by</c>

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

00:04:23.900 --> 00:04:27.130 align:start position:0%
so excel is going to multiply D five by
point<00:04:24.260><c> zero</c><00:04:24.350><c> seven</c><00:04:25.040><c> five</c><00:04:25.220><c> first</c><00:04:25.870><c> then</c><00:04:26.870><c> it</c><00:04:27.050><c> will</c>

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

00:04:27.140 --> 00:04:30.750 align:start position:0%
point zero seven five first then it will
add<00:04:27.320><c> d3</c><00:04:27.979><c> and</c><00:04:28.160><c> d4</c><00:04:28.460><c> which</c><00:04:29.150><c> isn't</c><00:04:29.390><c> what</c><00:04:29.690><c> we</c><00:04:29.840><c> want</c>

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

00:04:30.760 --> 00:04:33.550 align:start position:0%
add d3 and d4 which isn't what we want
we<00:04:31.760><c> want</c><00:04:31.790><c> these</c><00:04:32.210><c> three</c><00:04:32.540><c> values</c><00:04:32.930><c> to</c><00:04:33.140><c> be</c><00:04:33.169><c> added</c>

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

00:04:33.560 --> 00:04:36.610 align:start position:0%
we want these three values to be added
first<00:04:33.970><c> so</c><00:04:34.970><c> to</c><00:04:35.030><c> do</c><00:04:35.330><c> that</c><00:04:35.360><c> we</c><00:04:35.960><c> just</c><00:04:36.169><c> need</c><00:04:36.320><c> to</c><00:04:36.410><c> put</c>

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

00:04:36.620 --> 00:04:40.060 align:start position:0%
first so to do that we just need to put
them<00:04:36.770><c> in</c><00:04:36.950><c> parentheses</c><00:04:38.410><c> parentheses</c><00:04:39.410><c> are</c>

00:04:40.060 --> 00:04:40.070 align:start position:0%
them in parentheses parentheses are
 

00:04:40.070 --> 00:04:41.830 align:start position:0%
them in parentheses parentheses are
often<00:04:40.430><c> the</c><00:04:40.520><c> best</c><00:04:40.550><c> way</c><00:04:40.850><c> of</c><00:04:41.000><c> controlling</c><00:04:41.510><c> which</c>

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

00:04:41.840 --> 00:04:43.659 align:start position:0%
often the best way of controlling which
parts<00:04:42.169><c> of</c><00:04:42.260><c> the</c><00:04:42.320><c> formula</c><00:04:42.680><c> are</c><00:04:43.010><c> calculated</c>

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

00:04:43.669 --> 00:04:46.270 align:start position:0%
parts of the formula are calculated
first<00:04:43.910><c> and</c><00:04:44.560><c> when</c><00:04:45.560><c> this</c><00:04:45.740><c> formula</c><00:04:46.160><c> is</c>

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

00:04:46.280 --> 00:04:49.330 align:start position:0%
first and when this formula is
calculated<00:04:47.110><c> we</c><00:04:48.110><c> can</c><00:04:48.290><c> see</c><00:04:48.470><c> that</c><00:04:48.620><c> the</c><00:04:48.740><c> answer</c><00:04:49.130><c> is</c>

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

00:04:49.340 --> 00:04:53.680 align:start position:0%
calculated we can see that the answer is
20<00:04:49.790><c> dollars</c><00:04:49.910><c> and</c><00:04:50.300><c> 56</c><00:04:50.870><c> cents</c><00:04:52.390><c> writing</c><00:04:53.390><c> complex</c>

00:04:53.680 --> 00:04:53.690 align:start position:0%
20 dollars and 56 cents writing complex
 

00:04:53.690 --> 00:04:55.420 align:start position:0%
20 dollars and 56 cents writing complex
formulas<00:04:54.320><c> really</c><00:04:54.770><c> isn't</c><00:04:54.919><c> that</c><00:04:55.220><c> difficult</c>

00:04:55.420 --> 00:04:55.430 align:start position:0%
formulas really isn't that difficult
 

00:04:55.430 --> 00:04:57.150 align:start position:0%
formulas really isn't that difficult
once<00:04:55.970><c> you</c><00:04:56.120><c> know</c><00:04:56.300><c> how</c><00:04:56.450><c> they</c><00:04:56.570><c> work</c><00:04:56.780><c> just</c>

00:04:57.150 --> 00:04:57.160 align:start position:0%
once you know how they work just
 

00:04:57.160 --> 00:04:59.140 align:start position:0%
once you know how they work just
remember<00:04:58.160><c> to</c><00:04:58.280><c> use</c><00:04:58.310><c> the</c><00:04:58.580><c> order</c><00:04:58.910><c> of</c><00:04:58.940><c> operations</c>

00:04:59.140 --> 00:04:59.150 align:start position:0%
remember to use the order of operations
 

00:04:59.150 --> 00:05:01.480 align:start position:0%
remember to use the order of operations
and<00:04:59.930><c> you'll</c><00:05:00.110><c> get</c><00:05:00.229><c> the</c><00:05:00.380><c> correct</c><00:05:00.500><c> answer</c><00:05:00.830><c> every</c>

00:05:01.480 --> 00:05:01.490 align:start position:0%
and you'll get the correct answer every
 

00:05:01.490 --> 00:05:03.010 align:start position:0%
and you'll get the correct answer every
time

00:05:03.010 --> 00:05:03.020 align:start position:0%
time
 

00:05:03.020 --> 00:05:05.080 align:start position:0%
time
you