WEBVTT
Kind: captions
Language: en

00:00:01.149 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.149><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

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

00:00:03.739 --> 00:00:08.800 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.760><c> life</c>

00:00:08.800 --> 00:00:08.810 align:start position:0%
 
 

00:00:08.810 --> 00:00:11.420 align:start position:0%
 
functions<00:00:09.810><c> are</c><00:00:10.080><c> a</c><00:00:10.110><c> great</c><00:00:10.410><c> time-saving</c><00:00:10.950><c> option</c>

00:00:11.420 --> 00:00:11.430 align:start position:0%
functions are a great time-saving option
 

00:00:11.430 --> 00:00:13.250 align:start position:0%
functions are a great time-saving option
for<00:00:11.640><c> calculating</c><00:00:12.060><c> data</c><00:00:12.390><c> in</c><00:00:12.720><c> your</c><00:00:12.840><c> worksheet</c>

00:00:13.250 --> 00:00:13.260 align:start position:0%
for calculating data in your worksheet
 

00:00:13.260 --> 00:00:15.590 align:start position:0%
for calculating data in your worksheet
they<00:00:14.070><c> can</c><00:00:14.250><c> be</c><00:00:14.370><c> used</c><00:00:14.580><c> in</c><00:00:14.730><c> place</c><00:00:14.940><c> of</c><00:00:14.970><c> formulas</c>

00:00:15.590 --> 00:00:15.600 align:start position:0%
they can be used in place of formulas
 

00:00:15.600 --> 00:00:17.690 align:start position:0%
they can be used in place of formulas
when<00:00:15.900><c> a</c><00:00:15.930><c> formula</c><00:00:16.380><c> would</c><00:00:16.500><c> be</c><00:00:16.560><c> too</c><00:00:16.830><c> long</c><00:00:17.040><c> or</c><00:00:17.340><c> just</c>

00:00:17.690 --> 00:00:17.700 align:start position:0%
when a formula would be too long or just
 

00:00:17.700 --> 00:00:20.900 align:start position:0%
when a formula would be too long or just
too<00:00:17.820><c> complicated</c><00:00:18.180><c> to</c><00:00:18.600><c> write</c><00:00:18.750><c> out</c><00:00:18.900><c> manually</c><00:00:19.910><c> to</c>

00:00:20.900 --> 00:00:20.910 align:start position:0%
too complicated to write out manually to
 

00:00:20.910 --> 00:00:22.790 align:start position:0%
too complicated to write out manually to
access<00:00:21.330><c> the</c><00:00:21.480><c> function</c><00:00:21.869><c> library</c><00:00:22.020><c> go</c><00:00:22.650><c> to</c><00:00:22.680><c> the</c>

00:00:22.790 --> 00:00:22.800 align:start position:0%
access the function library go to the
 

00:00:22.800 --> 00:00:25.670 align:start position:0%
access the function library go to the
formulas<00:00:23.340><c> tab</c><00:00:23.550><c> on</c><00:00:23.790><c> the</c><00:00:23.880><c> ribbon</c><00:00:24.500><c> here</c><00:00:25.500><c> you'll</c>

00:00:25.670 --> 00:00:25.680 align:start position:0%
formulas tab on the ribbon here you'll
 

00:00:25.680 --> 00:00:27.170 align:start position:0%
formulas tab on the ribbon here you'll
find<00:00:25.950><c> hundreds</c><00:00:26.310><c> of</c><00:00:26.430><c> functions</c><00:00:26.820><c> to</c><00:00:26.880><c> choose</c>

00:00:27.170 --> 00:00:27.180 align:start position:0%
find hundreds of functions to choose
 

00:00:27.180 --> 00:00:27.620 align:start position:0%
find hundreds of functions to choose
from

00:00:27.620 --> 00:00:27.630 align:start position:0%
from
 

00:00:27.630 --> 00:00:29.330 align:start position:0%
from
they've<00:00:28.140><c> all</c><00:00:28.410><c> been</c><00:00:28.440><c> organized</c><00:00:29.100><c> into</c>

00:00:29.330 --> 00:00:29.340 align:start position:0%
they've all been organized into
 

00:00:29.340 --> 00:00:31.010 align:start position:0%
they've all been organized into
categories<00:00:29.970><c> to</c><00:00:30.180><c> make</c><00:00:30.300><c> them</c><00:00:30.480><c> easier</c><00:00:30.869><c> to</c><00:00:30.900><c> find</c>

00:00:31.010 --> 00:00:31.020 align:start position:0%
categories to make them easier to find
 

00:00:31.020 --> 00:00:34.520 align:start position:0%
categories to make them easier to find
for<00:00:32.000><c> example</c><00:00:33.000><c> under</c><00:00:33.210><c> financial</c><00:00:33.540><c> you'll</c><00:00:34.260><c> find</c>

00:00:34.520 --> 00:00:34.530 align:start position:0%
for example under financial you'll find
 

00:00:34.530 --> 00:00:35.810 align:start position:0%
for example under financial you'll find
functions<00:00:34.949><c> that</c><00:00:35.100><c> deal</c><00:00:35.280><c> with</c><00:00:35.430><c> things</c><00:00:35.610><c> like</c>

00:00:35.810 --> 00:00:35.820 align:start position:0%
functions that deal with things like
 

00:00:35.820 --> 00:00:39.200 align:start position:0%
functions that deal with things like
interest<00:00:36.270><c> and</c><00:00:36.540><c> monthly</c><00:00:36.840><c> payments</c><00:00:37.790><c> under</c><00:00:38.790><c> text</c>

00:00:39.200 --> 00:00:39.210 align:start position:0%
interest and monthly payments under text
 

00:00:39.210 --> 00:00:41.540 align:start position:0%
interest and monthly payments under text
you<00:00:39.510><c> can</c><00:00:39.660><c> perform</c><00:00:39.989><c> text</c><00:00:40.379><c> manipulations</c><00:00:41.070><c> like</c>

00:00:41.540 --> 00:00:41.550 align:start position:0%
you can perform text manipulations like
 

00:00:41.550 --> 00:00:43.000 align:start position:0%
you can perform text manipulations like
converting<00:00:41.879><c> lowercase</c><00:00:42.449><c> to</c><00:00:42.629><c> uppercase</c>

