WEBVTT
Kind: captions
Language: en

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

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

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

00:00:10.610 --> 00:00:10.620 align:start position:0%
 
 

00:00:10.620 --> 00:00:12.950 align:start position:0%
 
grouping<00:00:11.580><c> is</c><00:00:11.730><c> one</c><00:00:11.970><c> of</c><00:00:12.060><c> the</c><00:00:12.180><c> best</c><00:00:12.390><c> ways</c><00:00:12.630><c> to</c><00:00:12.810><c> make</c>

00:00:12.950 --> 00:00:12.960 align:start position:0%
grouping is one of the best ways to make
 

00:00:12.960 --> 00:00:13.540 align:start position:0%
grouping is one of the best ways to make
your<00:00:13.080><c> data</c><00:00:13.230><c> more</c>

00:00:13.540 --> 00:00:13.550 align:start position:0%
your data more
 

00:00:13.550 --> 00:00:15.910 align:start position:0%
your data more
managable<00:00:14.030><c> you</c><00:00:14.750><c> can</c><00:00:14.900><c> use</c><00:00:15.080><c> it</c><00:00:15.260><c> to</c><00:00:15.380><c> show</c><00:00:15.590><c> or</c><00:00:15.890><c> hide</c>

00:00:15.910 --> 00:00:15.920 align:start position:0%
managable you can use it to show or hide
 

00:00:15.920 --> 00:00:17.740 align:start position:0%
managable you can use it to show or hide
certain<00:00:16.190><c> parts</c><00:00:16.550><c> of</c><00:00:16.850><c> your</c><00:00:17.030><c> worksheet</c><00:00:17.390><c> so</c><00:00:17.690><c> you</c>

00:00:17.740 --> 00:00:17.750 align:start position:0%
certain parts of your worksheet so you
 

00:00:17.750 --> 00:00:19.480 align:start position:0%
certain parts of your worksheet so you
can<00:00:17.990><c> focus</c><00:00:18.170><c> on</c><00:00:18.410><c> the</c><00:00:18.530><c> information</c><00:00:19.100><c> you</c><00:00:19.220><c> need</c>

00:00:19.480 --> 00:00:19.490 align:start position:0%
can focus on the information you need
 

00:00:19.490 --> 00:00:22.150 align:start position:0%
can focus on the information you need
you<00:00:19.700><c> can</c><00:00:20.360><c> even</c><00:00:20.540><c> add</c><00:00:20.780><c> subtotals</c><00:00:21.290><c> to</c><00:00:21.680><c> summarize</c>

00:00:22.150 --> 00:00:22.160 align:start position:0%
you can even add subtotals to summarize
 

00:00:22.160 --> 00:00:25.780 align:start position:0%
you can even add subtotals to summarize
or<00:00:22.460><c> outline</c><00:00:22.939><c> your</c><00:00:23.150><c> data</c><00:00:23.360><c> in</c><00:00:24.160><c> this</c><00:00:25.160><c> example</c><00:00:25.520><c> I</c>

00:00:25.780 --> 00:00:25.790 align:start position:0%
or outline your data in this example I
 

00:00:25.790 --> 00:00:27.670 align:start position:0%
or outline your data in this example I
have<00:00:26.060><c> a</c><00:00:26.090><c> list</c><00:00:26.360><c> of</c><00:00:26.480><c> t-shirt</c><00:00:26.840><c> orders</c><00:00:27.170><c> but</c><00:00:27.650><c> I</c>

00:00:27.670 --> 00:00:27.680 align:start position:0%
have a list of t-shirt orders but I
 

00:00:27.680 --> 00:00:29.080 align:start position:0%
have a list of t-shirt orders but I
don't<00:00:27.980><c> really</c><00:00:28.160><c> need</c><00:00:28.369><c> to</c><00:00:28.430><c> see</c><00:00:28.670><c> the</c><00:00:28.790><c> people's</c>

00:00:29.080 --> 00:00:29.090 align:start position:0%
don't really need to see the people's
 

00:00:29.090 --> 00:00:31.170 align:start position:0%
don't really need to see the people's
names<00:00:29.420><c> and</c><00:00:29.720><c> payment</c><00:00:30.200><c> information</c><00:00:30.439><c> right</c><00:00:30.950><c> now</c>

00:00:31.170 --> 00:00:31.180 align:start position:0%
names and payment information right now
 

