WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.520><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.880 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.880 --> 00:00:10.890 align:start position:0%
 
 

00:00:10.890 --> 00:00:13.500 align:start position:0%
 
functions<00:00:11.890><c> are</c><00:00:12.100><c> a</c><00:00:12.160><c> great</c><00:00:12.490><c> time-saving</c><00:00:13.030><c> option</c>

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

00:00:13.510 --> 00:00:15.299 align:start position:0%
functions are a great time-saving option
for<00:00:13.690><c> calculating</c><00:00:14.140><c> data</c><00:00:14.530><c> in</c><00:00:14.800><c> your</c><00:00:14.920><c> worksheet</c>

00:00:15.299 --> 00:00:15.309 align:start position:0%
for calculating data in your worksheet
 

00:00:15.309 --> 00:00:17.670 align:start position:0%
for calculating data in your worksheet
they<00:00:16.150><c> can</c><00:00:16.330><c> be</c><00:00:16.450><c> used</c><00:00:16.660><c> in</c><00:00:16.810><c> place</c><00:00:17.020><c> of</c><00:00:17.050><c> formulas</c>

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

00:00:17.680 --> 00:00:19.769 align:start position:0%
they can be used in place of formulas
when<00:00:17.980><c> a</c><00:00:18.010><c> formula</c><00:00:18.460><c> would</c><00:00:18.580><c> be</c><00:00:18.640><c> too</c><00:00:18.910><c> long</c><00:00:19.119><c> or</c><00:00:19.390><c> just</c>

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

00:00:19.779 --> 00:00:22.830 align:start position:0%
when a formula would be too long or just
too<00:00:19.900><c> complicated</c><00:00:20.290><c> to</c><00:00:20.680><c> write</c><00:00:20.860><c> out</c><00:00:20.980><c> manually</c><00:00:21.840><c> to</c>

00:00:22.830 --> 00:00:22.840 align:start position:0%
too complicated to write out manually to
 

00:00:22.840 --> 00:00:24.690 align:start position:0%
too complicated to write out manually to
access<00:00:23.260><c> the</c><00:00:23.410><c> function</c><00:00:23.770><c> library</c><00:00:23.950><c> go</c><00:00:24.580><c> to</c><00:00:24.610><c> the</c>

00:00:24.690 --> 00:00:24.700 align:start position:0%
access the function library go to the
 

00:00:24.700 --> 00:00:27.600 align:start position:0%
access the function library go to the
formulas<00:00:25.270><c> tab</c><00:00:25.480><c> on</c><00:00:25.720><c> the</c><00:00:25.810><c> ribbon</c><00:00:26.430><c> here</c><00:00:27.430><c> you'll</c>

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

00:00:27.610 --> 00:00:28.920 align:start position:0%
formulas tab on the ribbon here you'll
find<00:00:27.850><c> hundreds</c><00:00:28.210><c> of</c><00:00:28.330><c> functions</c><00:00:28.720><c> to</c><00:00:28.810><c> choose</c>

00:00:28.920 --> 00:00:28.930 align:start position:0%
find hundreds of functions to choose
 

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

00:00:29.550 --> 00:00:29.560 align:start position:0%
from
 

00:00:29.560 --> 00:00:31.260 align:start position:0%
from
they've<00:00:30.070><c> all</c><00:00:30.340><c> been</c><00:00:30.369><c> organized</c><00:00:31.029><c> into</c>

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

00:00:31.270 --> 00:00:33.470 align:start position:0%
they've all been organized into
categories<00:00:31.900><c> to</c><00:00:32.110><c> make</c><00:00:32.140><c> them</c><00:00:32.410><c> easier</c><00:00:32.800><c> to</c><00:00:32.830><c> find</c>

00:00:33.470 --> 00:00:33.480 align:start position:0%
categories to make them easier to find
 

00:00:33.480 --> 00:00:36.450 align:start position:0%
categories to make them easier to find
for<00:00:34.480><c> example</c><00:00:34.930><c> under</c><00:00:35.140><c> financial</c><00:00:35.470><c> you'll</c><00:00:36.190><c> find</c>

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

00:00:36.460 --> 00:00:37.740 align:start position:0%
for example under financial you'll find
functions<00:00:36.879><c> that</c><00:00:37.030><c> deal</c><00:00:37.210><c> with</c><00:00:37.360><c> things</c><00:00:37.570><c> like</c>

00:00:37.740 --> 00:00:37.750 align:start position:0%
functions that deal with things like
 

00:00:37.750 --> 00:00:41.160 align:start position:0%
functions that deal with things like
interest<00:00:38.199><c> and</c><00:00:38.470><c> monthly</c><00:00:38.770><c> payments</c><00:00:39.720><c> under</c><00:00:40.720><c> text</c>

00:00:41.160 --> 00:00:41.170 align:start position:0%
interest and monthly payments under text
 

00:00:41.170 --> 00:00:43.470 align:start position:0%
interest and monthly payments under text
you<00:00:41.440><c> can</c><00:00:41.590><c> perform</c><00:00:41.920><c> text</c><00:00:42.309><c> manipulations</c><00:00:43.030><c> like</c>

00:00:43.470 --> 00:00:43.480 align:start position:0%
you can perform text manipulations like
 

00:00:43.480 --> 00:00:44.930 align:start position:0%
you can perform text manipulations like
converting<00:00:43.809><c> lowercase</c><00:00:44.380><c> to</c><00:00:44.559><c> uppercase</c>

00:00:44.930 --> 00:00:44.940 align:start position:0%
converting lowercase to uppercase
 

00:00:44.940 --> 00:00:48.690 align:start position:0%
converting lowercase to uppercase
replacing<00:00:45.940><c> text</c><00:00:46.300><c> and</c><00:00:46.450><c> more</c><00:00:47.220><c> date</c><00:00:48.220><c> and</c><00:00:48.430><c> time</c>