00:00:43.000 --> 00:00:43.010 align:start position:0%
converting lowercase to uppercase
 

00:00:43.010 --> 00:00:46.729 align:start position:0%
converting lowercase to uppercase
replacing<00:00:44.010><c> text</c><00:00:44.370><c> and</c><00:00:44.519><c> more</c><00:00:45.290><c> date</c><00:00:46.290><c> and</c><00:00:46.500><c> time</c>

00:00:46.729 --> 00:00:46.739 align:start position:0%
replacing text and more date and time
 

00:00:46.739 --> 00:00:48.380 align:start position:0%
replacing text and more date and time
includes<00:00:47.309><c> functions</c><00:00:47.550><c> that</c><00:00:47.909><c> return</c><00:00:48.239><c> the</c>

00:00:48.380 --> 00:00:48.390 align:start position:0%
includes functions that return the
 

00:00:48.390 --> 00:00:50.630 align:start position:0%
includes functions that return the
current<00:00:48.570><c> date</c><00:00:48.870><c> time</c><00:00:49.110><c> day</c><00:00:50.010><c> of</c><00:00:50.129><c> the</c><00:00:50.250><c> week</c><00:00:50.400><c> and</c>

00:00:50.630 --> 00:00:50.640 align:start position:0%
current date time day of the week and
 

00:00:50.640 --> 00:00:53.570 align:start position:0%
current date time day of the week and
other<00:00:50.970><c> useful</c><00:00:51.269><c> data</c><00:00:52.190><c> some</c><00:00:53.190><c> of</c><00:00:53.220><c> the</c><00:00:53.400><c> most</c>

00:00:53.570 --> 00:00:53.580 align:start position:0%
other useful data some of the most
 

00:00:53.580 --> 00:00:55.070 align:start position:0%
other useful data some of the most
common<00:00:54.030><c> functions</c><00:00:54.210><c> are</c><00:00:54.600><c> pretty</c><00:00:54.809><c> simple</c>

00:00:55.070 --> 00:00:55.080 align:start position:0%
common functions are pretty simple
 

00:00:55.080 --> 00:00:57.619 align:start position:0%
common functions are pretty simple
though<00:00:55.320><c> like</c><00:00:55.769><c> sum</c><00:00:56.070><c> and</c><00:00:56.339><c> average</c><00:00:56.549><c> you</c><00:00:57.449><c> can</c>

00:00:57.619 --> 00:00:57.629 align:start position:0%
though like sum and average you can
 

00:00:57.629 --> 00:00:59.509 align:start position:0%
though like sum and average you can
access<00:00:57.960><c> these</c><00:00:58.260><c> using</c><00:00:58.769><c> the</c><00:00:58.860><c> drop</c><00:00:59.070><c> down</c><00:00:59.280><c> arrow</c>

00:00:59.509 --> 00:00:59.519 align:start position:0%
access these using the drop down arrow
 

00:00:59.519 --> 00:01:05.240 align:start position:0%
access these using the drop down arrow
under<00:00:59.610><c> Auto</c><00:01:00.030><c> sum</c><00:01:01.129><c> in</c><00:01:03.500><c> this</c><00:01:04.500><c> example</c><00:01:04.860><c> I'd</c><00:01:05.190><c> like</c>

00:01:05.240 --> 00:01:05.250 align:start position:0%
under Auto sum in this example I'd like
 

00:01:05.250 --> 00:01:07.609 align:start position:0%
under Auto sum in this example I'd like
to<00:01:05.549><c> add</c><00:01:05.700><c> these</c><00:01:06.120><c> ten</c><00:01:06.479><c> cells</c><00:01:06.780><c> to</c><00:01:07.020><c> calculate</c><00:01:07.500><c> the</c>

00:01:07.609 --> 00:01:07.619 align:start position:0%
to add these ten cells to calculate the
 

00:01:07.619 --> 00:01:10.160 align:start position:0%
to add these ten cells to calculate the
total<00:01:07.979><c> if</c><00:01:08.159><c> I</c><00:01:08.909><c> tried</c><00:01:09.180><c> to</c><00:01:09.299><c> create</c><00:01:09.510><c> a</c><00:01:09.570><c> formula</c><00:01:10.020><c> for</c>

00:01:10.160 --> 00:01:10.170 align:start position:0%
total if I tried to create a formula for
 

00:01:10.170 --> 00:01:11.750 align:start position:0%
total if I tried to create a formula for
that<00:01:10.320><c> I'd</c><00:01:10.619><c> have</c><00:01:10.890><c> to</c><00:01:10.920><c> add</c><00:01:11.159><c> each</c><00:01:11.430><c> cell</c>

00:01:11.750 --> 00:01:11.760 align:start position:0%
that I'd have to add each cell
 

00:01:11.760 --> 00:01:14.240 align:start position:0%
that I'd have to add each cell
individually<00:01:12.560><c> not</c><00:01:13.560><c> only</c><00:01:13.800><c> would</c><00:01:13.950><c> that</c><00:01:13.980><c> be</c>

00:01:14.240 --> 00:01:14.250 align:start position:0%
individually not only would that be
 

00:01:14.250 --> 00:01:16.130 align:start position:0%
individually not only would that be
tedious<00:01:14.490><c> it</c><00:01:15.060><c> would</c><00:01:15.240><c> also</c><00:01:15.360><c> make</c><00:01:15.600><c> the</c><00:01:15.750><c> formula</c>

00:01:16.130 --> 00:01:16.140 align:start position:0%
tedious it would also make the formula
 

00:01:16.140 --> 00:01:18.500 align:start position:0%
tedious it would also make the formula
really<00:01:16.290><c> long</c><00:01:16.620><c> especially</c><00:01:17.220><c> if</c><00:01:17.610><c> I</c><00:01:17.730><c> had</c><00:01:17.940><c> say</c><00:01:18.330><c> a</c>

00:01:18.500 --> 00:01:18.510 align:start position:0%
really long especially if I had say a
 

