WEBVTT
Kind: captions
Language: en

00:00:04.790 --> 00:00:09.190 align:start position:0%
 
in<00:00:06.740><c> this</c><00:00:07.740><c> lesson</c><00:00:08.099><c> we're</c><00:00:08.639><c> going</c><00:00:08.820><c> to</c><00:00:08.940><c> explore</c>

00:00:09.190 --> 00:00:09.200 align:start position:0%
in this lesson we're going to explore
 

00:00:09.200 --> 00:00:12.200 align:start position:0%
in this lesson we're going to explore
functions<00:00:10.429><c> functions</c><00:00:11.429><c> are</c><00:00:11.550><c> predefined</c>

00:00:12.200 --> 00:00:12.210 align:start position:0%
functions functions are predefined
 

00:00:12.210 --> 00:00:15.379 align:start position:0%
functions functions are predefined
formulas<00:00:12.929><c> that</c><00:00:13.259><c> perform</c><00:00:13.679><c> calculations</c><00:00:14.389><c> using</c>

00:00:15.379 --> 00:00:15.389 align:start position:0%
formulas that perform calculations using
 

00:00:15.389 --> 00:00:18.279 align:start position:0%
formulas that perform calculations using
specific<00:00:16.139><c> values</c><00:00:16.740><c> in</c><00:00:17.070><c> a</c><00:00:17.190><c> particular</c><00:00:17.789><c> order</c>

00:00:18.279 --> 00:00:18.289 align:start position:0%
specific values in a particular order
 

00:00:18.289 --> 00:00:21.200 align:start position:0%
specific values in a particular order
while<00:00:19.289><c> you</c><00:00:19.500><c> may</c><00:00:19.710><c> think</c><00:00:20.039><c> of</c><00:00:20.189><c> formulas</c><00:00:20.760><c> as</c><00:00:20.939><c> being</c>

00:00:21.200 --> 00:00:21.210 align:start position:0%
while you may think of formulas as being
 

00:00:21.210 --> 00:00:24.560 align:start position:0%
while you may think of formulas as being
a<00:00:21.359><c> short</c><00:00:21.689><c> mathematical</c><00:00:22.590><c> equation</c><00:00:23.220><c> like</c><00:00:23.939><c> f</c><00:00:24.180><c> two</c>

00:00:24.560 --> 00:00:24.570 align:start position:0%
a short mathematical equation like f two
 

00:00:24.570 --> 00:00:28.509 align:start position:0%
a short mathematical equation like f two
times<00:00:24.990><c> C</c><00:00:25.619><c> two</c><00:00:25.890><c> they</c><00:00:26.699><c> can</c><00:00:27.060><c> be</c><00:00:27.269><c> really</c><00:00:27.599><c> lengthy</c>

00:00:28.509 --> 00:00:28.519 align:start position:0%
times C two they can be really lengthy
 

00:00:28.519 --> 00:00:31.640 align:start position:0%
times C two they can be really lengthy
Excel<00:00:29.519><c> even</c><00:00:29.910><c> gives</c><00:00:30.090><c> extra</c><00:00:30.630><c> space</c><00:00:30.929><c> here</c><00:00:31.380><c> in</c><00:00:31.560><c> the</c>

00:00:31.640 --> 00:00:31.650 align:start position:0%
Excel even gives extra space here in the
 

00:00:31.650 --> 00:00:36.190 align:start position:0%
Excel even gives extra space here in the
formula<00:00:31.949><c> bar</c><00:00:32.309><c> to</c><00:00:32.820><c> accommodate</c><00:00:33.420><c> long</c><00:00:33.660><c> formulas</c>

00:00:36.190 --> 00:00:36.200 align:start position:0%
formula bar to accommodate long formulas
 

00:00:36.200 --> 00:00:38.869 align:start position:0%
formula bar to accommodate long formulas
functions<00:00:37.200><c> can</c><00:00:37.410><c> actually</c><00:00:37.980><c> save</c><00:00:38.280><c> you</c><00:00:38.489><c> the</c><00:00:38.640><c> time</c>

00:00:38.869 --> 00:00:38.879 align:start position:0%
functions can actually save you the time
 

00:00:38.879 --> 00:00:41.180 align:start position:0%
functions can actually save you the time
of<00:00:39.120><c> writing</c><00:00:39.270><c> lengthy</c><00:00:39.809><c> formulas</c><00:00:40.350><c> because</c><00:00:41.040><c> the</c>

00:00:41.180 --> 00:00:41.190 align:start position:0%
of writing lengthy formulas because the
 

00:00:41.190 --> 00:00:43.750 align:start position:0%
of writing lengthy formulas because the
computation<00:00:42.000><c> the</c><00:00:42.239><c> function</c><00:00:42.690><c> will</c><00:00:42.840><c> perform</c><00:00:43.260><c> is</c>

00:00:43.750 --> 00:00:43.760 align:start position:0%
computation the function will perform is
 

00:00:43.760 --> 00:00:46.220 align:start position:0%
computation the function will perform is
predefined<00:00:44.760><c> so</c><00:00:45.270><c> that</c><00:00:45.390><c> you</c><00:00:45.539><c> don't</c><00:00:45.809><c> have</c><00:00:46.050><c> to</c>

00:00:46.220 --> 00:00:46.230 align:start position:0%
predefined so that you don't have to
 

00:00:46.230 --> 00:00:49.510 align:start position:0%
predefined so that you don't have to
answer<00:00:46.410><c> all</c><00:00:46.800><c> the</c><00:00:47.039><c> mathematical</c><00:00:47.670><c> operators</c>

00:00:49.510 --> 00:00:49.520 align:start position:0%
answer all the mathematical operators
 

00:00:49.520 --> 00:00:52.910 align:start position:0%
answer all the mathematical operators
for<00:00:50.520><c> example</c><00:00:51.120><c> let's</c><00:00:52.020><c> say</c><00:00:52.320><c> that</c><00:00:52.350><c> we</c><00:00:52.559><c> want</c><00:00:52.860><c> to</c>

00:00:52.910 --> 00:00:52.920 align:start position:0%
for example let's say that we want to
 

00:00:52.920 --> 00:00:54.740 align:start position:0%
for example let's say that we want to
find<00:00:53.160><c> the</c><00:00:53.340><c> total</c><00:00:53.730><c> cost</c><00:00:54.000><c> of</c><00:00:54.270><c> all</c><00:00:54.449><c> of</c><00:00:54.510><c> our</c>

00:00:54.740 --> 00:00:54.750 align:start position:0%
find the total cost of all of our
 

00:00:54.750 --> 00:00:57.920 align:start position:0%
find the total cost of all of our
inventory<00:00:55.850><c> basically</c><00:00:56.850><c> we</c><00:00:57.059><c> want</c><00:00:57.270><c> to</c><00:00:57.390><c> add</c><00:00:57.539><c> each</c>

00:00:57.920 --> 00:00:57.930 align:start position:0%
inventory basically we want to add each
 

00:00:57.930 --> 00:01:01.160 align:start position:0%
inventory basically we want to add each
item<00:00:58.379><c> in</c><00:00:58.500><c> column</c><00:00:58.949><c> G</c><00:00:59.250><c> together</c><00:00:59.989><c> instead</c><00:01:00.989><c> of</c>

00:01:01.160 --> 00:01:01.170 align:start position:0%
item in column G together instead of
 

00:01:01.170 --> 00:01:06.320 align:start position:0%
item in column G together instead of
writing<00:01:01.440><c> a</c><00:01:01.590><c> formula</c><00:01:01.620><c> to</c><00:01:02.250><c> add</c><00:01:02.550><c> G</c><00:01:03.120><c> 2</c><00:01:03.329><c> +</c><00:01:03.809><c> G</c><00:01:04.110><c> 3</c><00:01:04.739><c> +</c><00:01:05.519><c> G</c><00:01:06.030><c> 4</c>

00:01:06.320 --> 00:01:06.330 align:start position:0%
writing a formula to add G 2 + G 3 + G 4
 

00:01:06.330 --> 00:01:11.090 align:start position:0%
writing a formula to add G 2 + G 3 + G 4
and<00:01:06.720><c> so</c><00:01:07.020><c> on</c><00:01:07.260><c> we</c><00:01:08.100><c> could</c><00:01:08.280><c> use</c><00:01:08.490><c> a</c><00:01:08.520><c> function</c><00:01:10.100><c> let's</c>

00:01:11.090 --> 00:01:11.100 align:start position:0%
and so on we could use a function let's
 

00:01:11.100 --> 00:01:14.060 align:start position:0%
and so on we could use a function let's
scroll<00:01:11.430><c> down</c><00:01:11.490><c> to</c><00:01:11.700><c> a</c><00:01:11.939><c> 42</c><00:01:12.720><c> and</c><00:01:13.290><c> type</c><00:01:13.590><c> total</c>

00:01:14.060 --> 00:01:14.070 align:start position:0%
scroll down to a 42 and type total
 

00:01:14.070 --> 00:01:18.380 align:start position:0%
scroll down to a 42 and type total
inventory<00:01:14.640><c> cost</c><00:01:15.000><c> and</c><00:01:16.790><c> we're</c><00:01:17.790><c> going</c><00:01:18.030><c> to</c><00:01:18.090><c> use</c><00:01:18.360><c> a</c>

00:01:18.380 --> 00:01:18.390 align:start position:0%
inventory cost and we're going to use a
 

00:01:18.390 --> 00:01:21.230 align:start position:0%
inventory cost and we're going to use a
function<00:01:18.869><c> to</c><00:01:19.259><c> add</c><00:01:19.470><c> each</c><00:01:19.830><c> item</c><00:01:20.400><c> in</c><00:01:20.549><c> column</c><00:01:20.880><c> G</c>

00:01:21.230 --> 00:01:21.240 align:start position:0%
function to add each item in column G
 

00:01:21.240 --> 00:01:28.190 align:start position:0%
function to add each item in column G
and<00:01:21.650><c> place</c><00:01:22.650><c> the</c><00:01:22.890><c> total</c><00:01:23.130><c> here</c><00:01:23.790><c> in</c><00:01:23.909><c> G</c><00:01:24.630><c> 42</c><00:01:27.200><c> to</c>

00:01:28.190 --> 00:01:28.200 align:start position:0%
and place the total here in G 42 to
 

00:01:28.200 --> 00:01:31.100 align:start position:0%
and place the total here in G 42 to
access<00:01:28.710><c> our</c><00:01:28.829><c> functions</c><00:01:29.610><c> select</c><00:01:30.329><c> the</c><00:01:30.600><c> formulas</c>

00:01:31.100 --> 00:01:31.110 align:start position:0%
access our functions select the formulas
 