00:00:31.180 --> 00:00:33.790 align:start position:0%
names and payment information right now
so<00:00:32.180><c> with</c><00:00:32.360><c> my</c><00:00:32.509><c> three</c><00:00:32.780><c> column</c><00:00:33.170><c> selected</c><00:00:33.680><c> I'm</c>

00:00:33.790 --> 00:00:33.800 align:start position:0%
so with my three column selected I'm
 

00:00:33.800 --> 00:00:37.240 align:start position:0%
so with my three column selected I'm
going<00:00:34.190><c> to</c><00:00:34.250><c> go</c><00:00:34.400><c> to</c><00:00:34.460><c> the</c><00:00:34.670><c> data</c><00:00:34.880><c> tab</c><00:00:35.000><c> and</c><00:00:36.250><c> then</c>

00:00:37.240 --> 00:00:37.250 align:start position:0%
going to go to the data tab and then
 

00:00:37.250 --> 00:00:41.050 align:start position:0%
going to go to the data tab and then
click<00:00:37.579><c> the</c><00:00:37.850><c> group</c><00:00:38.060><c> command</c><00:00:39.670><c> now</c><00:00:40.670><c> we</c><00:00:40.730><c> can</c><00:00:41.030><c> show</c>

00:00:41.050 --> 00:00:41.060 align:start position:0%
click the group command now we can show
 

00:00:41.060 --> 00:00:43.030 align:start position:0%
click the group command now we can show
or<00:00:41.540><c> hide</c><00:00:41.750><c> the</c><00:00:41.930><c> group</c><00:00:42.140><c> using</c><00:00:42.649><c> the</c><00:00:42.770><c> button</c>

00:00:43.030 --> 00:00:43.040 align:start position:0%
or hide the group using the button
 

00:00:43.040 --> 00:00:45.900 align:start position:0%
or hide the group using the button
that's<00:00:43.160><c> attached</c><00:00:43.550><c> to</c><00:00:43.700><c> the</c><00:00:43.850><c> bracket</c><00:00:44.270><c> here</c>

00:00:45.900 --> 00:00:45.910 align:start position:0%
that's attached to the bracket here
 

00:00:45.910 --> 00:00:48.759 align:start position:0%
that's attached to the bracket here
click<00:00:46.910><c> the</c><00:00:47.030><c> minus</c><00:00:47.210><c> sign</c><00:00:47.390><c> to</c><00:00:47.629><c> hide</c><00:00:48.019><c> or</c><00:00:48.350><c> collapse</c>

00:00:48.759 --> 00:00:48.769 align:start position:0%
click the minus sign to hide or collapse
 

00:00:48.769 --> 00:00:51.910 align:start position:0%
click the minus sign to hide or collapse
the<00:00:49.010><c> data</c><00:00:49.190><c> and</c><00:00:49.960><c> the</c><00:00:50.960><c> plus</c><00:00:51.170><c> sign</c><00:00:51.410><c> to</c><00:00:51.620><c> show</c><00:00:51.649><c> it</c>

00:00:51.910 --> 00:00:51.920 align:start position:0%
the data and the plus sign to show it
 

00:00:51.920 --> 00:00:56.349 align:start position:0%
the data and the plus sign to show it
again<00:00:53.620><c> to</c><00:00:54.620><c> ungroup</c><00:00:54.949><c> any</c><00:00:55.219><c> data</c><00:00:55.489><c> just</c><00:00:55.940><c> make</c><00:00:56.149><c> sure</c>

00:00:56.349 --> 00:00:56.359 align:start position:0%
again to ungroup any data just make sure
 

00:00:56.359 --> 00:00:58.599 align:start position:0%
again to ungroup any data just make sure
it's<00:00:56.510><c> selected</c><00:00:56.660><c> then</c><00:00:57.140><c> click</c><00:00:57.980><c> the</c><00:00:58.160><c> ungroup</c>

00:00:58.599 --> 00:00:58.609 align:start position:0%
it's selected then click the ungroup
 

00:00:58.609 --> 00:01:03.459 align:start position:0%
it's selected then click the ungroup
command<00:00:58.969><c> and</c><00:00:59.410><c> you're</c><00:01:00.410><c> all</c><00:01:00.530><c> set</c><00:01:01.870><c> the</c><00:01:02.870><c> subtotal</c>