00:01:18.510 --> 00:01:20.960 align:start position:0%
really long especially if I had say a
hundred<00:01:18.750><c> cells</c><00:01:19.140><c> that</c><00:01:19.320><c> I</c><00:01:19.380><c> wanted</c><00:01:19.650><c> to</c><00:01:19.710><c> add</c><00:01:19.970><c> so</c>

00:01:20.960 --> 00:01:20.970 align:start position:0%
hundred cells that I wanted to add so
 

00:01:20.970 --> 00:01:22.880 align:start position:0%
hundred cells that I wanted to add so
instead<00:01:21.300><c> of</c><00:01:21.360><c> creating</c><00:01:21.750><c> a</c><00:01:21.840><c> formula</c><00:01:22.230><c> I'm</c><00:01:22.410><c> going</c>

00:01:22.880 --> 00:01:22.890 align:start position:0%
instead of creating a formula I'm going
 

00:01:22.890 --> 00:01:26.180 align:start position:0%
instead of creating a formula I'm going
to<00:01:22.950><c> use</c><00:01:23.070><c> a</c><00:01:23.100><c> function</c><00:01:24.380><c> first</c><00:01:25.380><c> select</c><00:01:26.040><c> the</c><00:01:26.160><c> cell</c>

00:01:26.180 --> 00:01:26.190 align:start position:0%
to use a function first select the cell
 

00:01:26.190 --> 00:01:28.910 align:start position:0%
to use a function first select the cell
where<00:01:26.550><c> you</c><00:01:26.580><c> want</c><00:01:26.670><c> the</c><00:01:26.880><c> answer</c><00:01:27.090><c> to</c><00:01:27.300><c> appear</c><00:01:27.920><c> then</c>

00:01:28.910 --> 00:01:28.920 align:start position:0%
where you want the answer to appear then
 

00:01:28.920 --> 00:01:31.370 align:start position:0%
where you want the answer to appear then
choose<00:01:29.250><c> a</c><00:01:29.280><c> function</c><00:01:29.550><c> in</c><00:01:29.970><c> our</c><00:01:30.570><c> case</c><00:01:30.810><c> we'll</c><00:01:31.200><c> open</c>

00:01:31.370 --> 00:01:31.380 align:start position:0%
choose a function in our case we'll open
 

00:01:31.380 --> 00:01:36.590 align:start position:0%
choose a function in our case we'll open
the<00:01:31.590><c> autosum</c><00:01:32.040><c> menu</c><00:01:32.370><c> and</c><00:01:32.550><c> then</c><00:01:33.510><c> choose</c><00:01:33.840><c> sum</c><00:01:35.600><c> now</c>

00:01:36.590 --> 00:01:36.600 align:start position:0%
the autosum menu and then choose sum now
 

00:01:36.600 --> 00:01:38.720 align:start position:0%
the autosum menu and then choose sum now
Excel<00:01:37.020><c> has</c><00:01:37.200><c> inserted</c><00:01:37.650><c> the</c><00:01:37.860><c> function</c><00:01:38.310><c> and</c><00:01:38.490><c> also</c>

00:01:38.720 --> 00:01:38.730 align:start position:0%
Excel has inserted the function and also
 

00:01:38.730 --> 00:01:40.640 align:start position:0%
Excel has inserted the function and also
selected<00:01:39.450><c> the</c><00:01:39.480><c> cells</c><00:01:39.810><c> that</c><00:01:40.080><c> are</c><00:01:40.140><c> being</c><00:01:40.380><c> added</c>

00:01:40.640 --> 00:01:40.650 align:start position:0%
selected the cells that are being added
 

00:01:40.650 --> 00:01:43.340 align:start position:0%
selected the cells that are being added
together<00:01:41.030><c> if</c><00:01:42.030><c> it</c><00:01:42.300><c> selects</c><00:01:42.720><c> the</c><00:01:42.840><c> wrong</c><00:01:43.020><c> cells</c>

00:01:43.340 --> 00:01:43.350 align:start position:0%
together if it selects the wrong cells
 

00:01:43.350 --> 00:01:45.410 align:start position:0%
together if it selects the wrong cells
you<00:01:43.800><c> can</c><00:01:43.980><c> always</c><00:01:44.100><c> change</c><00:01:44.460><c> that</c><00:01:44.610><c> by</c><00:01:45.000><c> dragging</c>

00:01:45.410 --> 00:01:45.420 align:start position:0%
you can always change that by dragging
 

00:01:45.420 --> 00:01:49.460 align:start position:0%
you can always change that by dragging
the<00:01:45.510><c> corner</c><00:01:45.690><c> handles</c><00:01:46.020><c> here</c><00:01:48.170><c> when</c><00:01:49.170><c> you're</c><00:01:49.290><c> done</c>

00:01:49.460 --> 00:01:49.470 align:start position:0%
the corner handles here when you're done
 

00:01:49.470 --> 00:01:52.340 align:start position:0%
the corner handles here when you're done
press<00:01:49.890><c> ENTER</c><00:01:50.370><c> on</c><00:01:50.400><c> your</c><00:01:50.580><c> keyboard</c><00:01:50.700><c> and</c><00:01:51.350><c> the</c>

00:01:52.340 --> 00:01:52.350 align:start position:0%
press ENTER on your keyboard and the
 

00:01:52.350 --> 00:01:55.310 align:start position:0%
press ENTER on your keyboard and the
answer<00:01:52.650><c> will</c><00:01:52.800><c> appear</c><00:01:53.870><c> let's</c><00:01:54.870><c> look</c><00:01:55.080><c> at</c><00:01:55.200><c> this</c>

00:01:55.310 --> 00:01:55.320 align:start position:0%
answer will appear let's look at this
 

00:01:55.320 --> 00:01:59.110 align:start position:0%
answer will appear let's look at this
function<00:01:55.560><c> in</c><00:01:55.920><c> a</c><00:01:56.010><c> little</c><00:01:56.220><c> more</c><00:01:56.370><c> detail</c><00:01:56.790><c> just</c>

00:01:59.110 --> 00:01:59.120 align:start position:0%
 
 

00:01:59.120 --> 00:02:02.120 align:start position:0%
 
like<00:02:00.120><c> formulas</c><00:02:00.720><c> functions</c><00:02:01.170><c> always</c><00:02:01.680><c> start</c>

