WEBVTT
Kind: captions
Language: en

00:00:00.000 --> 00:00:02.180 align:start position:0%
 
I'm<00:00:00.120><c> going</c><00:00:00.750><c> to</c><00:00:00.840><c> show</c><00:00:00.989><c> you</c><00:00:01.050><c> a</c><00:00:01.199><c> quick</c><00:00:01.620><c> way</c><00:00:01.860><c> to</c><00:00:01.890><c> use</c>

00:00:02.180 --> 00:00:02.190 align:start position:0%
I'm going to show you a quick way to use
 

00:00:02.190 --> 00:00:04.849 align:start position:0%
I'm going to show you a quick way to use
an<00:00:02.340><c> entire</c><00:00:02.730><c> column</c><00:00:03.300><c> in</c><00:00:03.480><c> a</c><00:00:03.570><c> cell</c><00:00:03.780><c> range</c><00:00:04.020><c> you</c><00:00:04.740><c> can</c>

00:00:04.849 --> 00:00:04.859 align:start position:0%
an entire column in a cell range you can
 

00:00:04.859 --> 00:00:06.980 align:start position:0%
an entire column in a cell range you can
use<00:00:05.009><c> this</c><00:00:05.160><c> in</c><00:00:05.370><c> many</c><00:00:05.670><c> situations</c><00:00:06.420><c> for</c><00:00:06.930><c> example</c>

00:00:06.980 --> 00:00:06.990 align:start position:0%
use this in many situations for example
 

00:00:06.990 --> 00:00:09.980 align:start position:0%
use this in many situations for example
finding<00:00:07.799><c> the</c><00:00:07.980><c> sum</c><00:00:08.250><c> or</c><00:00:08.490><c> average</c><00:00:08.910><c> of</c><00:00:09.450><c> all</c><00:00:09.719><c> of</c><00:00:09.900><c> the</c>

00:00:09.980 --> 00:00:09.990 align:start position:0%
finding the sum or average of all of the
 

00:00:09.990 --> 00:00:12.589 align:start position:0%
finding the sum or average of all of the
values<00:00:10.349><c> in</c><00:00:10.380><c> the</c><00:00:10.710><c> column</c><00:00:11.150><c> let's</c><00:00:12.150><c> say</c><00:00:12.300><c> I</c><00:00:12.360><c> want</c><00:00:12.570><c> to</c>

00:00:12.589 --> 00:00:12.599 align:start position:0%
values in the column let's say I want to
 

00:00:12.599 --> 00:00:15.340 align:start position:0%
values in the column let's say I want to
find<00:00:12.840><c> the</c><00:00:12.960><c> sum</c><00:00:13.290><c> of</c><00:00:13.469><c> all</c><00:00:13.799><c> of</c><00:00:14.009><c> the</c><00:00:14.160><c> January</c><00:00:14.670><c> sales</c>

00:00:15.340 --> 00:00:15.350 align:start position:0%
find the sum of all of the January sales
 

00:00:15.350 --> 00:00:19.160 align:start position:0%
find the sum of all of the January sales
first<00:00:16.350><c> I'll</c><00:00:16.590><c> type</c><00:00:16.800><c> sum</c><00:00:17.250><c> and</c><00:00:17.600><c> open</c><00:00:18.600><c> parenthesis</c>

00:00:19.160 --> 00:00:19.170 align:start position:0%
first I'll type sum and open parenthesis
 

00:00:19.170 --> 00:00:22.010 align:start position:0%
first I'll type sum and open parenthesis
and<00:00:19.699><c> then</c><00:00:20.699><c> to</c><00:00:20.820><c> create</c><00:00:21.029><c> the</c><00:00:21.150><c> argument</c><00:00:21.840><c> we're</c>

00:00:22.010 --> 00:00:22.020 align:start position:0%
and then to create the argument we're
 

00:00:22.020 --> 00:00:23.929 align:start position:0%
and then to create the argument we're
going<00:00:22.050><c> to</c><00:00:22.260><c> click</c><00:00:22.560><c> near</c><00:00:22.800><c> the</c><00:00:22.949><c> column</c><00:00:23.369><c> letter</c><00:00:23.670><c> in</c>

00:00:23.929 --> 00:00:23.939 align:start position:0%
going to click near the column letter in
 

00:00:23.939 --> 00:00:28.160 align:start position:0%
going to click near the column letter in
this<00:00:24.330><c> area</c><00:00:24.630><c> is</c><00:00:24.779><c> called</c><00:00:25.050><c> the</c><00:00:25.260><c> column</c><00:00:25.500><c> heading</c>

