WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:08.799 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.370><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:07.809><c> grouping</c>

00:00:08.799 --> 00:00:08.809 align:start position:0%
opportunities for a better life grouping
 

00:00:08.809 --> 00:00:10.629 align:start position:0%
opportunities for a better life grouping
is<00:00:08.990><c> a</c><00:00:09.049><c> good</c><00:00:09.469><c> way</c><00:00:09.679><c> to</c><00:00:09.740><c> make</c><00:00:09.950><c> your</c><00:00:10.129><c> data</c><00:00:10.370><c> more</c>

00:00:10.629 --> 00:00:10.639 align:start position:0%
is a good way to make your data more
 

00:00:10.639 --> 00:00:13.119 align:start position:0%
is a good way to make your data more
manageable<00:00:11.299><c> you</c><00:00:11.990><c> can</c><00:00:12.169><c> use</c><00:00:12.349><c> it</c><00:00:12.499><c> to</c><00:00:12.650><c> show</c><00:00:12.889><c> or</c>

00:00:13.119 --> 00:00:13.129 align:start position:0%
manageable you can use it to show or
 

00:00:13.129 --> 00:00:15.249 align:start position:0%
manageable you can use it to show or
hide<00:00:13.160><c> certain</c><00:00:13.369><c> parts</c><00:00:14.059><c> of</c><00:00:14.150><c> your</c><00:00:14.329><c> worksheet</c><00:00:14.719><c> so</c>

00:00:15.249 --> 00:00:15.259 align:start position:0%
hide certain parts of your worksheet so
 

00:00:15.259 --> 00:00:16.900 align:start position:0%
hide certain parts of your worksheet so
you<00:00:15.349><c> can</c><00:00:15.530><c> focus</c><00:00:15.740><c> on</c><00:00:16.039><c> the</c><00:00:16.190><c> information</c><00:00:16.429><c> you</c>

00:00:16.900 --> 00:00:16.910 align:start position:0%
you can focus on the information you
 

00:00:16.910 --> 00:00:19.810 align:start position:0%
you can focus on the information you
need<00:00:17.150><c> you</c><00:00:18.019><c> can</c><00:00:18.170><c> even</c><00:00:18.380><c> add</c><00:00:18.619><c> subtotals</c><00:00:19.279><c> to</c>

00:00:19.810 --> 00:00:19.820 align:start position:0%
need you can even add subtotals to
 

00:00:19.820 --> 00:00:23.349 align:start position:0%
need you can even add subtotals to
summarize<00:00:20.359><c> or</c><00:00:20.689><c> outline</c><00:00:21.349><c> your</c><00:00:21.679><c> data</c><00:00:22.009><c> in</c><00:00:22.359><c> this</c>

00:00:23.349 --> 00:00:23.359 align:start position:0%
summarize or outline your data in this
 

00:00:23.359 --> 00:00:25.660 align:start position:0%
summarize or outline your data in this
example<00:00:23.750><c> I</c><00:00:24.080><c> have</c><00:00:24.410><c> a</c><00:00:24.470><c> list</c><00:00:24.679><c> of</c><00:00:24.800><c> t-shirt</c><00:00:25.250><c> orders</c>

00:00:25.660 --> 00:00:25.670 align:start position:0%
example I have a list of t-shirt orders
 

00:00:25.670 --> 00:00:27.669 align:start position:0%
example I have a list of t-shirt orders
but<00:00:26.330><c> I</c><00:00:26.359><c> really</c><00:00:26.900><c> don't</c><00:00:27.109><c> need</c><00:00:27.259><c> to</c><00:00:27.320><c> see</c><00:00:27.439><c> the</c>

00:00:27.669 --> 00:00:27.679 align:start position:0%
but I really don't need to see the
 

00:00:27.679 --> 00:00:29.230 align:start position:0%
but I really don't need to see the
people's<00:00:28.039><c> names</c><00:00:28.429><c> and</c><00:00:28.759><c> payment</c><00:00:29.179><c> information</c>

00:00:29.230 --> 00:00:29.240 align:start position:0%
people's names and payment information
 

00:00:29.240 --> 00:00:32.470 align:start position:0%
people's names and payment information
right<00:00:29.960><c> now</c><00:00:30.189><c> so</c><00:00:31.189><c> with</c><00:00:31.339><c> these</c><00:00:31.490><c> three</c><00:00:31.880><c> columns</c>

00:00:32.470 --> 00:00:32.480 align:start position:0%
right now so with these three columns
 

00:00:32.480 --> 00:00:35.740 align:start position:0%
right now so with these three columns
selected<00:00:33.140><c> I'm</c><00:00:33.739><c> going</c><00:00:34.730><c> to</c><00:00:34.820><c> go</c><00:00:34.969><c> to</c><00:00:35.030><c> the</c><00:00:35.239><c> data</c><00:00:35.480><c> tab</c>

00:00:35.740 --> 00:00:35.750 align:start position:0%
selected I'm going to go to the data tab
 

00:00:35.750 --> 00:00:40.810 align:start position:0%
selected I'm going to go to the data tab
and<00:00:36.789><c> then</c><00:00:37.789><c> click</c><00:00:38.090><c> the</c><00:00:38.270><c> group</c><00:00:38.510><c> command</c><00:00:39.760><c> now</c><00:00:40.760><c> we</c>