00:01:31.110 --> 00:01:34.910 align:start position:0%
access our functions select the formulas
tab<00:01:32.240><c> you'll</c><00:01:33.240><c> see</c><00:01:33.329><c> a</c><00:01:33.540><c> variety</c><00:01:33.750><c> of</c><00:01:34.200><c> commands</c><00:01:34.710><c> in</c>

00:01:34.910 --> 00:01:34.920 align:start position:0%
tab you'll see a variety of commands in
 

00:01:34.920 --> 00:01:38.719 align:start position:0%
tab you'll see a variety of commands in
the<00:01:35.009><c> function</c><00:01:35.430><c> library</c><00:01:35.460><c> group</c><00:01:36.799><c> from</c><00:01:37.799><c> here</c><00:01:38.310><c> we</c>

00:01:38.719 --> 00:01:38.729 align:start position:0%
the function library group from here we
 

00:01:38.729 --> 00:01:40.609 align:start position:0%
the function library group from here we
can<00:01:38.909><c> access</c><00:01:39.119><c> all</c><00:01:39.540><c> of</c><00:01:39.630><c> the</c><00:01:40.140><c> available</c>

00:01:40.609 --> 00:01:40.619 align:start position:0%
can access all of the available
 

00:01:40.619 --> 00:01:45.289 align:start position:0%
can access all of the available
functions<00:01:40.860><c> in</c><00:01:42.320><c> G</c><00:01:43.320><c> 42</c><00:01:44.009><c> I</c><00:01:44.399><c> want</c><00:01:44.759><c> to</c><00:01:44.909><c> insert</c><00:01:45.270><c> a</c>

00:01:45.289 --> 00:01:45.299 align:start position:0%
functions in G 42 I want to insert a
 

00:01:45.299 --> 00:01:47.749 align:start position:0%
functions in G 42 I want to insert a
function<00:01:45.600><c> that</c><00:01:45.869><c> adds</c><00:01:46.170><c> or</c><00:01:46.560><c> provides</c><00:01:47.130><c> the</c><00:01:47.460><c> sum</c>

00:01:47.749 --> 00:01:47.759 align:start position:0%
function that adds or provides the sum
 

00:01:47.759 --> 00:01:54.679 align:start position:0%
function that adds or provides the sum
of<00:01:48.060><c> all</c><00:01:48.689><c> the</c><00:01:48.990><c> cells</c><00:01:49.350><c> in</c><00:01:49.619><c> column</c><00:01:50.070><c> G</c><00:01:52.909><c> so</c><00:01:53.909><c> let's</c>

00:01:54.679 --> 00:01:54.689 align:start position:0%
of all the cells in column G so let's
 

00:01:54.689 --> 00:01:57.230 align:start position:0%
of all the cells in column G so let's
select<00:01:55.020><c> the</c><00:01:55.500><c> drop</c><00:01:55.740><c> down</c><00:01:55.979><c> arrow</c><00:01:56.340><c> next</c><00:01:56.909><c> to</c><00:01:57.090><c> the</c>

00:01:57.230 --> 00:01:57.240 align:start position:0%
select the drop down arrow next to the
 

00:01:57.240 --> 00:02:01.940 align:start position:0%
select the drop down arrow next to the
auto<00:01:57.450><c> sum</c><00:01:57.869><c> command</c><00:01:58.350><c> and</c><00:01:58.680><c> select</c><00:01:59.460><c> sum</c><00:02:00.950><c> you'll</c>

00:02:01.940 --> 00:02:01.950 align:start position:0%
auto sum command and select sum you'll
 

00:02:01.950 --> 00:02:05.319 align:start position:0%
auto sum command and select sum you'll
see<00:02:02.250><c> a</c><00:02:02.280><c> formula</c><00:02:02.939><c> has</c><00:02:03.119><c> been</c><00:02:03.149><c> defined</c><00:02:03.719><c> in</c><00:02:03.960><c> G</c><00:02:04.229><c> 42</c>

00:02:05.319 --> 00:02:05.329 align:start position:0%
see a formula has been defined in G 42
 

00:02:05.329 --> 00:02:09.800 align:start position:0%
see a formula has been defined in G 42
this<00:02:06.329><c> is</c><00:02:06.509><c> called</c><00:02:06.810><c> a</c><00:02:07.140><c> function</c><00:02:07.770><c> I</c><00:02:08.450><c> know</c><00:02:09.450><c> this</c>

00:02:09.800 --> 00:02:09.810 align:start position:0%
this is called a function I know this
 

00:02:09.810 --> 00:02:11.570 align:start position:0%
this is called a function I know this
looks<00:02:10.020><c> a</c><00:02:10.140><c> little</c><00:02:10.319><c> different</c><00:02:10.470><c> in</c><00:02:10.950><c> the</c><00:02:11.039><c> formulas</c>

00:02:11.570 --> 00:02:11.580 align:start position:0%
looks a little different in the formulas
 

00:02:11.580 --> 00:02:13.850 align:start position:0%
looks a little different in the formulas
you're<00:02:11.700><c> used</c><00:02:12.000><c> to</c><00:02:12.120><c> but</c><00:02:12.510><c> don't</c><00:02:12.750><c> worry</c><00:02:12.959><c> I</c><00:02:13.290><c> like</c>

00:02:13.850 --> 00:02:13.860 align:start position:0%
you're used to but don't worry I like
 

00:02:13.860 --> 00:02:15.500 align:start position:0%
you're used to but don't worry I like
explain<00:02:14.070><c> more</c><00:02:14.400><c> about</c><00:02:14.460><c> the</c><00:02:14.880><c> function</c><00:02:15.300><c> in</c><00:02:15.450><c> a</c>

00:02:15.500 --> 00:02:15.510 align:start position:0%
explain more about the function in a
 

00:02:15.510 --> 00:02:19.940 align:start position:0%
explain more about the function in a
minute<00:02:17.510><c> you</c><00:02:18.510><c> can</c><00:02:18.690><c> see</c><00:02:18.930><c> that</c><00:02:19.050><c> the</c><00:02:19.170><c> cells</c><00:02:19.500><c> in</c><00:02:19.830><c> the</c>

00:02:19.940 --> 00:02:19.950 align:start position:0%
minute you can see that the cells in the
 

00:02:19.950 --> 00:02:20.420 align:start position:0%
minute you can see that the cells in the
column

00:02:20.420 --> 00:02:20.430 align:start position:0%
column
 

00:02:20.430 --> 00:02:24.620 align:start position:0%
column
are<00:02:20.580><c> selected</c><00:02:22.400><c> the</c><00:02:23.400><c> autosum</c><00:02:24.030><c> command</c>

00:02:24.620 --> 00:02:24.630 align:start position:0%
are selected the autosum command
 

00:02:24.630 --> 00:02:27.260 align:start position:0%
are selected the autosum command
automatically<00:02:25.440><c> selects</c><00:02:26.040><c> the</c><00:02:26.160><c> cells</c><00:02:26.460><c> G</c><00:02:27.030><c> 2</c>

00:02:27.260 --> 00:02:27.270 align:start position:0%
automatically selects the cells G 2
 

00:02:27.270 --> 00:02:32.390 align:start position:0%
automatically selects the cells G 2
through<00:02:28.080><c> G</c><00:02:28.350><c> 41</c><00:02:29.660><c> this</c><00:02:30.660><c> is</c><00:02:30.870><c> called</c><00:02:31.140><c> a</c><00:02:31.380><c> range</c><00:02:31.860><c> of</c>

00:02:32.390 --> 00:02:32.400 align:start position:0%
through G 41 this is called a range of
 

00:02:32.400 --> 00:02:37.370 align:start position:0%
through G 41 this is called a range of
cells<00:02:34.610><c> Excel</c><00:02:35.610><c> essentially</c><00:02:36.270><c> predicted</c><00:02:36.990><c> those</c>

00:02:37.370 --> 00:02:37.380 align:start position:0%
cells Excel essentially predicted those
 

00:02:37.380 --> 00:02:39.890 align:start position:0%
cells Excel essentially predicted those
were<00:02:37.620><c> the</c><00:02:37.740><c> cells</c><00:02:37.980><c> I</c><00:02:38.160><c> wanted</c><00:02:38.670><c> based</c><00:02:39.270><c> on</c><00:02:39.510><c> where</c><00:02:39.870><c> I</c>

00:02:39.890 --> 00:02:39.900 align:start position:0%
were the cells I wanted based on where I
 

00:02:39.900 --> 00:02:44.120 align:start position:0%
were the cells I wanted based on where I
was<00:02:40.230><c> inserting</c><00:02:40.740><c> the</c><00:02:40.830><c> function</c><00:02:42.530><c> if</c><00:02:43.530><c> I</c><00:02:43.770><c> press</c>

00:02:44.120 --> 00:02:44.130 align:start position:0%
was inserting the function if I press
 

00:02:44.130 --> 00:02:47.390 align:start position:0%
was inserting the function if I press
the<00:02:44.160><c> Enter</c><00:02:44.820><c> key</c><00:02:44.850><c> or</c><00:02:45.450><c> the</c><00:02:45.570><c> enter</c><00:02:45.780><c> button</c><00:02:46.470><c> next</c>

00:02:47.390 --> 00:02:47.400 align:start position:0%
the Enter key or the enter button next
 

00:02:47.400 --> 00:02:52.070 align:start position:0%
the Enter key or the enter button next
to<00:02:47.580><c> the</c><00:02:47.700><c> formula</c><00:02:48.030><c> bar</c><00:02:48.920><c> the</c><00:02:49.920><c> total</c><00:02:50.310><c> appears</c><00:02:51.080><c> we</c>

00:02:52.070 --> 00:02:52.080 align:start position:0%
to the formula bar the total appears we
 

00:02:52.080 --> 00:02:54.260 align:start position:0%
to the formula bar the total appears we
can<00:02:52.260><c> see</c><00:02:52.440><c> that</c><00:02:52.560><c> our</c><00:02:52.709><c> inventory</c><00:02:53.340><c> is</c><00:02:53.520><c> worth</c><00:02:53.820><c> four</c>

00:02:54.260 --> 00:02:54.270 align:start position:0%
can see that our inventory is worth four
 

00:02:54.270 --> 00:02:56.390 align:start position:0%
can see that our inventory is worth four
thousand<00:02:54.930><c> three</c><00:02:55.140><c> hundred</c><00:02:55.500><c> seventy</c><00:02:56.280><c> one</c>

00:02:56.390 --> 00:02:56.400 align:start position:0%
thousand three hundred seventy one
 

00:02:56.400 --> 00:03:00.800 align:start position:0%
thousand three hundred seventy one
dollars<00:02:56.430><c> and</c><00:02:57.120><c> six</c><00:02:57.450><c> cents</c><00:02:58.880><c> now</c><00:02:59.880><c> what</c><00:03:00.600><c> if</c><00:03:00.720><c> you</c>