00:01:03.459 --> 00:01:03.469 align:start position:0%
command and you're all set the subtotal
 

00:01:03.469 --> 00:01:05.980 align:start position:0%
command and you're all set the subtotal
command<00:01:03.500><c> is</c><00:01:04.010><c> similar</c><00:01:04.370><c> to</c><00:01:04.519><c> groups</c><00:01:04.760><c> you</c><00:01:05.660><c> can</c><00:01:05.780><c> use</c>

00:01:05.980 --> 00:01:05.990 align:start position:0%
command is similar to groups you can use
 

00:01:05.990 --> 00:01:07.750 align:start position:0%
command is similar to groups you can use
it<00:01:06.140><c> to</c><00:01:06.260><c> create</c><00:01:06.440><c> groups</c><00:01:06.830><c> automatically</c><00:01:07.490><c> and</c>

00:01:07.750 --> 00:01:07.760 align:start position:0%
it to create groups automatically and
 

00:01:07.760 --> 00:01:10.240 align:start position:0%
it to create groups automatically and
also<00:01:08.270><c> add</c><00:01:08.420><c> functions</c><00:01:08.900><c> like</c><00:01:09.110><c> sum</c><00:01:09.410><c> count</c><00:01:09.890><c> and</c>

00:01:10.240 --> 00:01:10.250 align:start position:0%
also add functions like sum count and
 

00:01:10.250 --> 00:01:11.890 align:start position:0%
also add functions like sum count and
average<00:01:10.430><c> to</c><00:01:10.910><c> help</c><00:01:11.090><c> you</c><00:01:11.240><c> summarize</c><00:01:11.690><c> your</c><00:01:11.870><c> data</c>

00:01:11.890 --> 00:01:11.900 align:start position:0%
average to help you summarize your data
 

00:01:11.900 --> 00:01:14.980 align:start position:0%
average to help you summarize your data
in<00:01:12.490><c> this</c><00:01:13.490><c> example</c><00:01:13.880><c> I'd</c><00:01:14.210><c> like</c><00:01:14.270><c> to</c><00:01:14.570><c> tally</c><00:01:14.900><c> the</c>

00:01:14.980 --> 00:01:14.990 align:start position:0%
in this example I'd like to tally the
 

00:01:14.990 --> 00:01:16.990 align:start position:0%
in this example I'd like to tally the
number<00:01:15.350><c> of</c><00:01:15.470><c> orders</c><00:01:15.710><c> for</c><00:01:16.040><c> each</c><00:01:16.220><c> t-shirt</c><00:01:16.730><c> size</c>

00:01:16.990 --> 00:01:17.000 align:start position:0%
number of orders for each t-shirt size
 

00:01:17.000 --> 00:01:19.600 align:start position:0%
number of orders for each t-shirt size
including<00:01:17.930><c> small</c><00:01:18.260><c> medium</c><00:01:18.920><c> large</c><00:01:19.070><c> and</c>

00:01:19.600 --> 00:01:19.610 align:start position:0%
including small medium large and
 

00:01:19.610 --> 00:01:22.540 align:start position:0%
including small medium large and
extra-large<00:01:21.070><c> before</c><00:01:22.070><c> you</c><00:01:22.190><c> can</c><00:01:22.340><c> add</c><00:01:22.520><c> a</c>

00:01:22.540 --> 00:01:22.550 align:start position:0%
extra-large before you can add a
 

00:01:22.550 --> 00:01:24.550 align:start position:0%
extra-large before you can add a
subtotal<00:01:23.030><c> your</c><00:01:23.450><c> data</c><00:01:23.660><c> has</c><00:01:23.870><c> to</c><00:01:23.900><c> be</c><00:01:24.080><c> sorted</c><00:01:24.500><c> by</c>

00:01:24.550 --> 00:01:24.560 align:start position:0%
subtotal your data has to be sorted by
 

00:01:24.560 --> 00:01:26.500 align:start position:0%
subtotal your data has to be sorted by
the<00:01:24.710><c> column</c><00:01:25.100><c> you</c><00:01:25.130><c> plan</c><00:01:25.400><c> to</c><00:01:25.430><c> summarize</c><00:01:25.970><c> so</c><00:01:26.390><c> I've</c>

00:01:26.500 --> 00:01:26.510 align:start position:0%
the column you plan to summarize so I've
 