00:00:40.810 --> 00:00:40.820 align:start position:0%
and then click the group command now we
 

00:00:40.820 --> 00:00:42.819 align:start position:0%
and then click the group command now we
can<00:00:41.120><c> show</c><00:00:41.360><c> or</c><00:00:41.539><c> hide</c><00:00:41.719><c> this</c><00:00:41.989><c> group</c><00:00:42.260><c> using</c><00:00:42.739><c> the</c>

00:00:42.819 --> 00:00:42.829 align:start position:0%
can show or hide this group using the
 

00:00:42.829 --> 00:00:44.680 align:start position:0%
can show or hide this group using the
button<00:00:43.190><c> that's</c><00:00:43.340><c> attached</c><00:00:43.820><c> to</c><00:00:44.090><c> this</c><00:00:44.210><c> bracket</c>

00:00:44.680 --> 00:00:44.690 align:start position:0%
button that's attached to this bracket
 

00:00:44.690 --> 00:00:48.069 align:start position:0%
button that's attached to this bracket
here<00:00:45.280><c> click</c><00:00:46.280><c> the</c><00:00:46.460><c> minus</c><00:00:46.670><c> sign</c><00:00:46.850><c> to</c><00:00:47.300><c> hide</c><00:00:47.750><c> or</c>

00:00:48.069 --> 00:00:48.079 align:start position:0%
here click the minus sign to hide or
 

00:00:48.079 --> 00:00:51.220 align:start position:0%
here click the minus sign to hide or
collapse<00:00:48.680><c> the</c><00:00:48.920><c> data</c><00:00:49.129><c> and</c><00:00:49.719><c> the</c><00:00:50.719><c> plus</c><00:00:50.930><c> sign</c><00:00:51.199><c> to</c>

00:00:51.220 --> 00:00:51.230 align:start position:0%
collapse the data and the plus sign to
 

00:00:51.230 --> 00:00:53.229 align:start position:0%
collapse the data and the plus sign to
show<00:00:51.559><c> it</c><00:00:51.710><c> again</c>

00:00:53.229 --> 00:00:53.239 align:start position:0%
show it again
 

00:00:53.239 --> 00:00:55.959 align:start position:0%
show it again
to<00:00:53.629><c> ungroup</c><00:00:54.079><c> any</c><00:00:54.320><c> data</c><00:00:54.590><c> make</c><00:00:55.579><c> sure</c><00:00:55.610><c> it's</c>

00:00:55.959 --> 00:00:55.969 align:start position:0%
to ungroup any data make sure it's
 

00:00:55.969 --> 00:00:57.590 align:start position:0%
to ungroup any data make sure it's
selected

00:00:57.590 --> 00:00:57.600 align:start position:0%
selected
 

00:00:57.600 --> 00:01:00.430 align:start position:0%
selected
then<00:00:58.230><c> click</c><00:00:58.530><c> the</c><00:00:58.560><c> ungroup</c><00:00:59.250><c> command</c><00:00:59.820><c> and</c>

00:01:00.430 --> 00:01:00.440 align:start position:0%
then click the ungroup command and
 

00:01:00.440 --> 00:01:04.490 align:start position:0%
then click the ungroup command and
you're<00:01:01.440><c> all</c><00:01:01.530><c> set</c><00:01:02.270><c> the</c><00:01:03.270><c> subtotal</c><00:01:03.960><c> command</c><00:01:03.989><c> is</c>

00:01:04.490 --> 00:01:04.500 align:start position:0%
you're all set the subtotal command is
 

00:01:04.500 --> 00:01:06.590 align:start position:0%
you're all set the subtotal command is
similar<00:01:04.920><c> to</c><00:01:05.100><c> groups</c><00:01:05.370><c> you</c><00:01:06.030><c> can</c><00:01:06.180><c> use</c><00:01:06.360><c> it</c><00:01:06.479><c> to</c>

00:01:06.590 --> 00:01:06.600 align:start position:0%
similar to groups you can use it to
 

00:01:06.600 --> 00:01:08.930 align:start position:0%
similar to groups you can use it to
create<00:01:06.960><c> groups</c><00:01:07.229><c> automatically</c><00:01:08.040><c> and</c><00:01:08.280><c> also</c><00:01:08.790><c> add</c>

00:01:08.930 --> 00:01:08.940 align:start position:0%
create groups automatically and also add
 

00:01:08.940 --> 00:01:12.530 align:start position:0%
create groups automatically and also add
functions<00:01:09.450><c> like</c><00:01:09.840><c> sum</c><00:01:10.260><c> count</c><00:01:10.979><c> and</c><00:01:11.340><c> average</c><00:01:11.790><c> to</c>

00:01:12.530 --> 00:01:12.540 align:start position:0%
functions like sum count and average to
 

00:01:12.540 --> 00:01:15.080 align:start position:0%
functions like sum count and average to
help<00:01:12.750><c> you</c><00:01:12.869><c> summarize</c><00:01:13.350><c> your</c><00:01:13.560><c> data</c><00:01:13.590><c> in</c><00:01:14.090><c> this</c>

