WEBVTT
Kind: captions
Language: en

00:00:00.770 --> 00:00:03.740 align:start position:0%
 
functions<00:00:01.770><c> are</c><00:00:02.010><c> a</c><00:00:02.040><c> great</c><00:00:02.430><c> time-saving</c><00:00:03.150><c> option</c>

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

00:00:03.750 --> 00:00:05.710 align:start position:0%
functions are a great time-saving option
for<00:00:03.990><c> calculating</c><00:00:04.500><c> data</c><00:00:04.800><c> in</c><00:00:05.160><c> your</c><00:00:05.400><c> spreadsheet</c>

00:00:05.710 --> 00:00:05.720 align:start position:0%
for calculating data in your spreadsheet
 

00:00:05.720 --> 00:00:08.209 align:start position:0%
for calculating data in your spreadsheet
they<00:00:06.720><c> can</c><00:00:06.870><c> be</c><00:00:06.990><c> used</c><00:00:07.200><c> in</c><00:00:07.350><c> place</c><00:00:07.560><c> of</c><00:00:07.589><c> formulas</c>

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

00:00:08.219 --> 00:00:10.249 align:start position:0%
they can be used in place of formulas
when<00:00:08.549><c> a</c><00:00:08.580><c> formula</c><00:00:09.089><c> would</c><00:00:09.240><c> be</c><00:00:09.299><c> too</c><00:00:09.629><c> long</c><00:00:09.839><c> or</c><00:00:10.200><c> just</c>

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

00:00:10.259 --> 00:00:12.489 align:start position:0%
when a formula would be too long or just
too<00:00:10.740><c> complicated</c><00:00:11.219><c> to</c><00:00:11.669><c> write</c><00:00:11.820><c> out</c><00:00:12.030><c> manually</c>

00:00:12.489 --> 00:00:12.499 align:start position:0%
too complicated to write out manually
 

00:00:12.499 --> 00:00:15.020 align:start position:0%
too complicated to write out manually
many<00:00:13.499><c> functions</c><00:00:13.980><c> in</c><00:00:14.159><c> Google</c><00:00:14.459><c> sheets</c><00:00:14.489><c> are</c>

00:00:15.020 --> 00:00:15.030 align:start position:0%
many functions in Google sheets are
 

00:00:15.030 --> 00:00:17.180 align:start position:0%
many functions in Google sheets are
geared<00:00:15.299><c> more</c><00:00:15.509><c> towards</c><00:00:15.959><c> advanced</c><00:00:16.470><c> users</c><00:00:16.860><c> and</c>

00:00:17.180 --> 00:00:17.190 align:start position:0%
geared more towards advanced users and
 

00:00:17.190 --> 00:00:19.280 align:start position:0%
geared more towards advanced users and
it<00:00:17.370><c> can</c><00:00:17.520><c> be</c><00:00:17.610><c> tricky</c><00:00:17.820><c> figuring</c><00:00:18.480><c> out</c><00:00:18.660><c> how</c><00:00:18.990><c> and</c>

00:00:19.280 --> 00:00:19.290 align:start position:0%
it can be tricky figuring out how and
 

00:00:19.290 --> 00:00:21.800 align:start position:0%
it can be tricky figuring out how and
when<00:00:19.470><c> to</c><00:00:19.500><c> use</c><00:00:19.920><c> them</c><00:00:20.160><c> but</c><00:00:20.820><c> other</c><00:00:21.030><c> functions</c><00:00:21.600><c> are</c>

00:00:21.800 --> 00:00:21.810 align:start position:0%
when to use them but other functions are
 

00:00:21.810 --> 00:00:23.750 align:start position:0%
when to use them but other functions are
easy<00:00:22.050><c> to</c><00:00:22.290><c> use</c><00:00:22.320><c> and</c><00:00:22.860><c> can</c><00:00:23.100><c> save</c><00:00:23.370><c> you</c><00:00:23.400><c> a</c><00:00:23.520><c> lot</c><00:00:23.700><c> of</c>

00:00:23.750 --> 00:00:23.760 align:start position:0%
easy to use and can save you a lot of
 

00:00:23.760 --> 00:00:26.300 align:start position:0%
easy to use and can save you a lot of
time<00:00:24.060><c> so</c><00:00:24.810><c> in</c><00:00:25.020><c> this</c><00:00:25.140><c> video</c><00:00:25.320><c> we'll</c><00:00:25.890><c> start</c><00:00:26.160><c> with</c>

00:00:26.300 --> 00:00:26.310 align:start position:0%
time so in this video we'll start with
 

00:00:26.310 --> 00:00:28.400 align:start position:0%
time so in this video we'll start with
some<00:00:26.520><c> basic</c><00:00:26.940><c> information</c><00:00:27.030><c> a</c><00:00:27.720><c> few</c><00:00:28.170><c> simple</c>

00:00:28.400 --> 00:00:28.410 align:start position:0%
some basic information a few simple
 

00:00:28.410 --> 00:00:30.560 align:start position:0%
some basic information a few simple
functions<00:00:29.039><c> as</c><00:00:29.220><c> well</c><00:00:29.700><c> as</c><00:00:29.760><c> what</c><00:00:30.090><c> you</c><00:00:30.240><c> need</c><00:00:30.450><c> to</c>