00:03:00.800 --> 00:03:00.810 align:start position:0%
dollars and six cents now what if you
 

00:03:00.810 --> 00:03:04.210 align:start position:0%
dollars and six cents now what if you
didn't<00:03:01.170><c> want</c><00:03:01.560><c> all</c><00:03:01.830><c> of</c><00:03:01.860><c> those</c><00:03:02.100><c> cells</c><00:03:02.430><c> selected</c>

00:03:04.210 --> 00:03:04.220 align:start position:0%
didn't want all of those cells selected
 

00:03:04.220 --> 00:03:08.960 align:start position:0%
didn't want all of those cells selected
well<00:03:05.220><c> you</c><00:03:05.850><c> can</c><00:03:06.030><c> edit</c><00:03:06.239><c> the</c><00:03:06.420><c> function</c><00:03:07.970><c> let's</c>

00:03:08.960 --> 00:03:08.970 align:start position:0%
well you can edit the function let's
 

00:03:08.970 --> 00:03:11.780 align:start position:0%
well you can edit the function let's
just<00:03:09.330><c> select</c><00:03:09.510><c> the</c><00:03:09.810><c> cell</c><00:03:10.080><c> and</c><00:03:10.590><c> go</c><00:03:11.190><c> up</c><00:03:11.430><c> to</c><00:03:11.670><c> our</c>

00:03:11.780 --> 00:03:11.790 align:start position:0%
just select the cell and go up to our
 

00:03:11.790 --> 00:03:16.699 align:start position:0%
just select the cell and go up to our
formula<00:03:12.270><c> bar</c><00:03:12.630><c> we</c><00:03:13.250><c> can</c><00:03:14.250><c> edit</c><00:03:14.700><c> the</c><00:03:14.970><c> range</c><00:03:15.709><c> right</c>

00:03:16.699 --> 00:03:16.709 align:start position:0%
formula bar we can edit the range right
 

00:03:16.709 --> 00:03:19.820 align:start position:0%
formula bar we can edit the range right
now<00:03:16.739><c> the</c><00:03:17.010><c> function</c><00:03:17.520><c> adds</c><00:03:17.850><c> cells</c><00:03:18.420><c> G</c><00:03:18.840><c> to</c><00:03:19.049><c> three</c><00:03:19.590><c> G</c>

00:03:19.820 --> 00:03:19.830 align:start position:0%
now the function adds cells G to three G
 

00:03:19.830 --> 00:03:23.449 align:start position:0%
now the function adds cells G to three G
41<00:03:20.400><c> if</c><00:03:20.900><c> we</c><00:03:21.900><c> don't</c><00:03:22.110><c> want</c><00:03:22.410><c> to</c><00:03:22.530><c> include</c><00:03:22.799><c> the</c><00:03:22.950><c> cups</c>

00:03:23.449 --> 00:03:23.459 align:start position:0%
41 if we don't want to include the cups
 

00:03:23.459 --> 00:03:26.060 align:start position:0%
41 if we don't want to include the cups
in<00:03:23.670><c> our</c><00:03:23.790><c> inventory</c><00:03:24.120><c> total</c><00:03:24.810><c> we</c><00:03:25.650><c> can</c><00:03:25.830><c> change</c>

00:03:26.060 --> 00:03:26.070 align:start position:0%
in our inventory total we can change
 

00:03:26.070 --> 00:03:32.810 align:start position:0%
in our inventory total we can change
this<00:03:26.430><c> to</c><00:03:26.489><c> G</c><00:03:27.060><c> 39</c><00:03:28.940><c> and</c><00:03:31.220><c> then</c><00:03:32.220><c> click</c><00:03:32.580><c> the</c><00:03:32.790><c> insert</c>

00:03:32.810 --> 00:03:32.820 align:start position:0%
this to G 39 and then click the insert
 

00:03:32.820 --> 00:03:36.259 align:start position:0%
this to G 39 and then click the insert
icon<00:03:34.040><c> we</c><00:03:35.040><c> can</c><00:03:35.220><c> see</c><00:03:35.459><c> that</c><00:03:35.610><c> the</c><00:03:35.730><c> total</c><00:03:36.150><c> has</c>

00:03:36.259 --> 00:03:36.269 align:start position:0%
icon we can see that the total has
 

00:03:36.269 --> 00:03:39.820 align:start position:0%
icon we can see that the total has
changed<00:03:36.720><c> to</c><00:03:36.810><c> reflect</c><00:03:36.930><c> our</c><00:03:37.530><c> new</c><00:03:37.860><c> range</c><00:03:38.190><c> I</c>

00:03:39.820 --> 00:03:39.830 align:start position:0%
changed to reflect our new range I
 

00:03:39.830 --> 00:03:42.530 align:start position:0%
changed to reflect our new range I
actually<00:03:40.830><c> do</c><00:03:41.400><c> want</c><00:03:41.730><c> all</c><00:03:41.970><c> my</c><00:03:42.299><c> inventory</c>

00:03:42.530 --> 00:03:42.540 align:start position:0%
actually do want all my inventory
 

00:03:42.540 --> 00:03:45.560 align:start position:0%
actually do want all my inventory
selected<00:03:43.410><c> so</c><00:03:43.890><c> let's</c><00:03:43.920><c> just</c><00:03:44.370><c> click</c><00:03:44.610><c> undo</c><00:03:45.209><c> on</c><00:03:45.540><c> the</c>

00:03:45.560 --> 00:03:45.570 align:start position:0%
selected so let's just click undo on the
 

00:03:45.570 --> 00:03:47.750 align:start position:0%
selected so let's just click undo on the
quick<00:03:45.660><c> access</c><00:03:45.870><c> toolbar</c><00:03:46.290><c> to</c><00:03:47.040><c> go</c><00:03:47.130><c> back</c><00:03:47.400><c> to</c><00:03:47.580><c> our</c>

00:03:47.750 --> 00:03:47.760 align:start position:0%
quick access toolbar to go back to our
 

00:03:47.760 --> 00:03:52.220 align:start position:0%
quick access toolbar to go back to our
original<00:03:48.390><c> function</c><00:03:50.060><c> now</c><00:03:51.060><c> let's</c><00:03:51.600><c> take</c><00:03:51.870><c> a</c><00:03:51.900><c> look</c>

00:03:52.220 --> 00:03:52.230 align:start position:0%
original function now let's take a look
 

00:03:52.230 --> 00:03:53.960 align:start position:0%
original function now let's take a look
at<00:03:52.350><c> the</c><00:03:52.440><c> parts</c><00:03:52.860><c> of</c><00:03:52.980><c> the</c><00:03:53.070><c> function</c><00:03:53.580><c> in</c><00:03:53.700><c> closer</c>

00:03:53.960 --> 00:03:53.970 align:start position:0%
at the parts of the function in closer
 

00:03:53.970 --> 00:03:59.330 align:start position:0%
at the parts of the function in closer
detail<00:03:56.030><c> each</c><00:03:57.110><c> function</c><00:03:58.110><c> has</c><00:03:58.590><c> a</c><00:03:58.620><c> specific</c>

00:03:59.330 --> 00:03:59.340 align:start position:0%
detail each function has a specific
 

00:03:59.340 --> 00:04:02.690 align:start position:0%
detail each function has a specific
order<00:03:59.640><c> called</c><00:04:00.299><c> syntax</c><00:04:01.190><c> which</c><00:04:02.190><c> must</c><00:04:02.580><c> be</c>

00:04:02.690 --> 00:04:02.700 align:start position:0%
order called syntax which must be
 

00:04:02.700 --> 00:04:04.820 align:start position:0%
order called syntax which must be
strictly<00:04:03.180><c> followed</c><00:04:03.780><c> for</c><00:04:04.170><c> the</c><00:04:04.230><c> function</c><00:04:04.709><c> to</c>

00:04:04.820 --> 00:04:04.830 align:start position:0%
strictly followed for the function to
 

00:04:04.830 --> 00:04:08.810 align:start position:0%
strictly followed for the function to
work<00:04:05.040><c> correctly</c><00:04:06.440><c> all</c><00:04:07.440><c> functions</c><00:04:08.370><c> begin</c><00:04:08.549><c> with</c>

00:04:08.810 --> 00:04:08.820 align:start position:0%
work correctly all functions begin with
 

00:04:08.820 --> 00:04:13.610 align:start position:0%
work correctly all functions begin with
the<00:04:08.910><c> equals</c><00:04:09.269><c> sign</c><00:04:09.560><c> after</c><00:04:11.239><c> the</c><00:04:12.239><c> equal</c><00:04:12.660><c> sign</c><00:04:12.930><c> you</c>

00:04:13.610 --> 00:04:13.620 align:start position:0%
the equals sign after the equal sign you
 

00:04:13.620 --> 00:04:16.940 align:start position:0%
the equals sign after the equal sign you
have<00:04:13.890><c> to</c><00:04:14.070><c> define</c><00:04:14.400><c> the</c><00:04:14.610><c> function</c><00:04:14.880><c> name</c><00:04:15.420><c> in</c><00:04:15.950><c> this</c>

00:04:16.940 --> 00:04:16.950 align:start position:0%
have to define the function name in this
 

00:04:16.950 --> 00:04:21.259 align:start position:0%
have to define the function name in this
case<00:04:17.010><c> it's</c><00:04:17.450><c> some</c><00:04:19.130><c> remember</c><00:04:20.130><c> a</c><00:04:20.340><c> function</c><00:04:21.000><c> is</c><00:04:21.120><c> a</c>

00:04:21.259 --> 00:04:21.269 align:start position:0%
case it's some remember a function is a
 

00:04:21.269 --> 00:04:24.260 align:start position:0%
case it's some remember a function is a
predefined<00:04:22.080><c> formula</c><00:04:22.650><c> so</c><00:04:23.430><c> this</c><00:04:23.610><c> function</c>

00:04:24.260 --> 00:04:24.270 align:start position:0%
predefined formula so this function
 

00:04:24.270 --> 00:04:26.680 align:start position:0%
predefined formula so this function
tells<00:04:24.479><c> Excel</c><00:04:24.690><c> that</c><00:04:25.680><c> it</c><00:04:25.830><c> will</c><00:04:26.010><c> add</c>

00:04:26.680 --> 00:04:26.690 align:start position:0%
tells Excel that it will add
 

00:04:26.690 --> 00:04:30.970 align:start position:0%
tells Excel that it will add
a<00:04:26.750><c> group</c><00:04:27.170><c> of</c><00:04:27.380><c> cells</c><00:04:29.020><c> the</c><00:04:30.020><c> next</c><00:04:30.500><c> part</c><00:04:30.770><c> of</c><00:04:30.860><c> the</c>