00:01:26.510 --> 00:01:29.050 align:start position:0%
the column you plan to summarize so I've
already<00:01:26.870><c> taken</c><00:01:27.050><c> care</c><00:01:27.200><c> of</c><00:01:27.410><c> that</c><00:01:27.650><c> all</c><00:01:28.040><c> we</c><00:01:28.910><c> have</c>

00:01:29.050 --> 00:01:29.060 align:start position:0%
already taken care of that all we have
 

00:01:29.060 --> 00:01:30.880 align:start position:0%
already taken care of that all we have
to<00:01:29.210><c> do</c><00:01:29.330><c> now</c><00:01:29.540><c> is</c><00:01:29.810><c> click</c><00:01:30.110><c> the</c><00:01:30.290><c> subtotal</c><00:01:30.860><c> command</c>

00:01:30.880 --> 00:01:30.890 align:start position:0%
to do now is click the subtotal command
 

00:01:30.890 --> 00:01:35.620 align:start position:0%
to do now is click the subtotal command
and<00:01:31.510><c> a</c><00:01:32.510><c> dialog</c><00:01:32.870><c> box</c><00:01:33.080><c> will</c><00:01:33.350><c> appear</c><00:01:34.450><c> here</c><00:01:35.450><c> we'll</c>

00:01:35.620 --> 00:01:35.630 align:start position:0%
and a dialog box will appear here we'll
 

00:01:35.630 --> 00:01:37.240 align:start position:0%
and a dialog box will appear here we'll
select<00:01:35.810><c> the</c><00:01:36.140><c> column</c><00:01:36.500><c> that's</c><00:01:36.650><c> going</c><00:01:36.890><c> to</c><00:01:36.980><c> be</c><00:01:37.100><c> the</c>

00:01:37.240 --> 00:01:37.250 align:start position:0%
select the column that's going to be the
 

00:01:37.250 --> 00:01:39.400 align:start position:0%
select the column that's going to be the
basis<00:01:37.640><c> for</c><00:01:37.670><c> the</c><00:01:37.850><c> subtotal</c><00:01:38.480><c> in</c><00:01:38.600><c> this</c><00:01:39.170><c> case</c>

00:01:39.400 --> 00:01:39.410 align:start position:0%
basis for the subtotal in this case
 

00:01:39.410 --> 00:01:42.550 align:start position:0%
basis for the subtotal in this case
t-shirt<00:01:40.070><c> size</c><00:01:40.990><c> next</c><00:01:41.990><c> we'll</c><00:01:42.200><c> pick</c><00:01:42.380><c> the</c>

00:01:42.550 --> 00:01:42.560 align:start position:0%
t-shirt size next we'll pick the
 

00:01:42.560 --> 00:01:44.929 align:start position:0%
t-shirt size next we'll pick the
function<00:01:42.980><c> that</c><00:01:43.010><c> we're</c><00:01:43.220><c> going</c><00:01:43.250><c> to</c><00:01:43.460><c> be</c><00:01:43.610><c> using</c>

00:01:44.929 --> 00:01:44.939 align:start position:0%
function that we're going to be using
 

00:01:44.939 --> 00:01:46.760 align:start position:0%
function that we're going to be using
there<00:01:45.390><c> are</c><00:01:45.509><c> several</c><00:01:45.749><c> common</c><00:01:46.020><c> functions</c><00:01:46.619><c> to</c>

00:01:46.760 --> 00:01:46.770 align:start position:0%
there are several common functions to
 

00:01:46.770 --> 00:01:48.859 align:start position:0%
there are several common functions to
choose<00:01:47.009><c> from</c><00:01:47.280><c> like</c><00:01:47.729><c> some</c><00:01:48.030><c> average</c><00:01:48.630><c> and</c>

00:01:48.859 --> 00:01:48.869 align:start position:0%
choose from like some average and
 

00:01:48.869 --> 00:01:51.230 align:start position:0%
choose from like some average and
product<00:01:49.350><c> but</c><00:01:50.219><c> we're</c><00:01:50.369><c> going</c><00:01:50.549><c> to</c><00:01:50.609><c> go</c><00:01:50.759><c> with</c><00:01:50.880><c> count</c>

00:01:51.230 --> 00:01:51.240 align:start position:0%
product but we're going to go with count
 