00:00:30.560 --> 00:00:30.570 align:start position:0%
functions as well as what you need to
 

00:00:30.570 --> 00:00:32.720 align:start position:0%
functions as well as what you need to
know<00:00:30.780><c> about</c><00:00:31.080><c> entering</c><00:00:31.770><c> them</c><00:00:31.920><c> correctly</c><00:00:32.430><c> in</c>

00:00:32.720 --> 00:00:32.730 align:start position:0%
know about entering them correctly in
 

00:00:32.730 --> 00:00:35.779 align:start position:0%
know about entering them correctly in
this<00:00:33.719><c> example</c><00:00:34.140><c> I'd</c><00:00:34.589><c> like</c><00:00:34.649><c> to</c><00:00:34.859><c> add</c><00:00:35.100><c> these</c><00:00:35.399><c> cells</c>

00:00:35.779 --> 00:00:35.789 align:start position:0%
this example I'd like to add these cells
 

00:00:35.789 --> 00:00:38.090 align:start position:0%
this example I'd like to add these cells
to<00:00:36.089><c> calculate</c><00:00:36.570><c> the</c><00:00:36.719><c> total</c><00:00:37.019><c> if</c><00:00:37.170><c> I</c><00:00:37.769><c> tried</c><00:00:38.010><c> to</c>

00:00:38.090 --> 00:00:38.100 align:start position:0%
to calculate the total if I tried to
 

00:00:38.100 --> 00:00:39.799 align:start position:0%
to calculate the total if I tried to
create<00:00:38.249><c> a</c><00:00:38.429><c> formula</c><00:00:38.940><c> for</c><00:00:39.120><c> that</c><00:00:39.179><c> I'd</c><00:00:39.539><c> have</c><00:00:39.780><c> to</c>

00:00:39.799 --> 00:00:39.809 align:start position:0%
create a formula for that I'd have to
 

00:00:39.809 --> 00:00:42.680 align:start position:0%
create a formula for that I'd have to
add<00:00:40.019><c> each</c><00:00:40.409><c> cell</c><00:00:40.769><c> individually</c><00:00:41.420><c> not</c><00:00:42.420><c> only</c>

00:00:42.680 --> 00:00:42.690 align:start position:0%
add each cell individually not only
 

00:00:42.690 --> 00:00:44.479 align:start position:0%
add each cell individually not only
would<00:00:42.839><c> that</c><00:00:42.870><c> be</c><00:00:43.109><c> tedious</c><00:00:43.620><c> it</c><00:00:43.890><c> would</c><00:00:44.039><c> also</c><00:00:44.249><c> make</c>

00:00:44.479 --> 00:00:44.489 align:start position:0%
would that be tedious it would also make
 

00:00:44.489 --> 00:00:46.849 align:start position:0%
would that be tedious it would also make
the<00:00:44.609><c> formula</c><00:00:44.879><c> really</c><00:00:45.359><c> long</c><00:00:45.780><c> especially</c><00:00:46.350><c> if</c><00:00:46.739><c> I</c>

00:00:46.849 --> 00:00:46.859 align:start position:0%
the formula really long especially if I
 

00:00:46.859 --> 00:00:49.189 align:start position:0%
the formula really long especially if I
had<00:00:47.129><c> say</c><00:00:47.579><c> a</c><00:00:47.819><c> hundred</c><00:00:48.120><c> cells</c><00:00:48.539><c> that</c><00:00:48.749><c> I</c><00:00:48.809><c> wanted</c><00:00:49.109><c> to</c>

00:00:49.189 --> 00:00:49.199 align:start position:0%
had say a hundred cells that I wanted to
 

00:00:49.199 --> 00:00:51.799 align:start position:0%
had say a hundred cells that I wanted to
add<00:00:49.350><c> so</c><00:00:50.100><c> instead</c><00:00:50.460><c> of</c><00:00:50.519><c> creating</c><00:00:51.030><c> a</c><00:00:51.120><c> formula</c><00:00:51.600><c> I'm</c>

00:00:51.799 --> 00:00:51.809 align:start position:0%
add so instead of creating a formula I'm
 

00:00:51.809 --> 00:00:54.529 align:start position:0%
add so instead of creating a formula I'm
going<00:00:51.870><c> to</c><00:00:52.409><c> use</c><00:00:52.649><c> a</c><00:00:52.679><c> function</c><00:00:53.239><c> first</c><00:00:54.239><c> I'll</c>

00:00:54.529 --> 00:00:54.539 align:start position:0%
going to use a function first I'll
 

00:00:54.539 --> 00:00:57.200 align:start position:0%
going to use a function first I'll
select<00:00:54.929><c> the</c><00:00:55.139><c> cells</c><00:00:55.379><c> and</c><00:00:55.649><c> click</c><00:00:56.519><c> the</c><00:00:56.760><c> functions</c>

00:00:57.200 --> 00:00:57.210 align:start position:0%
select the cells and click the functions
 

00:00:57.210 --> 00:00:59.329 align:start position:0%
select the cells and click the functions
command<00:00:57.629><c> if</c><00:00:57.839><c> you</c><00:00:58.350><c> don't</c><00:00:58.499><c> see</c><00:00:58.769><c> the</c><00:00:58.920><c> functions</c>

00:00:59.329 --> 00:00:59.339 align:start position:0%
command if you don't see the functions
 