00:04:30.970 --> 00:04:30.980 align:start position:0%
a group of cells the next part of the
 

00:04:30.980 --> 00:04:34.510 align:start position:0%
a group of cells the next part of the
function<00:04:31.430><c> is</c><00:04:31.550><c> the</c><00:04:31.700><c> argument</c><00:04:32.770><c> the</c><00:04:33.770><c> information</c>

00:04:34.510 --> 00:04:34.520 align:start position:0%
function is the argument the information
 

00:04:34.520 --> 00:04:36.640 align:start position:0%
function is the argument the information
enclosed<00:04:35.030><c> in</c><00:04:35.300><c> the</c><00:04:35.390><c> parenthesis</c><00:04:35.990><c> is</c><00:04:36.320><c> an</c>

00:04:36.640 --> 00:04:36.650 align:start position:0%
enclosed in the parenthesis is an
 

00:04:36.650 --> 00:04:39.790 align:start position:0%
enclosed in the parenthesis is an
argument<00:04:37.330><c> the</c><00:04:38.330><c> argument</c><00:04:39.020><c> and</c><00:04:39.200><c> this</c><00:04:39.440><c> function</c>

00:04:39.790 --> 00:04:39.800 align:start position:0%
argument the argument and this function
 

00:04:39.800 --> 00:04:44.860 align:start position:0%
argument the argument and this function
is<00:04:40.310><c> G</c><00:04:41.000><c> 2</c><00:04:41.330><c> through</c><00:04:42.230><c> G</c><00:04:42.530><c> 41</c><00:04:43.220><c> which</c><00:04:43.970><c> represents</c><00:04:44.780><c> a</c>

00:04:44.860 --> 00:04:44.870 align:start position:0%
is G 2 through G 41 which represents a
 

00:04:44.870 --> 00:04:49.690 align:start position:0%
is G 2 through G 41 which represents a
range<00:04:45.380><c> of</c><00:04:45.830><c> cells</c><00:04:47.590><c> you</c><00:04:48.590><c> use</c><00:04:48.830><c> the</c><00:04:49.040><c> colon</c><00:04:49.550><c> to</c>

00:04:49.690 --> 00:04:49.700 align:start position:0%
range of cells you use the colon to
 

00:04:49.700 --> 00:04:52.900 align:start position:0%
range of cells you use the colon to
represent<00:04:50.240><c> a</c><00:04:50.330><c> range</c><00:04:50.540><c> of</c><00:04:50.840><c> cells</c><00:04:51.550><c> the</c><00:04:52.550><c> range</c>

00:04:52.900 --> 00:04:52.910 align:start position:0%
represent a range of cells the range
 

00:04:52.910 --> 00:04:55.540 align:start position:0%
represent a range of cells the range
basically<00:04:53.420><c> says</c><00:04:54.020><c> that</c><00:04:54.050><c> all</c><00:04:54.650><c> the</c><00:04:55.010><c> cells</c><00:04:55.250><c> from</c>

00:04:55.540 --> 00:04:55.550 align:start position:0%
basically says that all the cells from
 

00:04:55.550 --> 00:05:01.120 align:start position:0%
basically says that all the cells from
g2<00:04:56.270><c> to</c><00:04:56.990><c> g4</c><00:04:57.020><c> t1</c><00:04:57.920><c> are</c><00:04:58.330><c> included</c><00:04:59.330><c> I</c><00:05:00.130><c> another</c>

00:05:01.120 --> 00:05:01.130 align:start position:0%
g2 to g4 t1 are included I another
 

00:05:01.130 --> 00:05:03.460 align:start position:0%
g2 to g4 t1 are included I another
language<00:05:01.520><c> can</c><00:05:01.880><c> be</c><00:05:01.910><c> really</c><00:05:02.360><c> confusing</c><00:05:03.020><c> but</c><00:05:03.200><c> it</c>

00:05:03.460 --> 00:05:03.470 align:start position:0%
language can be really confusing but it
 

00:05:03.470 --> 00:05:06.190 align:start position:0%
language can be really confusing but it
is<00:05:03.680><c> important</c><00:05:04.250><c> to</c><00:05:04.310><c> know</c><00:05:04.630><c> you</c><00:05:05.630><c> won't</c><00:05:05.840><c> need</c><00:05:06.020><c> to</c>

00:05:06.190 --> 00:05:06.200 align:start position:0%
is important to know you won't need to
 

00:05:06.200 --> 00:05:07.960 align:start position:0%
is important to know you won't need to
know<00:05:06.230><c> these</c><00:05:06.560><c> terms</c><00:05:06.890><c> to</c><00:05:07.100><c> use</c><00:05:07.310><c> the</c><00:05:07.430><c> functions</c>

00:05:07.960 --> 00:05:07.970 align:start position:0%
know these terms to use the functions
 

00:05:07.970 --> 00:05:09.610 align:start position:0%
know these terms to use the functions
but<00:05:08.180><c> you</c><00:05:08.300><c> will</c><00:05:08.540><c> need</c><00:05:08.720><c> to</c><00:05:08.780><c> know</c><00:05:09.110><c> them</c><00:05:09.350><c> if</c><00:05:09.500><c> you</c>

00:05:09.610 --> 00:05:09.620 align:start position:0%
but you will need to know them if you
 

00:05:09.620 --> 00:05:13.570 align:start position:0%
but you will need to know them if you
use<00:05:09.830><c> the</c><00:05:09.980><c> Excel</c><00:05:10.370><c> help</c><00:05:10.670><c> tool</c><00:05:12.160><c> you</c><00:05:13.160><c> can</c><00:05:13.340><c> also</c>

00:05:13.570 --> 00:05:13.580 align:start position:0%
use the Excel help tool you can also
 

00:05:13.580 --> 00:05:15.610 align:start position:0%
use the Excel help tool you can also
have<00:05:13.970><c> a</c><00:05:14.000><c> function</c><00:05:14.450><c> that</c><00:05:14.780><c> has</c><00:05:15.080><c> more</c><00:05:15.410><c> than</c><00:05:15.470><c> one</c>

00:05:15.610 --> 00:05:15.620 align:start position:0%
have a function that has more than one
 

00:05:15.620 --> 00:05:19.450 align:start position:0%
have a function that has more than one
argument<00:05:16.100><c> for</c><00:05:17.350><c> example</c><00:05:18.350><c> this</c><00:05:19.010><c> function</c>

00:05:19.450 --> 00:05:19.460 align:start position:0%
argument for example this function
 

00:05:19.460 --> 00:05:26.800 align:start position:0%
argument for example this function
calculates<00:05:20.390><c> the</c><00:05:20.570><c> sum</c><00:05:20.900><c> of</c><00:05:20.930><c> two</c><00:05:21.350><c> ranges</c><00:05:25.810><c> let's</c>

00:05:26.800 --> 00:05:26.810 align:start position:0%
calculates the sum of two ranges let's
 

00:05:26.810 --> 00:05:28.840 align:start position:0%
calculates the sum of two ranges let's
take<00:05:27.110><c> a</c><00:05:27.140><c> look</c><00:05:27.440><c> at</c><00:05:27.530><c> how</c><00:05:27.770><c> you</c><00:05:27.830><c> can</c><00:05:28.130><c> insert</c><00:05:28.550><c> this</c>

00:05:28.840 --> 00:05:28.850 align:start position:0%
take a look at how you can insert this
 

00:05:28.850 --> 00:05:32.860 align:start position:0%
take a look at how you can insert this
function<00:05:29.390><c> into</c><00:05:29.510><c> your</c><00:05:29.750><c> spreadsheet</c><00:05:31.600><c> we</c><00:05:32.600><c> want</c>

00:05:32.860 --> 00:05:32.870 align:start position:0%
function into your spreadsheet we want
 

00:05:32.870 --> 00:05:35.530 align:start position:0%
function into your spreadsheet we want
to<00:05:33.110><c> calculate</c><00:05:33.410><c> the</c><00:05:34.160><c> total</c><00:05:34.580><c> dollar</c><00:05:34.880><c> amount</c><00:05:35.030><c> we</c>

00:05:35.530 --> 00:05:35.540 align:start position:0%
to calculate the total dollar amount we
 

00:05:35.540 --> 00:05:44.350 align:start position:0%
to calculate the total dollar amount we
have<00:05:35.810><c> of</c><00:05:35.990><c> cones</c><00:05:36.320><c> and</c><00:05:36.740><c> cups</c><00:05:42.820><c> instead</c><00:05:43.820><c> of</c><00:05:43.970><c> using</c>

00:05:44.350 --> 00:05:44.360 align:start position:0%
have of cones and cups instead of using
 

00:05:44.360 --> 00:05:47.409 align:start position:0%
have of cones and cups instead of using
the<00:05:44.480><c> autosum</c><00:05:44.870><c> command</c><00:05:45.860><c> I</c><00:05:46.190><c> can</c><00:05:46.550><c> insert</c><00:05:47.270><c> the</c>

00:05:47.409 --> 00:05:47.419 align:start position:0%
the autosum command I can insert the
 

00:05:47.419 --> 00:05:51.070 align:start position:0%
the autosum command I can insert the
function<00:05:47.930><c> another</c><00:05:48.200><c> way</c><00:05:49.390><c> first</c><00:05:50.390><c> I</c><00:05:50.690><c> need</c><00:05:51.050><c> to</c>

00:05:51.070 --> 00:05:51.080 align:start position:0%
function another way first I need to
 

00:05:51.080 --> 00:05:53.470 align:start position:0%
function another way first I need to
select<00:05:51.380><c> the</c><00:05:51.830><c> cell</c><00:05:52.310><c> where</c><00:05:52.760><c> I</c><00:05:52.820><c> want</c><00:05:53.300><c> the</c>

00:05:53.470 --> 00:05:53.480 align:start position:0%
select the cell where I want the
 

00:05:53.480 --> 00:05:58.510 align:start position:0%
select the cell where I want the
function<00:05:53.840><c> to</c><00:05:53.960><c> appear</c><00:05:56.110><c> then</c><00:05:57.110><c> click</c><00:05:57.470><c> the</c><00:05:58.070><c> insert</c>

00:05:58.510 --> 00:05:58.520 align:start position:0%
function to appear then click the insert
 

00:05:58.520 --> 00:06:04.050 align:start position:0%
function to appear then click the insert
function<00:05:58.880><c> commands</c><00:05:59.720><c> on</c><00:05:59.840><c> the</c><00:05:59.960><c> formulas</c><00:06:00.530><c> tab</c><00:06:00.830><c> a</c>

00:06:04.050 --> 00:06:04.060 align:start position:0%
 
 

00:06:04.060 --> 00:06:11.440 align:start position:0%
 