00:00:28.160 --> 00:00:28.170 align:start position:0%
 
 

00:00:28.170 --> 00:00:31.640 align:start position:0%
 
it's<00:00:28.530><c> added</c><00:00:28.860><c> C</c><00:00:29.190><c> :</c><00:00:29.760><c> C</c><00:00:30.060><c> to</c><00:00:30.330><c> our</c><00:00:30.450><c> formula</c><00:00:30.810><c> which</c>

00:00:31.640 --> 00:00:31.650 align:start position:0%
it's added C : C to our formula which
 

00:00:31.650 --> 00:00:32.960 align:start position:0%
it's added C : C to our formula which
may<00:00:31.890><c> look</c><00:00:32.099><c> a</c><00:00:32.189><c> little</c><00:00:32.220><c> bit</c><00:00:32.520><c> different</c><00:00:32.880><c> from</c>

00:00:32.960 --> 00:00:32.970 align:start position:0%
may look a little bit different from
 

00:00:32.970 --> 00:00:35.060 align:start position:0%
may look a little bit different from
other<00:00:33.270><c> cell</c><00:00:33.540><c> ranges</c><00:00:33.900><c> that</c><00:00:33.989><c> you've</c><00:00:34.140><c> seen</c><00:00:34.410><c> but</c>

00:00:35.060 --> 00:00:35.070 align:start position:0%
other cell ranges that you've seen but
 

00:00:35.070 --> 00:00:36.770 align:start position:0%
other cell ranges that you've seen but
it<00:00:35.250><c> means</c><00:00:35.400><c> it's</c><00:00:35.670><c> going</c><00:00:35.850><c> to</c><00:00:36.000><c> pull</c><00:00:36.180><c> in</c><00:00:36.210><c> all</c><00:00:36.570><c> of</c>

00:00:36.770 --> 00:00:36.780 align:start position:0%
it means it's going to pull in all of
 

00:00:36.780 --> 00:00:39.799 align:start position:0%
it means it's going to pull in all of
the<00:00:36.870><c> cells</c><00:00:37.110><c> in</c><00:00:37.380><c> column</c><00:00:37.410><c> C</c><00:00:38.630><c> close</c><00:00:39.630><c> the</c>

00:00:39.799 --> 00:00:39.809 align:start position:0%
the cells in column C close the
 

00:00:39.809 --> 00:00:42.840 align:start position:0%
the cells in column C close the
parentheses<00:00:40.320><c> and</c><00:00:40.500><c> press</c><00:00:40.920><c> Enter</c>

00:00:42.840 --> 00:00:42.850 align:start position:0%
parentheses and press Enter
 

00:00:42.850 --> 00:00:46.229 align:start position:0%
parentheses and press Enter
and<00:00:42.940><c> there's</c><00:00:43.510><c> our</c><00:00:43.660><c> some</c><00:00:44.730><c> let's</c><00:00:45.730><c> try</c><00:00:45.910><c> one</c><00:00:46.210><c> more</c>

00:00:46.229 --> 00:00:46.239 align:start position:0%
and there's our some let's try one more
 

00:00:46.239 --> 00:00:49.340 align:start position:0%
and there's our some let's try one more
with<00:00:46.780><c> the</c><00:00:46.960><c> average</c><00:00:47.410><c> function</c>

00:00:49.340 --> 00:00:49.350 align:start position:0%
with the average function
 

00:00:49.350 --> 00:00:51.319 align:start position:0%
with the average function
if<00:00:49.410><c> we</c><00:00:49.829><c> want</c><00:00:50.010><c> to</c><00:00:50.039><c> find</c><00:00:50.219><c> the</c><00:00:50.370><c> average</c><00:00:50.550><c> of</c><00:00:51.090><c> the</c>

00:00:51.319 --> 00:00:51.329 align:start position:0%
if we want to find the average of the
 

00:00:51.329 --> 00:00:53.450 align:start position:0%
if we want to find the average of the
March<00:00:51.570><c> sales</c><00:00:51.870><c> we'll</c><00:00:52.469><c> just</c><00:00:52.710><c> click</c><00:00:52.980><c> at</c><00:00:53.190><c> the</c><00:00:53.280><c> top</c>

00:00:53.450 --> 00:00:53.460 align:start position:0%
March sales we'll just click at the top
 