00:00:59.339 --> 00:01:01.639 align:start position:0%
command if you don't see the functions
command<00:00:59.729><c> click</c><00:01:00.120><c> the</c><00:01:00.269><c> three</c><00:01:00.600><c> dots</c><00:01:00.629><c> here</c><00:01:01.260><c> to</c><00:01:01.499><c> see</c>

00:01:01.639 --> 00:01:01.649 align:start position:0%
command click the three dots here to see
 

00:01:01.649 --> 00:01:03.810 align:start position:0%
command click the three dots here to see
the<00:01:01.799><c> rest</c><00:01:02.010><c> of</c><00:01:02.129><c> the</c><00:01:02.280><c> commands</c>

00:01:03.810 --> 00:01:03.820 align:start position:0%
the rest of the commands
 

00:01:03.820 --> 00:01:05.969 align:start position:0%
the rest of the commands
a<00:01:03.880><c> drop-down</c><00:01:04.720><c> menu</c><00:01:04.930><c> will</c><00:01:05.379><c> appear</c><00:01:05.500><c> containing</c>

00:01:05.969 --> 00:01:05.979 align:start position:0%
a drop-down menu will appear containing
 

00:01:05.979 --> 00:01:08.490 align:start position:0%
a drop-down menu will appear containing
a<00:01:06.340><c> list</c><00:01:06.490><c> of</c><00:01:06.640><c> functions</c><00:01:07.090><c> here</c><00:01:07.930><c> you</c><00:01:08.170><c> can</c><00:01:08.290><c> find</c>

00:01:08.490 --> 00:01:08.500 align:start position:0%
a list of functions here you can find
 

00:01:08.500 --> 00:01:10.469 align:start position:0%
a list of functions here you can find
the<00:01:08.710><c> average</c><00:01:08.890><c> or</c><00:01:09.460><c> count</c><00:01:09.790><c> the</c><00:01:09.880><c> number</c><00:01:10.150><c> of</c><00:01:10.180><c> cells</c>

00:01:10.469 --> 00:01:10.479 align:start position:0%
the average or count the number of cells
 

00:01:10.479 --> 00:01:13.290 align:start position:0%
the average or count the number of cells
in<00:01:10.750><c> a</c><00:01:10.840><c> selection</c><00:01:11.380><c> I'm</c><00:01:11.620><c> going</c><00:01:12.430><c> to</c><00:01:12.550><c> use</c><00:01:12.760><c> the</c><00:01:13.030><c> sum</c>

00:01:13.290 --> 00:01:13.300 align:start position:0%
in a selection I'm going to use the sum
 

00:01:13.300 --> 00:01:15.300 align:start position:0%
in a selection I'm going to use the sum
function<00:01:13.330><c> to</c><00:01:14.140><c> add</c><00:01:14.260><c> all</c><00:01:14.590><c> of</c><00:01:14.620><c> the</c><00:01:14.860><c> cells</c><00:01:15.130><c> and</c>

00:01:15.300 --> 00:01:15.310 align:start position:0%
function to add all of the cells and
 

00:01:15.310 --> 00:01:18.390 align:start position:0%
function to add all of the cells and
find<00:01:15.729><c> the</c><00:01:15.880><c> total</c><00:01:16.560><c> when</c><00:01:17.560><c> you're</c><00:01:17.710><c> done</c><00:01:17.920><c> press</c>

00:01:18.390 --> 00:01:18.400 align:start position:0%
find the total when you're done press
 

00:01:18.400 --> 00:01:20.670 align:start position:0%
find the total when you're done press
ENTER<00:01:18.790><c> on</c><00:01:18.820><c> your</c><00:01:18.940><c> keyboard</c><00:01:19.090><c> and</c><00:01:19.659><c> the</c><00:01:20.320><c> answer</c>

00:01:20.670 --> 00:01:20.680 align:start position:0%
ENTER on your keyboard and the answer
 

00:01:20.680 --> 00:01:23.249 align:start position:0%
ENTER on your keyboard and the answer
will<00:01:20.830><c> appear</c><00:01:21.360><c> let's</c><00:01:22.360><c> look</c><00:01:22.660><c> at</c><00:01:22.780><c> this</c><00:01:22.930><c> function</c>

00:01:23.249 --> 00:01:23.259 align:start position:0%
will appear let's look at this function
 

00:01:23.259 --> 00:01:25.690 align:start position:0%
will appear let's look at this function
in<00:01:23.560><c> a</c><00:01:23.710><c> little</c><00:01:24.009><c> more</c><00:01:24.160><c> detail</c>

00:01:25.690 --> 00:01:25.700 align:start position:0%
in a little more detail
 

00:01:25.700 --> 00:01:27.969 align:start position:0%
in a little more detail
just<00:01:26.180><c> like</c><00:01:26.420><c> formulas</c><00:01:27.020><c> functions</c><00:01:27.710><c> always</c>

00:01:27.969 --> 00:01:27.979 align:start position:0%
just like formulas functions always
 

00:01:27.979 --> 00:01:30.249 align:start position:0%
just like formulas functions always
start<00:01:28.460><c> with</c><00:01:28.549><c> an</c><00:01:28.700><c> equal</c><00:01:28.969><c> sign</c><00:01:29.030><c> but</c><00:01:29.960><c> you</c><00:01:30.079><c> may</c>