00:01:15.080 --> 00:01:15.090 align:start position:0%
help you summarize your data in this
 

00:01:15.090 --> 00:01:17.240 align:start position:0%
help you summarize your data in this
example<00:01:15.540><c> I'd</c><00:01:15.900><c> like</c><00:01:15.960><c> to</c><00:01:16.410><c> tally</c><00:01:16.710><c> up</c><00:01:16.920><c> the</c><00:01:17.220><c> number</c>

00:01:17.240 --> 00:01:17.250 align:start position:0%
example I'd like to tally up the number
 

00:01:17.250 --> 00:01:19.420 align:start position:0%
example I'd like to tally up the number
of<00:01:17.520><c> orders</c><00:01:18.030><c> for</c><00:01:18.300><c> each</c><00:01:18.450><c> t-shirt</c><00:01:19.110><c> size</c>

00:01:19.420 --> 00:01:19.430 align:start position:0%
of orders for each t-shirt size
 

00:01:19.430 --> 00:01:22.969 align:start position:0%
of orders for each t-shirt size
including<00:01:20.430><c> small</c><00:01:20.970><c> medium</c><00:01:21.900><c> large</c><00:01:22.200><c> and</c>

00:01:22.969 --> 00:01:22.979 align:start position:0%
including small medium large and
 

00:01:22.979 --> 00:01:26.990 align:start position:0%
including small medium large and
extra-large<00:01:24.979><c> before</c><00:01:25.979><c> we</c><00:01:26.160><c> can</c><00:01:26.280><c> add</c><00:01:26.460><c> a</c><00:01:26.490><c> subtotal</c>

00:01:26.990 --> 00:01:27.000 align:start position:0%
extra-large before we can add a subtotal
 

00:01:27.000 --> 00:01:29.510 align:start position:0%
extra-large before we can add a subtotal
our<00:01:27.360><c> data</c><00:01:27.780><c> has</c><00:01:28.050><c> to</c><00:01:28.320><c> be</c><00:01:28.440><c> sorted</c><00:01:28.800><c> by</c><00:01:28.860><c> the</c><00:01:29.009><c> column</c>

00:01:29.510 --> 00:01:29.520 align:start position:0%
our data has to be sorted by the column
 

00:01:29.520 --> 00:01:31.400 align:start position:0%
our data has to be sorted by the column
we<00:01:29.670><c> plan</c><00:01:29.970><c> to</c><00:01:30.119><c> summarize</c><00:01:30.600><c> so</c><00:01:31.110><c> I've</c><00:01:31.229><c> already</c>

00:01:31.400 --> 00:01:31.410 align:start position:0%
we plan to summarize so I've already
 

00:01:31.410 --> 00:01:34.160 align:start position:0%
we plan to summarize so I've already
taken<00:01:31.830><c> care</c><00:01:32.009><c> of</c><00:01:32.070><c> that</c><00:01:32.190><c> here</c><00:01:32.670><c> as</c><00:01:32.820><c> you</c><00:01:33.810><c> can</c><00:01:33.960><c> see</c>

00:01:34.160 --> 00:01:34.170 align:start position:0%
taken care of that here as you can see
 

00:01:34.170 --> 00:01:36.320 align:start position:0%
taken care of that here as you can see
the<00:01:34.560><c> t-shirts</c><00:01:34.979><c> have</c><00:01:35.160><c> been</c><00:01:35.280><c> put</c><00:01:35.460><c> into</c><00:01:35.640><c> a</c><00:01:35.729><c> custom</c>

00:01:36.320 --> 00:01:36.330 align:start position:0%
the t-shirts have been put into a custom
 

00:01:36.330 --> 00:01:38.359 align:start position:0%
the t-shirts have been put into a custom
sort<00:01:36.509><c> order</c><00:01:36.930><c> going</c><00:01:37.560><c> from</c><00:01:37.830><c> smallest</c><00:01:38.190><c> to</c>

00:01:38.359 --> 00:01:38.369 align:start position:0%
sort order going from smallest to
 

00:01:38.369 --> 00:01:41.240 align:start position:0%
sort order going from smallest to
largest<00:01:38.899><c> all</c><00:01:39.899><c> we</c><00:01:40.200><c> have</c><00:01:40.380><c> to</c><00:01:40.530><c> do</c><00:01:40.649><c> now</c><00:01:40.890><c> is</c><00:01:41.100><c> click</c>

00:01:41.240 --> 00:01:41.250 align:start position:0%
largest all we have to do now is click
 

00:01:41.250 --> 00:01:44.300 align:start position:0%
largest all we have to do now is click
the<00:01:41.490><c> subtotal</c><00:01:42.060><c> command</c><00:01:42.090><c> and</c><00:01:42.660><c> a</c><00:01:43.590><c> dialog</c><00:01:44.100><c> box</c>

00:01:44.300 --> 00:01:44.310 align:start position:0%
the subtotal command and a dialog box
 

00:01:44.310 --> 00:01:47.120 align:start position:0%
the subtotal command and a dialog box
will<00:01:44.640><c> appear</c><00:01:44.990><c> here</c><00:01:45.990><c> we'll</c><00:01:46.170><c> select</c><00:01:46.380><c> the</c><00:01:46.710><c> column</c>