00:02:02.120 --> 00:02:02.130 align:start position:0%
like formulas functions always start
 

00:02:02.130 --> 00:02:04.190 align:start position:0%
like formulas functions always start
with<00:02:02.280><c> an</c><00:02:02.400><c> equal</c><00:02:02.640><c> sign</c><00:02:02.880><c> but</c><00:02:03.870><c> you</c><00:02:04.020><c> may</c><00:02:04.170><c> have</c>

00:02:04.190 --> 00:02:04.200 align:start position:0%
with an equal sign but you may have
 

00:02:04.200 --> 00:02:05.930 align:start position:0%
with an equal sign but you may have
noticed<00:02:04.620><c> that</c><00:02:04.710><c> there</c><00:02:04.979><c> are</c><00:02:05.010><c> no</c><00:02:05.130><c> mathematical</c>

00:02:05.930 --> 00:02:05.940 align:start position:0%
noticed that there are no mathematical
 

00:02:05.940 --> 00:02:07.670 align:start position:0%
noticed that there are no mathematical
operators<00:02:06.479><c> such</c><00:02:06.720><c> as</c><00:02:06.960><c> addition</c><00:02:07.530><c> or</c>

00:02:07.670 --> 00:02:07.680 align:start position:0%
operators such as addition or
 

00:02:07.680 --> 00:02:09.469 align:start position:0%
operators such as addition or
subtraction<00:02:07.920><c> like</c><00:02:08.670><c> you</c><00:02:08.819><c> would</c><00:02:08.940><c> normally</c><00:02:09.269><c> see</c>

00:02:09.469 --> 00:02:09.479 align:start position:0%
subtraction like you would normally see
 

00:02:09.479 --> 00:02:12.410 align:start position:0%
subtraction like you would normally see
in<00:02:09.509><c> a</c><00:02:09.659><c> formula</c><00:02:10.280><c> instead</c><00:02:11.280><c> functions</c><00:02:12.209><c> use</c><00:02:12.390><c> a</c>

00:02:12.410 --> 00:02:12.420 align:start position:0%
in a formula instead functions use a
 

00:02:12.420 --> 00:02:14.750 align:start position:0%
in a formula instead functions use a
specific<00:02:12.750><c> syntax</c><00:02:13.349><c> that</c><00:02:13.890><c> includes</c><00:02:14.370><c> the</c><00:02:14.580><c> name</c>

00:02:14.750 --> 00:02:14.760 align:start position:0%
specific syntax that includes the name
 

00:02:14.760 --> 00:02:17.360 align:start position:0%
specific syntax that includes the name
of<00:02:14.909><c> the</c><00:02:15.030><c> function</c><00:02:15.769><c> followed</c><00:02:16.769><c> by</c><00:02:16.920><c> one</c><00:02:17.189><c> or</c><00:02:17.310><c> more</c>

00:02:17.360 --> 00:02:17.370 align:start position:0%
of the function followed by one or more
 

00:02:17.370 --> 00:02:20.040 align:start position:0%
of the function followed by one or more
arguments<00:02:17.819><c> in</c><00:02:18.239><c> parentheses</c>

00:02:20.040 --> 00:02:20.050 align:start position:0%
arguments in parentheses
 

00:02:20.050 --> 00:02:21.960 align:start position:0%
arguments in parentheses
the<00:02:20.440><c> arguments</c><00:02:21.040><c> tell</c><00:02:21.310><c> the</c><00:02:21.400><c> function</c><00:02:21.580><c> which</c>

00:02:21.960 --> 00:02:21.970 align:start position:0%
the arguments tell the function which
 

00:02:21.970 --> 00:02:23.430 align:start position:0%
the arguments tell the function which
sells<00:02:22.300><c> our</c><00:02:22.510><c> numbers</c><00:02:22.810><c> to</c><00:02:22.840><c> use</c><00:02:23.170><c> when</c>

00:02:23.430 --> 00:02:23.440 align:start position:0%
sells our numbers to use when
 

00:02:23.440 --> 00:02:26.130 align:start position:0%
sells our numbers to use when
calculating<00:02:24.070><c> the</c><00:02:24.190><c> result</c><00:02:24.550><c> in</c><00:02:24.790><c> this</c><00:02:25.750><c> example</c>

00:02:26.130 --> 00:02:26.140 align:start position:0%
calculating the result in this example
 

00:02:26.140 --> 00:02:28.290 align:start position:0%
calculating the result in this example
we<00:02:26.560><c> only</c><00:02:26.590><c> have</c><00:02:27.040><c> one</c><00:02:27.250><c> argument</c><00:02:27.550><c> even</c><00:02:28.120><c> though</c>

00:02:28.290 --> 00:02:28.300 align:start position:0%
we only have one argument even though
 

00:02:28.300 --> 00:02:29.880 align:start position:0%
we only have one argument even though
there<00:02:28.630><c> are</c><00:02:28.750><c> two</c><00:02:28.900><c> different</c><00:02:29.200><c> cell</c><00:02:29.350><c> references</c>

00:02:29.880 --> 00:02:29.890 align:start position:0%
there are two different cell references
 

00:02:29.890 --> 00:02:32.400 align:start position:0%
there are two different cell references
this<00:02:30.730><c> is</c><00:02:30.790><c> called</c><00:02:31.240><c> a</c><00:02:31.420><c> range</c><00:02:31.660><c> of</c><00:02:31.810><c> cells</c><00:02:32.050><c> or</c><00:02:32.350><c> a</c>

00:02:32.400 --> 00:02:32.410 align:start position:0%
this is called a range of cells or a
 

00:02:32.410 --> 00:02:36.030 align:start position:0%
this is called a range of cells or a
cell<00:02:33.010><c> range</c><00:02:33.220><c> a</c><00:02:34.020><c> cell</c><00:02:35.020><c> range</c><00:02:35.200><c> is</c><00:02:35.470><c> represented</c>

00:02:36.030 --> 00:02:36.040 align:start position:0%
cell range a cell range is represented
 

00:02:36.040 --> 00:02:37.800 align:start position:0%
cell range a cell range is represented
by<00:02:36.190><c> two</c><00:02:36.250><c> different</c><00:02:36.640><c> cell</c><00:02:37.000><c> references</c><00:02:37.510><c> with</c><00:02:37.780><c> a</c>