00:01:30.249 --> 00:01:30.259 align:start position:0%
start with an equal sign but you may
 

00:01:30.259 --> 00:01:31.600 align:start position:0%
start with an equal sign but you may
have<00:01:30.469><c> noticed</c><00:01:30.860><c> that</c><00:01:31.189><c> there</c><00:01:31.340><c> are</c><00:01:31.430><c> no</c>

00:01:31.600 --> 00:01:31.610 align:start position:0%
have noticed that there are no
 

00:01:31.610 --> 00:01:34.060 align:start position:0%
have noticed that there are no
mathematical<00:01:32.240><c> operators</c><00:01:32.869><c> such</c><00:01:33.409><c> as</c><00:01:33.439><c> addition</c>

00:01:34.060 --> 00:01:34.070 align:start position:0%
mathematical operators such as addition
 

00:01:34.070 --> 00:01:35.950 align:start position:0%
mathematical operators such as addition
or<00:01:34.219><c> subtraction</c><00:01:34.369><c> like</c><00:01:35.299><c> you</c><00:01:35.450><c> would</c><00:01:35.570><c> normally</c>

00:01:35.950 --> 00:01:35.960 align:start position:0%
or subtraction like you would normally
 

00:01:35.960 --> 00:01:38.560 align:start position:0%
or subtraction like you would normally
see<00:01:36.110><c> in</c><00:01:36.140><c> a</c><00:01:36.320><c> formula</c><00:01:36.490><c> instead</c><00:01:37.490><c> functions</c><00:01:38.360><c> use</c><00:01:38.539><c> a</c>

00:01:38.560 --> 00:01:38.570 align:start position:0%
see in a formula instead functions use a
 

00:01:38.570 --> 00:01:40.840 align:start position:0%
see in a formula instead functions use a
specific<00:01:38.929><c> syntax</c><00:01:39.770><c> that</c><00:01:39.979><c> includes</c><00:01:40.460><c> the</c><00:01:40.640><c> name</c>

00:01:40.840 --> 00:01:40.850 align:start position:0%
specific syntax that includes the name
 

00:01:40.850 --> 00:01:43.359 align:start position:0%
specific syntax that includes the name
of<00:01:41.000><c> the</c><00:01:41.119><c> function</c><00:01:41.570><c> followed</c><00:01:42.409><c> by</c><00:01:42.560><c> one</c><00:01:42.890><c> or</c><00:01:43.159><c> more</c>

00:01:43.359 --> 00:01:43.369 align:start position:0%
of the function followed by one or more
 

00:01:43.369 --> 00:01:46.270 align:start position:0%
of the function followed by one or more
arguments<00:01:43.759><c> in</c><00:01:44.119><c> parentheses</c><00:01:44.179><c> the</c><00:01:45.280><c> arguments</c>

00:01:46.270 --> 00:01:46.280 align:start position:0%
arguments in parentheses the arguments
 

00:01:46.280 --> 00:01:48.340 align:start position:0%
arguments in parentheses the arguments
tell<00:01:46.460><c> the</c><00:01:46.610><c> function</c><00:01:47.060><c> which</c><00:01:47.270><c> cells</c><00:01:47.630><c> or</c><00:01:47.990><c> numbers</c>

00:01:48.340 --> 00:01:48.350 align:start position:0%
tell the function which cells or numbers
 

00:01:48.350 --> 00:01:50.350 align:start position:0%
tell the function which cells or numbers
to<00:01:48.560><c> use</c><00:01:48.770><c> when</c><00:01:49.039><c> calculating</c><00:01:49.670><c> the</c><00:01:49.700><c> result</c><00:01:50.119><c> in</c>

00:01:50.350 --> 00:01:50.360 align:start position:0%
to use when calculating the result in
 

00:01:50.360 --> 00:01:53.169 align:start position:0%
to use when calculating the result in
this<00:01:51.020><c> example</c><00:01:51.409><c> we</c><00:01:51.860><c> only</c><00:01:52.100><c> have</c><00:01:52.399><c> one</c><00:01:52.700><c> argument</c>

00:01:53.169 --> 00:01:53.179 align:start position:0%
this example we only have one argument
 

00:01:53.179 --> 00:01:55.120 align:start position:0%
this example we only have one argument
even<00:01:53.810><c> though</c><00:01:53.960><c> there</c><00:01:54.229><c> are</c><00:01:54.259><c> two</c><00:01:54.560><c> different</c><00:01:54.920><c> cell</c>

00:01:55.120 --> 00:01:55.130 align:start position:0%
even though there are two different cell
 

00:01:55.130 --> 00:01:57.880 align:start position:0%
even though there are two different cell
references<00:01:55.759><c> this</c><00:01:56.450><c> is</c><00:01:56.509><c> called</c><00:01:56.929><c> a</c><00:01:57.170><c> range</c><00:01:57.590><c> of</c>

00:01:57.880 --> 00:01:57.890 align:start position:0%
references this is called a range of
 

00:01:57.890 --> 00:02:01.240 align:start position:0%
references this is called a range of
cells<00:01:58.159><c> or</c><00:01:58.580><c> a</c><00:01:59.090><c> cell</c><00:01:59.420><c> range</c><00:01:59.750><c> a</c><00:02:00.020><c> cell</c><00:02:00.679><c> range</c><00:02:00.950><c> is</c>