00:00:48.690 --> 00:00:48.700 align:start position:0%
replacing text and more date and time
 

00:00:48.700 --> 00:00:50.310 align:start position:0%
replacing text and more date and time
includes<00:00:49.270><c> functions</c><00:00:49.510><c> that</c><00:00:49.870><c> return</c><00:00:50.200><c> the</c>

00:00:50.310 --> 00:00:50.320 align:start position:0%
includes functions that return the
 

00:00:50.320 --> 00:00:52.560 align:start position:0%
includes functions that return the
current<00:00:50.500><c> date</c><00:00:50.800><c> time</c><00:00:51.040><c> day</c><00:00:51.969><c> of</c><00:00:52.090><c> the</c><00:00:52.180><c> week</c><00:00:52.360><c> and</c>

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

00:00:52.570 --> 00:00:55.650 align:start position:0%
current date time day of the week and
other<00:00:52.930><c> useful</c><00:00:53.230><c> data</c><00:00:54.270><c> some</c><00:00:55.270><c> of</c><00:00:55.300><c> the</c><00:00:55.510><c> most</c>

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

00:00:55.660 --> 00:00:57.150 align:start position:0%
other useful data some of the most
common<00:00:56.110><c> functions</c><00:00:56.290><c> are</c><00:00:56.680><c> pretty</c><00:00:56.890><c> simple</c>

00:00:57.150 --> 00:00:57.160 align:start position:0%
common functions are pretty simple
 

00:00:57.160 --> 00:00:59.729 align:start position:0%
common functions are pretty simple
though<00:00:57.399><c> like</c><00:00:57.850><c> sum</c><00:00:58.180><c> and</c><00:00:58.450><c> average</c><00:00:58.629><c> you</c><00:00:59.590><c> can</c>

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

00:00:59.739 --> 00:01:01.619 align:start position:0%
though like sum and average you can
access<00:01:00.070><c> these</c><00:01:00.430><c> using</c><00:01:00.910><c> the</c><00:01:01.000><c> drop</c><00:01:01.210><c> down</c><00:01:01.239><c> arrow</c>

00:01:01.619 --> 00:01:01.629 align:start position:0%
access these using the drop down arrow
 

00:01:01.629 --> 00:01:07.380 align:start position:0%
access these using the drop down arrow
under<00:01:01.750><c> Auto</c><00:01:02.170><c> sum</c><00:01:03.149><c> in</c><00:01:05.640><c> this</c><00:01:06.640><c> example</c><00:01:07.000><c> I'd</c><00:01:07.330><c> like</c>

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

00:01:07.390 --> 00:01:09.779 align:start position:0%
under Auto sum in this example I'd like
to<00:01:07.690><c> add</c><00:01:07.840><c> these</c><00:01:08.259><c> ten</c><00:01:08.619><c> cells</c><00:01:08.920><c> to</c><00:01:09.160><c> calculate</c><00:01:09.640><c> the</c>

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

00:01:09.789 --> 00:01:12.300 align:start position:0%
to add these ten cells to calculate the
total<00:01:10.119><c> if</c><00:01:10.300><c> I</c><00:01:11.050><c> tried</c><00:01:11.320><c> to</c><00:01:11.350><c> create</c><00:01:11.560><c> a</c><00:01:11.710><c> formula</c><00:01:12.039><c> for</c>

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

00:01:12.310 --> 00:01:13.889 align:start position:0%
total if I tried to create a formula for
that<00:01:12.460><c> I'd</c><00:01:12.789><c> have</c><00:01:13.030><c> to</c><00:01:13.060><c> add</c><00:01:13.300><c> each</c><00:01:13.570><c> cell</c>

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

00:01:13.899 --> 00:01:16.290 align:start position:0%
that I'd have to add each cell
individually<00:01:14.610><c> not</c><00:01:15.610><c> only</c><00:01:15.850><c> would</c><00:01:16.000><c> that</c><00:01:16.149><c> be</c>

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

00:01:16.300 --> 00:01:18.059 align:start position:0%
individually not only would that be
tedious<00:01:16.539><c> it</c><00:01:17.110><c> would</c><00:01:17.289><c> also</c><00:01:17.410><c> make</c><00:01:17.649><c> the</c><00:01:17.800><c> formula</c>

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

00:01:18.069 --> 00:01:20.550 align:start position:0%
tedious it would also make the formula
really<00:01:18.459><c> long</c><00:01:18.700><c> especially</c><00:01:19.300><c> if</c><00:01:19.690><c> I</c><00:01:19.810><c> had</c><00:01:20.020><c> say</c><00:01:20.380><c> a</c>

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

00:01:20.560 --> 00:01:23.010 align:start position:0%
really long especially if I had say a
hundred<00:01:20.800><c> cells</c><00:01:21.160><c> that</c><00:01:21.399><c> I</c><00:01:21.459><c> wanted</c><00:01:21.700><c> to</c><00:01:21.759><c> add</c><00:01:22.020><c> so</c>

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

00:01:23.020 --> 00:01:24.930 align:start position:0%
hundred cells that I wanted to add so
instead<00:01:23.350><c> of</c><00:01:23.410><c> creating</c><00:01:23.830><c> a</c><00:01:23.890><c> formula</c><00:01:24.310><c> I'm</c><00:01:24.459><c> going</c>

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

00:01:24.940 --> 00:01:28.260 align:start position:0%
instead of creating a formula I'm going
to<00:01:25.030><c> use</c><00:01:25.149><c> a</c><00:01:25.179><c> function</c><00:01:26.459><c> first</c><00:01:27.459><c> select</c><00:01:28.090><c> the</c><00:01:28.240><c> cell</c>

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