dialog<00:06:05.060><c> box</c><00:06:05.330><c> appears</c><00:06:09.070><c> by</c><00:06:10.070><c> default</c><00:06:10.150><c> the</c><00:06:11.150><c> sum</c>

00:06:11.440 --> 00:06:11.450 align:start position:0%
dialog box appears by default the sum
 

00:06:11.450 --> 00:06:14.020 align:start position:0%
dialog box appears by default the sum
function<00:06:11.900><c> is</c><00:06:12.260><c> selected</c><00:06:12.890><c> but</c><00:06:13.340><c> if</c><00:06:13.460><c> I</c><00:06:13.550><c> wanted</c><00:06:13.940><c> to</c>

00:06:14.020 --> 00:06:14.030 align:start position:0%
function is selected but if I wanted to
 

00:06:14.030 --> 00:06:16.840 align:start position:0%
function is selected but if I wanted to
perform<00:06:14.540><c> another</c><00:06:14.960><c> mathematical</c><00:06:15.520><c> operation</c><00:06:16.520><c> I</c>

00:06:16.840 --> 00:06:16.850 align:start position:0%
perform another mathematical operation I
 

00:06:16.850 --> 00:06:20.260 align:start position:0%
perform another mathematical operation I
could<00:06:17.570><c> use</c><00:06:17.780><c> this</c><00:06:18.050><c> search</c><00:06:18.560><c> tool</c><00:06:18.890><c> to</c><00:06:19.220><c> find</c><00:06:20.030><c> a</c>

00:06:20.260 --> 00:06:20.270 align:start position:0%
could use this search tool to find a
 

00:06:20.270 --> 00:06:21.730 align:start position:0%
could use this search tool to find a
function<00:06:20.600><c> that</c><00:06:20.870><c> would</c><00:06:21.080><c> perform</c><00:06:21.590><c> the</c>

00:06:21.730 --> 00:06:21.740 align:start position:0%
function that would perform the
 

00:06:21.740 --> 00:06:25.030 align:start position:0%
function that would perform the
calculation<00:06:22.430><c> that</c><00:06:22.610><c> I</c><00:06:22.730><c> need</c><00:06:23.410><c> all</c><00:06:24.410><c> you</c><00:06:24.740><c> have</c><00:06:24.890><c> to</c>

00:06:25.030 --> 00:06:25.040 align:start position:0%
calculation that I need all you have to
 

00:06:25.040 --> 00:06:27.310 align:start position:0%
calculation that I need all you have to
do<00:06:25.250><c> is</c><00:06:25.430><c> type</c><00:06:25.669><c> a</c><00:06:25.790><c> question</c><00:06:26.120><c> in</c><00:06:26.480><c> the</c><00:06:26.600><c> search</c><00:06:26.900><c> for</c>

00:06:27.310 --> 00:06:27.320 align:start position:0%
do is type a question in the search for
 

00:06:27.320 --> 00:06:31.500 align:start position:0%
do is type a question in the search for
a<00:06:27.380><c> function</c><00:06:28.100><c> box</c><00:06:28.400><c> and</c><00:06:29.440><c> click</c><00:06:30.440><c> go</c>

00:06:31.500 --> 00:06:31.510 align:start position:0%
a function box and click go
 

00:06:31.510 --> 00:06:35.620 align:start position:0%
a function box and click go
or<00:06:33.220><c> you</c><00:06:34.220><c> can</c><00:06:34.400><c> scroll</c><00:06:34.669><c> through</c><00:06:34.729><c> the</c><00:06:35.120><c> list</c><00:06:35.150><c> of</c>

00:06:35.620 --> 00:06:35.630 align:start position:0%
or you can scroll through the list of
 

00:06:35.630 --> 00:06:37.870 align:start position:0%
or you can scroll through the list of
functions<00:06:35.930><c> in</c><00:06:36.320><c> the</c><00:06:36.440><c> select</c><00:06:36.919><c> a</c><00:06:37.100><c> function</c><00:06:37.580><c> field</c>

00:06:37.870 --> 00:06:37.880 align:start position:0%
functions in the select a function field
 

00:06:37.880 --> 00:06:41.710 align:start position:0%
functions in the select a function field
as<00:06:38.800><c> you</c><00:06:39.800><c> select</c><00:06:40.010><c> different</c><00:06:40.669><c> functions</c><00:06:41.479><c> a</c>

00:06:41.710 --> 00:06:41.720 align:start position:0%
as you select different functions a
 

00:06:41.720 --> 00:06:43.870 align:start position:0%
as you select different functions a
description<00:06:42.470><c> of</c><00:06:42.710><c> the</c><00:06:42.830><c> function</c><00:06:43.310><c> will</c><00:06:43.430><c> display</c>

00:06:43.870 --> 00:06:43.880 align:start position:0%
description of the function will display
 

00:06:43.880 --> 00:06:46.390 align:start position:0%
description of the function will display
below<00:06:44.320><c> describing</c><00:06:45.320><c> what</c><00:06:45.590><c> calculation</c><00:06:46.280><c> the</c>

00:06:46.390 --> 00:06:46.400 align:start position:0%
below describing what calculation the
 

00:06:46.400 --> 00:06:51.159 align:start position:0%
below describing what calculation the
function<00:06:46.820><c> will</c><00:06:46.970><c> perform</c><00:06:48.550><c> if</c><00:06:50.050><c> you</c><00:06:51.050><c> would</c>

00:06:51.159 --> 00:06:51.169 align:start position:0%
function will perform if you would
 

00:06:51.169 --> 00:06:53.680 align:start position:0%
function will perform if you would
prefer<00:06:51.289><c> to</c><00:06:51.680><c> narrow</c><00:06:52.070><c> this</c><00:06:52.400><c> list</c><00:06:52.510><c> you</c><00:06:53.510><c> can</c>

00:06:53.680 --> 00:06:53.690 align:start position:0%
prefer to narrow this list you can
 

00:06:53.690 --> 00:06:56.380 align:start position:0%
prefer to narrow this list you can
select<00:06:53.840><c> a</c><00:06:54.229><c> category</c><00:06:54.470><c> and</c><00:06:55.190><c> only</c><00:06:55.850><c> view</c><00:06:56.180><c> these</c>

00:06:56.380 --> 00:06:56.390 align:start position:0%
select a category and only view these
 

00:06:56.390 --> 00:07:01.029 align:start position:0%
select a category and only view these
types<00:06:56.810><c> of</c><00:06:57.050><c> functions</c><00:06:59.530><c> we'll</c><00:07:00.530><c> just</c><00:07:00.860><c> select</c>

00:07:01.029 --> 00:07:01.039 align:start position:0%
types of functions we'll just select
 

00:07:01.039 --> 00:07:04.750 align:start position:0%
types of functions we'll just select
some<00:07:01.669><c> and</c><00:07:02.060><c> click</c><00:07:02.419><c> OK</c><00:07:02.840><c> and</c><00:07:03.310><c> the</c><00:07:04.310><c> function</c>

00:07:04.750 --> 00:07:04.760 align:start position:0%
some and click OK and the function
 

00:07:04.760 --> 00:07:07.480 align:start position:0%
some and click OK and the function
arguments<00:07:05.360><c> dialog</c><00:07:05.840><c> box</c><00:07:06.169><c> appears</c><00:07:06.710><c> so</c><00:07:07.310><c> that</c><00:07:07.460><c> I</c>

00:07:07.480 --> 00:07:07.490 align:start position:0%
arguments dialog box appears so that I
 

00:07:07.490 --> 00:07:09.700 align:start position:0%
arguments dialog box appears so that I
can<00:07:07.760><c> enter</c><00:07:07.940><c> cells</c><00:07:08.419><c> that</c><00:07:08.930><c> I</c><00:07:09.020><c> want</c><00:07:09.320><c> to</c><00:07:09.440><c> include</c>

00:07:09.700 --> 00:07:09.710 align:start position:0%
can enter cells that I want to include
 

00:07:09.710 --> 00:07:11.909 align:start position:0%
can enter cells that I want to include
in<00:07:10.010><c> the</c><00:07:10.160><c> function</c>

00:07:11.909 --> 00:07:11.919 align:start position:0%
in the function
 

00:07:11.919 --> 00:07:14.740 align:start position:0%
in the function
we'll<00:07:12.919><c> make</c><00:07:13.160><c> sure</c><00:07:13.460><c> our</c><00:07:13.490><c> cursor</c><00:07:14.270><c> is</c><00:07:14.419><c> in</c><00:07:14.600><c> the</c>

00:07:14.740 --> 00:07:14.750 align:start position:0%
we'll make sure our cursor is in the
 

00:07:14.750 --> 00:07:18.250 align:start position:0%
we'll make sure our cursor is in the
number<00:07:15.169><c> one</c><00:07:15.440><c> field</c><00:07:15.979><c> and</c><00:07:16.570><c> then</c><00:07:17.570><c> find</c><00:07:17.930><c> the</c><00:07:18.080><c> area</c>

00:07:18.250 --> 00:07:18.260 align:start position:0%
number one field and then find the area
 

00:07:18.260 --> 00:07:20.680 align:start position:0%
number one field and then find the area
of<00:07:18.740><c> our</c><00:07:18.860><c> spreadsheet</c><00:07:19.250><c> where</c><00:07:19.910><c> the</c><00:07:19.940><c> cones</c><00:07:20.330><c> are</c>

00:07:20.680 --> 00:07:20.690 align:start position:0%
of our spreadsheet where the cones are
 

00:07:20.690 --> 00:07:25.600 align:start position:0%
of our spreadsheet where the cones are
listed<00:07:22.300><c> now</c><00:07:23.470><c> left-click</c><00:07:24.470><c> and</c><00:07:24.800><c> drag</c><00:07:25.039><c> your</c>

00:07:25.600 --> 00:07:25.610 align:start position:0%
listed now left-click and drag your
 

00:07:25.610 --> 00:07:29.140 align:start position:0%
listed now left-click and drag your
cursor<00:07:25.849><c> to</c><00:07:26.090><c> select</c><00:07:26.599><c> cells</c><00:07:26.930><c> G</c><00:07:27.320><c> 21</c><00:07:27.919><c> through</c><00:07:28.760><c> 26</c>

00:07:29.140 --> 00:07:29.150 align:start position:0%
cursor to select cells G 21 through 26
 

00:07:29.150 --> 00:07:34.659 align:start position:0%
cursor to select cells G 21 through 26
and<00:07:31.090><c> then</c><00:07:32.090><c> release</c><00:07:32.510><c> the</c><00:07:32.690><c> mouse</c><00:07:32.870><c> button</c><00:07:33.490><c> we</c><00:07:34.490><c> can</c>

00:07:34.659 --> 00:07:34.669 align:start position:0%
and then release the mouse button we can
 

