WEBVTT
Kind: captions
Language: en

00:00:00.000 --> 00:00:01.910 align:start position:0%
 
what<00:00:00.480><c> if</c><00:00:00.570><c> I</c><00:00:00.690><c> told</c><00:00:00.900><c> you</c><00:00:01.140><c> you</c><00:00:01.350><c> could</c><00:00:01.500><c> find</c><00:00:01.740><c> the</c>

00:00:01.910 --> 00:00:01.920 align:start position:0%
what if I told you you could find the
 

00:00:01.920 --> 00:00:04.490 align:start position:0%
what if I told you you could find the
some<00:00:02.280><c> average</c><00:00:03.030><c> or</c><00:00:03.240><c> count</c><00:00:03.300><c> of</c><00:00:03.959><c> cell</c><00:00:04.230><c> range</c>

00:00:04.490 --> 00:00:04.500 align:start position:0%
some average or count of cell range
 

00:00:04.500 --> 00:00:07.730 align:start position:0%
some average or count of cell range
without<00:00:04.920><c> using</c><00:00:05.549><c> a</c><00:00:05.700><c> single</c><00:00:06.120><c> formula</c><00:00:06.390><c> it's</c><00:00:07.379><c> true</c>

00:00:07.730 --> 00:00:07.740 align:start position:0%
without using a single formula it's true
 

00:00:07.740 --> 00:00:10.549 align:start position:0%
without using a single formula it's true
and<00:00:07.950><c> it's</c><00:00:08.370><c> very</c><00:00:08.700><c> easy</c><00:00:08.790><c> to</c><00:00:09.059><c> do</c><00:00:09.300><c> in</c><00:00:09.540><c> fact</c><00:00:10.260><c> you</c>

00:00:10.549 --> 00:00:10.559 align:start position:0%
and it's very easy to do in fact you
 

00:00:10.559 --> 00:00:12.680 align:start position:0%
and it's very easy to do in fact you
don't<00:00:10.740><c> really</c><00:00:11.010><c> have</c><00:00:11.219><c> to</c><00:00:11.400><c> do</c><00:00:11.639><c> anything</c><00:00:12.059><c> because</c>

00:00:12.680 --> 00:00:12.690 align:start position:0%
don't really have to do anything because
 

00:00:12.690 --> 00:00:14.299 align:start position:0%
don't really have to do anything because
Excel<00:00:13.259><c> runs</c><00:00:13.530><c> these</c><00:00:13.740><c> calculations</c>

00:00:14.299 --> 00:00:14.309 align:start position:0%
Excel runs these calculations
 

00:00:14.309 --> 00:00:16.820 align:start position:0%
Excel runs these calculations
automatically<00:00:15.210><c> whenever</c><00:00:15.960><c> you</c><00:00:16.170><c> select</c><00:00:16.379><c> a</c><00:00:16.650><c> cell</c>

00:00:16.820 --> 00:00:16.830 align:start position:0%
automatically whenever you select a cell
 

00:00:16.830 --> 00:00:19.550 align:start position:0%
automatically whenever you select a cell
range<00:00:17.010><c> and</c><00:00:17.310><c> it</c><00:00:18.119><c> displays</c><00:00:18.539><c> the</c><00:00:18.720><c> results</c><00:00:19.170><c> here</c>

00:00:19.550 --> 00:00:19.560 align:start position:0%
range and it displays the results here
 

00:00:19.560 --> 00:00:22.820 align:start position:0%
range and it displays the results here
near<00:00:19.920><c> the</c><00:00:20.039><c> lower</c><00:00:20.250><c> right</c><00:00:20.520><c> corner</c><00:00:20.550><c> for</c><00:00:21.830><c> example</c>

00:00:22.820 --> 00:00:22.830 align:start position:0%
near the lower right corner for example
 

00:00:22.830 --> 00:00:25.550 align:start position:0%
near the lower right corner for example
I<00:00:23.279><c> have</c><00:00:23.430><c> some</c><00:00:23.609><c> basketball</c><00:00:24.090><c> stats</c><00:00:24.480><c> and</c><00:00:24.810><c> I</c><00:00:25.380><c> can</c>

00:00:25.550 --> 00:00:25.560 align:start position:0%
I have some basketball stats and I can
 

00:00:25.560 --> 00:00:27.740 align:start position:0%
I have some basketball stats and I can
select<00:00:25.890><c> any</c><00:00:26.189><c> column</c><00:00:26.670><c> of</c><00:00:26.789><c> data</c><00:00:26.939><c> to</c><00:00:27.210><c> quickly</c><00:00:27.449><c> see</c>

00:00:27.740 --> 00:00:27.750 align:start position:0%
select any column of data to quickly see
 

00:00:27.750 --> 00:00:29.390 align:start position:0%
select any column of data to quickly see
the<00:00:27.779><c> total</c><00:00:28.199><c> points</c><00:00:28.560><c> scored</c><00:00:28.859><c> in</c><00:00:29.039><c> a</c><00:00:29.189><c> specific</c>

00:00:29.390 --> 00:00:29.400 align:start position:0%
the total points scored in a specific
 

00:00:29.400 --> 00:00:31.760 align:start position:0%
the total points scored in a specific
game

00:00:31.760 --> 00:00:31.770 align:start position:0%
game
 

00:00:31.770 --> 00:00:34.130 align:start position:0%
game
I<00:00:31.830><c> can</c><00:00:32.310><c> also</c><00:00:32.430><c> select</c><00:00:32.730><c> a</c><00:00:32.970><c> specific</c><00:00:33.180><c> players</c><00:00:33.780><c> row</c>