00:01:28.270 --> 00:01:30.990 align:start position:0%
to use a function first select the cell
where<00:01:28.630><c> you</c><00:01:28.660><c> want</c><00:01:28.750><c> the</c><00:01:28.959><c> answer</c><00:01:29.170><c> to</c><00:01:29.380><c> appear</c><00:01:30.000><c> then</c>

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

00:01:31.000 --> 00:01:33.419 align:start position:0%
where you want the answer to appear then
choose<00:01:31.330><c> a</c><00:01:31.360><c> function</c><00:01:31.630><c> in</c><00:01:32.050><c> our</c><00:01:32.649><c> case</c><00:01:32.890><c> we'll</c><00:01:33.280><c> open</c>

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

00:01:33.429 --> 00:01:38.669 align:start position:0%
choose a function in our case we'll open
the<00:01:33.640><c> autosum</c><00:01:34.119><c> menu</c><00:01:34.450><c> and</c><00:01:34.630><c> then</c><00:01:35.590><c> choose</c><00:01:35.920><c> sum</c><00:01:37.679><c> now</c>

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

00:01:38.679 --> 00:01:40.800 align:start position:0%
the autosum menu and then choose sum now
Excel<00:01:39.099><c> has</c><00:01:39.280><c> inserted</c><00:01:39.729><c> the</c><00:01:39.940><c> function</c><00:01:40.390><c> and</c><00:01:40.539><c> also</c>

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

00:01:40.810 --> 00:01:42.839 align:start position:0%
Excel has inserted the function and also
selected<00:01:41.530><c> the</c><00:01:41.560><c> cells</c><00:01:41.860><c> that</c><00:01:42.160><c> are</c><00:01:42.280><c> being</c><00:01:42.459><c> added</c>

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

00:01:42.849 --> 00:01:45.419 align:start position:0%
selected the cells that are being added
together<00:01:43.110><c> if</c><00:01:44.110><c> it</c><00:01:44.380><c> selects</c><00:01:44.800><c> the</c><00:01:44.920><c> wrong</c><00:01:45.099><c> cells</c>

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

00:01:45.429 --> 00:01:47.490 align:start position:0%
together if it selects the wrong cells
you<00:01:45.880><c> can</c><00:01:46.060><c> always</c><00:01:46.179><c> change</c><00:01:46.539><c> that</c><00:01:46.690><c> by</c><00:01:47.080><c> dragging</c>

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

00:01:47.500 --> 00:01:50.240 align:start position:0%
you can always change that by dragging
the<00:01:47.590><c> corner</c><00:01:47.770><c> handles</c><00:01:48.099><c> here</c>

00:01:50.240 --> 00:01:50.250 align:start position:0%
the corner handles here
 

00:01:50.250 --> 00:01:52.650 align:start position:0%
the corner handles here
when<00:01:51.250><c> you're</c><00:01:51.400><c> done</c><00:01:51.550><c> press</c><00:01:52.000><c> ENTER</c><00:01:52.480><c> on</c><00:01:52.510><c> your</c>

00:01:52.650 --> 00:01:52.660 align:start position:0%
when you're done press ENTER on your
 

00:01:52.660 --> 00:01:55.970 align:start position:0%
when you're done press ENTER on your
keyboard<00:01:52.810><c> and</c><00:01:53.430><c> the</c><00:01:54.430><c> answer</c><00:01:54.730><c> will</c><00:01:54.850><c> appear</c>

00:01:55.970 --> 00:01:55.980 align:start position:0%
keyboard and the answer will appear
 

00:01:55.980 --> 00:01:58.320 align:start position:0%
keyboard and the answer will appear
let's<00:01:56.980><c> look</c><00:01:57.160><c> at</c><00:01:57.280><c> this</c><00:01:57.400><c> function</c><00:01:57.760><c> in</c><00:01:58.030><c> a</c><00:01:58.090><c> little</c>

00:01:58.320 --> 00:01:58.330 align:start position:0%
let's look at this function in a little
 

00:01:58.330 --> 00:02:03.270 align:start position:0%
let's look at this function in a little
more<00:01:58.450><c> detail</c><00:02:01.080><c> just</c><00:02:02.080><c> like</c><00:02:02.200><c> formulas</c><00:02:02.830><c> functions</c>

00:02:03.270 --> 00:02:03.280 align:start position:0%
more detail just like formulas functions
 

00:02:03.280 --> 00:02:06.090 align:start position:0%
more detail just like formulas functions
always<00:02:03.760><c> start</c><00:02:04.240><c> with</c><00:02:04.360><c> an</c><00:02:04.510><c> equal</c><00:02:04.570><c> sign</c><00:02:04.990><c> but</c><00:02:05.980><c> you</c>

00:02:06.090 --> 00:02:06.100 align:start position:0%
always start with an equal sign but you
 

00:02:06.100 --> 00:02:07.320 align:start position:0%
always start with an equal sign but you
may<00:02:06.250><c> have</c><00:02:06.400><c> noticed</c><00:02:06.730><c> that</c><00:02:06.820><c> there</c><00:02:07.090><c> are</c><00:02:07.180><c> no</c>

00:02:07.320 --> 00:02:07.330 align:start position:0%
may have noticed that there are no
 

00:02:07.330 --> 00:02:09.630 align:start position:0%
may have noticed that there are no
mathematical<00:02:08.020><c> operators</c><00:02:08.590><c> such</c><00:02:08.830><c> as</c><00:02:09.190><c> addition</c>

00:02:09.630 --> 00:02:09.640 align:start position:0%
mathematical operators such as addition
 

00:02:09.640 --> 00:02:11.370 align:start position:0%
mathematical operators such as addition
or<00:02:09.790><c> subtraction</c><00:02:10.000><c> like</c><00:02:10.780><c> you</c><00:02:10.930><c> would</c><00:02:11.050><c> normally</c>