00:01:47.120 --> 00:01:47.130 align:start position:0%
will appear here we'll select the column
 

00:01:47.130 --> 00:01:48.710 align:start position:0%
will appear here we'll select the column
that's<00:01:47.220><c> going</c><00:01:47.490><c> to</c><00:01:47.580><c> be</c><00:01:47.670><c> the</c><00:01:47.789><c> basis</c><00:01:48.270><c> for</c><00:01:48.420><c> the</c>

00:01:48.710 --> 00:01:48.720 align:start position:0%
that's going to be the basis for the
 

00:01:48.720 --> 00:01:51.410 align:start position:0%
that's going to be the basis for the
subtotal<00:01:49.289><c> in</c><00:01:49.440><c> this</c><00:01:50.039><c> case</c><00:01:50.310><c> that's</c><00:01:50.789><c> t-shirt</c>

00:01:51.410 --> 00:01:51.420 align:start position:0%
subtotal in this case that's t-shirt
 

00:01:51.420 --> 00:01:54.620 align:start position:0%
subtotal in this case that's t-shirt
size<00:01:52.190><c> next</c><00:01:53.190><c> we'll</c><00:01:53.729><c> pick</c><00:01:53.940><c> the</c><00:01:54.090><c> function</c><00:01:54.509><c> that</c>

00:01:54.620 --> 00:01:54.630 align:start position:0%
size next we'll pick the function that
 

00:01:54.630 --> 00:01:56.810 align:start position:0%
size next we'll pick the function that
we're<00:01:54.780><c> going</c><00:01:54.899><c> to</c><00:01:55.020><c> be</c><00:01:55.200><c> using</c><00:01:55.520><c> now</c><00:01:56.520><c> there</c><00:01:56.700><c> are</c>

00:01:56.810 --> 00:01:56.820 align:start position:0%
we're going to be using now there are
 

00:01:56.820 --> 00:01:58.999 align:start position:0%
we're going to be using now there are
several<00:01:57.090><c> common</c><00:01:57.539><c> functions</c><00:01:58.200><c> to</c><00:01:58.410><c> choose</c><00:01:58.440><c> from</c>

00:01:58.999 --> 00:01:59.009 align:start position:0%
several common functions to choose from
 

00:01:59.009 --> 00:02:02.270 align:start position:0%
several common functions to choose from
like<00:01:59.399><c> some</c><00:01:59.700><c> average</c><00:02:00.450><c> and</c><00:02:00.690><c> product</c><00:02:01.259><c> but</c><00:02:02.130><c> we're</c>

00:02:02.270 --> 00:02:02.280 align:start position:0%
like some average and product but we're
 

00:02:02.280 --> 00:02:04.249 align:start position:0%
like some average and product but we're
going<00:02:02.460><c> to</c><00:02:02.640><c> use</c><00:02:02.790><c> count</c><00:02:03.150><c> which</c><00:02:03.540><c> will</c><00:02:03.750><c> just</c><00:02:03.930><c> count</c>

00:02:04.249 --> 00:02:04.259 align:start position:0%
going to use count which will just count
 

00:02:04.259 --> 00:02:06.020 align:start position:0%
going to use count which will just count
the<00:02:04.439><c> number</c><00:02:04.710><c> of</c><00:02:04.740><c> cells</c><00:02:05.009><c> that</c><00:02:05.250><c> contain</c><00:02:05.700><c> each</c>

00:02:06.020 --> 00:02:06.030 align:start position:0%
the number of cells that contain each
 

00:02:06.030 --> 00:02:09.440 align:start position:0%
the number of cells that contain each
size<00:02:06.390><c> if</c><00:02:06.770><c> you</c><00:02:07.770><c> had</c><00:02:07.950><c> numerical</c><00:02:08.549><c> data</c><00:02:08.759><c> you</c><00:02:09.269><c> could</c>

00:02:09.440 --> 00:02:09.450 align:start position:0%
size if you had numerical data you could
 

00:02:09.450 --> 00:02:11.479 align:start position:0%
size if you had numerical data you could
choose<00:02:09.660><c> sum</c><00:02:09.989><c> instead</c><00:02:10.470><c> and</c><00:02:10.920><c> it</c><00:02:11.220><c> would</c><00:02:11.310><c> actually</c>

00:02:11.479 --> 00:02:11.489 align:start position:0%
choose sum instead and it would actually
 

00:02:11.489 --> 00:02:13.819 align:start position:0%
choose sum instead and it would actually
add<00:02:11.880><c> the</c><00:02:12.209><c> values</c><00:02:12.630><c> from</c><00:02:12.840><c> each</c><00:02:13.170><c> of</c><00:02:13.320><c> those</c><00:02:13.470><c> cells</c>

00:02:13.819 --> 00:02:13.829 align:start position:0%
add the values from each of those cells
 

00:02:13.829 --> 00:02:17.120 align:start position:0%
add the values from each of those cells
to<00:02:14.190><c> create</c><00:02:14.489><c> a</c><00:02:14.670><c> subtotal</c><00:02:15.739><c> finally</c><00:02:16.739><c> check</c><00:02:17.100><c> the</c>