00:02:37.800 --> 00:02:37.810 align:start position:0%
by two different cell references with a
 

00:02:37.810 --> 00:02:40.890 align:start position:0%
by two different cell references with a
colon<00:02:38.140><c> in</c><00:02:38.470><c> between</c><00:02:38.500><c> in</c><00:02:39.100><c> this</c><00:02:40.000><c> case</c><00:02:40.060><c> the</c><00:02:40.690><c> range</c>

00:02:40.890 --> 00:02:40.900 align:start position:0%
colon in between in this case the range
 

00:02:40.900 --> 00:02:43.320 align:start position:0%
colon in between in this case the range
consists<00:02:41.440><c> of</c><00:02:41.500><c> all</c><00:02:41.680><c> the</c><00:02:41.830><c> cells</c><00:02:42.100><c> between</c><00:02:42.370><c> d3</c><00:02:43.150><c> and</c>

00:02:43.320 --> 00:02:43.330 align:start position:0%
consists of all the cells between d3 and
 

00:02:43.330 --> 00:02:46.110 align:start position:0%
consists of all the cells between d3 and
d12<00:02:44.080><c> if</c><00:02:44.380><c> you</c><00:02:45.280><c> want</c><00:02:45.460><c> to</c><00:02:45.550><c> use</c><00:02:45.670><c> more</c><00:02:45.940><c> than</c><00:02:45.970><c> one</c>

00:02:46.110 --> 00:02:46.120 align:start position:0%
d12 if you want to use more than one
 

00:02:46.120 --> 00:02:47.970 align:start position:0%
d12 if you want to use more than one
argument<00:02:46.540><c> you'll</c><00:02:47.020><c> need</c><00:02:47.230><c> to</c><00:02:47.350><c> separate</c><00:02:47.740><c> each</c>

00:02:47.970 --> 00:02:47.980 align:start position:0%
argument you'll need to separate each
 

00:02:47.980 --> 00:02:53.580 align:start position:0%
argument you'll need to separate each
one<00:02:48.280><c> with</c><00:02:48.490><c> a</c><00:02:48.520><c> comma</c><00:02:52.200><c> let's</c><00:02:53.200><c> try</c><00:02:53.440><c> a</c><00:02:53.470><c> different</c>

00:02:53.580 --> 00:02:53.590 align:start position:0%
one with a comma let's try a different
 

00:02:53.590 --> 00:02:56.490 align:start position:0%
one with a comma let's try a different
function<00:02:54.100><c> now</c><00:02:54.490><c> in</c><00:02:54.760><c> this</c><00:02:55.450><c> example</c><00:02:55.840><c> we</c><00:02:56.290><c> have</c><00:02:56.320><c> a</c>

00:02:56.490 --> 00:02:56.500 align:start position:0%
function now in this example we have a
 

00:02:56.500 --> 00:02:58.110 align:start position:0%
function now in this example we have a
column<00:02:56.890><c> for</c><00:02:57.040><c> the</c><00:02:57.100><c> date</c><00:02:57.160><c> that</c><00:02:57.460><c> each</c><00:02:57.610><c> item</c><00:02:58.000><c> was</c>

00:02:58.110 --> 00:02:58.120 align:start position:0%
column for the date that each item was
 

00:02:58.120 --> 00:02:59.400 align:start position:0%
column for the date that each item was
ordered<00:02:58.450><c> and</c><00:02:58.570><c> the</c><00:02:58.960><c> date</c><00:02:59.140><c> that</c><00:02:59.290><c> it</c><00:02:59.380><c> was</c>

00:02:59.400 --> 00:02:59.410 align:start position:0%
ordered and the date that it was
 

00:02:59.410 --> 00:03:01.740 align:start position:0%
ordered and the date that it was
received<00:02:59.790><c> what</c><00:03:00.790><c> I'd</c><00:03:00.940><c> like</c><00:03:01.090><c> to</c><00:03:01.150><c> know</c><00:03:01.300><c> is</c><00:03:01.600><c> how</c>

00:03:01.740 --> 00:03:01.750 align:start position:0%
received what I'd like to know is how
 

00:03:01.750 --> 00:03:03.540 align:start position:0%
received what I'd like to know is how
many<00:03:01.930><c> business</c><00:03:02.320><c> days</c><00:03:02.500><c> it</c><00:03:02.680><c> took</c><00:03:02.830><c> for</c><00:03:03.160><c> each</c><00:03:03.280><c> item</c>

00:03:03.540 --> 00:03:03.550 align:start position:0%
many business days it took for each item
 

00:03:03.550 --> 00:03:06.840 align:start position:0%
many business days it took for each item
to<00:03:03.790><c> be</c><00:03:03.910><c> delivered</c><00:03:04.860><c> first</c><00:03:05.860><c> select</c><00:03:06.520><c> the</c><00:03:06.640><c> cell</c>

00:03:06.840 --> 00:03:06.850 align:start position:0%
to be delivered first select the cell
 

00:03:06.850 --> 00:03:09.420 align:start position:0%
to be delivered first select the cell
where<00:03:07.030><c> you</c><00:03:07.090><c> want</c><00:03:07.180><c> the</c><00:03:07.390><c> function</c><00:03:07.720><c> to</c><00:03:07.840><c> go</c><00:03:08.430><c> then</c>

00:03:09.420 --> 00:03:09.430 align:start position:0%
where you want the function to go then
 

00:03:09.430 --> 00:03:10.710 align:start position:0%
where you want the function to go then
choose<00:03:09.700><c> a</c><00:03:09.730><c> function</c><00:03:09.970><c> if</c><00:03:10.330><c> you</c><00:03:10.360><c> know</c><00:03:10.570><c> what</c>

00:03:10.710 --> 00:03:10.720 align:start position:0%
choose a function if you know what
 

00:03:10.720 --> 00:03:13.950 align:start position:0%
choose a function if you know what
category<00:03:10.900><c> it's</c><00:03:11.350><c> in</c><00:03:11.560><c> if</c><00:03:12.090><c> you</c><00:03:13.090><c> don't</c><00:03:13.300><c> you</c><00:03:13.780><c> can</c>