00:02:11.370 --> 00:02:11.380 align:start position:0%
or subtraction like you would normally
 

00:02:11.380 --> 00:02:14.520 align:start position:0%
or subtraction like you would normally
see<00:02:11.590><c> in</c><00:02:11.620><c> a</c><00:02:11.740><c> formula</c><00:02:12.390><c> instead</c><00:02:13.390><c> functions</c><00:02:14.320><c> use</c><00:02:14.500><c> a</c>

00:02:14.520 --> 00:02:14.530 align:start position:0%
see in a formula instead functions use a
 

00:02:14.530 --> 00:02:16.860 align:start position:0%
see in a formula instead functions use a
specific<00:02:14.890><c> syntax</c><00:02:15.700><c> that</c><00:02:16.000><c> includes</c><00:02:16.480><c> the</c><00:02:16.690><c> name</c>

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

00:02:16.870 --> 00:02:19.560 align:start position:0%
specific syntax that includes the name
of<00:02:17.020><c> the</c><00:02:17.140><c> function</c><00:02:17.880><c> followed</c><00:02:18.880><c> by</c><00:02:19.030><c> one</c><00:02:19.300><c> or</c><00:02:19.330><c> more</c>

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

00:02:19.570 --> 00:02:23.160 align:start position:0%
of the function followed by one or more
arguments<00:02:19.930><c> in</c><00:02:20.350><c> parentheses</c><00:02:21.540><c> the</c><00:02:22.540><c> arguments</c>

00:02:23.160 --> 00:02:23.170 align:start position:0%
arguments in parentheses the arguments
 

00:02:23.170 --> 00:02:24.600 align:start position:0%
arguments in parentheses the arguments
tell<00:02:23.410><c> the</c><00:02:23.500><c> function</c><00:02:23.710><c> which</c><00:02:24.070><c> cells</c><00:02:24.400><c> are</c>

00:02:24.600 --> 00:02:24.610 align:start position:0%
tell the function which cells are
 

00:02:24.610 --> 00:02:26.220 align:start position:0%
tell the function which cells are
numbers<00:02:24.940><c> to</c><00:02:25.120><c> use</c><00:02:25.300><c> when</c><00:02:25.570><c> calculating</c><00:02:26.200><c> the</c>

00:02:26.220 --> 00:02:26.230 align:start position:0%
numbers to use when calculating the
 

00:02:26.230 --> 00:02:29.370 align:start position:0%
numbers to use when calculating the
result<00:02:26.680><c> in</c><00:02:26.890><c> this</c><00:02:27.850><c> example</c><00:02:28.240><c> we</c><00:02:28.690><c> only</c><00:02:28.720><c> have</c><00:02:29.140><c> one</c>

00:02:29.370 --> 00:02:29.380 align:start position:0%
result in this example we only have one
 

00:02:29.380 --> 00:02:30.990 align:start position:0%
result in this example we only have one
argument<00:02:29.830><c> even</c><00:02:30.250><c> though</c><00:02:30.430><c> there</c><00:02:30.760><c> are</c><00:02:30.790><c> two</c>

00:02:30.990 --> 00:02:31.000 align:start position:0%
argument even though there are two
 

00:02:31.000 --> 00:02:33.330 align:start position:0%
argument even though there are two
different<00:02:31.330><c> cell</c><00:02:31.480><c> references</c><00:02:32.020><c> this</c><00:02:32.860><c> is</c><00:02:32.920><c> called</c>

00:02:33.330 --> 00:02:33.340 align:start position:0%
different cell references this is called
 

00:02:33.340 --> 00:02:37.140 align:start position:0%
different cell references this is called
a<00:02:33.550><c> range</c><00:02:33.790><c> of</c><00:02:33.940><c> cells</c><00:02:34.150><c> or</c><00:02:34.480><c> a</c><00:02:34.540><c> cell</c><00:02:35.140><c> range</c><00:02:35.350><c> a</c><00:02:36.150><c> cell</c>

00:02:37.140 --> 00:02:37.150 align:start position:0%
a range of cells or a cell range a cell
 

00:02:37.150 --> 00:02:38.610 align:start position:0%
a range of cells or a cell range a cell
range<00:02:37.420><c> is</c><00:02:37.600><c> represented</c><00:02:38.170><c> by</c><00:02:38.200><c> two</c><00:02:38.350><c> different</c>

00:02:38.610 --> 00:02:38.620 align:start position:0%
range is represented by two different
 

00:02:38.620 --> 00:02:40.620 align:start position:0%
range is represented by two different
cell<00:02:39.130><c> references</c><00:02:39.640><c> with</c><00:02:39.910><c> a</c><00:02:39.940><c> colon</c><00:02:40.270><c> in</c><00:02:40.600><c> between</c>

00:02:40.620 --> 00:02:40.630 align:start position:0%
cell references with a colon in between
 

00:02:40.630 --> 00:02:43.830 align:start position:0%
cell references with a colon in between
in<00:02:41.260><c> this</c><00:02:42.130><c> case</c><00:02:42.190><c> the</c><00:02:42.820><c> range</c><00:02:43.000><c> consists</c><00:02:43.570><c> of</c><00:02:43.630><c> all</c>

00:02:43.830 --> 00:02:43.840 align:start position:0%
in this case the range consists of all
 

00:02:43.840 --> 00:02:47.610 align:start position:0%
in this case the range consists of all
the<00:02:43.990><c> cells</c><00:02:44.230><c> between</c><00:02:44.500><c> d3</c><00:02:45.280><c> and</c><00:02:45.460><c> d12</c><00:02:46.240><c> if</c><00:02:46.540><c> you</c><00:02:47.410><c> want</c>