00:02:01.240 --> 00:02:01.250 align:start position:0%
cells or a cell range a cell range is
 

00:02:01.250 --> 00:02:02.980 align:start position:0%
cells or a cell range a cell range is
represented<00:02:02.000><c> by</c><00:02:02.119><c> two</c><00:02:02.179><c> different</c><00:02:02.780><c> cell</c>

00:02:02.980 --> 00:02:02.990 align:start position:0%
represented by two different cell
 

00:02:02.990 --> 00:02:05.169 align:start position:0%
represented by two different cell
references<00:02:03.590><c> with</c><00:02:03.829><c> a</c><00:02:03.860><c> colon</c><00:02:04.159><c> in</c><00:02:04.490><c> between</c><00:02:04.520><c> in</c>

00:02:05.169 --> 00:02:05.179 align:start position:0%
references with a colon in between in
 

00:02:05.179 --> 00:02:07.899 align:start position:0%
references with a colon in between in
this<00:02:05.899><c> case</c><00:02:06.140><c> the</c><00:02:06.560><c> range</c><00:02:06.770><c> consists</c><00:02:07.429><c> of</c><00:02:07.490><c> all</c><00:02:07.729><c> the</c>

00:02:07.899 --> 00:02:07.909 align:start position:0%
this case the range consists of all the
 

00:02:07.909 --> 00:02:12.069 align:start position:0%
this case the range consists of all the
cells<00:02:08.179><c> from</c><00:02:08.539><c> d3</c><00:02:09.229><c> through</c><00:02:09.920><c> d12</c><00:02:10.670><c> if</c><00:02:11.030><c> you</c><00:02:11.750><c> want</c><00:02:11.959><c> to</c>

00:02:12.069 --> 00:02:12.079 align:start position:0%
cells from d3 through d12 if you want to
 

00:02:12.079 --> 00:02:13.870 align:start position:0%
cells from d3 through d12 if you want to
use<00:02:12.260><c> more</c><00:02:12.560><c> than</c><00:02:12.620><c> one</c><00:02:12.799><c> argument</c><00:02:13.130><c> you'll</c><00:02:13.700><c> need</c>

00:02:13.870 --> 00:02:13.880 align:start position:0%
use more than one argument you'll need
 

00:02:13.880 --> 00:02:16.750 align:start position:0%
use more than one argument you'll need
to<00:02:14.000><c> separate</c><00:02:14.450><c> each</c><00:02:14.660><c> one</c><00:02:14.959><c> with</c><00:02:15.200><c> a</c><00:02:15.230><c> comma</c><00:02:15.760><c> let's</c>

00:02:16.750 --> 00:02:16.760 align:start position:0%
to separate each one with a comma let's
 

00:02:16.760 --> 00:02:18.460 align:start position:0%
to separate each one with a comma let's
try<00:02:17.030><c> another</c><00:02:17.269><c> function</c><00:02:17.810><c> now</c><00:02:18.019><c> that</c><00:02:18.260><c> has</c><00:02:18.440><c> a</c>

00:02:18.460 --> 00:02:18.470 align:start position:0%
try another function now that has a
 

00:02:18.470 --> 00:02:21.190 align:start position:0%
try another function now that has a
different<00:02:18.799><c> syntax</c><00:02:19.250><c> in</c><00:02:19.640><c> this</c><00:02:20.390><c> example</c><00:02:20.750><c> there's</c>

00:02:21.190 --> 00:02:21.200 align:start position:0%
different syntax in this example there's
 

00:02:21.200 --> 00:02:23.140 align:start position:0%
different syntax in this example there's
a<00:02:21.290><c> column</c><00:02:21.680><c> for</c><00:02:21.890><c> the</c><00:02:21.980><c> date</c><00:02:22.010><c> each</c><00:02:22.430><c> item</c><00:02:22.970><c> was</c>

00:02:23.140 --> 00:02:23.150 align:start position:0%
a column for the date each item was
 

00:02:23.150 --> 00:02:25.360 align:start position:0%
a column for the date each item was
ordered<00:02:23.540><c> and</c><00:02:23.720><c> the</c><00:02:24.290><c> date</c><00:02:24.500><c> each</c><00:02:24.739><c> item</c><00:02:25.190><c> was</c>

00:02:25.360 --> 00:02:25.370 align:start position:0%
ordered and the date each item was
 

00:02:25.370 --> 00:02:27.819 align:start position:0%
ordered and the date each item was
received<00:02:25.549><c> I</c><00:02:26.120><c> want</c><00:02:26.989><c> to</c><00:02:27.079><c> find</c><00:02:27.319><c> out</c><00:02:27.470><c> how</c><00:02:27.769><c> many</c>

00:02:27.819 --> 00:02:27.829 align:start position:0%
received I want to find out how many
 

00:02:27.829 --> 00:02:30.039 align:start position:0%
received I want to find out how many
business<00:02:28.400><c> days</c><00:02:28.610><c> it</c><00:02:28.819><c> took</c><00:02:29.030><c> for</c><00:02:29.239><c> each</c><00:02:29.450><c> order</c><00:02:29.870><c> to</c>

00:02:30.039 --> 00:02:30.049 align:start position:0%
business days it took for each order to
 