00:03:13.950 --> 00:03:13.960 align:start position:0%
category it's in if you don't you can
 

00:03:13.960 --> 00:03:16.710 align:start position:0%
category it's in if you don't you can
try<00:03:14.140><c> searching</c><00:03:14.380><c> for</c><00:03:14.590><c> it</c><00:03:14.890><c> instead</c><00:03:15.450><c> just</c><00:03:16.450><c> click</c>

00:03:16.710 --> 00:03:16.720 align:start position:0%
try searching for it instead just click
 

00:03:16.720 --> 00:03:18.660 align:start position:0%
try searching for it instead just click
the<00:03:16.870><c> insert</c><00:03:17.260><c> function</c><00:03:17.500><c> command</c><00:03:17.740><c> on</c><00:03:18.280><c> the</c><00:03:18.460><c> far</c>

00:03:18.660 --> 00:03:18.670 align:start position:0%
the insert function command on the far
 

00:03:18.670 --> 00:03:22.230 align:start position:0%
the insert function command on the far
left<00:03:18.940><c> of</c><00:03:19.060><c> the</c><00:03:19.120><c> ribbon</c><00:03:21.060><c> searching</c><00:03:22.060><c> for</c>

00:03:22.230 --> 00:03:22.240 align:start position:0%
left of the ribbon searching for
 

00:03:22.240 --> 00:03:24.180 align:start position:0%
left of the ribbon searching for
functions<00:03:22.600><c> can</c><00:03:22.900><c> be</c><00:03:22.930><c> tricky</c><00:03:23.350><c> but</c><00:03:23.830><c> for</c><00:03:24.070><c> more</c>

00:03:24.180 --> 00:03:24.190 align:start position:0%
functions can be tricky but for more
 

00:03:24.190 --> 00:03:25.830 align:start position:0%
functions can be tricky but for more
experienced<00:03:24.730><c> users</c><00:03:25.090><c> this</c><00:03:25.390><c> can</c><00:03:25.600><c> be</c><00:03:25.750><c> an</c>

00:03:25.830 --> 00:03:25.840 align:start position:0%
experienced users this can be an
 

00:03:25.840 --> 00:03:28.530 align:start position:0%
experienced users this can be an
extremely<00:03:25.930><c> useful</c><00:03:26.560><c> tool</c><00:03:27.240><c> just</c><00:03:28.240><c> type</c><00:03:28.420><c> a</c>

00:03:28.530 --> 00:03:28.540 align:start position:0%
extremely useful tool just type a
 

00:03:28.540 --> 00:03:29.730 align:start position:0%
extremely useful tool just type a
description<00:03:28.930><c> of</c><00:03:29.140><c> the</c><00:03:29.260><c> function</c><00:03:29.650><c> you're</c>

00:03:29.730 --> 00:03:29.740 align:start position:0%
description of the function you're
 

00:03:29.740 --> 00:03:32.040 align:start position:0%
description of the function you're
looking<00:03:30.040><c> for</c><00:03:30.280><c> I'm</c><00:03:30.580><c> looking</c><00:03:31.240><c> for</c><00:03:31.750><c> something</c>

00:03:32.040 --> 00:03:32.050 align:start position:0%
looking for I'm looking for something
 

00:03:32.050 --> 00:03:33.150 align:start position:0%
looking for I'm looking for something
that'll<00:03:32.230><c> count</c><00:03:32.470><c> the</c><00:03:32.590><c> number</c><00:03:32.860><c> of</c><00:03:32.950><c> days</c><00:03:33.130><c> that</c>

00:03:33.150 --> 00:03:33.160 align:start position:0%
that'll count the number of days that
 

00:03:33.160 --> 00:03:35.730 align:start position:0%
that'll count the number of days that
have<00:03:33.459><c> elapsed</c><00:03:33.970><c> so</c><00:03:34.300><c> I'll</c><00:03:34.450><c> type</c><00:03:34.660><c> count</c><00:03:35.050><c> days</c><00:03:35.380><c> and</c>

00:03:35.730 --> 00:03:35.740 align:start position:0%
have elapsed so I'll type count days and
 

00:03:35.740 --> 00:03:39.690 align:start position:0%
have elapsed so I'll type count days and
then<00:03:36.100><c> press</c><00:03:36.400><c> Enter</c><00:03:38.010><c> we've</c><00:03:39.010><c> gotten</c><00:03:39.340><c> a</c><00:03:39.430><c> lot</c><00:03:39.640><c> of</c>

00:03:39.690 --> 00:03:39.700 align:start position:0%
then press Enter we've gotten a lot of
 

00:03:39.700 --> 00:03:42.510 align:start position:0%
then press Enter we've gotten a lot of
different<00:03:40.209><c> results</c><00:03:40.570><c> here</c><00:03:41.130><c> to</c><00:03:42.130><c> learn</c><00:03:42.250><c> more</c>

00:03:42.510 --> 00:03:42.520 align:start position:0%
different results here to learn more
 

00:03:42.520 --> 00:03:44.390 align:start position:0%
different results here to learn more
about<00:03:42.610><c> a</c><00:03:42.730><c> function</c><00:03:43.180><c> just</c><00:03:43.600><c> click</c><00:03:43.780><c> the</c><00:03:43.930><c> name</c><00:03:44.080><c> and</c>

00:03:44.390 --> 00:03:44.400 align:start position:0%
about a function just click the name and
 

00:03:44.400 --> 00:03:47.540 align:start position:0%
about a function just click the name and
a<00:03:45.400><c> description</c><00:03:45.670><c> will</c><00:03:46.060><c> appear</c><00:03:46.090><c> below</c><00:03:46.540><c> the</c>

00:03:47.540 --> 00:03:47.550 align:start position:0%
a description will appear below the
 

00:03:47.550 --> 00:03:50.370 align:start position:0%
a description will appear below the
function<00:03:48.550><c> called</c><00:03:48.790><c> Network</c><00:03:49.300><c> days</c><00:03:49.600><c> returns</c><00:03:50.170><c> the</c>

00:03:50.370 --> 00:03:50.380 align:start position:0%
function called Network days returns the
 