00:01:51.240 --> 00:01:52.789 align:start position:0%
product but we're going to go with count
which<00:01:51.780><c> will</c><00:01:51.960><c> just</c><00:01:52.140><c> count</c><00:01:52.350><c> the</c><00:01:52.530><c> number</c><00:01:52.560><c> of</c>

00:01:52.789 --> 00:01:52.799 align:start position:0%
which will just count the number of
 

00:01:52.799 --> 00:01:55.730 align:start position:0%
which will just count the number of
cells<00:01:53.130><c> that</c><00:01:53.250><c> contain</c><00:01:53.670><c> each</c><00:01:53.939><c> size</c><00:01:54.270><c> if</c><00:01:54.600><c> you</c><00:01:55.560><c> had</c>

00:01:55.730 --> 00:01:55.740 align:start position:0%
cells that contain each size if you had
 

00:01:55.740 --> 00:01:57.740 align:start position:0%
cells that contain each size if you had
numerical<00:01:56.250><c> data</c><00:01:56.460><c> you</c><00:01:56.759><c> could</c><00:01:57.000><c> choose</c><00:01:57.210><c> some</c><00:01:57.509><c> and</c>

00:01:57.740 --> 00:01:57.750 align:start position:0%
numerical data you could choose some and
 

00:01:57.750 --> 00:01:59.510 align:start position:0%
numerical data you could choose some and
it<00:01:58.049><c> would</c><00:01:58.170><c> actually</c><00:01:58.350><c> add</c><00:01:58.709><c> the</c><00:01:58.890><c> values</c><00:01:59.250><c> of</c><00:01:59.429><c> the</c>

00:01:59.510 --> 00:01:59.520 align:start position:0%
it would actually add the values of the
 

00:01:59.520 --> 00:02:03.380 align:start position:0%
it would actually add the values of the
cells<00:01:59.759><c> to</c><00:01:59.909><c> create</c><00:02:00.179><c> a</c><00:02:00.329><c> subtotal</c><00:02:01.909><c> finally</c><00:02:02.909><c> check</c>

00:02:03.380 --> 00:02:03.390 align:start position:0%
cells to create a subtotal finally check
 

00:02:03.390 --> 00:02:04.910 align:start position:0%
cells to create a subtotal finally check
the<00:02:03.420><c> column</c><00:02:03.899><c> where</c><00:02:04.020><c> you</c><00:02:04.109><c> want</c><00:02:04.289><c> the</c><00:02:04.409><c> subtotal</c>

00:02:04.910 --> 00:02:04.920 align:start position:0%
the column where you want the subtotal
 

00:02:04.920 --> 00:02:11.449 align:start position:0%
the column where you want the subtotal
to<00:02:05.039><c> appear</c><00:02:05.840><c> then</c><00:02:06.840><c> click</c><00:02:06.869><c> OK</c><00:02:09.739><c> now</c><00:02:10.739><c> a</c><00:02:10.769><c> couple</c><00:02:11.370><c> of</c>

00:02:11.449 --> 00:02:11.459 align:start position:0%
to appear then click OK now a couple of
 

00:02:11.459 --> 00:02:12.589 align:start position:0%
to appear then click OK now a couple of
things<00:02:11.610><c> have</c><00:02:11.849><c> happened</c><00:02:12.000><c> here</c>

00:02:12.589 --> 00:02:12.599 align:start position:0%
things have happened here
 

00:02:12.599 --> 00:02:15.110 align:start position:0%
things have happened here
each<00:02:13.290><c> t-shirt</c><00:02:13.860><c> size</c><00:02:14.129><c> is</c><00:02:14.430><c> now</c><00:02:14.670><c> in</c><00:02:14.819><c> its</c><00:02:14.970><c> own</c>

00:02:15.110 --> 00:02:15.120 align:start position:0%
each t-shirt size is now in its own
 

00:02:15.120 --> 00:02:17.539 align:start position:0%
each t-shirt size is now in its own
group<00:02:15.450><c> indicated</c><00:02:16.319><c> by</c><00:02:16.440><c> the</c><00:02:16.500><c> brackets</c><00:02:17.040><c> here</c><00:02:17.370><c> and</c>

00:02:17.539 --> 00:02:17.549 align:start position:0%
group indicated by the brackets here and
 

00:02:17.549 --> 00:02:20.150 align:start position:0%
group indicated by the brackets here and
all<00:02:18.360><c> of</c><00:02:18.510><c> those</c><00:02:18.629><c> groups</c><00:02:18.900><c> are</c><00:02:19.110><c> inside</c><00:02:19.530><c> a</c><00:02:19.709><c> larger</c>