00:02:47.610 --> 00:02:47.620 align:start position:0%
the cells between d3 and d12 if you want
 

00:02:47.620 --> 00:02:49.170 align:start position:0%
the cells between d3 and d12 if you want
to<00:02:47.680><c> use</c><00:02:47.830><c> more</c><00:02:48.040><c> than</c><00:02:48.100><c> one</c><00:02:48.280><c> argument</c><00:02:48.670><c> you'll</c>

00:02:49.170 --> 00:02:49.180 align:start position:0%
to use more than one argument you'll
 

00:02:49.180 --> 00:02:54.320 align:start position:0%
to use more than one argument you'll
need<00:02:49.390><c> to</c><00:02:49.510><c> separate</c><00:02:49.900><c> each</c><00:02:50.140><c> one</c><00:02:50.410><c> with</c><00:02:50.650><c> a</c><00:02:50.680><c> comma</c>

00:02:54.320 --> 00:02:54.330 align:start position:0%
 
 

00:02:54.330 --> 00:02:56.910 align:start position:0%
 
let's<00:02:55.330><c> try</c><00:02:55.600><c> a</c><00:02:55.630><c> different</c><00:02:55.720><c> function</c><00:02:56.260><c> now</c><00:02:56.650><c> in</c>

00:02:56.910 --> 00:02:56.920 align:start position:0%
let's try a different function now in
 

00:02:56.920 --> 00:02:59.280 align:start position:0%
let's try a different function now in
this<00:02:57.640><c> example</c><00:02:58.000><c> we</c><00:02:58.450><c> have</c><00:02:58.480><c> a</c><00:02:58.660><c> column</c><00:02:59.050><c> for</c><00:02:59.200><c> the</c>

00:02:59.280 --> 00:02:59.290 align:start position:0%
this example we have a column for the
 

00:02:59.290 --> 00:03:01.110 align:start position:0%
this example we have a column for the
date<00:02:59.320><c> that</c><00:02:59.620><c> each</c><00:02:59.770><c> item</c><00:03:00.040><c> was</c><00:03:00.280><c> ordered</c><00:03:00.610><c> and</c><00:03:00.760><c> the</c>

00:03:01.110 --> 00:03:01.120 align:start position:0%
date that each item was ordered and the
 

00:03:01.120 --> 00:03:03.240 align:start position:0%
date that each item was ordered and the
date<00:03:01.270><c> that</c><00:03:01.300><c> it</c><00:03:01.540><c> was</c><00:03:01.570><c> received</c><00:03:01.950><c> what</c><00:03:02.950><c> I'd</c><00:03:03.100><c> like</c>

00:03:03.240 --> 00:03:03.250 align:start position:0%
date that it was received what I'd like
 

00:03:03.250 --> 00:03:04.800 align:start position:0%
date that it was received what I'd like
to<00:03:03.310><c> know</c><00:03:03.459><c> is</c><00:03:03.760><c> how</c><00:03:03.910><c> many</c><00:03:03.970><c> business</c><00:03:04.480><c> days</c><00:03:04.660><c> it</c>

00:03:04.800 --> 00:03:04.810 align:start position:0%
to know is how many business days it
 

00:03:04.810 --> 00:03:07.979 align:start position:0%
to know is how many business days it
took<00:03:04.989><c> for</c><00:03:05.320><c> each</c><00:03:05.470><c> item</c><00:03:05.709><c> to</c><00:03:05.860><c> be</c><00:03:06.070><c> delivered</c><00:03:06.989><c> first</c>

00:03:07.979 --> 00:03:07.989 align:start position:0%
took for each item to be delivered first
 

00:03:07.989 --> 00:03:09.600 align:start position:0%
took for each item to be delivered first
select<00:03:08.680><c> the</c><00:03:08.800><c> cell</c><00:03:08.830><c> where</c><00:03:09.220><c> you</c><00:03:09.250><c> want</c><00:03:09.489><c> the</c>

00:03:09.600 --> 00:03:09.610 align:start position:0%
select the cell where you want the
 

00:03:09.610 --> 00:03:12.479 align:start position:0%
select the cell where you want the
function<00:03:09.880><c> to</c><00:03:10.090><c> go</c><00:03:10.590><c> then</c><00:03:11.590><c> choose</c><00:03:11.860><c> a</c><00:03:11.890><c> function</c><00:03:12.160><c> if</c>

00:03:12.479 --> 00:03:12.489 align:start position:0%
function to go then choose a function if
 

00:03:12.489 --> 00:03:15.270 align:start position:0%
function to go then choose a function if
you<00:03:12.580><c> know</c><00:03:12.730><c> what</c><00:03:12.880><c> category</c><00:03:13.360><c> it's</c><00:03:13.510><c> in</c><00:03:13.720><c> if</c><00:03:14.280><c> you</c>

00:03:15.270 --> 00:03:15.280 align:start position:0%
you know what category it's in if you
 

00:03:15.280 --> 00:03:17.040 align:start position:0%
you know what category it's in if you
don't<00:03:15.520><c> you</c><00:03:15.970><c> can</c><00:03:16.150><c> try</c><00:03:16.300><c> searching</c><00:03:16.570><c> for</c><00:03:16.959><c> it</c>

00:03:17.040 --> 00:03:17.050 align:start position:0%
don't you can try searching for it
 

00:03:17.050 --> 00:03:19.650 align:start position:0%
don't you can try searching for it
instead<00:03:17.610><c> just</c><00:03:18.610><c> click</c><00:03:18.880><c> the</c><00:03:19.030><c> insert</c><00:03:19.450><c> function</c>

00:03:19.650 --> 00:03:19.660 align:start position:0%
instead just click the insert function
 