00:02:30.049 --> 00:02:32.770 align:start position:0%
business days it took for each order to
arrive<00:02:30.319><c> I</c><00:02:30.680><c> can</c><00:02:31.579><c> use</c><00:02:31.730><c> the</c><00:02:31.940><c> network</c><00:02:32.209><c> day's</c>

00:02:32.770 --> 00:02:32.780 align:start position:0%
arrive I can use the network day's
 

00:02:32.780 --> 00:02:34.660 align:start position:0%
arrive I can use the network day's
function<00:02:33.290><c> to</c><00:02:33.470><c> find</c><00:02:33.650><c> out</c><00:02:33.859><c> how</c><00:02:34.100><c> long</c><00:02:34.160><c> it</c><00:02:34.519><c> took</c>

00:02:34.660 --> 00:02:34.670 align:start position:0%
function to find out how long it took
 

00:02:34.670 --> 00:02:36.970 align:start position:0%
function to find out how long it took
for<00:02:34.730><c> each</c><00:02:35.090><c> delivery</c><00:02:35.569><c> go</c><00:02:36.530><c> back</c><00:02:36.709><c> to</c><00:02:36.889><c> the</c>

00:02:36.970 --> 00:02:36.980 align:start position:0%
for each delivery go back to the
 

00:02:36.980 --> 00:02:39.430 align:start position:0%
for each delivery go back to the
functions<00:02:37.400><c> command</c><00:02:37.870><c> here</c><00:02:38.870><c> you</c><00:02:39.049><c> can</c><00:02:39.230><c> choose</c><00:02:39.410><c> a</c>

00:02:39.430 --> 00:02:39.440 align:start position:0%
functions command here you can choose a
 

00:02:39.440 --> 00:02:42.460 align:start position:0%
functions command here you can choose a
category<00:02:39.680><c> in</c><00:02:40.250><c> this</c><00:02:40.880><c> case</c><00:02:41.120><c> date</c><00:02:41.720><c> to</c><00:02:42.260><c> narrow</c>

00:02:42.460 --> 00:02:42.470 align:start position:0%
category in this case date to narrow
 

00:02:42.470 --> 00:02:45.069 align:start position:0%
category in this case date to narrow
down<00:02:42.680><c> the</c><00:02:42.739><c> choices</c><00:02:43.269><c> you</c><00:02:44.269><c> can</c><00:02:44.420><c> hover</c><00:02:44.600><c> over</c><00:02:45.049><c> each</c>

00:02:45.069 --> 00:02:45.079 align:start position:0%
down the choices you can hover over each
 

00:02:45.079 --> 00:02:46.960 align:start position:0%
down the choices you can hover over each
function<00:02:45.709><c> to</c><00:02:45.859><c> see</c><00:02:46.010><c> a</c><00:02:46.040><c> brief</c><00:02:46.310><c> description</c><00:02:46.639><c> of</c>

00:02:46.960 --> 00:02:46.970 align:start position:0%
function to see a brief description of
 

00:02:46.970 --> 00:02:49.420 align:start position:0%
function to see a brief description of
what<00:02:47.209><c> action</c><00:02:47.630><c> it</c><00:02:47.720><c> performs</c><00:02:48.230><c> just</c><00:02:48.470><c> click</c><00:02:49.400><c> a</c>

00:02:49.420 --> 00:02:49.430 align:start position:0%
what action it performs just click a
 

00:02:49.430 --> 00:02:52.059 align:start position:0%
what action it performs just click a
function<00:02:49.880><c> to</c><00:02:50.030><c> insert</c><00:02:50.359><c> it</c><00:02:50.530><c> you</c><00:02:51.530><c> can</c><00:02:51.709><c> click</c><00:02:51.920><c> the</c>

00:02:52.059 --> 00:02:52.069 align:start position:0%
function to insert it you can click the
 

00:02:52.069 --> 00:02:53.860 align:start position:0%
function to insert it you can click the
question<00:02:52.280><c> mark</c><00:02:52.489><c> next</c><00:02:52.910><c> to</c><00:02:53.090><c> the</c><00:02:53.150><c> cell</c><00:02:53.480><c> to</c><00:02:53.720><c> see</c>

00:02:53.860 --> 00:02:53.870 align:start position:0%
question mark next to the cell to see
 

00:02:53.870 --> 00:02:56.110 align:start position:0%
question mark next to the cell to see
more<00:02:54.109><c> detailed</c><00:02:54.560><c> information</c><00:02:54.940><c> although</c><00:02:55.940><c> this</c>

00:02:56.110 --> 00:02:56.120 align:start position:0%
more detailed information although this
 

00:02:56.120 --> 00:02:58.030 align:start position:0%
more detailed information although this
information<00:02:56.750><c> may</c><00:02:56.959><c> appear</c><00:02:57.290><c> by</c><00:02:57.440><c> default</c><00:02:57.500><c> in</c>

00:02:58.030 --> 00:02:58.040 align:start position:0%
information may appear by default in
 

00:02:58.040 --> 00:03:01.300 align:start position:0%
information may appear by default in
this<00:02:58.850><c> case</c><00:02:59.090><c> we</c><00:02:59.510><c> need</c><00:02:59.660><c> two</c><00:02:59.930><c> arguments</c><00:03:00.530><c> a</c><00:03:00.709><c> start</c>