00:02:20.150 --> 00:02:20.160 align:start position:0%
all of those groups are inside a larger
 

00:02:20.160 --> 00:02:22.640 align:start position:0%
all of those groups are inside a larger
group<00:02:20.569><c> another</c><00:02:21.569><c> word</c><00:02:21.840><c> for</c><00:02:22.079><c> this</c><00:02:22.200><c> is</c><00:02:22.440><c> an</c>

00:02:22.640 --> 00:02:22.650 align:start position:0%
group another word for this is an
 

00:02:22.650 --> 00:02:26.360 align:start position:0%
group another word for this is an
outline<00:02:24.349><c> the</c><00:02:25.349><c> other</c><00:02:25.560><c> thing</c><00:02:25.829><c> that's</c><00:02:25.950><c> happened</c>

00:02:26.360 --> 00:02:26.370 align:start position:0%
outline the other thing that's happened
 

00:02:26.370 --> 00:02:28.339 align:start position:0%
outline the other thing that's happened
is<00:02:26.549><c> that</c><00:02:26.790><c> each</c><00:02:26.940><c> group</c><00:02:27.150><c> has</c><00:02:27.480><c> a</c><00:02:27.510><c> subtotal</c><00:02:27.989><c> under</c>

00:02:28.339 --> 00:02:28.349 align:start position:0%
is that each group has a subtotal under
 

00:02:28.349 --> 00:02:30.619 align:start position:0%
is that each group has a subtotal under
it<00:02:28.470><c> so</c><00:02:29.400><c> we</c><00:02:29.549><c> can</c><00:02:29.700><c> see</c><00:02:29.849><c> the</c><00:02:30.000><c> number</c><00:02:30.269><c> of</c><00:02:30.299><c> shirts</c>

00:02:30.619 --> 00:02:30.629 align:start position:0%
it so we can see the number of shirts
 

00:02:30.629 --> 00:02:34.230 align:start position:0%
it so we can see the number of shirts
that<00:02:30.870><c> have</c><00:02:30.959><c> been</c><00:02:31.079><c> ordered</c><00:02:31.319><c> in</c><00:02:31.560><c> each</c><00:02:31.709><c> size</c>

00:02:34.230 --> 00:02:34.240 align:start position:0%
 
 

00:02:34.240 --> 00:02:37.350 align:start position:0%
 
and<00:02:34.650><c> at</c><00:02:35.650><c> the</c><00:02:35.740><c> very</c><00:02:35.890><c> bottom</c><00:02:36.040><c> we</c><00:02:36.580><c> can</c><00:02:36.760><c> also</c><00:02:36.970><c> see</c>

00:02:37.350 --> 00:02:37.360 align:start position:0%
and at the very bottom we can also see
 

00:02:37.360 --> 00:02:42.250 align:start position:0%
and at the very bottom we can also see
the<00:02:37.510><c> grand</c><00:02:37.750><c> total</c>

00:02:42.250 --> 00:02:42.260 align:start position:0%
 
 

00:02:42.260 --> 00:02:45.050 align:start position:0%
 
to<00:02:43.260><c> make</c><00:02:43.410><c> the</c><00:02:43.530><c> worksheet</c><00:02:43.920><c> easier</c><00:02:44.340><c> to</c><00:02:44.459><c> read</c><00:02:44.670><c> you</c>

00:02:45.050 --> 00:02:45.060 align:start position:0%
to make the worksheet easier to read you
 

00:02:45.060 --> 00:02:47.030 align:start position:0%
to make the worksheet easier to read you
can<00:02:45.090><c> show</c><00:02:45.480><c> or</c><00:02:45.690><c> hide</c><00:02:45.900><c> each</c><00:02:46.110><c> group</c><00:02:46.440><c> just</c><00:02:46.709><c> like</c><00:02:46.920><c> I</c>

00:02:47.030 --> 00:02:47.040 align:start position:0%
can show or hide each group just like I
 

00:02:47.040 --> 00:02:51.290 align:start position:0%
can show or hide each group just like I
showed<00:02:47.220><c> you</c><00:02:47.280><c> before</c><00:02:49.880><c> but</c><00:02:50.880><c> when</c><00:02:51.030><c> you</c><00:02:51.150><c> have</c>