00:03:19.660 --> 00:03:23.240 align:start position:0%
instead just click the insert function
command<00:03:19.930><c> on</c><00:03:20.470><c> the</c><00:03:20.620><c> far</c><00:03:20.830><c> left</c><00:03:21.100><c> of</c><00:03:21.250><c> the</c><00:03:21.310><c> ribbon</c>

00:03:23.240 --> 00:03:23.250 align:start position:0%
command on the far left of the ribbon
 

00:03:23.250 --> 00:03:25.620 align:start position:0%
command on the far left of the ribbon
searching<00:03:24.250><c> for</c><00:03:24.400><c> functions</c><00:03:24.790><c> can</c><00:03:25.060><c> be</c><00:03:25.090><c> tricky</c>

00:03:25.620 --> 00:03:25.630 align:start position:0%
searching for functions can be tricky
 

00:03:25.630 --> 00:03:27.780 align:start position:0%
searching for functions can be tricky
but<00:03:26.050><c> for</c><00:03:26.230><c> more</c><00:03:26.380><c> experienced</c><00:03:26.890><c> users</c><00:03:27.250><c> this</c><00:03:27.580><c> can</c>

00:03:27.780 --> 00:03:27.790 align:start position:0%
but for more experienced users this can
 

00:03:27.790 --> 00:03:30.720 align:start position:0%
but for more experienced users this can
be<00:03:27.910><c> an</c><00:03:28.000><c> extremely</c><00:03:28.120><c> useful</c><00:03:28.600><c> tool</c><00:03:29.340><c> just</c><00:03:30.340><c> type</c><00:03:30.610><c> a</c>

00:03:30.720 --> 00:03:30.730 align:start position:0%
be an extremely useful tool just type a
 

00:03:30.730 --> 00:03:31.920 align:start position:0%
be an extremely useful tool just type a
description<00:03:31.120><c> of</c><00:03:31.330><c> the</c><00:03:31.450><c> function</c><00:03:31.810><c> you're</c>

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

00:03:31.930 --> 00:03:34.229 align:start position:0%
description of the function you're
looking<00:03:32.230><c> for</c><00:03:32.470><c> I'm</c><00:03:32.760><c> looking</c><00:03:33.760><c> for</c><00:03:33.940><c> something</c>

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

00:03:34.239 --> 00:03:35.550 align:start position:0%
looking for I'm looking for something
that'll<00:03:34.420><c> count</c><00:03:34.660><c> the</c><00:03:34.780><c> number</c><00:03:35.050><c> of</c><00:03:35.080><c> days</c><00:03:35.290><c> that</c>

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

00:03:35.560 --> 00:03:37.590 align:start position:0%
that'll count the number of days that
have<00:03:35.680><c> you</c><00:03:35.739><c> elapsed</c><00:03:36.160><c> so</c><00:03:36.489><c> I'll</c><00:03:36.640><c> type</c><00:03:36.850><c> count</c><00:03:37.239><c> days</c>

00:03:37.590 --> 00:03:37.600 align:start position:0%
have you elapsed so I'll type count days
 

00:03:37.600 --> 00:03:40.300 align:start position:0%
have you elapsed so I'll type count days
and<00:03:37.930><c> then</c><00:03:38.290><c> press</c><00:03:38.590><c> Enter</c>

00:03:40.300 --> 00:03:40.310 align:start position:0%
and then press Enter
 

00:03:40.310 --> 00:03:42.760 align:start position:0%
and then press Enter
we've<00:03:41.209><c> gotten</c><00:03:41.540><c> a</c><00:03:41.630><c> lot</c><00:03:41.840><c> of</c><00:03:41.900><c> different</c><00:03:42.410><c> results</c>

00:03:42.760 --> 00:03:42.770 align:start position:0%
we've gotten a lot of different results
 

00:03:42.770 --> 00:03:45.730 align:start position:0%
we've gotten a lot of different results
here<00:03:43.330><c> to</c><00:03:44.330><c> learn</c><00:03:44.450><c> more</c><00:03:44.510><c> about</c><00:03:44.750><c> a</c><00:03:44.930><c> function</c><00:03:45.380><c> just</c>

00:03:45.730 --> 00:03:45.740 align:start position:0%
here to learn more about a function just
 

00:03:45.740 --> 00:03:48.280 align:start position:0%
here to learn more about a function just
click<00:03:45.980><c> the</c><00:03:46.130><c> name</c><00:03:46.280><c> and</c><00:03:46.600><c> a</c><00:03:47.600><c> description</c><00:03:47.870><c> will</c>

00:03:48.280 --> 00:03:48.290 align:start position:0%
click the name and a description will
 

00:03:48.290 --> 00:03:51.520 align:start position:0%
click the name and a description will
appear<00:03:48.590><c> below</c><00:03:49.300><c> the</c><00:03:50.300><c> function</c><00:03:50.750><c> called</c><00:03:51.020><c> Network</c>

00:03:51.520 --> 00:03:51.530 align:start position:0%
appear below the function called Network
 

00:03:51.530 --> 00:03:53.350 align:start position:0%
appear below the function called Network
days<00:03:51.800><c> returns</c><00:03:52.400><c> the</c><00:03:52.580><c> number</c><00:03:52.850><c> of</c><00:03:52.970><c> workdays</c>

00:03:53.350 --> 00:03:53.360 align:start position:0%
days returns the number of workdays
 

00:03:53.360 --> 00:03:55.120 align:start position:0%
days returns the number of workdays
between<00:03:53.810><c> two</c><00:03:53.959><c> dates</c><00:03:54.200><c> and</c><00:03:54.500><c> that's</c><00:03:54.770><c> exactly</c>

00:03:55.120 --> 00:03:55.130 align:start position:0%
between two dates and that's exactly
 