00:07:34.669 --> 00:07:36.940 align:start position:0%
and then release the mouse button we can
see<00:07:34.880><c> now</c><00:07:35.180><c> that</c><00:07:35.210><c> the</c><00:07:35.510><c> argument</c><00:07:36.110><c> appears</c><00:07:36.590><c> in</c><00:07:36.860><c> the</c>

00:07:36.940 --> 00:07:36.950 align:start position:0%
see now that the argument appears in the
 

00:07:36.950 --> 00:07:41.050 align:start position:0%
see now that the argument appears in the
number<00:07:37.370><c> 1</c><00:07:37.640><c> field</c><00:07:39.220><c> since</c><00:07:40.220><c> we</c><00:07:40.430><c> want</c><00:07:40.700><c> to</c><00:07:40.849><c> add</c>

00:07:41.050 --> 00:07:41.060 align:start position:0%
number 1 field since we want to add
 

00:07:41.060 --> 00:07:43.960 align:start position:0%
number 1 field since we want to add
another<00:07:41.599><c> arguments</c><00:07:42.590><c> we'll</c><00:07:43.220><c> just</c><00:07:43.460><c> place</c><00:07:43.729><c> our</c>

00:07:43.960 --> 00:07:43.970 align:start position:0%
another arguments we'll just place our
 

00:07:43.970 --> 00:07:47.290 align:start position:0%
another arguments we'll just place our
cursor<00:07:44.330><c> in</c><00:07:44.720><c> the</c><00:07:44.840><c> number</c><00:07:45.169><c> 2</c><00:07:45.380><c> fields</c><00:07:46.039><c> and</c><00:07:46.190><c> in</c><00:07:47.180><c> the</c>

00:07:47.290 --> 00:07:47.300 align:start position:0%
cursor in the number 2 fields and in the
 

00:07:47.300 --> 00:07:52.140 align:start position:0%
cursor in the number 2 fields and in the
spreadsheet<00:07:47.660><c> select</c><00:07:48.080><c> cells</c><00:07:48.680><c> G</c><00:07:49.039><c> 40</c><00:07:49.580><c> and</c><00:07:49.849><c> 41</c><00:07:50.780><c> and</c>

00:07:52.140 --> 00:07:52.150 align:start position:0%
spreadsheet select cells G 40 and 41 and
 

00:07:52.150 --> 00:07:56.380 align:start position:0%
spreadsheet select cells G 40 and 41 and
the<00:07:53.150><c> argument</c><00:07:53.660><c> appears</c><00:07:54.020><c> in</c><00:07:54.260><c> the</c><00:07:54.349><c> field</c><00:07:54.680><c> if</c><00:07:55.390><c> we</c>

00:07:56.380 --> 00:07:56.390 align:start position:0%
the argument appears in the field if we
 

00:07:56.390 --> 00:07:58.659 align:start position:0%
the argument appears in the field if we
look<00:07:56.660><c> at</c><00:07:56.750><c> the</c><00:07:56.870><c> spreadsheets</c><00:07:57.590><c> we</c><00:07:58.039><c> can</c><00:07:58.220><c> see</c><00:07:58.520><c> that</c>

00:07:58.659 --> 00:07:58.669 align:start position:0%
look at the spreadsheets we can see that
 

00:07:58.669 --> 00:08:01.089 align:start position:0%
look at the spreadsheets we can see that
the<00:07:58.760><c> function</c><00:07:59.300><c> with</c><00:07:59.479><c> two</c><00:07:59.510><c> arguments</c><00:08:00.289><c> appears</c>

00:08:01.089 --> 00:08:01.099 align:start position:0%
the function with two arguments appears
 

00:08:01.099 --> 00:08:05.980 align:start position:0%
the function with two arguments appears
in<00:08:01.310><c> the</c><00:08:01.430><c> cell</c><00:08:03.160><c> now</c><00:08:04.160><c> click</c><00:08:04.820><c> OK</c><00:08:05.210><c> in</c><00:08:05.390><c> the</c><00:08:05.510><c> dialog</c>

00:08:05.980 --> 00:08:05.990 align:start position:0%
in the cell now click OK in the dialog
 

00:08:05.990 --> 00:08:09.040 align:start position:0%
in the cell now click OK in the dialog
box<00:08:06.289><c> and</c><00:08:06.650><c> the</c><00:08:07.400><c> function</c><00:08:07.849><c> adds</c><00:08:08.030><c> the</c><00:08:08.360><c> amounts</c><00:08:08.930><c> of</c>

00:08:09.040 --> 00:08:09.050 align:start position:0%
box and the function adds the amounts of
 

00:08:09.050 --> 00:08:11.380 align:start position:0%
box and the function adds the amounts of
cups<00:08:09.349><c> and</c><00:08:09.650><c> cones</c><00:08:10.070><c> we</c><00:08:10.340><c> have</c><00:08:10.550><c> together</c><00:08:10.820><c> and</c>

00:08:11.380 --> 00:08:11.390 align:start position:0%
cups and cones we have together and
 

00:08:11.390 --> 00:08:16.900 align:start position:0%
cups and cones we have together and
displays<00:08:12.380><c> it</c><00:08:12.650><c> in</c><00:08:12.800><c> G</c><00:08:13.130><c> 44</c><00:08:15.099><c> there</c><00:08:16.099><c> are</c><00:08:16.310><c> so</c><00:08:16.640><c> many</c>

00:08:16.900 --> 00:08:16.910 align:start position:0%
displays it in G 44 there are so many
 

00:08:16.910 --> 00:08:19.360 align:start position:0%
displays it in G 44 there are so many
ways<00:08:17.330><c> you</c><00:08:17.390><c> can</c><00:08:17.720><c> write</c><00:08:17.990><c> functions</c><00:08:18.680><c> in</c><00:08:18.860><c> so</c><00:08:19.160><c> many</c>

00:08:19.360 --> 00:08:19.370 align:start position:0%
ways you can write functions in so many
 

00:08:19.370 --> 00:08:22.180 align:start position:0%
ways you can write functions in so many
types<00:08:19.789><c> of</c><00:08:20.000><c> functions</c><00:08:20.740><c> another</c><00:08:21.740><c> simple</c>

00:08:22.180 --> 00:08:22.190 align:start position:0%
types of functions another simple
 

00:08:22.190 --> 00:08:24.040 align:start position:0%
types of functions another simple
function<00:08:22.669><c> that</c><00:08:22.789><c> I</c><00:08:22.910><c> can</c><00:08:23.120><c> show</c><00:08:23.390><c> you</c><00:08:23.450><c> using</c><00:08:23.960><c> the</c>

00:08:24.040 --> 00:08:24.050 align:start position:0%
function that I can show you using the
 

00:08:24.050 --> 00:08:26.380 align:start position:0%
function that I can show you using the
inventory<00:08:24.500><c> spreadsheets</c><00:08:25.130><c> is</c><00:08:25.340><c> the</c><00:08:25.849><c> average</c>

00:08:26.380 --> 00:08:26.390 align:start position:0%
inventory spreadsheets is the average
 

00:08:26.390 --> 00:08:29.830 align:start position:0%
inventory spreadsheets is the average
function<00:08:27.460><c> this</c><00:08:28.460><c> function</c><00:08:28.660><c> computes</c><00:08:29.660><c> the</c>

00:08:29.830 --> 00:08:29.840 align:start position:0%
function this function computes the
 

00:08:29.840 --> 00:08:33.430 align:start position:0%
function this function computes the
average<00:08:29.990><c> of</c><00:08:30.470><c> a</c><00:08:30.560><c> range</c><00:08:30.919><c> of</c><00:08:31.250><c> cells</c><00:08:31.930><c> let's</c><00:08:32.930><c> say</c><00:08:33.260><c> we</c>

00:08:33.430 --> 00:08:33.440 align:start position:0%
average of a range of cells let's say we
 

00:08:33.440 --> 00:08:35.290 align:start position:0%
average of a range of cells let's say we
want<00:08:33.620><c> to</c><00:08:33.709><c> calculate</c><00:08:34.010><c> the</c><00:08:34.400><c> average</c><00:08:34.430><c> cost</c><00:08:35.089><c> we</c>

00:08:35.290 --> 00:08:35.300 align:start position:0%
want to calculate the average cost we
 

00:08:35.300 --> 00:08:39.420 align:start position:0%
want to calculate the average cost we
pay<00:08:35.330><c> for</c><00:08:35.780><c> a</c><00:08:35.810><c> 2.5</c><00:08:36.589><c> gallons</c><00:08:37.130><c> help</c><00:08:37.400><c> of</c><00:08:37.520><c> ice</c><00:08:37.700><c> cream</c>

00:08:39.420 --> 00:08:39.430 align:start position:0%
pay for a 2.5 gallons help of ice cream
 

00:08:39.430 --> 00:08:42.730 align:start position:0%
pay for a 2.5 gallons help of ice cream
the<00:08:40.430><c> price</c><00:08:40.789><c> varies</c><00:08:41.390><c> a</c><00:08:41.419><c> bit</c><00:08:41.570><c> depending</c><00:08:42.500><c> on</c><00:08:42.650><c> the</c>

00:08:42.730 --> 00:08:42.740 align:start position:0%
the price varies a bit depending on the
 

00:08:42.740 --> 00:08:44.860 align:start position:0%
the price varies a bit depending on the
flavor<00:08:43.070><c> but</c><00:08:43.820><c> we</c><00:08:43.940><c> want</c><00:08:44.209><c> to</c><00:08:44.329><c> find</c><00:08:44.600><c> the</c><00:08:44.750><c> average</c>

00:08:44.860 --> 00:08:44.870 align:start position:0%
flavor but we want to find the average
 

00:08:44.870 --> 00:08:53.230 align:start position:0%
flavor but we want to find the average
cost<00:08:45.880><c> and</c><00:08:47.890><c> a</c><00:08:48.890><c> 46</c><00:08:49.880><c> I'll</c><00:08:50.360><c> type</c><00:08:51.110><c> average</c><00:08:51.860><c> flavor</c>

00:08:53.230 --> 00:08:53.240 align:start position:0%
cost and a 46 I'll type average flavor
 

00:08:53.240 --> 00:08:57.040 align:start position:0%
cost and a 46 I'll type average flavor
and<00:08:53.330><c> then</c><00:08:53.870><c> select</c><00:08:54.700><c> c-46</c><00:08:55.910><c> where</c><00:08:56.510><c> I</c><00:08:56.540><c> want</c><00:08:56.959><c> the</c>

00:08:57.040 --> 00:08:57.050 align:start position:0%
and then select c-46 where I want the
 

00:08:57.050 --> 00:09:01.389 align:start position:0%
and then select c-46 where I want the
function<00:08:57.350><c> to</c><00:08:57.560><c> appear</c><00:08:59.020><c> now</c><00:09:00.020><c> if</c><00:09:00.410><c> I</c><00:09:00.770><c> click</c><00:09:01.160><c> the</c>