00:03:50.380 --> 00:03:52.260 align:start position:0%
function called Network days returns the
number<00:03:50.500><c> of</c><00:03:50.740><c> workdays</c><00:03:51.130><c> between</c><00:03:51.580><c> two</c><00:03:51.760><c> dates</c><00:03:52.000><c> and</c>

00:03:52.260 --> 00:03:52.270 align:start position:0%
number of workdays between two dates and
 

00:03:52.270 --> 00:03:54.960 align:start position:0%
number of workdays between two dates and
that's<00:03:52.570><c> exactly</c><00:03:53.110><c> what</c><00:03:53.260><c> we</c><00:03:53.380><c> want</c><00:03:53.590><c> so</c><00:03:54.490><c> I'm</c><00:03:54.760><c> just</c>

00:03:54.960 --> 00:03:54.970 align:start position:0%
that's exactly what we want so I'm just
 

00:03:54.970 --> 00:03:58.110 align:start position:0%
that's exactly what we want so I'm just
going<00:03:55.120><c> to</c><00:03:55.209><c> click</c><00:03:55.390><c> OK</c><00:03:55.570><c> and</c><00:03:56.459><c> another</c><00:03:57.459><c> dialog</c><00:03:57.880><c> box</c>

00:03:58.110 --> 00:03:58.120 align:start position:0%
going to click OK and another dialog box
 

00:03:58.120 --> 00:04:00.990 align:start position:0%
going to click OK and another dialog box
will<00:03:58.360><c> appear</c><00:03:59.340><c> there</c><00:04:00.340><c> will</c><00:04:00.520><c> be</c><00:04:00.550><c> separate</c>

00:04:00.990 --> 00:04:01.000 align:start position:0%
will appear there will be separate
 

00:04:01.000 --> 00:04:02.810 align:start position:0%
will appear there will be separate
fields<00:04:01.390><c> for</c><00:04:01.570><c> each</c><00:04:01.720><c> argument</c><00:04:02.050><c> in</c><00:04:02.440><c> the</c><00:04:02.530><c> function</c>

00:04:02.810 --> 00:04:02.820 align:start position:0%
fields for each argument in the function
 

00:04:02.820 --> 00:04:05.460 align:start position:0%
fields for each argument in the function
this<00:04:03.820><c> function</c><00:04:03.850><c> has</c><00:04:04.480><c> up</c><00:04:04.630><c> to</c><00:04:04.780><c> three</c><00:04:04.990><c> arguments</c>

00:04:05.460 --> 00:04:05.470 align:start position:0%
this function has up to three arguments
 

00:04:05.470 --> 00:04:09.570 align:start position:0%
this function has up to three arguments
start<00:04:06.130><c> date</c><00:04:06.400><c> and</c><00:04:06.640><c> date</c><00:04:07.300><c> and</c><00:04:07.510><c> holidays</c><00:04:08.580><c> when</c>

00:04:09.570 --> 00:04:09.580 align:start position:0%
start date and date and holidays when
 

00:04:09.580 --> 00:04:10.770 align:start position:0%
start date and date and holidays when
you<00:04:09.670><c> click</c><00:04:09.880><c> a</c><00:04:09.910><c> field</c><00:04:10.240><c> you'll</c><00:04:10.540><c> see</c><00:04:10.750><c> a</c>

00:04:10.770 --> 00:04:10.780 align:start position:0%
you click a field you'll see a
 

00:04:10.780 --> 00:04:13.680 align:start position:0%
you click a field you'll see a
description<00:04:10.930><c> of</c><00:04:11.440><c> it</c><00:04:11.590><c> below</c><00:04:11.860><c> and</c><00:04:12.420><c> if</c><00:04:13.420><c> you</c><00:04:13.510><c> need</c>

00:04:13.680 --> 00:04:13.690 align:start position:0%
description of it below and if you need
 

00:04:13.690 --> 00:04:15.270 align:start position:0%
description of it below and if you need
more<00:04:13.840><c> help</c><00:04:14.050><c> you</c><00:04:14.350><c> can</c><00:04:14.709><c> click</c><00:04:14.890><c> the</c><00:04:15.040><c> link</c><00:04:15.220><c> that</c>

00:04:15.270 --> 00:04:15.280 align:start position:0%
more help you can click the link that
 

00:04:15.280 --> 00:04:20.280 align:start position:0%
more help you can click the link that
says<00:04:15.400><c> help</c><00:04:15.970><c> on</c><00:04:16.120><c> this</c><00:04:16.270><c> function</c><00:04:18.930><c> for</c><00:04:19.930><c> the</c><00:04:20.020><c> start</c>

00:04:20.280 --> 00:04:20.290 align:start position:0%
says help on this function for the start
 

00:04:20.290 --> 00:04:24.510 align:start position:0%
says help on this function for the start
date<00:04:20.500><c> I'm</c><00:04:20.739><c> going</c><00:04:21.160><c> to</c><00:04:21.220><c> select</c><00:04:21.370><c> cell</c><00:04:21.880><c> e3</c><00:04:22.150><c> and</c><00:04:23.520><c> for</c>

00:04:24.510 --> 00:04:24.520 align:start position:0%
date I'm going to select cell e3 and for
 

00:04:24.520 --> 00:04:28.469 align:start position:0%
date I'm going to select cell e3 and for
the<00:04:24.610><c> end</c><00:04:24.760><c> date</c><00:04:24.910><c> I'll</c><00:04:25.030><c> select</c><00:04:25.660><c> f3</c><00:04:27.180><c> we</c><00:04:28.180><c> know</c><00:04:28.330><c> the</c>

00:04:28.469 --> 00:04:28.479 align:start position:0%
the end date I'll select f3 we know the
 

00:04:28.479 --> 00:04:30.240 align:start position:0%
the end date I'll select f3 we know the
holidays<00:04:28.840><c> argument</c><00:04:29.350><c> is</c><00:04:29.470><c> optional</c><00:04:29.979><c> because</c>

00:04:30.240 --> 00:04:30.250 align:start position:0%
holidays argument is optional because
 