00:03:55.130 --> 00:03:57.580 align:start position:0%
between two dates and that's exactly
what<00:03:55.459><c> we</c><00:03:55.580><c> want</c><00:03:55.819><c> so</c><00:03:56.690><c> I'm</c><00:03:56.959><c> just</c><00:03:57.170><c> going</c><00:03:57.319><c> to</c><00:03:57.410><c> click</c>

00:03:57.580 --> 00:03:57.590 align:start position:0%
what we want so I'm just going to click
 

00:03:57.590 --> 00:04:01.559 align:start position:0%
what we want so I'm just going to click
OK<00:03:58.040><c> and</c><00:03:58.690><c> another</c><00:03:59.690><c> dialog</c><00:04:00.110><c> box</c><00:04:00.350><c> will</c><00:04:00.590><c> appear</c>

00:04:01.559 --> 00:04:01.569 align:start position:0%
OK and another dialog box will appear
 

00:04:01.569 --> 00:04:03.970 align:start position:0%
OK and another dialog box will appear
there<00:04:02.569><c> will</c><00:04:02.750><c> be</c><00:04:02.780><c> separate</c><00:04:03.260><c> fields</c><00:04:03.620><c> for</c><00:04:03.800><c> each</c>

00:04:03.970 --> 00:04:03.980 align:start position:0%
there will be separate fields for each
 

00:04:03.980 --> 00:04:06.040 align:start position:0%
there will be separate fields for each
argument<00:04:04.250><c> in</c><00:04:04.670><c> the</c><00:04:04.760><c> function</c><00:04:05.150><c> this</c><00:04:06.020><c> function</c>

00:04:06.040 --> 00:04:06.050 align:start position:0%
argument in the function this function
 

00:04:06.050 --> 00:04:08.800 align:start position:0%
argument in the function this function
has<00:04:06.709><c> up</c><00:04:06.860><c> to</c><00:04:06.890><c> 3</c><00:04:07.220><c> arguments</c><00:04:07.459><c> start</c><00:04:08.330><c> date</c><00:04:08.630><c> end</c>

00:04:08.800 --> 00:04:08.810 align:start position:0%
has up to 3 arguments start date end
 

00:04:08.810 --> 00:04:12.460 align:start position:0%
has up to 3 arguments start date end
date<00:04:08.900><c> and</c><00:04:09.709><c> holidays</c><00:04:10.780><c> when</c><00:04:11.780><c> you</c><00:04:11.900><c> click</c><00:04:12.110><c> a</c><00:04:12.140><c> field</c>

00:04:12.460 --> 00:04:12.470 align:start position:0%
date and holidays when you click a field
 

00:04:12.470 --> 00:04:14.640 align:start position:0%
date and holidays when you click a field
you'll<00:04:12.769><c> see</c><00:04:12.980><c> a</c><00:04:13.010><c> description</c><00:04:13.430><c> of</c><00:04:13.700><c> it</c><00:04:13.790><c> below</c><00:04:14.090><c> and</c>

00:04:14.640 --> 00:04:14.650 align:start position:0%
you'll see a description of it below and
 

00:04:14.650 --> 00:04:17.259 align:start position:0%
you'll see a description of it below and
if<00:04:15.650><c> you</c><00:04:15.739><c> need</c><00:04:15.920><c> more</c><00:04:16.070><c> help</c><00:04:16.280><c> you</c><00:04:16.760><c> can</c><00:04:16.790><c> click</c><00:04:17.060><c> the</c>

00:04:17.259 --> 00:04:17.269 align:start position:0%
if you need more help you can click the
 

00:04:17.269 --> 00:04:22.150 align:start position:0%
if you need more help you can click the
link<00:04:17.480><c> that</c><00:04:17.510><c> says</c><00:04:17.630><c> help</c><00:04:18.200><c> on</c><00:04:18.350><c> this</c><00:04:18.500><c> function</c><00:04:21.160><c> for</c>

00:04:22.150 --> 00:04:22.160 align:start position:0%
link that says help on this function for
 

00:04:22.160 --> 00:04:24.100 align:start position:0%
link that says help on this function for
the<00:04:22.250><c> start</c><00:04:22.520><c> date</c><00:04:22.730><c> I'm</c><00:04:22.970><c> going</c><00:04:23.360><c> to</c><00:04:23.419><c> select</c><00:04:23.600><c> cell</c>

00:04:24.100 --> 00:04:24.110 align:start position:0%
the start date I'm going to select cell
 

00:04:24.110 --> 00:04:29.430 align:start position:0%
the start date I'm going to select cell
e3<00:04:24.410><c> and</c><00:04:25.750><c> for</c><00:04:26.750><c> the</c><00:04:26.840><c> end</c><00:04:26.990><c> date</c><00:04:27.140><c> I'll</c><00:04:27.290><c> select</c><00:04:27.919><c> f3</c>

00:04:29.430 --> 00:04:29.440 align:start position:0%
e3 and for the end date I'll select f3
 

00:04:29.440 --> 00:04:31.690 align:start position:0%
e3 and for the end date I'll select f3
we<00:04:30.440><c> know</c><00:04:30.590><c> the</c><00:04:30.710><c> holidays</c><00:04:31.100><c> argument</c><00:04:31.580><c> is</c>

00:04:31.690 --> 00:04:31.700 align:start position:0%
we know the holidays argument is
 

00:04:31.700 --> 00:04:34.060 align:start position:0%
we know the holidays argument is
optional<00:04:31.940><c> because</c><00:04:32.630><c> it's</c><00:04:32.780><c> not</c><00:04:32.960><c> in</c><00:04:33.110><c> bold</c><00:04:33.290><c> so</c><00:04:33.860><c> I'm</c>

00:04:34.060 --> 00:04:34.070 align:start position:0%
optional because it's not in bold so I'm
 