00:09:01.389 --> 00:09:01.399 align:start position:0%
function to appear now if I click the
 

00:09:01.399 --> 00:09:04.420 align:start position:0%
function to appear now if I click the
drop<00:09:01.730><c> down</c><00:09:01.760><c> arrow</c><00:09:02.240><c> next</c><00:09:02.870><c> to</c><00:09:03.649><c> the</c><00:09:03.800><c> autosum</c>

00:09:04.420 --> 00:09:04.430 align:start position:0%
drop down arrow next to the autosum
 

00:09:04.430 --> 00:09:08.440 align:start position:0%
drop down arrow next to the autosum
command<00:09:05.060><c> and</c><00:09:05.420><c> select</c><00:09:06.320><c> average</c><00:09:07.310><c> we</c><00:09:08.029><c> can</c><00:09:08.209><c> see</c>

00:09:08.440 --> 00:09:08.450 align:start position:0%
command and select average we can see
 

00:09:08.450 --> 00:09:11.290 align:start position:0%
command and select average we can see
that<00:09:08.600><c> Excel</c><00:09:08.920><c> automatically</c><00:09:09.920><c> selects</c><00:09:10.520><c> all</c><00:09:10.760><c> the</c>

00:09:11.290 --> 00:09:11.300 align:start position:0%
that Excel automatically selects all the
 

00:09:11.300 --> 00:09:16.180 align:start position:0%
that Excel automatically selects all the
cells<00:09:11.600><c> and</c><00:09:11.990><c> column</c><00:09:12.350><c> C</c><00:09:13.420><c> but</c><00:09:14.420><c> wait</c><00:09:14.720><c> I</c><00:09:15.080><c> only</c><00:09:15.860><c> want</c>

00:09:16.180 --> 00:09:16.190 align:start position:0%
cells and column C but wait I only want
 

00:09:16.190 --> 00:09:18.400 align:start position:0%
cells and column C but wait I only want
to<00:09:16.339><c> find</c><00:09:16.580><c> the</c><00:09:16.730><c> average</c><00:09:16.880><c> cost</c><00:09:17.240><c> that</c><00:09:17.990><c> I</c><00:09:18.110><c> pay</c><00:09:18.380><c> for</c>

00:09:18.400 --> 00:09:18.410 align:start position:0%
to find the average cost that I pay for
 

00:09:18.410 --> 00:09:23.320 align:start position:0%
to find the average cost that I pay for
a<00:09:18.709><c> 2.5</c><00:09:19.700><c> gallon</c><00:09:20.540><c> tub</c><00:09:20.779><c> of</c><00:09:20.990><c> ice</c><00:09:21.170><c> cream</c><00:09:22.330><c> Excel</c>

00:09:23.320 --> 00:09:23.330 align:start position:0%
a 2.5 gallon tub of ice cream Excel
 

00:09:23.330 --> 00:09:26.170 align:start position:0%
a 2.5 gallon tub of ice cream Excel
automatically<00:09:24.050><c> chose</c><00:09:24.410><c> all</c><00:09:24.709><c> of</c><00:09:25.339><c> the</c><00:09:25.490><c> cells</c><00:09:25.760><c> but</c>

00:09:26.170 --> 00:09:26.180 align:start position:0%
automatically chose all of the cells but
 

00:09:26.180 --> 00:09:29.680 align:start position:0%
automatically chose all of the cells but
it's<00:09:26.480><c> not</c><00:09:26.720><c> quite</c><00:09:27.050><c> right</c><00:09:27.580><c> so</c><00:09:28.580><c> all</c><00:09:28.940><c> I</c><00:09:29.000><c> need</c><00:09:29.360><c> to</c><00:09:29.480><c> do</c>

00:09:29.680 --> 00:09:29.690 align:start position:0%
it's not quite right so all I need to do
 

00:09:29.690 --> 00:09:32.470 align:start position:0%
it's not quite right so all I need to do
is<00:09:29.959><c> left-click</c><00:09:30.529><c> and</c><00:09:31.160><c> drag</c><00:09:31.250><c> to</c><00:09:31.940><c> select</c><00:09:32.120><c> the</c>

00:09:32.470 --> 00:09:32.480 align:start position:0%
is left-click and drag to select the
 

00:09:32.480 --> 00:09:36.910 align:start position:0%
is left-click and drag to select the
cells<00:09:32.779><c> I</c><00:09:33.020><c> want</c><00:09:33.320><c> to</c><00:09:33.470><c> average</c><00:09:34.040><c> as</c><00:09:35.410><c> I'm</c><00:09:36.410><c> dragging</c>

00:09:36.910 --> 00:09:36.920 align:start position:0%
cells I want to average as I'm dragging
 

00:09:36.920 --> 00:09:39.880 align:start position:0%
cells I want to average as I'm dragging
my<00:09:36.950><c> mouse</c><00:09:37.070><c> and</c><00:09:37.670><c> selecting</c><00:09:38.450><c> the</c><00:09:38.570><c> cells</c><00:09:38.870><c> I</c><00:09:39.230><c> can</c>

00:09:39.880 --> 00:09:39.890 align:start position:0%
my mouse and selecting the cells I can
 

00:09:39.890 --> 00:09:42.130 align:start position:0%
my mouse and selecting the cells I can
see<00:09:40.040><c> in</c><00:09:40.130><c> the</c><00:09:40.220><c> formula</c><00:09:40.730><c> bar</c><00:09:40.760><c> how</c><00:09:41.600><c> the</c><00:09:41.660><c> formula</c>

00:09:42.130 --> 00:09:42.140 align:start position:0%
see in the formula bar how the formula
 

00:09:42.140 --> 00:09:46.030 align:start position:0%
see in the formula bar how the formula
is<00:09:42.350><c> changing</c><00:09:43.720><c> once</c><00:09:44.720><c> the</c><00:09:44.959><c> correct</c><00:09:45.260><c> cells</c><00:09:45.740><c> are</c>

00:09:46.030 --> 00:09:46.040 align:start position:0%
is changing once the correct cells are
 

00:09:46.040 --> 00:09:49.060 align:start position:0%
is changing once the correct cells are
selected<00:09:46.279><c> I</c><00:09:46.880><c> can</c><00:09:47.480><c> click</c><00:09:47.720><c> the</c><00:09:47.870><c> insert</c><00:09:48.260><c> icon</c><00:09:48.440><c> and</c>

00:09:49.060 --> 00:09:49.070 align:start position:0%
selected I can click the insert icon and
 

00:09:49.070 --> 00:09:51.400 align:start position:0%
selected I can click the insert icon and
see<00:09:49.640><c> that</c><00:09:49.820><c> the</c><00:09:49.940><c> amounts</c><00:09:50.450><c> listed</c><00:09:51.170><c> is</c><00:09:51.350><c> the</c>

00:09:51.400 --> 00:09:51.410 align:start position:0%
see that the amounts listed is the
 

00:09:51.410 --> 00:09:55.750 align:start position:0%
see that the amounts listed is the
average<00:09:51.860><c> cost</c><00:09:52.490><c> for</c><00:09:52.850><c> a</c><00:09:53.060><c> 2.5</c><00:09:53.870><c> gallon</c><00:09:54.190><c> tub</c><00:09:55.190><c> of</c><00:09:55.520><c> ice</c>

00:09:55.750 --> 00:09:55.760 align:start position:0%
average cost for a 2.5 gallon tub of ice
 

00:09:55.760 --> 00:09:58.360 align:start position:0%
average cost for a 2.5 gallon tub of ice
cream<00:09:56.440><c> ok</c><00:09:57.440><c> this</c><00:09:57.620><c> is</c><00:09:57.829><c> something</c><00:09:58.010><c> I</c><00:09:58.190><c> need</c><00:09:58.339><c> to</c>

00:09:58.360 --> 00:09:58.370 align:start position:0%
cream ok this is something I need to
 

00:09:58.370 --> 00:10:00.430 align:start position:0%
cream ok this is something I need to
point<00:09:58.640><c> out</c><00:09:58.790><c> really</c><00:09:59.029><c> quickly</c><00:09:59.329><c> if</c><00:09:59.630><c> you</c><00:10:00.170><c> look</c>

00:10:00.430 --> 00:10:00.440 align:start position:0%
point out really quickly if you look
 

00:10:00.440 --> 00:10:03.790 align:start position:0%
point out really quickly if you look
closely<00:10:01.010><c> a</c><00:10:01.279><c> small</c><00:10:01.790><c> green</c><00:10:02.120><c> triangle</c><00:10:02.839><c> and</c><00:10:03.050><c> an</c>

00:10:03.790 --> 00:10:03.800 align:start position:0%
closely a small green triangle and an
 

00:10:03.800 --> 00:10:06.069 align:start position:0%
closely a small green triangle and an
exclamation<00:10:04.190><c> mark</c><00:10:04.640><c> appeared</c><00:10:05.480><c> in</c><00:10:05.660><c> the</c><00:10:05.750><c> left</c>

00:10:06.069 --> 00:10:06.079 align:start position:0%
exclamation mark appeared in the left
 

00:10:06.079 --> 00:10:08.290 align:start position:0%
exclamation mark appeared in the left
corner<00:10:06.680><c> of</c><00:10:06.860><c> the</c><00:10:07.399><c> cell</c><00:10:07.730><c> where</c><00:10:08.060><c> I</c><00:10:08.089><c> was</c>

00:10:08.290 --> 00:10:08.300 align:start position:0%
corner of the cell where I was
 

00:10:08.300 --> 00:10:11.440 align:start position:0%
corner of the cell where I was
calculating<00:10:08.870><c> my</c><00:10:08.959><c> average</c><00:10:09.910><c> this</c><00:10:10.910><c> usually</c>

00:10:11.440 --> 00:10:11.450 align:start position:0%
calculating my average this usually
 

00:10:11.450 --> 00:10:15.010 align:start position:0%
calculating my average this usually
indicates<00:10:11.930><c> some</c><00:10:12.350><c> type</c><00:10:12.709><c> of</c><00:10:12.740><c> mistake</c><00:10:13.810><c> so</c><00:10:14.810><c> let's</c>

00:10:15.010 --> 00:10:15.020 align:start position:0%
indicates some type of mistake so let's
 

00:10:15.020 --> 00:10:17.860 align:start position:0%
indicates some type of mistake so let's
take<00:10:15.200><c> a</c><00:10:15.230><c> quick</c><00:10:15.529><c> look</c><00:10:15.770><c> if</c><00:10:16.100><c> I</c><00:10:16.730><c> scroll</c><00:10:17.120><c> over</c><00:10:17.480><c> the</c>

00:10:17.860 --> 00:10:17.870 align:start position:0%
take a quick look if I scroll over the
 