00:00:53.460 --> 00:00:58.069 align:start position:0%
March sales we'll just click at the top
of<00:00:53.609><c> column</c><00:00:53.820><c> E</c><00:00:54.859><c> so</c><00:00:55.859><c> our</c><00:00:55.980><c> argument</c><00:00:56.190><c> is</c><00:00:56.579><c> e</c><00:00:56.850><c> :</c><00:00:57.600><c> e</c><00:00:57.839><c> and</c>

00:00:58.069 --> 00:00:58.079 align:start position:0%
of column E so our argument is e : e and
 

00:00:58.079 --> 00:01:00.619 align:start position:0%
of column E so our argument is e : e and
you<00:00:58.110><c> can</c><00:00:59.039><c> type</c><00:00:59.280><c> this</c><00:00:59.519><c> or</c><00:00:59.789><c> click</c><00:01:00.180><c> the</c><00:01:00.300><c> column</c>

00:01:00.619 --> 00:01:00.629 align:start position:0%
you can type this or click the column
 

00:01:00.629 --> 00:01:03.259 align:start position:0%
you can type this or click the column
heading<00:01:00.960><c> it's</c><00:01:01.140><c> really</c><00:01:01.379><c> up</c><00:01:01.500><c> to</c><00:01:01.530><c> you</c><00:01:02.030><c> then</c><00:01:03.030><c> just</c>

00:01:03.259 --> 00:01:03.269 align:start position:0%
heading it's really up to you then just
 

00:01:03.269 --> 00:01:06.399 align:start position:0%
heading it's really up to you then just
close<00:01:03.510><c> the</c><00:01:03.719><c> parentheses</c><00:01:04.199><c> and</c><00:01:04.379><c> press</c><00:01:04.619><c> Enter</c>

00:01:06.399 --> 00:01:06.409 align:start position:0%
close the parentheses and press Enter
 

00:01:06.409 --> 00:01:08.740 align:start position:0%
close the parentheses and press Enter
and<00:01:06.499><c> there's</c><00:01:07.039><c> our</c><00:01:07.159><c> average</c>

00:01:08.740 --> 00:01:08.750 align:start position:0%
and there's our average
 

00:01:08.750 --> 00:01:10.870 align:start position:0%
and there's our average
I'm<00:01:08.810><c> going</c><00:01:09.560><c> to</c><00:01:09.650><c> double-click</c><00:01:10.010><c> the</c><00:01:10.340><c> formula</c><00:01:10.730><c> so</c>

00:01:10.870 --> 00:01:10.880 align:start position:0%
I'm going to double-click the formula so
 

00:01:10.880 --> 00:01:13.840 align:start position:0%
I'm going to double-click the formula so
we<00:01:10.970><c> can</c><00:01:11.120><c> take</c><00:01:11.270><c> a</c><00:01:11.300><c> closer</c><00:01:11.630><c> look</c><00:01:11.780><c> if</c><00:01:12.710><c> I</c><00:01:13.550><c> scroll</c>

00:01:13.840 --> 00:01:13.850 align:start position:0%
we can take a closer look if I scroll
 

00:01:13.850 --> 00:01:15.700 align:start position:0%
we can take a closer look if I scroll
down<00:01:13.910><c> you</c><00:01:14.450><c> can</c><00:01:14.540><c> see</c><00:01:14.660><c> that</c><00:01:14.900><c> it</c><00:01:15.170><c> selected</c><00:01:15.650><c> the</c>

00:01:15.700 --> 00:01:15.710 align:start position:0%
down you can see that it selected the
 

00:01:15.710 --> 00:01:18.160 align:start position:0%
down you can see that it selected the
whole<00:01:16.040><c> column</c><00:01:16.550><c> including</c><00:01:17.420><c> all</c><00:01:17.630><c> of</c><00:01:17.660><c> the</c><00:01:17.870><c> empty</c>

00:01:18.160 --> 00:01:18.170 align:start position:0%
whole column including all of the empty
 

00:01:18.170 --> 00:01:20.530 align:start position:0%
whole column including all of the empty
cells<00:01:18.440><c> below</c><00:01:18.890><c> the</c><00:01:18.920><c> data</c><00:01:19.280><c> this</c><00:01:20.150><c> is</c><00:01:20.330><c> good</c>

00:01:20.530 --> 00:01:20.540 align:start position:0%
cells below the data this is good
 

00:01:20.540 --> 00:01:22.240 align:start position:0%
cells below the data this is good
because<00:01:20.750><c> it</c><00:01:21.020><c> means</c><00:01:21.140><c> we</c><00:01:21.350><c> can</c><00:01:21.500><c> add</c><00:01:21.680><c> more</c><00:01:22.010><c> data</c>