00:00:34.130 --> 00:00:34.140 align:start position:0%
I can also select a specific players row
 

00:00:34.140 --> 00:00:36.290 align:start position:0%
I can also select a specific players row
to<00:00:34.680><c> see</c><00:00:34.860><c> the</c><00:00:35.010><c> total</c><00:00:35.340><c> points</c><00:00:35.670><c> scored</c><00:00:36.000><c> by</c><00:00:36.060><c> that</c>

00:00:36.290 --> 00:00:36.300 align:start position:0%
to see the total points scored by that
 

00:00:36.300 --> 00:00:40.420 align:start position:0%
to see the total points scored by that
player<00:00:36.540><c> or</c><00:00:37.200><c> their</c><00:00:37.650><c> average</c><00:00:37.980><c> points</c><00:00:38.340><c> per</c><00:00:38.400><c> game</c>

00:00:40.420 --> 00:00:40.430 align:start position:0%
player or their average points per game
 

00:00:40.430 --> 00:00:43.000 align:start position:0%
player or their average points per game
when<00:00:41.150><c> selecting</c><00:00:41.630><c> text</c><00:00:41.870><c> values</c><00:00:42.410><c> it</c><00:00:42.620><c> won't</c><00:00:42.860><c> show</c>

00:00:43.000 --> 00:00:43.010 align:start position:0%
when selecting text values it won't show
 

00:00:43.010 --> 00:00:45.370 align:start position:0%
when selecting text values it won't show
a<00:00:43.040><c> sum</c><00:00:43.370><c> or</c><00:00:43.580><c> average</c><00:00:43.790><c> but</c><00:00:44.600><c> it</c><00:00:44.840><c> still</c><00:00:45.110><c> shows</c><00:00:45.320><c> the</c>

00:00:45.370 --> 00:00:45.380 align:start position:0%
a sum or average but it still shows the
 

00:00:45.380 --> 00:00:47.770 align:start position:0%
a sum or average but it still shows the
count<00:00:45.800><c> which</c><00:00:46.430><c> we</c><00:00:46.610><c> could</c><00:00:46.790><c> use</c><00:00:46.820><c> to</c><00:00:47.000><c> quickly</c><00:00:47.420><c> see</c>

00:00:47.770 --> 00:00:47.780 align:start position:0%
count which we could use to quickly see
 

00:00:47.780 --> 00:00:50.490 align:start position:0%
count which we could use to quickly see
how<00:00:48.050><c> many</c><00:00:48.230><c> players</c><00:00:48.470><c> are</c><00:00:48.740><c> on</c><00:00:48.770><c> the</c><00:00:49.010><c> team</c>

00:00:50.490 --> 00:00:50.500 align:start position:0%
how many players are on the team
 

00:00:50.500 --> 00:00:52.350 align:start position:0%
how many players are on the team
now<00:00:51.130><c> it's</c><00:00:51.280><c> still</c><00:00:51.430><c> a</c><00:00:51.490><c> good</c><00:00:51.730><c> idea</c><00:00:52.030><c> to</c><00:00:52.210><c> create</c>

00:00:52.350 --> 00:00:52.360 align:start position:0%
now it's still a good idea to create
 

00:00:52.360 --> 00:00:54.060 align:start position:0%
now it's still a good idea to create
formulas<00:00:52.990><c> for</c><00:00:53.170><c> calculations</c><00:00:53.800><c> that</c><00:00:53.890><c> you'll</c>

00:00:54.060 --> 00:00:54.070 align:start position:0%
formulas for calculations that you'll
 

00:00:54.070 --> 00:00:56.550 align:start position:0%
formulas for calculations that you'll
use<00:00:54.280><c> over</c><00:00:54.460><c> and</c><00:00:54.790><c> over</c><00:00:54.880><c> but</c><00:00:55.750><c> if</c><00:00:55.960><c> you</c><00:00:56.110><c> just</c><00:00:56.350><c> need</c>

00:00:56.550 --> 00:00:56.560 align:start position:0%
use over and over but if you just need
 

00:00:56.560 --> 00:00:58.380 align:start position:0%
use over and over but if you just need
some<00:00:56.830><c> quick</c><00:00:57.100><c> info</c><00:00:57.490><c> about</c><00:00:57.610><c> your</c><00:00:57.880><c> spreadsheet</c>

00:00:58.380 --> 00:00:58.390 align:start position:0%
some quick info about your spreadsheet
 

00:00:58.390 --> 00:01:04.390 align:start position:0%
some quick info about your spreadsheet
this<00:00:58.810><c> is</c><00:00:58.990><c> a</c><00:00:59.020><c> fast</c><00:00:59.440><c> and</c><00:00:59.740><c> easy</c><00:00:59.950><c> feature</c><00:01:00.340><c> to</c><00:01:00.640><c> use</c>

00:01:04.390 --> 00:01:04.400 align:start position:0%
 
 

00:01:04.400 --> 00:01:06.760 align:start position:0%
 
Goodwill<00:01:05.180><c> Community</c><00:01:05.660><c> Foundation</c><00:01:06.320><c> creating</c>

00:01:06.760 --> 00:01:06.770 align:start position:0%
Goodwill Community Foundation creating
 

00:01:06.770 --> 00:01:09.850 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:01:07.370><c> for</c><00:01:07.580><c> a</c><00:01:07.640><c> better</c><00:01:07.670><c> life</c>