00:02:17.120 --> 00:02:17.130 align:start position:0%
to create a subtotal finally check the
 

00:02:17.130 --> 00:02:18.830 align:start position:0%
to create a subtotal finally check the
column<00:02:17.640><c> where</c><00:02:17.790><c> you</c><00:02:17.820><c> want</c><00:02:18.060><c> the</c><00:02:18.180><c> subtitle</c><00:02:18.690><c> to</c>

00:02:18.830 --> 00:02:18.840 align:start position:0%
column where you want the subtitle to
 

00:02:18.840 --> 00:02:23.330 align:start position:0%
column where you want the subtitle to
appear<00:02:19.519><c> then</c><00:02:20.519><c> click</c><00:02:20.549><c> OK</c><00:02:21.620><c> now</c><00:02:22.620><c> a</c><00:02:22.650><c> couple</c><00:02:23.100><c> of</c>

00:02:23.330 --> 00:02:23.340 align:start position:0%
appear then click OK now a couple of
 

00:02:23.340 --> 00:02:25.640 align:start position:0%
appear then click OK now a couple of
things<00:02:23.579><c> have</c><00:02:23.730><c> happened</c><00:02:23.760><c> here</c><00:02:24.329><c> each</c><00:02:25.170><c> t-shirt</c>

00:02:25.640 --> 00:02:25.650 align:start position:0%
things have happened here each t-shirt
 

00:02:25.650 --> 00:02:28.280 align:start position:0%
things have happened here each t-shirt
size<00:02:26.070><c> is</c><00:02:26.430><c> now</c><00:02:26.640><c> in</c><00:02:26.790><c> its</c><00:02:26.850><c> own</c><00:02:27.120><c> group</c><00:02:27.510><c> indicated</c>

00:02:28.280 --> 00:02:28.290 align:start position:0%
size is now in its own group indicated
 

00:02:28.290 --> 00:02:31.100 align:start position:0%
size is now in its own group indicated
by<00:02:28.680><c> the</c><00:02:28.739><c> brackets</c><00:02:29.310><c> here</c><00:02:29.489><c> on</c><00:02:29.610><c> the</c><00:02:29.760><c> left</c><00:02:29.970><c> and</c><00:02:30.299><c> all</c>

00:02:31.100 --> 00:02:31.110 align:start position:0%
by the brackets here on the left and all
 

00:02:31.110 --> 00:02:33.490 align:start position:0%
by the brackets here on the left and all
those<00:02:31.500><c> groups</c><00:02:31.829><c> are</c><00:02:32.040><c> inside</c><00:02:32.489><c> a</c><00:02:32.519><c> larger</c><00:02:33.180><c> group</c>

00:02:33.490 --> 00:02:33.500 align:start position:0%
those groups are inside a larger group
 

00:02:33.500 --> 00:02:36.910 align:start position:0%
those groups are inside a larger group
this<00:02:34.500><c> is</c><00:02:34.680><c> also</c><00:02:34.860><c> called</c><00:02:35.280><c> an</c><00:02:35.459><c> outline</c><00:02:35.970><c> in</c><00:02:36.299><c> Excel</c>

00:02:36.910 --> 00:02:36.920 align:start position:0%
this is also called an outline in Excel
 

00:02:36.920 --> 00:02:39.199 align:start position:0%
this is also called an outline in Excel
the<00:02:37.920><c> other</c><00:02:38.100><c> thing</c><00:02:38.400><c> that's</c><00:02:38.519><c> happened</c><00:02:39.000><c> is</c><00:02:39.090><c> that</c>

00:02:39.199 --> 00:02:39.209 align:start position:0%
the other thing that's happened is that
 

00:02:39.209 --> 00:02:43.039 align:start position:0%
the other thing that's happened is that
each<00:02:39.510><c> group</c><00:02:39.810><c> has</c><00:02:40.140><c> a</c><00:02:40.170><c> subtotal</c><00:02:40.829><c> beneath</c><00:02:41.280><c> it</c><00:02:42.049><c> so</c>

00:02:43.039 --> 00:02:43.049 align:start position:0%
each group has a subtotal beneath it so
 

00:02:43.049 --> 00:02:44.630 align:start position:0%
each group has a subtotal beneath it so
we<00:02:43.230><c> can</c><00:02:43.380><c> see</c><00:02:43.620><c> the</c><00:02:43.769><c> number</c><00:02:44.040><c> of</c><00:02:44.160><c> shirts</c><00:02:44.400><c> that</c>

00:02:44.630 --> 00:02:44.640 align:start position:0%
we can see the number of shirts that
 

00:02:44.640 --> 00:02:47.569 align:start position:0%
we can see the number of shirts that
have<00:02:44.760><c> been</c><00:02:44.880><c> ordered</c><00:02:45.180><c> in</c><00:02:45.420><c> each</c><00:02:45.720><c> size</c><00:02:46.079><c> and</c><00:02:46.579><c> at</c>

00:02:47.569 --> 00:02:47.579 align:start position:0%
have been ordered in each size and at
 

