WEBVTT
Kind: captions
Language: en

00:00:10.629 --> 00:00:13.089 align:start position:0%
 
Excel<00:00:11.629><c> has</c><00:00:11.870><c> a</c><00:00:11.900><c> really</c><00:00:12.379><c> powerful</c><00:00:12.590><c> and</c>

00:00:13.089 --> 00:00:13.099 align:start position:0%
Excel has a really powerful and
 

00:00:13.099 --> 00:00:15.540 align:start position:0%
Excel has a really powerful and
convenient<00:00:13.610><c> feature</c><00:00:13.820><c> called</c><00:00:14.269><c> functions</c><00:00:15.080><c> a</c>

00:00:15.540 --> 00:00:15.550 align:start position:0%
convenient feature called functions a
 

00:00:15.550 --> 00:00:18.550 align:start position:0%
convenient feature called functions a
function<00:00:16.550><c> is</c><00:00:16.759><c> a</c><00:00:16.790><c> predefined</c><00:00:17.720><c> formula</c><00:00:18.169><c> and</c>

00:00:18.550 --> 00:00:18.560 align:start position:0%
function is a predefined formula and
 

00:00:18.560 --> 00:00:20.589 align:start position:0%
function is a predefined formula and
it's<00:00:19.040><c> used</c><00:00:19.310><c> when</c><00:00:19.490><c> a</c><00:00:19.550><c> formula</c><00:00:20.090><c> would</c><00:00:20.180><c> be</c><00:00:20.240><c> too</c>

00:00:20.589 --> 00:00:20.599 align:start position:0%
it's used when a formula would be too
 

00:00:20.599 --> 00:00:23.859 align:start position:0%
it's used when a formula would be too
complicated<00:00:21.050><c> or</c><00:00:21.590><c> just</c><00:00:21.650><c> too</c><00:00:22.310><c> long</c><00:00:22.750><c> you</c><00:00:23.750><c> can</c>

00:00:23.859 --> 00:00:23.869 align:start position:0%
complicated or just too long you can
 

00:00:23.869 --> 00:00:26.950 align:start position:0%
complicated or just too long you can
access<00:00:24.230><c> them</c><00:00:24.439><c> from</c><00:00:24.500><c> the</c><00:00:24.980><c> formulas</c><00:00:25.489><c> tab</c><00:00:25.960><c> there</c>

00:00:26.950 --> 00:00:26.960 align:start position:0%
access them from the formulas tab there
 

00:00:26.960 --> 00:00:28.630 align:start position:0%
access them from the formulas tab there
are<00:00:26.989><c> hundreds</c><00:00:27.770><c> of</c><00:00:27.860><c> functions</c><00:00:28.250><c> that</c><00:00:28.340><c> you</c><00:00:28.489><c> can</c>

00:00:28.630 --> 00:00:28.640 align:start position:0%
are hundreds of functions that you can
 

00:00:28.640 --> 00:00:30.670 align:start position:0%
are hundreds of functions that you can
choose<00:00:28.880><c> from</c><00:00:29.119><c> and</c><00:00:29.450><c> they're</c><00:00:29.960><c> organized</c><00:00:30.410><c> by</c>

00:00:30.670 --> 00:00:30.680 align:start position:0%
choose from and they're organized by
 

00:00:30.680 --> 00:00:34.000 align:start position:0%
choose from and they're organized by
category<00:00:31.279><c> in</c><00:00:31.520><c> the</c><00:00:31.700><c> function</c><00:00:32.059><c> library</c><00:00:33.010><c> for</c>

00:00:34.000 --> 00:00:34.010 align:start position:0%
category in the function library for
 

00:00:34.010 --> 00:00:36.220 align:start position:0%
category in the function library for
example<00:00:34.370><c> the</c><00:00:34.670><c> financial</c><00:00:34.940><c> category</c><00:00:35.750><c> contains</c>

00:00:36.220 --> 00:00:36.230 align:start position:0%
example the financial category contains
 

00:00:36.230 --> 00:00:37.840 align:start position:0%
example the financial category contains
functions<00:00:36.739><c> that</c><00:00:36.890><c> deal</c><00:00:37.100><c> with</c><00:00:37.280><c> things</c><00:00:37.550><c> like</c>

00:00:37.840 --> 00:00:37.850 align:start position:0%
functions that deal with things like
 

00:00:37.850 --> 00:00:42.310 align:start position:0%
functions that deal with things like
interest<00:00:38.510><c> and</c><00:00:38.840><c> monthly</c><00:00:39.590><c> payments</c>

00:00:42.310 --> 00:00:42.320 align:start position:0%
 
 

00:00:42.320 --> 00:00:44.200 align:start position:0%
 
the<00:00:42.440><c> text</c><00:00:42.829><c> category</c><00:00:43.309><c> allows</c><00:00:43.550><c> you</c><00:00:43.760><c> to</c><00:00:43.850><c> convert</c>

00:00:44.200 --> 00:00:44.210 align:start position:0%
the text category allows you to convert
 

00:00:44.210 --> 00:00:46.930 align:start position:0%
the text category allows you to convert
text<00:00:44.539><c> to</c><00:00:44.719><c> lowercase</c><00:00:45.140><c> or</c><00:00:45.500><c> uppercase</c><00:00:45.940><c> replace</c>

00:00:46.930 --> 00:00:46.940 align:start position:0%
text to lowercase or uppercase replace
 

00:00:46.940 --> 00:00:48.549 align:start position:0%
text to lowercase or uppercase replace
text<00:00:47.420><c> and</c><00:00:47.539><c> do</c><00:00:47.629><c> other</c><00:00:47.750><c> types</c><00:00:47.989><c> of</c><00:00:48.230><c> text</c>