00:03:01.300 --> 00:03:01.310 align:start position:0%
this case we need two arguments a start
 

00:03:01.310 --> 00:03:03.789 align:start position:0%
this case we need two arguments a start
date<00:03:01.549><c> and</c><00:03:01.790><c> an</c><00:03:02.180><c> end</c><00:03:02.329><c> date</c><00:03:02.510><c> now</c><00:03:03.470><c> I'll</c><00:03:03.769><c> just</c>

00:03:03.789 --> 00:03:03.799 align:start position:0%
date and an end date now I'll just
 

00:03:03.799 --> 00:03:06.340 align:start position:0%
date and an end date now I'll just
select<00:03:04.549><c> the</c><00:03:04.730><c> start</c><00:03:05.060><c> date</c><00:03:05.120><c> and</c><00:03:05.389><c> the</c><00:03:05.780><c> end</c><00:03:05.930><c> date</c>

00:03:06.340 --> 00:03:06.350 align:start position:0%
select the start date and the end date
 

00:03:06.350 --> 00:03:08.410 align:start position:0%
select the start date and the end date
make<00:03:07.100><c> sure</c><00:03:07.280><c> to</c><00:03:07.400><c> separate</c><00:03:07.790><c> them</c><00:03:07.970><c> with</c><00:03:08.150><c> a</c><00:03:08.180><c> comma</c>

00:03:08.410 --> 00:03:08.420 align:start position:0%
make sure to separate them with a comma
 

00:03:08.420 --> 00:03:10.270 align:start position:0%
make sure to separate them with a comma
and<00:03:08.780><c> make</c><00:03:09.319><c> sure</c><00:03:09.470><c> it</c><00:03:09.590><c> has</c><00:03:09.769><c> a</c><00:03:09.799><c> closing</c>

00:03:10.270 --> 00:03:10.280 align:start position:0%
and make sure it has a closing
 

00:03:10.280 --> 00:03:12.550 align:start position:0%
and make sure it has a closing
parenthesis

00:03:12.550 --> 00:03:12.560 align:start position:0%
 
 

00:03:12.560 --> 00:03:14.590 align:start position:0%
 
remember<00:03:13.310><c> that</c><00:03:13.490><c> in</c><00:03:13.640><c> order</c><00:03:13.880><c> for</c><00:03:14.150><c> the</c><00:03:14.240><c> function</c>

00:03:14.590 --> 00:03:14.600 align:start position:0%
remember that in order for the function
 

00:03:14.600 --> 00:03:17.199 align:start position:0%
remember that in order for the function
to<00:03:14.720><c> work</c><00:03:14.900><c> the</c><00:03:15.230><c> syntax</c><00:03:15.680><c> must</c><00:03:16.220><c> be</c><00:03:16.430><c> exact</c>

00:03:17.199 --> 00:03:17.209 align:start position:0%
to work the syntax must be exact
 

00:03:17.209 --> 00:03:19.600 align:start position:0%
to work the syntax must be exact
if<00:03:17.270><c> you</c><00:03:17.870><c> enter</c><00:03:18.170><c> a</c><00:03:18.200><c> function</c><00:03:18.410><c> incorrectly</c><00:03:19.280><c> you</c>

00:03:19.600 --> 00:03:19.610 align:start position:0%
if you enter a function incorrectly you
 

00:03:19.610 --> 00:03:21.430 align:start position:0%
if you enter a function incorrectly you
can<00:03:19.640><c> click</c><00:03:20.000><c> the</c><00:03:20.180><c> cell</c><00:03:20.420><c> and</c><00:03:20.690><c> a</c><00:03:20.959><c> window</c><00:03:21.260><c> will</c>

00:03:21.430 --> 00:03:21.440 align:start position:0%
can click the cell and a window will
 

00:03:21.440 --> 00:03:22.870 align:start position:0%
can click the cell and a window will
appear<00:03:21.590><c> telling</c><00:03:22.190><c> you</c><00:03:22.310><c> what</c><00:03:22.550><c> the</c><00:03:22.700><c> function</c>

00:03:22.870 --> 00:03:22.880 align:start position:0%
appear telling you what the function
 

00:03:22.880 --> 00:03:25.740 align:start position:0%
appear telling you what the function
needs

00:03:25.740 --> 00:03:25.750 align:start position:0%
 
 

00:03:25.750 --> 00:03:28.020 align:start position:0%
 
so<00:03:25.870><c> just</c><00:03:26.230><c> like</c><00:03:26.380><c> with</c><00:03:26.530><c> formulas</c><00:03:27.130><c> you</c><00:03:27.580><c> can</c><00:03:27.610><c> copy</c>

00:03:28.020 --> 00:03:28.030 align:start position:0%
so just like with formulas you can copy
 

00:03:28.030 --> 00:03:30.150 align:start position:0%
so just like with formulas you can copy
the<00:03:28.270><c> function</c><00:03:28.690><c> to</c><00:03:28.840><c> other</c><00:03:29.020><c> cells</c><00:03:29.350><c> by</c><00:03:29.650><c> using</c><00:03:29.680><c> the</c>

00:03:30.150 --> 00:03:30.160 align:start position:0%
the function to other cells by using the
 

00:03:30.160 --> 00:03:31.650 align:start position:0%
the function to other cells by using the
fill<00:03:30.340><c> handle</c>