00:02:47.579 --> 00:02:49.759 align:start position:0%
have been ordered in each size and at
the<00:02:47.700><c> very</c><00:02:47.880><c> bottom</c><00:02:48.030><c> we</c><00:02:48.660><c> can</c><00:02:48.810><c> also</c><00:02:48.959><c> see</c><00:02:49.380><c> a</c><00:02:49.410><c> grand</c>

00:02:49.759 --> 00:02:49.769 align:start position:0%
the very bottom we can also see a grand
 

00:02:49.769 --> 00:02:51.410 align:start position:0%
the very bottom we can also see a grand
total

00:02:51.410 --> 00:02:51.420 align:start position:0%
total
 

00:02:51.420 --> 00:02:54.410 align:start position:0%
total
to<00:02:52.170><c> make</c><00:02:52.350><c> the</c><00:02:52.470><c> worksheet</c><00:02:52.830><c> easier</c><00:02:53.340><c> to</c><00:02:53.520><c> read</c><00:02:53.760><c> we</c>

00:02:54.410 --> 00:02:54.420 align:start position:0%
to make the worksheet easier to read we
 

00:02:54.420 --> 00:02:56.420 align:start position:0%
to make the worksheet easier to read we
can<00:02:54.630><c> show</c><00:02:54.870><c> or</c><00:02:55.110><c> hide</c><00:02:55.140><c> the</c><00:02:55.350><c> groups</c><00:02:55.770><c> like</c><00:02:55.950><c> we</c><00:02:56.130><c> did</c>

00:02:56.420 --> 00:02:56.430 align:start position:0%
can show or hide the groups like we did
 

00:02:56.430 --> 00:02:59.690 align:start position:0%
can show or hide the groups like we did
before<00:02:57.440><c> but</c><00:02:58.440><c> when</c><00:02:58.560><c> you</c><00:02:58.650><c> have</c><00:02:58.830><c> groups</c><00:02:59.190><c> inside</c>

00:02:59.690 --> 00:02:59.700 align:start position:0%
before but when you have groups inside
 

00:02:59.700 --> 00:03:01.690 align:start position:0%
before but when you have groups inside
of<00:02:59.910><c> groups</c><00:03:00.209><c> like</c><00:03:00.690><c> we</c><00:03:00.720><c> do</c><00:03:00.959><c> in</c><00:03:01.080><c> this</c><00:03:01.230><c> example</c>

00:03:01.690 --> 00:03:01.700 align:start position:0%
of groups like we do in this example
 

00:03:01.700 --> 00:03:03.890 align:start position:0%
of groups like we do in this example
sometimes<00:03:02.700><c> it's</c><00:03:02.880><c> easier</c><00:03:03.209><c> just</c><00:03:03.300><c> to</c><00:03:03.540><c> view</c><00:03:03.780><c> them</c>

00:03:03.890 --> 00:03:03.900 align:start position:0%
sometimes it's easier just to view them
 

00:03:03.900 --> 00:03:06.770 align:start position:0%
sometimes it's easier just to view them
by<00:03:04.140><c> level</c><00:03:04.620><c> just</c><00:03:05.610><c> look</c><00:03:05.850><c> for</c><00:03:06.090><c> the</c><00:03:06.150><c> buttons</c><00:03:06.510><c> to</c>

00:03:06.770 --> 00:03:06.780 align:start position:0%
by level just look for the buttons to
 

00:03:06.780 --> 00:03:09.260 align:start position:0%
by level just look for the buttons to
the<00:03:06.810><c> left</c><00:03:07.200><c> of</c><00:03:07.410><c> your</c><00:03:07.500><c> worksheet</c><00:03:07.950><c> the</c><00:03:08.850><c> highest</c>

00:03:09.260 --> 00:03:09.270 align:start position:0%
the left of your worksheet the highest
 

00:03:09.270 --> 00:03:11.690 align:start position:0%
the left of your worksheet the highest
level<00:03:09.690><c> which</c><00:03:10.050><c> is</c><00:03:10.260><c> three</c><00:03:10.620><c> in</c><00:03:10.800><c> this</c><00:03:10.920><c> case</c><00:03:11.190><c> will</c>

00:03:11.690 --> 00:03:11.700 align:start position:0%
level which is three in this case will
 

00:03:11.700 --> 00:03:14.660 align:start position:0%
level which is three in this case will
show<00:03:11.940><c> all</c><00:03:12.180><c> of</c><00:03:12.360><c> your</c><00:03:12.510><c> data</c><00:03:13.250><c> level</c><00:03:14.250><c> two</c><00:03:14.430><c> will</c>

00:03:14.660 --> 00:03:14.670 align:start position:0%
show all of your data level two will
 

00:03:14.670 --> 00:03:17.120 align:start position:0%
show all of your data level two will
hide<00:03:14.820><c> the</c><00:03:14.970><c> details</c><00:03:15.390><c> of</c><00:03:15.600><c> each</c><00:03:15.720><c> size</c><00:03:16.130><c> leaving</c>

00:03:17.120 --> 00:03:17.130 align:start position:0%
hide the details of each size leaving
 