00:04:30.250 --> 00:04:32.190 align:start position:0%
holidays argument is optional because
it's<00:04:30.550><c> not</c><00:04:30.700><c> in</c><00:04:30.850><c> bold</c><00:04:31.090><c> so</c><00:04:31.330><c> I'm</c><00:04:31.810><c> going</c><00:04:31.990><c> to</c><00:04:32.050><c> leave</c>

00:04:32.190 --> 00:04:32.200 align:start position:0%
it's not in bold so I'm going to leave
 

00:04:32.200 --> 00:04:33.749 align:start position:0%
it's not in bold so I'm going to leave
that<00:04:32.229><c> one</c><00:04:32.440><c> blank</c>

00:04:33.749 --> 00:04:33.759 align:start position:0%
that one blank
 

00:04:33.759 --> 00:04:35.939 align:start position:0%
that one blank
before<00:04:34.539><c> you</c><00:04:34.659><c> continue</c><00:04:34.839><c> you</c><00:04:35.439><c> can</c><00:04:35.620><c> check</c><00:04:35.830><c> the</c>

00:04:35.939 --> 00:04:35.949 align:start position:0%
before you continue you can check the
 

00:04:35.949 --> 00:04:39.570 align:start position:0%
before you continue you can check the
result<00:04:36.249><c> of</c><00:04:36.370><c> the</c><00:04:36.490><c> function</c><00:04:36.879><c> here</c><00:04:38.430><c> when</c><00:04:39.430><c> you're</c>

00:04:39.570 --> 00:04:39.580 align:start position:0%
result of the function here when you're
 

00:04:39.580 --> 00:04:42.450 align:start position:0%
result of the function here when you're
ready<00:04:39.759><c> click</c><00:04:40.120><c> OK</c><00:04:40.270><c> and</c><00:04:40.919><c> the</c><00:04:41.919><c> function</c><00:04:42.309><c> will</c><00:04:42.339><c> be</c>

00:04:42.450 --> 00:04:42.460 align:start position:0%
ready click OK and the function will be
 

00:04:42.460 --> 00:04:45.570 align:start position:0%
ready click OK and the function will be
added<00:04:42.849><c> to</c><00:04:42.879><c> the</c><00:04:43.059><c> worksheet</c><00:04:44.159><c> just</c><00:04:45.159><c> like</c><00:04:45.400><c> with</c>

00:04:45.570 --> 00:04:45.580 align:start position:0%
added to the worksheet just like with
 

00:04:45.580 --> 00:04:47.700 align:start position:0%
added to the worksheet just like with
formulas<00:04:46.059><c> you</c><00:04:46.330><c> can</c><00:04:46.360><c> copy</c><00:04:46.749><c> the</c><00:04:46.960><c> function</c><00:04:47.349><c> using</c>

00:04:47.700 --> 00:04:47.710 align:start position:0%
formulas you can copy the function using
 

00:04:47.710 --> 00:04:51.869 align:start position:0%
formulas you can copy the function using
the<00:04:47.800><c> fill</c><00:04:47.979><c> handle</c><00:04:48.189><c> here</c><00:04:48.699><c> and</c><00:04:50.400><c> now</c><00:04:51.400><c> we</c><00:04:51.460><c> can</c><00:04:51.580><c> see</c>

00:04:51.869 --> 00:04:51.879 align:start position:0%
the fill handle here and now we can see
 

00:04:51.879 --> 00:04:53.579 align:start position:0%
the fill handle here and now we can see
the<00:04:52.029><c> number</c><00:04:52.300><c> of</c><00:04:52.330><c> business</c><00:04:52.779><c> days</c><00:04:52.960><c> it</c><00:04:53.139><c> took</c><00:04:53.259><c> for</c>

00:04:53.579 --> 00:04:53.589 align:start position:0%
the number of business days it took for
 

00:04:53.589 --> 00:04:56.760 align:start position:0%
the number of business days it took for
each<00:04:53.740><c> item</c><00:04:53.979><c> to</c><00:04:54.249><c> be</c><00:04:54.370><c> delivered</c><00:04:54.990><c> if</c><00:04:55.990><c> you've</c>

00:04:56.760 --> 00:04:56.770 align:start position:0%
each item to be delivered if you've
 

00:04:56.770 --> 00:04:58.860 align:start position:0%
each item to be delivered if you've
never<00:04:56.919><c> used</c><00:04:57.069><c> functions</c><00:04:57.639><c> before</c><00:04:57.849><c> the</c><00:04:58.449><c> syntax</c>

00:04:58.860 --> 00:04:58.870 align:start position:0%
never used functions before the syntax
 

00:04:58.870 --> 00:05:00.570 align:start position:0%
never used functions before the syntax
may<00:04:59.050><c> seem</c><00:04:59.259><c> a</c><00:04:59.289><c> little</c><00:04:59.379><c> strange</c><00:04:59.770><c> at</c><00:05:00.009><c> first</c><00:05:00.039><c> but</c>

00:05:00.570 --> 00:05:00.580 align:start position:0%
may seem a little strange at first but
 

00:05:00.580 --> 00:05:02.670 align:start position:0%
may seem a little strange at first but
with<00:05:01.300><c> some</c><00:05:01.449><c> practice</c><00:05:01.900><c> you're</c><00:05:02.229><c> bound</c><00:05:02.439><c> to</c><00:05:02.529><c> get</c>

00:05:02.670 --> 00:05:02.680 align:start position:0%
with some practice you're bound to get
 

00:05:02.680 --> 00:05:04.350 align:start position:0%
with some practice you're bound to get
the<00:05:02.830><c> hang</c><00:05:03.009><c> of</c><00:05:03.099><c> it</c><00:05:03.189><c> and</c><00:05:03.370><c> soon</c><00:05:04.029><c> you'll</c><00:05:04.210><c> be</c><00:05:04.270><c> using</c>

00:05:04.350 --> 00:05:04.360 align:start position:0%
the hang of it and soon you'll be using
 

00:05:04.360 --> 00:05:08.460 align:start position:0%
the hang of it and soon you'll be using
your<00:05:04.659><c> favorite</c><00:05:05.169><c> functions</c><00:05:05.589><c> over</c><00:05:06.039><c> and</c><00:05:06.189><c> over</c>