00:00:48.549 --> 00:00:48.559 align:start position:0%
text and do other types of text
 

00:00:48.559 --> 00:00:52.119 align:start position:0%
text and do other types of text
manipulation<00:00:49.809><c> date</c><00:00:50.809><c> and</c><00:00:51.079><c> time</c><00:00:51.440><c> includes</c>

00:00:52.119 --> 00:00:52.129 align:start position:0%
manipulation date and time includes
 

00:00:52.129 --> 00:00:53.860 align:start position:0%
manipulation date and time includes
functions<00:00:52.579><c> that</c><00:00:52.729><c> return</c><00:00:52.940><c> the</c><00:00:53.300><c> current</c><00:00:53.629><c> date</c>

00:00:53.860 --> 00:00:53.870 align:start position:0%
functions that return the current date
 

00:00:53.870 --> 00:00:56.770 align:start position:0%
functions that return the current date
time<00:00:54.339><c> day</c><00:00:55.339><c> of</c><00:00:55.550><c> the</c><00:00:55.670><c> week</c><00:00:55.879><c> and</c><00:00:56.210><c> others</c><00:00:56.510><c> and</c>

00:00:56.770 --> 00:00:56.780 align:start position:0%
time day of the week and others and
 

00:00:56.780 --> 00:00:59.970 align:start position:0%
time day of the week and others and
there<00:00:57.620><c> are</c><00:00:57.739><c> many</c><00:00:57.979><c> more</c><00:00:58.219><c> functions</c>

00:00:59.970 --> 00:00:59.980 align:start position:0%
there are many more functions
 

00:00:59.980 --> 00:01:01.980 align:start position:0%
there are many more functions
much<00:01:00.610><c> of</c><00:01:00.790><c> the</c><00:01:00.880><c> time</c><00:01:01.090><c> though</c><00:01:01.360><c> you'll</c><00:01:01.690><c> just</c><00:01:01.840><c> need</c>

00:01:01.980 --> 00:01:01.990 align:start position:0%
much of the time though you'll just need
 

00:01:01.990 --> 00:01:04.710 align:start position:0%
much of the time though you'll just need
to<00:01:02.140><c> use</c><00:01:02.320><c> common</c><00:01:02.770><c> functions</c><00:01:03.250><c> such</c><00:01:03.670><c> as</c><00:01:03.700><c> sum</c><00:01:04.360><c> and</c>

00:01:04.710 --> 00:01:04.720 align:start position:0%
to use common functions such as sum and
 

00:01:04.720 --> 00:01:06.900 align:start position:0%
to use common functions such as sum and
average<00:01:04.930><c> and</c><00:01:05.410><c> you</c><00:01:05.950><c> can</c><00:01:06.070><c> access</c><00:01:06.430><c> these</c><00:01:06.610><c> by</c>

00:01:06.900 --> 00:01:06.910 align:start position:0%
average and you can access these by
 

00:01:06.910 --> 00:01:11.620 align:start position:0%
average and you can access these by
clicking<00:01:06.940><c> the</c><00:01:07.510><c> autosum</c><00:01:08.170><c> drop</c><00:01:08.680><c> down</c><00:01:08.920><c> arrow</c>

00:01:11.620 --> 00:01:11.630 align:start position:0%
 
 

00:01:11.630 --> 00:01:14.260 align:start position:0%
 
in<00:01:11.689><c> this</c><00:01:12.500><c> example</c><00:01:12.920><c> I'd</c><00:01:13.250><c> like</c><00:01:13.310><c> to</c><00:01:13.490><c> add</c><00:01:13.610><c> all</c><00:01:14.090><c> of</c>

00:01:14.260 --> 00:01:14.270 align:start position:0%
in this example I'd like to add all of
 

00:01:14.270 --> 00:01:17.529 align:start position:0%
in this example I'd like to add all of
these<00:01:14.420><c> cells</c><00:01:14.810><c> if</c><00:01:15.409><c> I</c><00:01:16.310><c> try</c><00:01:16.520><c> to</c><00:01:16.549><c> create</c><00:01:16.850><c> a</c><00:01:17.090><c> formula</c>

00:01:17.529 --> 00:01:17.539 align:start position:0%
these cells if I try to create a formula
 

00:01:17.539 --> 00:01:19.749 align:start position:0%
these cells if I try to create a formula
for<00:01:17.869><c> this</c><00:01:18.020><c> I</c><00:01:18.229><c> would</c><00:01:18.619><c> have</c><00:01:18.799><c> to</c><00:01:18.950><c> add</c><00:01:19.100><c> each</c><00:01:19.490><c> one</c>

00:01:19.749 --> 00:01:19.759 align:start position:0%
for this I would have to add each one
 

00:01:19.759 --> 00:01:21.490 align:start position:0%
for this I would have to add each one
individually<00:01:20.180><c> and</c><00:01:20.720><c> that</c><00:01:20.810><c> would</c><00:01:21.170><c> get</c><00:01:21.320><c> pretty</c>

00:01:21.490 --> 00:01:21.500 align:start position:0%
individually and that would get pretty
 

00:01:21.500 --> 00:01:23.380 align:start position:0%
individually and that would get pretty
long<00:01:21.770><c> and</c><00:01:22.070><c> if</c><00:01:22.130><c> I</c><00:01:22.250><c> had</c><00:01:22.430><c> to</c><00:01:22.549><c> add</c><00:01:22.670><c> hundreds</c><00:01:23.240><c> of</c>

00:01:23.380 --> 00:01:23.390 align:start position:0%
long and if I had to add hundreds of
 

00:01:23.390 --> 00:01:24.880 align:start position:0%
long and if I had to add hundreds of
cells<00:01:23.600><c> then</c><00:01:24.170><c> it</c><00:01:24.259><c> would</c><00:01:24.380><c> really</c><00:01:24.590><c> not</c><00:01:24.829><c> be</c>