00:02:51.290 --> 00:02:51.300 align:start position:0%
showed you before but when you have
 

00:02:51.300 --> 00:02:53.390 align:start position:0%
showed you before but when you have
groups<00:02:51.600><c> inside</c><00:02:52.140><c> of</c><00:02:52.319><c> groups</c><00:02:52.560><c> like</c><00:02:52.980><c> we</c><00:02:53.010><c> do</c><00:02:53.250><c> in</c>

00:02:53.390 --> 00:02:53.400 align:start position:0%
groups inside of groups like we do in
 

00:02:53.400 --> 00:02:55.400 align:start position:0%
groups inside of groups like we do in
this<00:02:53.550><c> example</c><00:02:53.910><c> sometimes</c><00:02:54.840><c> it's</c><00:02:55.020><c> easier</c><00:02:55.350><c> to</c>

00:02:55.400 --> 00:02:55.410 align:start position:0%
this example sometimes it's easier to
 

00:02:55.410 --> 00:02:57.650 align:start position:0%
this example sometimes it's easier to
view<00:02:55.680><c> them</c><00:02:55.830><c> by</c><00:02:55.860><c> level</c><00:02:56.340><c> just</c><00:02:57.180><c> look</c><00:02:57.420><c> for</c><00:02:57.600><c> the</c>

00:02:57.650 --> 00:02:57.660 align:start position:0%
view them by level just look for the
 

00:02:57.660 --> 00:03:00.760 align:start position:0%
view them by level just look for the
buttons<00:02:57.989><c> to</c><00:02:58.260><c> the</c><00:02:58.350><c> left</c><00:02:58.560><c> of</c><00:02:58.709><c> your</c><00:02:58.800><c> worksheet</c>

00:03:00.760 --> 00:03:00.770 align:start position:0%
buttons to the left of your worksheet
 

00:03:00.770 --> 00:03:03.470 align:start position:0%
buttons to the left of your worksheet
the<00:03:01.770><c> highest</c><00:03:02.130><c> level</c><00:03:02.430><c> which</c><00:03:02.700><c> is</c><00:03:02.880><c> 3</c><00:03:03.150><c> in</c><00:03:03.330><c> this</c>

00:03:03.470 --> 00:03:03.480 align:start position:0%
the highest level which is 3 in this
 

00:03:03.480 --> 00:03:06.590 align:start position:0%
the highest level which is 3 in this
case<00:03:03.750><c> will</c><00:03:04.170><c> show</c><00:03:04.380><c> all</c><00:03:04.590><c> of</c><00:03:04.770><c> your</c><00:03:04.890><c> data</c><00:03:05.600><c> while</c>

00:03:06.590 --> 00:03:06.600 align:start position:0%
case will show all of your data while
 

00:03:06.600 --> 00:03:08.540 align:start position:0%
case will show all of your data while
level<00:03:06.989><c> 2</c><00:03:07.200><c> will</c><00:03:07.560><c> hide</c><00:03:07.770><c> the</c><00:03:07.890><c> details</c><00:03:08.310><c> of</c><00:03:08.459><c> each</c>

00:03:08.540 --> 00:03:08.550 align:start position:0%
level 2 will hide the details of each
 

00:03:08.550 --> 00:03:10.460 align:start position:0%
level 2 will hide the details of each
size<00:03:08.880><c> leaving</c><00:03:09.510><c> just</c><00:03:09.720><c> the</c><00:03:09.840><c> individual</c>

00:03:10.460 --> 00:03:10.470 align:start position:0%
size leaving just the individual
 

00:03:10.470 --> 00:03:14.420 align:start position:0%
size leaving just the individual
subtotals<00:03:12.110><c> finally</c><00:03:13.110><c> level</c><00:03:13.590><c> 1</c><00:03:13.860><c> will</c><00:03:14.220><c> hide</c>

00:03:14.420 --> 00:03:14.430 align:start position:0%
subtotals finally level 1 will hide
 

00:03:14.430 --> 00:03:16.580 align:start position:0%
subtotals finally level 1 will hide
everything<00:03:14.970><c> so</c><00:03:15.360><c> we</c><00:03:15.480><c> can</c><00:03:15.630><c> only</c><00:03:15.840><c> see</c><00:03:16.200><c> the</c><00:03:16.230><c> grand</c>