00:03:31.650 --> 00:03:31.660 align:start position:0%
fill handle
 

00:03:31.660 --> 00:03:33.630 align:start position:0%
fill handle
and<00:03:31.750><c> now</c><00:03:32.110><c> we</c><00:03:32.170><c> can</c><00:03:32.440><c> see</c><00:03:32.650><c> the</c><00:03:32.800><c> number</c><00:03:33.100><c> of</c><00:03:33.130><c> days</c><00:03:33.430><c> it</c>

00:03:33.630 --> 00:03:33.640 align:start position:0%
and now we can see the number of days it
 

00:03:33.640 --> 00:03:35.930 align:start position:0%
and now we can see the number of days it
took<00:03:33.790><c> for</c><00:03:34.030><c> each</c><00:03:34.270><c> item</c><00:03:34.690><c> to</c><00:03:34.720><c> be</c><00:03:34.930><c> delivered</c><00:03:34.960><c> if</c>

00:03:35.930 --> 00:03:35.940 align:start position:0%
took for each item to be delivered if
 

00:03:35.940 --> 00:03:38.460 align:start position:0%
took for each item to be delivered if
functions<00:03:36.940><c> are</c><00:03:37.090><c> new</c><00:03:37.270><c> to</c><00:03:37.450><c> you</c><00:03:37.630><c> the</c><00:03:37.930><c> syntax</c><00:03:38.140><c> for</c>

00:03:38.460 --> 00:03:38.470 align:start position:0%
functions are new to you the syntax for
 

00:03:38.470 --> 00:03:40.950 align:start position:0%
functions are new to you the syntax for
some<00:03:38.830><c> may</c><00:03:39.190><c> look</c><00:03:39.400><c> complicated</c><00:03:39.820><c> and</c><00:03:40.270><c> strange</c><00:03:40.630><c> if</c>

00:03:40.950 --> 00:03:40.960 align:start position:0%
some may look complicated and strange if
 

00:03:40.960 --> 00:03:43.560 align:start position:0%
some may look complicated and strange if
you<00:03:41.380><c> are</c><00:03:41.650><c> unsure</c><00:03:42.130><c> of</c><00:03:42.160><c> when</c><00:03:42.640><c> or</c><00:03:43.000><c> how</c><00:03:43.210><c> to</c><00:03:43.270><c> use</c><00:03:43.540><c> a</c>

00:03:43.560 --> 00:03:43.570 align:start position:0%
you are unsure of when or how to use a
 

00:03:43.570 --> 00:03:45.750 align:start position:0%
you are unsure of when or how to use a
particular<00:03:43.840><c> function</c><00:03:44.650><c> it's</c><00:03:44.950><c> probably</c><00:03:45.520><c> a</c><00:03:45.550><c> good</c>

00:03:45.750 --> 00:03:45.760 align:start position:0%
particular function it's probably a good
 

00:03:45.760 --> 00:03:48.030 align:start position:0%
particular function it's probably a good
idea<00:03:45.820><c> to</c><00:03:46.150><c> skip</c><00:03:46.570><c> it</c><00:03:46.720><c> however</c><00:03:47.470><c> if</c><00:03:47.770><c> you're</c>

00:03:48.030 --> 00:03:48.040 align:start position:0%
idea to skip it however if you're
 

00:03:48.040 --> 00:03:49.950 align:start position:0%
idea to skip it however if you're
familiar<00:03:48.280><c> with</c><00:03:48.580><c> more</c><00:03:48.910><c> common</c><00:03:49.330><c> actions</c><00:03:49.750><c> like</c>

00:03:49.950 --> 00:03:49.960 align:start position:0%
familiar with more common actions like
 

00:03:49.960 --> 00:03:52.260 align:start position:0%
familiar with more common actions like
sum<00:03:50.290><c> or</c><00:03:50.560><c> average</c><00:03:50.830><c> look</c><00:03:51.490><c> closely</c><00:03:51.820><c> at</c><00:03:52.120><c> the</c>

00:03:52.260 --> 00:03:52.270 align:start position:0%
sum or average look closely at the
 

00:03:52.270 --> 00:03:54.600 align:start position:0%
sum or average look closely at the
syntax<00:03:52.630><c> and</c><00:03:52.990><c> give</c><00:03:53.260><c> functions</c><00:03:53.710><c> a</c><00:03:53.800><c> try</c><00:03:54.010><c> they</c>

00:03:54.600 --> 00:03:54.610 align:start position:0%
syntax and give functions a try they
 

00:03:54.610 --> 00:04:00.460 align:start position:0%
syntax and give functions a try they
might<00:03:54.820><c> just</c><00:03:55.000><c> be</c><00:03:55.090><c> easier</c><00:03:55.540><c> than</c><00:03:55.780><c> you</c><00:03:55.840><c> thought</c>

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

00:04:00.470 --> 00:04:04.190 align:start position:0%
 
GCF<00:04:01.470><c> global</c><00:04:02.150><c> creating</c><00:04:03.150><c> opportunities</c><00:04:03.810><c> for</c><00:04:04.140><c> a</c>

00:04:04.190 --> 00:04:04.200 align:start position:0%
GCF global creating opportunities for a
 

00:04:04.200 --> 00:04:06.709 align:start position:0%
GCF global creating opportunities for a
better<00:04:04.260><c> life</c>