00:01:24.880 --> 00:01:24.890 align:start position:0%
cells then it would really not be
 

00:01:24.890 --> 00:01:27.310 align:start position:0%
cells then it would really not be
manageable<00:01:25.579><c> at</c><00:01:25.700><c> all</c><00:01:25.820><c> so</c><00:01:26.810><c> I'm</c><00:01:26.929><c> just</c><00:01:27.110><c> going</c><00:01:27.259><c> to</c>

00:01:27.310 --> 00:01:27.320 align:start position:0%
manageable at all so I'm just going to
 

00:01:27.320 --> 00:01:30.679 align:start position:0%
manageable at all so I'm just going to
add<00:01:27.500><c> them</c><00:01:27.770><c> by</c><00:01:27.950><c> using</c><00:01:28.189><c> a</c><00:01:28.579><c> function</c>

00:01:30.679 --> 00:01:30.689 align:start position:0%
add them by using a function
 

00:01:30.689 --> 00:01:32.450 align:start position:0%
add them by using a function
click<00:01:31.380><c> on</c><00:01:31.499><c> the</c><00:01:31.619><c> cell</c><00:01:31.920><c> where</c><00:01:32.130><c> you</c><00:01:32.159><c> want</c><00:01:32.249><c> the</c>

00:01:32.450 --> 00:01:32.460 align:start position:0%
click on the cell where you want the
 

00:01:32.460 --> 00:01:34.940 align:start position:0%
click on the cell where you want the
function<00:01:32.909><c> to</c><00:01:32.999><c> be</c><00:01:33.030><c> and</c><00:01:33.390><c> then</c><00:01:34.259><c> click</c><00:01:34.619><c> on</c><00:01:34.649><c> the</c>

00:01:34.940 --> 00:01:34.950 align:start position:0%
function to be and then click on the
 

00:01:34.950 --> 00:01:40.280 align:start position:0%
function to be and then click on the
autosum<00:01:35.640><c> drop</c><00:01:36.030><c> down</c><00:01:36.299><c> arrow</c><00:01:36.539><c> and</c><00:01:36.719><c> select</c><00:01:37.380><c> some</c>

00:01:40.280 --> 00:01:40.290 align:start position:0%
autosum drop down arrow and select some
 

00:01:40.290 --> 00:01:42.200 align:start position:0%
 
now<00:01:40.620><c> this</c><00:01:40.830><c> has</c><00:01:41.010><c> inserted</c><00:01:41.490><c> the</c><00:01:41.610><c> function</c><00:01:42.030><c> and</c>

00:01:42.200 --> 00:01:42.210 align:start position:0%
now this has inserted the function and
 

00:01:42.210 --> 00:01:44.480 align:start position:0%
now this has inserted the function and
it's<00:01:42.690><c> also</c><00:01:43.200><c> selected</c><00:01:43.860><c> the</c><00:01:43.950><c> cells</c><00:01:44.190><c> that</c><00:01:44.430><c> are</c>

00:01:44.480 --> 00:01:44.490 align:start position:0%
it's also selected the cells that are
 

00:01:44.490 --> 00:01:47.240 align:start position:0%
it's also selected the cells that are
being<00:01:44.580><c> added</c><00:01:45.240><c> if</c><00:01:45.560><c> it</c><00:01:46.560><c> selects</c><00:01:46.950><c> the</c><00:01:47.070><c> wrong</c>

00:01:47.240 --> 00:01:47.250 align:start position:0%
being added if it selects the wrong
 

00:01:47.250 --> 00:01:49.250 align:start position:0%
being added if it selects the wrong
cells<00:01:47.580><c> then</c><00:01:47.880><c> we</c><00:01:47.910><c> can</c><00:01:48.090><c> always</c><00:01:48.450><c> change</c><00:01:48.750><c> that</c><00:01:49.080><c> by</c>

00:01:49.250 --> 00:01:49.260 align:start position:0%
cells then we can always change that by
 

00:01:49.260 --> 00:01:53.590 align:start position:0%
cells then we can always change that by
dragging<00:01:49.710><c> these</c><00:01:49.830><c> corner</c><00:01:50.310><c> handles</c>

00:01:53.590 --> 00:01:53.600 align:start position:0%
 
 

00:01:53.600 --> 00:01:56.110 align:start position:0%
 
but<00:01:54.170><c> this</c><00:01:54.350><c> looks</c><00:01:54.560><c> right</c><00:01:54.800><c> so</c><00:01:55.190><c> I'll</c><00:01:55.430><c> press</c><00:01:55.729><c> ENTER</c>

00:01:56.110 --> 00:01:56.120 align:start position:0%
but this looks right so I'll press ENTER
 

00:01:56.120 --> 00:02:00.090 align:start position:0%
but this looks right so I'll press ENTER
to<00:01:56.270><c> get</c><00:01:56.390><c> the</c><00:01:56.479><c> result</c>

00:02:00.090 --> 00:02:00.100 align:start position:0%
 
 

00:02:00.100 --> 00:02:01.980 align:start position:0%
 
let's<00:02:00.730><c> look</c><00:02:00.850><c> at</c><00:02:00.970><c> this</c><00:02:01.120><c> function</c><00:02:01.330><c> and</c><00:02:01.659><c> a</c><00:02:01.750><c> little</c>

00:02:01.980 --> 00:02:01.990 align:start position:0%
let's look at this function and a little
 

00:02:01.990 --> 00:02:03.719 align:start position:0%
let's look at this function and a little
bit<00:02:02.110><c> more</c><00:02:02.290><c> detail</c>

00:02:03.719 --> 00:02:03.729 align:start position:0%
bit more detail
 