00:03:17.130 --> 00:03:20.090 align:start position:0%
hide the details of each size leaving
just<00:03:17.430><c> the</c><00:03:17.580><c> individual</c><00:03:18.120><c> subtotals</c><00:03:19.100><c> finally</c>

00:03:20.090 --> 00:03:20.100 align:start position:0%
just the individual subtotals finally
 

00:03:20.100 --> 00:03:22.580 align:start position:0%
just the individual subtotals finally
level<00:03:20.640><c> one</c><00:03:20.880><c> will</c><00:03:21.090><c> hide</c><00:03:21.270><c> everything</c><00:03:21.959><c> so</c><00:03:22.319><c> we</c><00:03:22.440><c> can</c>

00:03:22.580 --> 00:03:22.590 align:start position:0%
level one will hide everything so we can
 

00:03:22.590 --> 00:03:24.340 align:start position:0%
level one will hide everything so we can
only<00:03:22.770><c> see</c><00:03:23.069><c> the</c><00:03:23.100><c> grand</c><00:03:23.459><c> total</c>

00:03:24.340 --> 00:03:24.350 align:start position:0%
only see the grand total
 

00:03:24.350 --> 00:03:26.780 align:start position:0%
only see the grand total
let's<00:03:25.350><c> click</c><00:03:25.590><c> three</c><00:03:25.950><c> to</c><00:03:26.130><c> show</c><00:03:26.280><c> the</c><00:03:26.459><c> entire</c>

00:03:26.780 --> 00:03:26.790 align:start position:0%
let's click three to show the entire
 

00:03:26.790 --> 00:03:28.650 align:start position:0%
let's click three to show the entire
worksheet<00:03:27.150><c> again</c>

00:03:28.650 --> 00:03:28.660 align:start position:0%
worksheet again
 

00:03:28.660 --> 00:03:31.050 align:start position:0%
worksheet again
okay<00:03:29.590><c> there's</c><00:03:29.860><c> one</c><00:03:29.920><c> more</c><00:03:30.370><c> thing</c><00:03:30.610><c> we'd</c><00:03:30.820><c> like</c><00:03:30.850><c> to</c>

00:03:31.050 --> 00:03:31.060 align:start position:0%
okay there's one more thing we'd like to
 

00:03:31.060 --> 00:03:34.020 align:start position:0%
okay there's one more thing we'd like to
point<00:03:31.450><c> out</c><00:03:31.630><c> when</c><00:03:32.380><c> you</c><00:03:32.530><c> use</c><00:03:32.770><c> subtotals</c><00:03:33.550><c> you'll</c>

00:03:34.020 --> 00:03:34.030 align:start position:0%
point out when you use subtotals you'll
 

00:03:34.030 --> 00:03:35.610 align:start position:0%
point out when you use subtotals you'll
notice<00:03:34.360><c> these</c><00:03:34.510><c> extra</c><00:03:35.020><c> rows</c><00:03:35.230><c> have</c><00:03:35.500><c> been</c>

00:03:35.610 --> 00:03:35.620 align:start position:0%
notice these extra rows have been
 

00:03:35.620 --> 00:03:37.590 align:start position:0%
notice these extra rows have been
inserted<00:03:35.950><c> in</c><00:03:36.250><c> the</c><00:03:36.340><c> spreadsheet</c><00:03:36.850><c> and</c><00:03:37.000><c> while</c>

00:03:37.590 --> 00:03:37.600 align:start position:0%
inserted in the spreadsheet and while
 

00:03:37.600 --> 00:03:39.240 align:start position:0%
inserted in the spreadsheet and while
they're<00:03:37.750><c> very</c><00:03:37.930><c> useful</c><00:03:38.290><c> for</c><00:03:38.800><c> viewing</c><00:03:39.010><c> our</c>

00:03:39.240 --> 00:03:39.250 align:start position:0%
they're very useful for viewing our
 

00:03:39.250 --> 00:03:41.460 align:start position:0%
they're very useful for viewing our
subtotal<00:03:39.760><c> information</c><00:03:40.540><c> if</c><00:03:41.020><c> you</c><00:03:41.200><c> need</c><00:03:41.380><c> to</c>

00:03:41.460 --> 00:03:41.470 align:start position:0%
subtotal information if you need to
 

00:03:41.470 --> 00:03:43.320 align:start position:0%
subtotal information if you need to
change<00:03:41.680><c> the</c><00:03:41.980><c> formatting</c><00:03:42.460><c> or</c><00:03:42.760><c> arrangement</c><00:03:43.120><c> of</c>

00:03:43.320 --> 00:03:43.330 align:start position:0%
change the formatting or arrangement of
 

00:03:43.330 --> 00:03:45.150 align:start position:0%
change the formatting or arrangement of
your<00:03:43.450><c> spreadsheet</c><00:03:44.020><c> you</c><00:03:44.230><c> might</c><00:03:44.770><c> find</c><00:03:45.010><c> that</c>

00:03:45.150 --> 00:03:45.160 align:start position:0%
your spreadsheet you might find that
 

00:03:45.160 --> 00:03:47.460 align:start position:0%
your spreadsheet you might find that
these<00:03:45.400><c> subtotal</c><00:03:46.030><c> rows</c><00:03:46.240><c> just</c><00:03:46.600><c> get</c><00:03:47.050><c> in</c><00:03:47.170><c> the</c><00:03:47.290><c> way</c>