00:10:17.870 --> 00:10:20.680 align:start position:0%
take a quick look if I scroll over the
exclamation<00:10:18.589><c> point</c><00:10:18.620><c> I</c><00:10:19.130><c> can</c><00:10:19.700><c> select</c><00:10:20.089><c> the</c><00:10:20.420><c> drop</c>

00:10:20.680 --> 00:10:20.690 align:start position:0%
exclamation point I can select the drop
 

00:10:20.690 --> 00:10:23.380 align:start position:0%
exclamation point I can select the drop
down<00:10:21.020><c> arrow</c><00:10:21.470><c> which</c><00:10:22.250><c> will</c><00:10:22.459><c> give</c><00:10:22.640><c> me</c><00:10:22.790><c> a</c><00:10:22.820><c> list</c><00:10:23.180><c> of</c>

00:10:23.380 --> 00:10:23.390 align:start position:0%
down arrow which will give me a list of
 

00:10:23.390 --> 00:10:28.690 align:start position:0%
down arrow which will give me a list of
options<00:10:23.959><c> I</c><00:10:26.770><c> don't</c><00:10:27.770><c> want</c><00:10:28.100><c> to</c><00:10:28.250><c> include</c><00:10:28.550><c> the</c>

00:10:28.690 --> 00:10:28.700 align:start position:0%
options I don't want to include the
 

00:10:28.700 --> 00:10:29.889 align:start position:0%
options I don't want to include the
adjacent<00:10:29.360><c> cells</c>

00:10:29.889 --> 00:10:29.899 align:start position:0%
adjacent cells
 

00:10:29.899 --> 00:10:33.699 align:start position:0%
adjacent cells
so<00:10:30.170><c> I'll</c><00:10:30.529><c> just</c><00:10:30.950><c> ignore</c><00:10:31.490><c> this</c><00:10:31.700><c> error</c><00:10:32.589><c> one</c><00:10:33.589><c> of</c>

00:10:33.699 --> 00:10:33.709 align:start position:0%
so I'll just ignore this error one of
 

00:10:33.709 --> 00:10:35.680 align:start position:0%
so I'll just ignore this error one of
the<00:10:33.800><c> many</c><00:10:34.070><c> great</c><00:10:34.339><c> features</c><00:10:34.520><c> in</c><00:10:34.850><c> excel</c><00:10:35.240><c> is</c><00:10:35.270><c> that</c>

00:10:35.680 --> 00:10:35.690 align:start position:0%
the many great features in excel is that
 

00:10:35.690 --> 00:10:37.720 align:start position:0%
the many great features in excel is that
it<00:10:35.779><c> will</c><00:10:35.899><c> catch</c><00:10:36.110><c> your</c><00:10:36.350><c> mistakes</c><00:10:36.829><c> for</c><00:10:36.980><c> you</c><00:10:37.520><c> and</c>

00:10:37.720 --> 00:10:37.730 align:start position:0%
it will catch your mistakes for you and
 

00:10:37.730 --> 00:10:40.090 align:start position:0%
it will catch your mistakes for you and
make<00:10:38.480><c> suggestions</c><00:10:38.990><c> on</c><00:10:39.350><c> how</c><00:10:39.500><c> to</c><00:10:39.529><c> fix</c><00:10:39.829><c> those</c>

00:10:40.090 --> 00:10:40.100 align:start position:0%
make suggestions on how to fix those
 

00:10:40.100 --> 00:10:45.010 align:start position:0%
make suggestions on how to fix those
mistakes<00:10:42.279><c> sum</c><00:10:43.279><c> and</c><00:10:43.640><c> average</c><00:10:43.880><c> are</c><00:10:44.329><c> just</c><00:10:44.630><c> two</c><00:10:44.990><c> of</c>

00:10:45.010 --> 00:10:45.020 align:start position:0%
mistakes sum and average are just two of
 

00:10:45.020 --> 00:10:48.190 align:start position:0%
mistakes sum and average are just two of
the<00:10:45.290><c> most</c><00:10:45.709><c> commonly</c><00:10:46.279><c> used</c><00:10:46.610><c> functions</c><00:10:47.079><c> you</c><00:10:48.079><c> can</c>

00:10:48.190 --> 00:10:48.200 align:start position:0%
the most commonly used functions you can
 

00:10:48.200 --> 00:10:50.410 align:start position:0%
the most commonly used functions you can
use<00:10:48.260><c> functions</c><00:10:48.980><c> to</c><00:10:49.070><c> accomplish</c><00:10:49.610><c> a</c><00:10:49.730><c> variety</c><00:10:50.089><c> of</c>

00:10:50.410 --> 00:10:50.420 align:start position:0%
use functions to accomplish a variety of
 

00:10:50.420 --> 00:10:53.949 align:start position:0%
use functions to accomplish a variety of
mathematical<00:10:50.829><c> calculations</c><00:10:52.779><c> from</c><00:10:53.779><c> the</c>

00:10:53.949 --> 00:10:53.959 align:start position:0%
mathematical calculations from the
 

00:10:53.959 --> 00:10:56.290 align:start position:0%
mathematical calculations from the
functional<00:10:54.410><c> library</c><00:10:55.040><c> you</c><00:10:55.579><c> can</c><00:10:55.760><c> see</c><00:10:55.940><c> some</c><00:10:56.270><c> of</c>

00:10:56.290 --> 00:10:56.300 align:start position:0%
functional library you can see some of
 

00:10:56.300 --> 00:10:59.170 align:start position:0%
functional library you can see some of
the<00:10:56.450><c> categories</c><00:10:57.079><c> of</c><00:10:57.110><c> functions</c><00:10:58.000><c> there</c><00:10:59.000><c> are</c>

00:10:59.170 --> 00:10:59.180 align:start position:0%
the categories of functions there are
 

00:10:59.180 --> 00:11:00.850 align:start position:0%
the categories of functions there are
financial<00:10:59.450><c> functions</c><00:11:00.230><c> that</c><00:11:00.320><c> will</c><00:11:00.470><c> help</c><00:11:00.649><c> you</c>

00:11:00.850 --> 00:11:00.860 align:start position:0%
financial functions that will help you
 

00:11:00.860 --> 00:11:03.490 align:start position:0%
financial functions that will help you
work<00:11:01.160><c> with</c><00:11:01.190><c> interest</c><00:11:01.790><c> rates</c><00:11:02.260><c> calculate</c><00:11:03.260><c> loan</c>

00:11:03.490 --> 00:11:03.500 align:start position:0%
work with interest rates calculate loan
 

00:11:03.500 --> 00:11:06.100 align:start position:0%
work with interest rates calculate loan
payments<00:11:04.130><c> and</c><00:11:04.390><c> determine</c><00:11:05.390><c> depreciation</c>

00:11:06.100 --> 00:11:06.110 align:start position:0%
payments and determine depreciation
 

00:11:06.110 --> 00:11:07.689 align:start position:0%
payments and determine depreciation
amounts

00:11:07.689 --> 00:11:07.699 align:start position:0%
amounts
 

00:11:07.699 --> 00:11:10.210 align:start position:0%
amounts
there<00:11:08.149><c> are</c><00:11:08.359><c> dates</c><00:11:08.749><c> and</c><00:11:08.959><c> time</c><00:11:09.199><c> functions</c><00:11:09.889><c> that</c>

00:11:10.210 --> 00:11:10.220 align:start position:0%
there are dates and time functions that
 

00:11:10.220 --> 00:11:11.889 align:start position:0%
there are dates and time functions that
will<00:11:10.399><c> help</c><00:11:10.579><c> you</c><00:11:10.730><c> do</c><00:11:10.879><c> things</c><00:11:11.179><c> like</c><00:11:11.329><c> calculate</c>

00:11:11.889 --> 00:11:11.899 align:start position:0%
will help you do things like calculate
 

00:11:11.899 --> 00:11:14.879 align:start position:0%
will help you do things like calculate
the<00:11:12.019><c> number</c><00:11:12.350><c> of</c><00:11:12.470><c> days</c><00:11:12.709><c> between</c><00:11:12.739><c> two</c><00:11:13.519><c> dates</c>

00:11:14.879 --> 00:11:14.889 align:start position:0%
the number of days between two dates
 

00:11:14.889 --> 00:11:18.909 align:start position:0%
the number of days between two dates
there<00:11:15.889><c> are</c><00:11:16.100><c> math</c><00:11:16.459><c> and</c><00:11:16.669><c> trig</c><00:11:16.939><c> functions</c><00:11:17.779><c> and</c><00:11:18.079><c> so</c>

00:11:18.909 --> 00:11:18.919 align:start position:0%
there are math and trig functions and so
 

00:11:18.919 --> 00:11:23.049 align:start position:0%
there are math and trig functions and so
much<00:11:19.160><c> more</c><00:11:20.379><c> Excel</c><00:11:21.379><c> literally</c><00:11:22.339><c> has</c><00:11:22.549><c> hundreds</c>

00:11:23.049 --> 00:11:23.059 align:start position:0%
much more Excel literally has hundreds
 

00:11:23.059 --> 00:11:24.759 align:start position:0%
much more Excel literally has hundreds
of<00:11:23.149><c> different</c><00:11:23.600><c> functions</c><00:11:24.109><c> to</c><00:11:24.199><c> assist</c><00:11:24.589><c> you</c>

00:11:24.759 --> 00:11:24.769 align:start position:0%
of different functions to assist you
 

00:11:24.769 --> 00:11:27.429 align:start position:0%
of different functions to assist you
with<00:11:24.859><c> your</c><00:11:24.919><c> calculations</c><00:11:25.899><c> building</c><00:11:26.899><c> formulas</c>

00:11:27.429 --> 00:11:27.439 align:start position:0%
with your calculations building formulas
 

00:11:27.439 --> 00:11:30.030 align:start position:0%
with your calculations building formulas
can<00:11:27.649><c> be</c><00:11:27.679><c> difficult</c><00:11:28.339><c> and</c><00:11:28.549><c> time-consuming</c>

00:11:30.030 --> 00:11:30.040 align:start position:0%
can be difficult and time-consuming
 

00:11:30.040 --> 00:11:32.590 align:start position:0%
can be difficult and time-consuming
excels<00:11:31.040><c> functions</c><00:11:31.549><c> can</c><00:11:31.699><c> save</c><00:11:31.970><c> you</c><00:11:32.119><c> a</c><00:11:32.149><c> lot</c><00:11:32.239><c> of</c>

00:11:32.590 --> 00:11:32.600 align:start position:0%
excels functions can save you a lot of
 

00:11:32.600 --> 00:11:35.980 align:start position:0%
excels functions can save you a lot of
time<00:11:32.839><c> and</c><00:11:33.230><c> headaches</c>