00:02:03.729 --> 00:02:06.270 align:start position:0%
bit more detail
just<00:02:04.360><c> like</c><00:02:04.509><c> formulas</c><00:02:05.200><c> functions</c><00:02:06.039><c> always</c>

00:02:06.270 --> 00:02:06.280 align:start position:0%
just like formulas functions always
 

00:02:06.280 --> 00:02:09.419 align:start position:0%
just like formulas functions always
start<00:02:06.880><c> with</c><00:02:07.030><c> the</c><00:02:07.090><c> equals</c><00:02:07.600><c> sign</c><00:02:08.099><c> but</c><00:02:09.099><c> you</c><00:02:09.129><c> might</c>

00:02:09.419 --> 00:02:09.429 align:start position:0%
start with the equals sign but you might
 

00:02:09.429 --> 00:02:11.070 align:start position:0%
start with the equals sign but you might
notice<00:02:09.700><c> that</c><00:02:09.729><c> there</c><00:02:10.030><c> are</c><00:02:10.179><c> no</c><00:02:10.390><c> mathematical</c>

00:02:11.070 --> 00:02:11.080 align:start position:0%
notice that there are no mathematical
 

00:02:11.080 --> 00:02:12.720 align:start position:0%
notice that there are no mathematical
operators<00:02:11.680><c> such</c><00:02:11.920><c> as</c><00:02:11.950><c> addition</c><00:02:12.580><c> or</c>

00:02:12.720 --> 00:02:12.730 align:start position:0%
operators such as addition or
 

00:02:12.730 --> 00:02:14.400 align:start position:0%
operators such as addition or
subtraction<00:02:13.000><c> like</c><00:02:13.629><c> you</c><00:02:13.750><c> would</c><00:02:13.870><c> normally</c><00:02:14.230><c> see</c>

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

00:02:14.410 --> 00:02:17.400 align:start position:0%
subtraction like you would normally see
in<00:02:14.440><c> a</c><00:02:14.560><c> formula</c><00:02:15.030><c> instead</c><00:02:16.170><c> functions</c><00:02:17.170><c> have</c><00:02:17.379><c> a</c>

00:02:17.400 --> 00:02:17.410 align:start position:0%
in a formula instead functions have a
 

00:02:17.410 --> 00:02:20.580 align:start position:0%
in a formula instead functions have a
specific<00:02:18.340><c> syntax</c><00:02:18.730><c> that</c><00:02:19.629><c> includes</c><00:02:20.050><c> the</c><00:02:20.349><c> name</c>

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

00:02:20.590 --> 00:02:23.190 align:start position:0%
specific syntax that includes the name
of<00:02:20.830><c> the</c><00:02:20.980><c> function</c><00:02:21.239><c> followed</c><00:02:22.239><c> by</c><00:02:22.569><c> one</c><00:02:22.930><c> or</c><00:02:22.959><c> more</c>

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

00:02:23.200 --> 00:02:26.699 align:start position:0%
of the function followed by one or more
arguments<00:02:23.920><c> in</c><00:02:24.280><c> parentheses</c><00:02:25.200><c> the</c><00:02:26.200><c> arguments</c>

00:02:26.699 --> 00:02:26.709 align:start position:0%
arguments in parentheses the arguments
 

00:02:26.709 --> 00:02:28.710 align:start position:0%
arguments in parentheses the arguments
tell<00:02:26.890><c> the</c><00:02:26.980><c> function</c><00:02:27.370><c> which</c><00:02:27.580><c> cells</c><00:02:28.030><c> or</c><00:02:28.330><c> numbers</c>

00:02:28.710 --> 00:02:28.720 align:start position:0%
tell the function which cells or numbers
 

00:02:28.720 --> 00:02:31.650 align:start position:0%
tell the function which cells or numbers
to<00:02:28.930><c> use</c><00:02:29.110><c> to</c><00:02:29.319><c> calculate</c><00:02:29.470><c> the</c><00:02:29.950><c> result</c><00:02:30.280><c> in</c><00:02:30.660><c> this</c>

00:02:31.650 --> 00:02:31.660 align:start position:0%
to use to calculate the result in this
 

00:02:31.660 --> 00:02:33.089 align:start position:0%
to use to calculate the result in this
example<00:02:32.049><c> we</c><00:02:32.290><c> actually</c><00:02:32.440><c> only</c><00:02:32.830><c> have</c><00:02:33.069><c> one</c>

00:02:33.089 --> 00:02:33.099 align:start position:0%
example we actually only have one
 

00:02:33.099 --> 00:02:35.009 align:start position:0%
example we actually only have one
argument<00:02:33.849><c> even</c><00:02:34.330><c> though</c><00:02:34.510><c> there</c><00:02:34.750><c> are</c><00:02:34.780><c> two</c>

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

00:02:35.019 --> 00:02:37.470 align:start position:0%
argument even though there are two
different<00:02:35.319><c> cell</c><00:02:35.530><c> references</c><00:02:36.130><c> this</c><00:02:36.940><c> is</c><00:02:37.180><c> called</c>

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

00:02:37.480 --> 00:02:41.100 align:start position:0%
different cell references this is called
a<00:02:37.720><c> range</c><00:02:38.290><c> of</c><00:02:38.620><c> cells</c><00:02:38.890><c> a</c><00:02:39.450><c> range</c><00:02:40.450><c> of</c><00:02:40.630><c> cells</c><00:02:40.840><c> is</c>

00:02:41.100 --> 00:02:41.110 align:start position:0%
a range of cells a range of cells is
 

00:02:41.110 --> 00:02:43.199 align:start position:0%
a range of cells a range of cells is
indicated<00:02:41.709><c> by</c><00:02:41.739><c> two</c><00:02:41.920><c> cell</c><00:02:42.610><c> references</c>