00:03:47.460 --> 00:03:47.470 align:start position:0%
these subtotal rows just get in the way
 

00:03:47.470 --> 00:03:50.640 align:start position:0%
these subtotal rows just get in the way
in<00:03:47.710><c> a</c><00:03:48.520><c> case</c><00:03:48.730><c> like</c><00:03:48.970><c> this</c><00:03:49.030><c> it's</c><00:03:49.570><c> best</c><00:03:50.050><c> to</c><00:03:50.260><c> remove</c>

00:03:50.640 --> 00:03:50.650 align:start position:0%
in a case like this it's best to remove
 

00:03:50.650 --> 00:03:52.710 align:start position:0%
in a case like this it's best to remove
subtotals<00:03:51.400><c> from</c><00:03:51.580><c> your</c><00:03:51.730><c> spreadsheet</c><00:03:51.940><c> before</c>

00:03:52.710 --> 00:03:52.720 align:start position:0%
subtotals from your spreadsheet before
 

00:03:52.720 --> 00:03:56.010 align:start position:0%
subtotals from your spreadsheet before
you<00:03:52.810><c> make</c><00:03:52.990><c> any</c><00:03:53.140><c> other</c><00:03:53.230><c> big</c><00:03:53.710><c> changes</c><00:03:54.630><c> to</c><00:03:55.630><c> remove</c>

00:03:56.010 --> 00:03:56.020 align:start position:0%
you make any other big changes to remove
 

00:03:56.020 --> 00:03:58.470 align:start position:0%
you make any other big changes to remove
subtotals<00:03:56.680><c> from</c><00:03:56.860><c> your</c><00:03:57.010><c> worksheet</c><00:03:57.430><c> all</c><00:03:58.090><c> you</c>

00:03:58.470 --> 00:03:58.480 align:start position:0%
subtotals from your worksheet all you
 

00:03:58.480 --> 00:04:01.190 align:start position:0%
subtotals from your worksheet all you
have<00:03:58.630><c> to</c><00:03:58.810><c> do</c><00:03:58.960><c> is</c><00:03:59.140><c> click</c><00:03:59.380><c> the</c><00:03:59.530><c> subtotal</c><00:04:00.040><c> command</c>

00:04:01.190 --> 00:04:01.200 align:start position:0%
have to do is click the subtotal command
 

00:04:01.200 --> 00:04:04.170 align:start position:0%
have to do is click the subtotal command
then<00:04:02.200><c> click</c><00:04:02.560><c> the</c><00:04:02.740><c> button</c><00:04:02.860><c> that</c><00:04:03.130><c> says</c><00:04:03.190><c> remove</c>

00:04:04.170 --> 00:04:04.180 align:start position:0%
then click the button that says remove
 

00:04:04.180 --> 00:04:05.809 align:start position:0%
then click the button that says remove
all

00:04:05.809 --> 00:04:05.819 align:start position:0%
all
 

00:04:05.819 --> 00:04:08.059 align:start position:0%
all
grouping<00:04:06.810><c> and</c><00:04:06.930><c> subtitling</c><00:04:07.530><c> can</c><00:04:07.709><c> make</c><00:04:07.890><c> your</c>

00:04:08.059 --> 00:04:08.069 align:start position:0%
grouping and subtitling can make your
 

00:04:08.069 --> 00:04:10.429 align:start position:0%
grouping and subtitling can make your
worksheet<00:04:08.459><c> less</c><00:04:08.790><c> cluttered</c><00:04:09.299><c> more</c><00:04:09.840><c> organized</c>

00:04:10.429 --> 00:04:10.439 align:start position:0%
worksheet less cluttered more organized
 

00:04:10.439 --> 00:04:12.979 align:start position:0%
worksheet less cluttered more organized
and<00:04:10.769><c> easier</c><00:04:11.430><c> to</c><00:04:11.489><c> view</c><00:04:11.849><c> so</c><00:04:12.540><c> keep</c><00:04:12.780><c> these</c>

00:04:12.979 --> 00:04:12.989 align:start position:0%
and easier to view so keep these
 

00:04:12.989 --> 00:04:14.630 align:start position:0%
and easier to view so keep these
features<00:04:13.379><c> in</c><00:04:13.530><c> mind</c><00:04:13.739><c> the</c><00:04:13.920><c> next</c><00:04:14.069><c> time</c><00:04:14.340><c> you</c><00:04:14.609><c> need</c>

00:04:14.630 --> 00:04:14.640 align:start position:0%
features in mind the next time you need
 

00:04:14.640 --> 00:04:15.259 align:start position:0%
features in mind the next time you need
help

00:04:15.259 --> 00:04:15.269 align:start position:0%
help
 

00:04:15.269 --> 00:04:17.870 align:start position:0%
help
summarizing<00:04:15.870><c> your</c><00:04:15.900><c> data</c>

00:04:17.870 --> 00:04:17.880 align:start position:0%
summarizing your data
 

00:04:17.880 --> 00:04:19.940 align:start position:0%
summarizing your data
you