00:03:16.580 --> 00:03:16.590 align:start position:0%
everything so we can only see the grand
 

00:03:16.590 --> 00:03:17.920 align:start position:0%
everything so we can only see the grand
total

00:03:17.920 --> 00:03:17.930 align:start position:0%
total
 

00:03:17.930 --> 00:03:20.390 align:start position:0%
total
let's<00:03:18.930><c> click</c><00:03:19.170><c> 3</c><00:03:19.500><c> to</c><00:03:19.709><c> show</c><00:03:19.739><c> the</c><00:03:19.950><c> entire</c>

00:03:20.390 --> 00:03:20.400 align:start position:0%
let's click 3 to show the entire
 

00:03:20.400 --> 00:03:24.890 align:start position:0%
let's click 3 to show the entire
worksheet<00:03:20.670><c> again</c><00:03:22.850><c> to</c><00:03:23.850><c> remove</c><00:03:24.120><c> subtotals</c><00:03:24.720><c> from</c>

00:03:24.890 --> 00:03:24.900 align:start position:0%
worksheet again to remove subtotals from
 

00:03:24.900 --> 00:03:26.780 align:start position:0%
worksheet again to remove subtotals from
your<00:03:25.050><c> worksheet</c><00:03:25.440><c> all</c><00:03:25.620><c> you</c><00:03:26.100><c> have</c><00:03:26.280><c> to</c><00:03:26.400><c> do</c><00:03:26.550><c> is</c>

00:03:26.780 --> 00:03:26.790 align:start position:0%
your worksheet all you have to do is
 

00:03:26.790 --> 00:03:30.140 align:start position:0%
your worksheet all you have to do is
click<00:03:27.030><c> the</c><00:03:27.209><c> subtotal</c><00:03:27.780><c> command</c><00:03:28.850><c> then</c><00:03:29.850><c> click</c>

00:03:30.140 --> 00:03:30.150 align:start position:0%
click the subtotal command then click
 

00:03:30.150 --> 00:03:35.030 align:start position:0%
click the subtotal command then click
the<00:03:30.269><c> button</c><00:03:30.540><c> that</c><00:03:30.569><c> says</c><00:03:30.690><c> remove</c><00:03:31.440><c> all</c><00:03:34.040><c> grouping</c>

00:03:35.030 --> 00:03:35.040 align:start position:0%
the button that says remove all grouping
 

00:03:35.040 --> 00:03:36.290 align:start position:0%
the button that says remove all grouping
and<00:03:35.190><c> sub</c><00:03:35.400><c> totalling</c><00:03:35.819><c> can</c><00:03:36.000><c> make</c><00:03:36.150><c> your</c>

00:03:36.290 --> 00:03:36.300 align:start position:0%
and sub totalling can make your
 

00:03:36.300 --> 00:03:38.240 align:start position:0%
and sub totalling can make your
worksheet<00:03:36.660><c> less</c><00:03:36.900><c> cluttered</c><00:03:37.350><c> more</c><00:03:37.739><c> organized</c>

00:03:38.240 --> 00:03:38.250 align:start position:0%
worksheet less cluttered more organized
 

00:03:38.250 --> 00:03:40.430 align:start position:0%
worksheet less cluttered more organized
and<00:03:38.459><c> easier</c><00:03:38.819><c> to</c><00:03:39.090><c> view</c><00:03:39.420><c> so</c><00:03:40.110><c> keep</c><00:03:40.290><c> these</c>

00:03:40.430 --> 00:03:40.440 align:start position:0%
and easier to view so keep these
 

00:03:40.440 --> 00:03:42.229 align:start position:0%
and easier to view so keep these
features<00:03:40.860><c> in</c><00:03:40.980><c> mind</c><00:03:41.250><c> the</c><00:03:41.519><c> next</c><00:03:41.640><c> time</c><00:03:41.940><c> you</c><00:03:42.090><c> need</c>

00:03:42.229 --> 00:03:42.239 align:start position:0%
features in mind the next time you need
 

00:03:42.239 --> 00:03:46.070 align:start position:0%
features in mind the next time you need
help<00:03:42.300><c> summarizing</c><00:03:43.050><c> your</c><00:03:43.170><c> data</c>

00:03:46.070 --> 00:03:46.080 align:start position:0%
 
 

00:03:46.080 --> 00:03:48.140 align:start position:0%
 
you