00:02:43.199 --> 00:02:43.209 align:start position:0%
indicated by two cell references
 

00:02:43.209 --> 00:02:46.559 align:start position:0%
indicated by two cell references
separated<00:02:43.930><c> by</c><00:02:44.110><c> a</c><00:02:44.140><c> colon</c><00:02:44.440><c> in</c><00:02:45.090><c> this</c><00:02:46.090><c> case</c><00:02:46.329><c> the</c>

00:02:46.559 --> 00:02:46.569 align:start position:0%
separated by a colon in this case the
 

00:02:46.569 --> 00:02:49.229 align:start position:0%
separated by a colon in this case the
range<00:02:46.720><c> consists</c><00:02:47.380><c> of</c><00:02:47.470><c> all</c><00:02:47.739><c> the</c><00:02:47.920><c> cells</c><00:02:48.160><c> from</c><00:02:48.519><c> f6</c>

00:02:49.229 --> 00:02:49.239 align:start position:0%
range consists of all the cells from f6
 

00:02:49.239 --> 00:02:51.490 align:start position:0%
range consists of all the cells from f6
to<00:02:49.599><c> f-14</c>

00:02:51.490 --> 00:02:51.500 align:start position:0%
to f-14
 

00:02:51.500 --> 00:02:53.050 align:start position:0%
to f-14
if<00:02:51.560><c> you</c><00:02:52.070><c> want</c><00:02:52.250><c> to</c><00:02:52.310><c> use</c><00:02:52.430><c> more</c><00:02:52.670><c> than</c><00:02:52.730><c> one</c>

00:02:53.050 --> 00:02:53.060 align:start position:0%
if you want to use more than one
 

00:02:53.060 --> 00:02:54.850 align:start position:0%
if you want to use more than one
argument<00:02:53.300><c> you'll</c><00:02:53.990><c> need</c><00:02:54.200><c> to</c><00:02:54.320><c> separate</c><00:02:54.680><c> them</c>

00:02:54.850 --> 00:02:54.860 align:start position:0%
argument you'll need to separate them
 

00:02:54.860 --> 00:02:59.420 align:start position:0%
argument you'll need to separate them
with<00:02:55.070><c> commas</c>

00:02:59.420 --> 00:02:59.430 align:start position:0%
 
 

00:02:59.430 --> 00:03:01.960 align:start position:0%
 
let's<00:03:00.180><c> try</c><00:03:00.450><c> a</c><00:03:00.480><c> different</c><00:03:00.629><c> function</c><00:03:01.379><c> now</c><00:03:01.530><c> in</c>

00:03:01.960 --> 00:03:01.970 align:start position:0%
let's try a different function now in
 

00:03:01.970 --> 00:03:04.670 align:start position:0%
let's try a different function now in
this<00:03:02.970><c> example</c><00:03:03.360><c> we</c><00:03:03.689><c> have</c><00:03:03.720><c> a</c><00:03:03.870><c> column</c><00:03:04.319><c> for</c><00:03:04.349><c> the</c>

00:03:04.670 --> 00:03:04.680 align:start position:0%
this example we have a column for the
 

00:03:04.680 --> 00:03:07.009 align:start position:0%
this example we have a column for the
date<00:03:04.709><c> that</c><00:03:05.189><c> each</c><00:03:05.370><c> item</c><00:03:05.579><c> was</c><00:03:05.819><c> ordered</c><00:03:06.239><c> and</c><00:03:06.420><c> the</c>

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

00:03:07.019 --> 00:03:09.140 align:start position:0%
date that each item was ordered and the
date<00:03:07.200><c> that</c><00:03:07.319><c> it</c><00:03:07.439><c> was</c><00:03:07.470><c> received</c><00:03:07.590><c> and</c><00:03:08.459><c> I'd</c><00:03:09.000><c> like</c>

00:03:09.140 --> 00:03:09.150 align:start position:0%
date that it was received and I'd like
 

00:03:09.150 --> 00:03:11.000 align:start position:0%
date that it was received and I'd like
to<00:03:09.299><c> know</c><00:03:09.450><c> how</c><00:03:09.689><c> many</c><00:03:09.750><c> business</c><00:03:10.319><c> days</c><00:03:10.530><c> it</c><00:03:10.799><c> took</c>

00:03:11.000 --> 00:03:11.010 align:start position:0%
to know how many business days it took
 

00:03:11.010 --> 00:03:13.869 align:start position:0%
to know how many business days it took
to<00:03:11.069><c> receive</c><00:03:11.670><c> the</c><00:03:11.879><c> item</c><00:03:12.239><c> after</c><00:03:12.420><c> it</c><00:03:12.780><c> was</c><00:03:12.900><c> ordered</c>

00:03:13.869 --> 00:03:13.879 align:start position:0%
to receive the item after it was ordered
 

00:03:13.879 --> 00:03:16.490 align:start position:0%
to receive the item after it was ordered
first<00:03:14.879><c> select</c><00:03:15.540><c> the</c><00:03:15.720><c> cell</c><00:03:15.750><c> where</c><00:03:16.140><c> you</c><00:03:16.170><c> want</c><00:03:16.260><c> the</c>

00:03:16.490 --> 00:03:16.500 align:start position:0%
first select the cell where you want the
 

00:03:16.500 --> 00:03:19.160 align:start position:0%
first select the cell where you want the
function<00:03:16.709><c> to</c><00:03:16.950><c> go</c><00:03:17.129><c> and</c><00:03:17.720><c> if</c><00:03:18.720><c> you</c><00:03:18.840><c> know</c><00:03:18.989><c> which</c>

00:03:19.160 --> 00:03:19.170 align:start position:0%
function to go and if you know which
 