00:01:22.240 --> 00:01:22.250 align:start position:0%
because it means we can add more data
 

00:01:22.250 --> 00:01:24.430 align:start position:0%
because it means we can add more data
later<00:01:22.640><c> on</c><00:01:22.880><c> and</c><00:01:23.210><c> it</c><00:01:23.540><c> will</c><00:01:23.630><c> automatically</c><00:01:24.200><c> be</c>

00:01:24.430 --> 00:01:24.440 align:start position:0%
later on and it will automatically be
 

00:01:24.440 --> 00:01:26.980 align:start position:0%
later on and it will automatically be
included<00:01:24.560><c> in</c><00:01:25.070><c> our</c><00:01:25.160><c> formula</c><00:01:25.670><c> on</c><00:01:25.880><c> the</c><00:01:26.840><c> other</c>

00:01:26.980 --> 00:01:26.990 align:start position:0%
included in our formula on the other
 

00:01:26.990 --> 00:01:28.840 align:start position:0%
included in our formula on the other
hand<00:01:27.320><c> it</c><00:01:27.500><c> also</c><00:01:27.740><c> means</c><00:01:28.130><c> we</c><00:01:28.250><c> need</c><00:01:28.400><c> to</c><00:01:28.490><c> make</c><00:01:28.640><c> sure</c>

00:01:28.840 --> 00:01:28.850 align:start position:0%
hand it also means we need to make sure
 

00:01:28.850 --> 00:01:30.250 align:start position:0%
hand it also means we need to make sure
that<00:01:29.030><c> we're</c><00:01:29.180><c> not</c><00:01:29.210><c> adding</c><00:01:29.720><c> any</c><00:01:29.900><c> kind</c><00:01:30.200><c> of</c>

00:01:30.250 --> 00:01:30.260 align:start position:0%
that we're not adding any kind of
 

00:01:30.260 --> 00:01:32.200 align:start position:0%
that we're not adding any kind of
unrelated<00:01:30.950><c> data</c><00:01:31.100><c> here</c><00:01:31.460><c> that</c><00:01:31.490><c> we</c><00:01:31.700><c> don't</c><00:01:31.910><c> want</c>

00:01:32.200 --> 00:01:32.210 align:start position:0%
unrelated data here that we don't want
 

00:01:32.210 --> 00:01:35.020 align:start position:0%
unrelated data here that we don't want
included<00:01:33.010><c> so</c><00:01:34.010><c> you</c><00:01:34.040><c> do</c><00:01:34.250><c> have</c><00:01:34.280><c> to</c><00:01:34.460><c> be</c><00:01:34.640><c> careful</c>

00:01:35.020 --> 00:01:35.030 align:start position:0%
included so you do have to be careful
 

00:01:35.030 --> 00:01:36.310 align:start position:0%
included so you do have to be careful
when<00:01:35.150><c> you're</c><00:01:35.240><c> using</c><00:01:35.479><c> a</c><00:01:35.630><c> whole</c><00:01:35.780><c> column</c><00:01:36.140><c> in</c><00:01:36.260><c> a</c>

00:01:36.310 --> 00:01:36.320 align:start position:0%
when you're using a whole column in a
 

00:01:36.320 --> 00:01:37.840 align:start position:0%
when you're using a whole column in a
cell<00:01:36.500><c> range</c><00:01:36.710><c> but</c><00:01:37.310><c> it's</c><00:01:37.460><c> still</c><00:01:37.580><c> a</c><00:01:37.640><c> great</c>

00:01:37.840 --> 00:01:37.850 align:start position:0%
cell range but it's still a great
 

00:01:37.850 --> 00:01:42.170 align:start position:0%
cell range but it's still a great
shortcut<00:01:38.479><c> to</c><00:01:38.600><c> use</c>

00:01:42.170 --> 00:01:42.180 align:start position:0%
 
 

00:01:42.180 --> 00:01:44.540 align:start position:0%
 
Goodwill<00:01:42.960><c> Community</c><00:01:43.410><c> Foundation</c><00:01:44.070><c> creating</c>

00:01:44.540 --> 00:01:44.550 align:start position:0%
Goodwill Community Foundation creating
 

00:01:44.550 --> 00:01:47.630 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:01:45.120><c> for</c><00:01:45.330><c> a</c><00:01:45.420><c> better</c><00:01:45.450><c> life</c>