00:04:34.070 --> 00:04:36.880 align:start position:0%
optional because it's not in bold so I'm
going<00:04:34.250><c> to</c><00:04:34.310><c> leave</c><00:04:34.460><c> that</c><00:04:34.640><c> one</c><00:04:34.820><c> blank</c><00:04:35.620><c> before</c><00:04:36.620><c> you</c>

00:04:36.880 --> 00:04:36.890 align:start position:0%
going to leave that one blank before you
 

00:04:36.890 --> 00:04:38.740 align:start position:0%
going to leave that one blank before you
continue<00:04:37.400><c> you</c><00:04:37.700><c> can</c><00:04:37.729><c> check</c><00:04:38.060><c> the</c><00:04:38.210><c> result</c><00:04:38.510><c> of</c><00:04:38.630><c> the</c>

00:04:38.740 --> 00:04:38.750 align:start position:0%
continue you can check the result of the
 

00:04:38.750 --> 00:04:42.760 align:start position:0%
continue you can check the result of the
function<00:04:39.139><c> here</c><00:04:40.690><c> when</c><00:04:41.690><c> you're</c><00:04:41.840><c> ready</c><00:04:42.020><c> click</c><00:04:42.350><c> OK</c>

00:04:42.760 --> 00:04:42.770 align:start position:0%
function here when you're ready click OK
 

00:04:42.770 --> 00:04:45.310 align:start position:0%
function here when you're ready click OK
and<00:04:43.180><c> the</c><00:04:44.180><c> function</c><00:04:44.570><c> will</c><00:04:44.720><c> be</c><00:04:44.750><c> added</c><00:04:45.110><c> to</c><00:04:45.229><c> the</c>

00:04:45.310 --> 00:04:45.320 align:start position:0%
and the function will be added to the
 

00:04:45.320 --> 00:04:48.490 align:start position:0%
and the function will be added to the
worksheet<00:04:46.330><c> just</c><00:04:47.330><c> like</c><00:04:47.570><c> with</c><00:04:47.750><c> formulas</c><00:04:48.229><c> you</c>

00:04:48.490 --> 00:04:48.500 align:start position:0%
worksheet just like with formulas you
 

00:04:48.500 --> 00:04:50.140 align:start position:0%
worksheet just like with formulas you
can<00:04:48.680><c> copy</c><00:04:48.919><c> the</c><00:04:49.130><c> function</c><00:04:49.520><c> using</c><00:04:49.880><c> the</c><00:04:49.970><c> fill</c>

00:04:50.140 --> 00:04:50.150 align:start position:0%
can copy the function using the fill
 

00:04:50.150 --> 00:04:54.190 align:start position:0%
can copy the function using the fill
handle<00:04:50.360><c> here</c><00:04:50.870><c> and</c><00:04:52.570><c> now</c><00:04:53.570><c> we</c><00:04:53.630><c> can</c><00:04:53.750><c> see</c><00:04:54.050><c> the</c>

00:04:54.190 --> 00:04:54.200 align:start position:0%
handle here and now we can see the
 

00:04:54.200 --> 00:04:55.900 align:start position:0%
handle here and now we can see the
number<00:04:54.470><c> of</c><00:04:54.560><c> business</c><00:04:54.950><c> days</c><00:04:55.130><c> it</c><00:04:55.310><c> took</c><00:04:55.430><c> for</c><00:04:55.760><c> each</c>

00:04:55.900 --> 00:04:55.910 align:start position:0%
number of business days it took for each
 

00:04:55.910 --> 00:04:59.080 align:start position:0%
number of business days it took for each
item<00:04:56.180><c> to</c><00:04:56.419><c> be</c><00:04:56.539><c> delivered</c><00:04:57.280><c> if</c><00:04:58.280><c> you've</c><00:04:58.940><c> never</c>

00:04:59.080 --> 00:04:59.090 align:start position:0%
item to be delivered if you've never
 

00:04:59.090 --> 00:05:01.210 align:start position:0%
item to be delivered if you've never
used<00:04:59.240><c> functions</c><00:04:59.630><c> before</c><00:05:00.020><c> the</c><00:05:00.620><c> syntax</c><00:05:01.039><c> may</c>

00:05:01.210 --> 00:05:01.220 align:start position:0%
used functions before the syntax may
 

00:05:01.220 --> 00:05:03.430 align:start position:0%
used functions before the syntax may
seem<00:05:01.430><c> a</c><00:05:01.460><c> little</c><00:05:01.550><c> strange</c><00:05:01.820><c> at</c><00:05:02.180><c> first</c><00:05:02.210><c> but</c><00:05:02.750><c> with</c>

00:05:03.430 --> 00:05:03.440 align:start position:0%
seem a little strange at first but with
 

00:05:03.440 --> 00:05:04.900 align:start position:0%
seem a little strange at first but with
some<00:05:03.650><c> practice</c><00:05:04.070><c> you're</c><00:05:04.400><c> bound</c><00:05:04.610><c> to</c><00:05:04.700><c> get</c><00:05:04.850><c> the</c>

00:05:04.900 --> 00:05:04.910 align:start position:0%
some practice you're bound to get the
 

00:05:04.910 --> 00:05:06.850 align:start position:0%
some practice you're bound to get the
hang<00:05:05.180><c> of</c><00:05:05.270><c> it</c><00:05:05.390><c> and</c><00:05:05.570><c> soon</c><00:05:06.200><c> you'll</c><00:05:06.410><c> be</c><00:05:06.440><c> using</c><00:05:06.710><c> your</c>

00:05:06.850 --> 00:05:06.860 align:start position:0%
hang of it and soon you'll be using your
 

00:05:06.860 --> 00:05:10.660 align:start position:0%
hang of it and soon you'll be using your
favorite<00:05:07.340><c> functions</c><00:05:07.789><c> over</c><00:05:08.240><c> and</c><00:05:08.390><c> over</c>