00:03:19.170 --> 00:03:20.899 align:start position:0%
function to go and if you know which
category<00:03:19.680><c> your</c><00:03:19.739><c> function</c><00:03:20.099><c> is</c><00:03:20.220><c> in</c><00:03:20.400><c> you</c><00:03:20.730><c> can</c>

00:03:20.899 --> 00:03:20.909 align:start position:0%
category your function is in you can
 

00:03:20.909 --> 00:03:23.330 align:start position:0%
category your function is in you can
select<00:03:21.090><c> it</c><00:03:21.390><c> from</c><00:03:21.510><c> there</c><00:03:21.810><c> or</c><00:03:22.019><c> you</c><00:03:22.980><c> can</c><00:03:23.159><c> just</c>

00:03:23.330 --> 00:03:23.340 align:start position:0%
select it from there or you can just
 

00:03:23.340 --> 00:03:25.069 align:start position:0%
select it from there or you can just
search<00:03:23.609><c> for</c><00:03:23.640><c> the</c><00:03:23.970><c> function</c><00:03:24.359><c> by</c><00:03:24.540><c> clicking</c><00:03:24.959><c> the</c>

00:03:25.069 --> 00:03:25.079 align:start position:0%
search for the function by clicking the
 

00:03:25.079 --> 00:03:31.740 align:start position:0%
search for the function by clicking the
insert<00:03:25.230><c> function</c><00:03:25.739><c> command</c>

00:03:31.740 --> 00:03:31.750 align:start position:0%
 
 

00:03:31.750 --> 00:03:33.750 align:start position:0%
 
just<00:03:32.410><c> type</c><00:03:32.620><c> in</c><00:03:32.770><c> a</c><00:03:32.890><c> description</c><00:03:33.010><c> of</c><00:03:33.520><c> what</c>

00:03:33.750 --> 00:03:33.760 align:start position:0%
just type in a description of what
 

00:03:33.760 --> 00:03:35.730 align:start position:0%
just type in a description of what
you're<00:03:33.910><c> looking</c><00:03:34.090><c> for</c><00:03:34.540><c> I'm</c><00:03:34.720><c> looking</c><00:03:35.560><c> for</c><00:03:35.710><c> a</c>

00:03:35.730 --> 00:03:35.740 align:start position:0%
you're looking for I'm looking for a
 

00:03:35.740 --> 00:03:37.080 align:start position:0%
you're looking for I'm looking for a
function<00:03:36.160><c> that</c><00:03:36.190><c> can</c><00:03:36.460><c> count</c><00:03:36.700><c> the</c><00:03:36.820><c> number</c><00:03:37.060><c> of</c>

00:03:37.080 --> 00:03:37.090 align:start position:0%
function that can count the number of
 

00:03:37.090 --> 00:03:41.809 align:start position:0%
function that can count the number of
days<00:03:37.450><c> elapsed</c><00:03:38.020><c> so</c><00:03:38.560><c> I'll</c><00:03:38.740><c> type</c><00:03:38.980><c> count</c><00:03:39.460><c> days</c>

00:03:41.809 --> 00:03:41.819 align:start position:0%
days elapsed so I'll type count days
 

00:03:41.819 --> 00:03:45.190 align:start position:0%
days elapsed so I'll type count days
and<00:03:41.909><c> press</c><00:03:42.510><c> enter</c>

00:03:45.190 --> 00:03:45.200 align:start position:0%
 
 

00:03:45.200 --> 00:03:47.470 align:start position:0%
 
lot<00:03:45.319><c> of</c><00:03:45.349><c> different</c><00:03:45.800><c> results</c><00:03:46.220><c> here</c><00:03:46.400><c> you</c><00:03:46.610><c> can</c>

00:03:47.470 --> 00:03:47.480 align:start position:0%
lot of different results here you can
 

00:03:47.480 --> 00:03:48.850 align:start position:0%
lot of different results here you can
click<00:03:47.690><c> on</c><00:03:47.870><c> a</c><00:03:47.900><c> function</c><00:03:48.379><c> and</c><00:03:48.590><c> read</c><00:03:48.830><c> a</c>

00:03:48.850 --> 00:03:48.860 align:start position:0%
click on a function and read a
 

00:03:48.860 --> 00:03:53.800 align:start position:0%
click on a function and read a
description<00:03:49.310><c> of</c><00:03:49.550><c> it</c><00:03:49.700><c> below</c>

00:03:53.800 --> 00:03:53.810 align:start position:0%
 
 

00:03:53.810 --> 00:03:55.990 align:start position:0%
 
Network<00:03:54.770><c> day's</c><00:03:55.069><c> returns</c><00:03:55.459><c> the</c><00:03:55.670><c> number</c><00:03:55.790><c> of</c>

00:03:55.990 --> 00:03:56.000 align:start position:0%
Network day's returns the number of
 

00:03:56.000 --> 00:03:58.059 align:start position:0%
Network day's returns the number of
workdays<00:03:56.390><c> between</c><00:03:56.840><c> two</c><00:03:57.110><c> dates</c><00:03:57.380><c> and</c><00:03:57.680><c> that's</c>

00:03:58.059 --> 00:03:58.069 align:start position:0%
workdays between two dates and that's
 

00:03:58.069 --> 00:04:01.400 align:start position:0%
workdays between two dates and that's
what<00:03:58.280><c> we</c><00:03:58.400><c> want</c><00:03:58.640><c> so</c><00:03:58.850><c> I'll</c><00:03:59.270><c> click</c><00:03:59.480><c> OK</c>

00:04:01.400 --> 00:04:01.410 align:start position:0%
what we want so I'll click OK
 

00:04:01.410 --> 00:04:03.890 align:start position:0%
what we want so I'll click OK
there<00:04:02.130><c> will</c><00:04:02.250><c> be</c><00:04:02.280><c> a</c><00:04:02.400><c> field</c><00:04:02.880><c> for</c><00:04:03.330><c> each</c><00:04:03.540><c> argument</c>

00:04:03.890 --> 00:04:03.900 align:start position:0%
there will be a field for each argument
 

00:04:03.900 --> 00:04:06.170 align:start position:0%
there will be a field for each argument
and<00:04:04.410><c> this</c><00:04:04.800><c> function</c><00:04:05.040><c> has</c><00:04:05.400><c> up</c><00:04:05.700><c> to</c><00:04:05.850><c> three</c>

00:04:06.170 --> 00:04:06.180 align:start position:0%
and this function has up to three
 

00:04:06.180 --> 00:04:09.370 align:start position:0%
and this function has up to three
arguments<00:04:06.720><c> the</c><00:04:07.050><c> start</c><00:04:07.500><c> date</c><00:04:07.740><c> end</c><00:04:07.920><c> date</c><00:04:08.700><c> and</c>

00:04:09.370 --> 00:04:09.380 align:start position:0%
arguments the start date end date and
 

00:04:09.380 --> 00:04:11.500 align:start position:0%
arguments the start date end date and
holidays

00:04:11.500 --> 00:04:11.510 align:start position:0%
holidays
 

00:04:11.510 --> 00:04:13.479 align:start position:0%
holidays
when<00:04:11.930><c> you</c><00:04:12.019><c> click</c><00:04:12.230><c> in</c><00:04:12.440><c> each</c><00:04:12.590><c> field</c><00:04:12.830><c> you</c><00:04:13.129><c> can</c><00:04:13.280><c> see</c>

00:04:13.479 --> 00:04:13.489 align:start position:0%
when you click in each field you can see
 

00:04:13.489 --> 00:04:16.910 align:start position:0%
when you click in each field you can see
a<00:04:13.519><c> description</c><00:04:13.849><c> of</c><00:04:14.269><c> it</c><00:04:14.420><c> below</c>

00:04:16.910 --> 00:04:16.920 align:start position:0%
 
 

00:04:16.920 --> 00:04:18.230 align:start position:0%
 
and<00:04:17.010><c> if</c><00:04:17.400><c> you</c><00:04:17.490><c> need</c><00:04:17.640><c> more</c><00:04:17.790><c> help</c><00:04:17.850><c> on</c><00:04:18.210><c> a</c>

00:04:18.230 --> 00:04:18.240 align:start position:0%
and if you need more help on a
 

00:04:18.240 --> 00:04:20.420 align:start position:0%
and if you need more help on a
particular<00:04:18.720><c> function</c><00:04:19.110><c> you</c><00:04:19.560><c> can</c><00:04:19.740><c> click</c><00:04:20.040><c> help</c>

00:04:20.420 --> 00:04:20.430 align:start position:0%
particular function you can click help
 

00:04:20.430 --> 00:04:27.260 align:start position:0%
particular function you can click help
on<00:04:20.610><c> this</c><00:04:20.880><c> function</c>

00:04:27.260 --> 00:04:27.270 align:start position:0%
 
 

00:04:27.270 --> 00:04:32.270 align:start position:0%
 
I'll<00:04:27.330><c> select</c><00:04:28.020><c> g6</c><00:04:28.830><c> for</c><00:04:29.129><c> the</c><00:04:29.190><c> start</c><00:04:29.460><c> date</c>

00:04:32.270 --> 00:04:32.280 align:start position:0%
 
 

00:04:32.280 --> 00:04:36.390 align:start position:0%
 
h6<00:04:33.280><c> for</c><00:04:33.759><c> the</c><00:04:33.819><c> end</c><00:04:34.000><c> date</c><00:04:34.360><c> and</c><00:04:34.979><c> the</c><00:04:35.979><c> holidays</c>

00:04:36.390 --> 00:04:36.400 align:start position:0%
h6 for the end date and the holidays
 

00:04:36.400 --> 00:04:38.490 align:start position:0%
h6 for the end date and the holidays
argument<00:04:36.879><c> is</c><00:04:36.970><c> optional</c><00:04:37.180><c> so</c><00:04:37.900><c> I'll</c><00:04:38.110><c> just</c><00:04:38.289><c> leave</c>

00:04:38.490 --> 00:04:38.500 align:start position:0%
argument is optional so I'll just leave
 

00:04:38.500 --> 00:04:40.570 align:start position:0%
argument is optional so I'll just leave
it<00:04:38.650><c> blank</c>

00:04:40.570 --> 00:04:40.580 align:start position:0%
it blank
 

00:04:40.580 --> 00:04:44.269 align:start position:0%
it blank
you'll<00:04:41.270><c> be</c><00:04:41.420><c> able</c><00:04:41.510><c> to</c><00:04:41.690><c> see</c><00:04:41.960><c> the</c><00:04:42.110><c> result</c><00:04:42.560><c> here</c>

00:04:44.269 --> 00:04:44.279 align:start position:0%
you'll be able to see the result here
 

00:04:44.279 --> 00:04:46.879 align:start position:0%
you'll be able to see the result here
click<00:04:44.999><c> okay</c><00:04:45.389><c> and</c><00:04:45.599><c> the</c><00:04:46.349><c> function</c><00:04:46.709><c> will</c><00:04:46.859><c> be</c>

00:04:46.879 --> 00:04:46.889 align:start position:0%
click okay and the function will be
 

00:04:46.889 --> 00:04:49.360 align:start position:0%
click okay and the function will be
added<00:04:47.309><c> to</c><00:04:47.489><c> the</c><00:04:47.639><c> worksheet</c>

00:04:49.360 --> 00:04:49.370 align:start position:0%
added to the worksheet
 

00:04:49.370 --> 00:04:51.970 align:start position:0%
added to the worksheet
just<00:04:50.210><c> like</c><00:04:50.389><c> with</c><00:04:50.540><c> formulas</c><00:04:51.110><c> we</c><00:04:51.320><c> can</c><00:04:51.500><c> drag</c><00:04:51.740><c> the</c>

00:04:51.970 --> 00:04:51.980 align:start position:0%
just like with formulas we can drag the
 

00:04:51.980 --> 00:04:54.839 align:start position:0%
just like with formulas we can drag the
fill<00:04:52.190><c> handle</c><00:04:52.220><c> to</c><00:04:52.639><c> copy</c><00:04:52.760><c> it</c>

00:04:54.839 --> 00:04:54.849 align:start position:0%
fill handle to copy it
 

00:04:54.849 --> 00:04:56.969 align:start position:0%
fill handle to copy it
and<00:04:55.389><c> now</c><00:04:55.539><c> we</c><00:04:55.599><c> can</c><00:04:55.809><c> see</c><00:04:55.990><c> how</c><00:04:56.169><c> long</c><00:04:56.199><c> it</c><00:04:56.559><c> took</c><00:04:56.740><c> each</c>

00:04:56.969 --> 00:04:56.979 align:start position:0%
and now we can see how long it took each
 

00:04:56.979 --> 00:05:00.460 align:start position:0%
and now we can see how long it took each
of<00:04:57.129><c> these</c><00:04:57.249><c> items</c><00:04:57.429><c> to</c><00:04:57.759><c> arrive</c>

00:05:00.460 --> 00:05:00.470 align:start position:0%
 
 

00:05:00.470 --> 00:05:02.440 align:start position:0%
 
if<00:05:00.530><c> you've</c><00:05:01.250><c> never</c><00:05:01.400><c> used</c><00:05:01.520><c> functions</c><00:05:02.270><c> before</c>

00:05:02.440 --> 00:05:02.450 align:start position:0%
if you've never used functions before
 

00:05:02.450 --> 00:05:04.870 align:start position:0%
if you've never used functions before
the<00:05:02.960><c> syntax</c><00:05:03.380><c> may</c><00:05:03.620><c> seem</c><00:05:03.890><c> a</c><00:05:04.070><c> little</c><00:05:04.280><c> strange</c><00:05:04.670><c> at</c>

00:05:04.870 --> 00:05:04.880 align:start position:0%
the syntax may seem a little strange at
 

00:05:04.880 --> 00:05:07.090 align:start position:0%
the syntax may seem a little strange at
first<00:05:04.930><c> but</c><00:05:05.930><c> with</c><00:05:06.230><c> some</c><00:05:06.440><c> practice</c><00:05:06.590><c> you'll</c>

00:05:07.090 --> 00:05:07.100 align:start position:0%
first but with some practice you'll
 

00:05:07.100 --> 00:05:08.650 align:start position:0%
first but with some practice you'll
start<00:05:07.370><c> to</c><00:05:07.460><c> get</c><00:05:07.580><c> the</c><00:05:07.670><c> hang</c><00:05:07.850><c> of</c><00:05:07.970><c> it</c><00:05:08.090><c> and</c><00:05:08.210><c> over</c>

00:05:08.650 --> 00:05:08.660 align:start position:0%
start to get the hang of it and over
 

00:05:08.660 --> 00:05:10.480 align:start position:0%
start to get the hang of it and over
time<00:05:08.810><c> you'll</c><00:05:09.200><c> probably</c><00:05:09.260><c> find</c><00:05:09.830><c> your</c><00:05:10.040><c> favorite</c>

00:05:10.480 --> 00:05:10.490 align:start position:0%
time you'll probably find your favorite
 

00:05:10.490 --> 00:05:12.400 align:start position:0%
time you'll probably find your favorite
functions<00:05:10.910><c> that</c><00:05:11.270><c> you'll</c><00:05:11.450><c> use</c><00:05:11.690><c> over</c><00:05:11.960><c> and</c><00:05:12.290><c> over</c>

00:05:12.400 --> 00:05:12.410 align:start position:0%
functions that you'll use over and over
 

00:05:12.410 --> 00:05:17.860 align:start position:0%
functions that you'll use over and over
again<00:05:12.680><c> like</c><00:05:14.050><c> what</c><00:05:15.050><c> you</c><00:05:15.230><c> just</c><00:05:15.260><c> saw</c><00:05:16.300><c> radix</c><00:05:17.300><c> add</c><00:05:17.810><c> a</c>

00:05:17.860 --> 00:05:17.870 align:start position:0%
again like what you just saw radix add a
 

00:05:17.870 --> 00:05:20.950 align:start position:0%
again like what you just saw radix add a
comment<00:05:18.200><c> subscribe</c><00:05:18.950><c> to</c><00:05:19.400><c> our</c><00:05:19.490><c> Channel</c><00:05:20.000><c> the</c>

00:05:20.950 --> 00:05:20.960 align:start position:0%
comment subscribe to our Channel the
 

00:05:20.960 --> 00:05:25.060 align:start position:0%
comment subscribe to our Channel the
freedom<00:05:21.410><c> to</c><00:05:21.560><c> learn</c><00:05:22.330><c> what</c><00:05:23.330><c> you</c><00:05:23.540><c> want</c><00:05:24.040><c> when</c><00:05:25.040><c> you</c>

00:05:25.060 --> 00:05:25.070 align:start position:0%
freedom to learn what you want when you
 

00:05:25.070 --> 00:05:35.230 align:start position:0%
freedom to learn what you want when you
want<00:05:26.470><c> absolutely</c><00:05:27.470><c> free</c><00:05:31.630><c> GCF</c><00:05:32.630><c> learn</c><00:05:33.200><c> free.org</c>