WEBVTT
Kind: captions
Language: en

00:00:09.290 --> 00:00:11.720 align:start position:0%
 
outlining<00:00:10.290><c> is</c><00:00:10.559><c> one</c><00:00:10.800><c> of</c><00:00:10.920><c> the</c><00:00:10.980><c> best</c><00:00:11.219><c> ways</c><00:00:11.460><c> of</c>

00:00:11.720 --> 00:00:11.730 align:start position:0%
outlining is one of the best ways of
 

00:00:11.730 --> 00:00:14.480 align:start position:0%
outlining is one of the best ways of
making<00:00:12.120><c> your</c><00:00:12.240><c> data</c><00:00:12.480><c> more</c><00:00:12.780><c> manageable</c><00:00:13.440><c> you</c><00:00:14.340><c> can</c>

00:00:14.480 --> 00:00:14.490 align:start position:0%
making your data more manageable you can
 

00:00:14.490 --> 00:00:17.510 align:start position:0%
making your data more manageable you can
use<00:00:14.610><c> it</c><00:00:14.759><c> to</c><00:00:14.910><c> automatically</c><00:00:15.540><c> add</c><00:00:15.809><c> subtotals</c><00:00:16.529><c> to</c>

00:00:17.510 --> 00:00:17.520 align:start position:0%
use it to automatically add subtotals to
 

00:00:17.520 --> 00:00:19.400 align:start position:0%
use it to automatically add subtotals to
group<00:00:17.789><c> certain</c><00:00:18.180><c> rows</c><00:00:18.420><c> or</c><00:00:18.660><c> columns</c><00:00:18.690><c> together</c>

00:00:19.400 --> 00:00:19.410 align:start position:0%
group certain rows or columns together
 

00:00:19.410 --> 00:00:22.279 align:start position:0%
group certain rows or columns together
and<00:00:19.740><c> also</c><00:00:20.640><c> to</c><00:00:20.880><c> hide</c><00:00:21.270><c> details</c><00:00:21.779><c> that</c><00:00:21.990><c> you</c><00:00:22.080><c> don't</c>

00:00:22.279 --> 00:00:22.289 align:start position:0%
and also to hide details that you don't
 

00:00:22.289 --> 00:00:25.790 align:start position:0%
and also to hide details that you don't
need<00:00:22.439><c> to</c><00:00:22.500><c> see</c><00:00:22.800><c> in</c><00:00:23.869><c> this</c><00:00:24.869><c> example</c><00:00:25.260><c> I</c><00:00:25.590><c> have</c><00:00:25.769><c> a</c>

00:00:25.790 --> 00:00:25.800 align:start position:0%
need to see in this example I have a
 

00:00:25.800 --> 00:00:28.310 align:start position:0%
need to see in this example I have a
t-shirt<00:00:26.099><c> order</c><00:00:26.640><c> form</c><00:00:26.910><c> and</c><00:00:27.119><c> I'd</c><00:00:27.900><c> like</c><00:00:28.019><c> to</c><00:00:28.170><c> know</c>

00:00:28.310 --> 00:00:28.320 align:start position:0%
t-shirt order form and I'd like to know
 

00:00:28.320 --> 00:00:30.349 align:start position:0%
t-shirt order form and I'd like to know
how<00:00:28.560><c> many</c><00:00:28.619><c> of</c><00:00:28.890><c> each</c><00:00:29.039><c> size</c><00:00:29.400><c> have</c><00:00:29.760><c> been</c><00:00:29.939><c> ordered</c>

00:00:30.349 --> 00:00:30.359 align:start position:0%
how many of each size have been ordered
 

00:00:30.359 --> 00:00:34.010 align:start position:0%
how many of each size have been ordered
so<00:00:30.960><c> I'll</c><00:00:31.199><c> use</c><00:00:31.470><c> the</c><00:00:31.740><c> subtotal</c><00:00:32.189><c> command</c><00:00:33.020><c> before</c>

00:00:34.010 --> 00:00:34.020 align:start position:0%
so I'll use the subtotal command before
 

00:00:34.020 --> 00:00:36.410 align:start position:0%
so I'll use the subtotal command before
you<00:00:34.320><c> create</c><00:00:34.590><c> subtotals</c><00:00:35.430><c> you'll</c><00:00:35.700><c> need</c><00:00:35.910><c> to</c><00:00:36.090><c> sort</c>

00:00:36.410 --> 00:00:36.420 align:start position:0%
you create subtotals you'll need to sort
 

00:00:36.420 --> 00:00:38.660 align:start position:0%
you create subtotals you'll need to sort
your<00:00:36.660><c> data</c><00:00:36.930><c> and</c><00:00:37.230><c> I've</c><00:00:37.800><c> already</c><00:00:38.010><c> sorted</c><00:00:38.550><c> it</c><00:00:38.640><c> by</c>

00:00:38.660 --> 00:00:38.670 align:start position:0%
your data and I've already sorted it by
 

00:00:38.670 --> 00:00:41.369 align:start position:0%
your data and I've already sorted it by
t-shirt<00:00:39.270><c> size</c>

00:00:41.369 --> 00:00:41.379 align:start position:0%
t-shirt size
 

00:00:41.379 --> 00:00:44.009 align:start position:0%
t-shirt size
the<00:00:42.070><c> subtotal</c><00:00:42.609><c> command</c><00:00:42.640><c> is</c><00:00:43.149><c> found</c><00:00:43.480><c> on</c><00:00:43.750><c> the</c>

00:00:44.009 --> 00:00:44.019 align:start position:0%
the subtotal command is found on the
 

00:00:44.019 --> 00:00:47.240 align:start position:0%
the subtotal command is found on the
data<00:00:44.230><c> tab</c>

00:00:47.240 --> 00:00:47.250 align:start position:0%
 
 

00:00:47.250 --> 00:00:48.800 align:start position:0%
 
and<00:00:47.850><c> it</c><00:00:47.940><c> will</c><00:00:48.030><c> open</c><00:00:48.180><c> up</c>

00:00:48.800 --> 00:00:48.810 align:start position:0%
and it will open up
 

00:00:48.810 --> 00:00:54.700 align:start position:0%
and it will open up
Lockbox

00:00:54.700 --> 00:00:54.710 align:start position:0%
 
 

00:00:54.710 --> 00:00:56.860 align:start position:0%
 
here<00:00:55.430><c> we'll</c><00:00:55.700><c> select</c><00:00:55.880><c> the</c><00:00:56.270><c> column</c><00:00:56.630><c> this</c><00:00:56.810><c> is</c>

00:00:56.860 --> 00:00:56.870 align:start position:0%
here we'll select the column this is
 

00:00:56.870 --> 00:00:58.920 align:start position:0%
here we'll select the column this is
going<00:00:57.110><c> to</c><00:00:57.200><c> be</c><00:00:57.290><c> the</c><00:00:57.410><c> basis</c><00:00:57.830><c> for</c><00:00:57.860><c> the</c><00:00:58.070><c> outline</c><00:00:58.490><c> in</c>

00:00:58.920 --> 00:00:58.930 align:start position:0%
going to be the basis for the outline in
 

00:00:58.930 --> 00:01:01.780 align:start position:0%
going to be the basis for the outline in
this<00:00:59.930><c> case</c><00:01:00.170><c> I'll</c><00:01:00.410><c> pick</c><00:01:00.650><c> t-shirt</c><00:01:01.100><c> size</c><00:01:01.370><c> because</c>

00:01:01.780 --> 00:01:01.790 align:start position:0%
this case I'll pick t-shirt size because
 

00:01:01.790 --> 00:01:05.149 align:start position:0%
this case I'll pick t-shirt size because
that's<00:01:02.000><c> how</c><00:01:02.150><c> my</c><00:01:02.300><c> spreadsheet</c><00:01:02.810><c> is</c><00:01:02.989><c> sorted</c>

00:01:05.149 --> 00:01:05.159 align:start position:0%
that's how my spreadsheet is sorted
 

00:01:05.159 --> 00:01:07.370 align:start position:0%
that's how my spreadsheet is sorted
then<00:01:05.850><c> you'll</c><00:01:06.210><c> need</c><00:01:06.420><c> to</c><00:01:06.509><c> pick</c><00:01:06.659><c> the</c><00:01:06.899><c> function</c>

00:01:07.370 --> 00:01:07.380 align:start position:0%
then you'll need to pick the function
 

00:01:07.380 --> 00:01:09.380 align:start position:0%
then you'll need to pick the function
that<00:01:07.469><c> you'll</c><00:01:07.619><c> be</c><00:01:07.740><c> using</c><00:01:08.100><c> there</c><00:01:09.090><c> are</c><00:01:09.240><c> some</c>

00:01:09.380 --> 00:01:09.390 align:start position:0%
that you'll be using there are some
 

00:01:09.390 --> 00:01:11.870 align:start position:0%
that you'll be using there are some
common<00:01:09.689><c> functions</c><00:01:10.110><c> like</c><00:01:10.259><c> sum</c><00:01:10.649><c> average</c><00:01:11.039><c> and</c>

00:01:11.870 --> 00:01:11.880 align:start position:0%
common functions like sum average and
 

00:01:11.880 --> 00:01:13.940 align:start position:0%
common functions like sum average and
product<00:01:12.329><c> but</c><00:01:12.930><c> we're</c><00:01:13.110><c> going</c><00:01:13.289><c> to</c><00:01:13.380><c> use</c><00:01:13.470><c> count</c>

00:01:13.940 --> 00:01:13.950 align:start position:0%
product but we're going to use count
 

00:01:13.950 --> 00:01:15.440 align:start position:0%
product but we're going to use count
which<00:01:14.250><c> will</c><00:01:14.430><c> just</c><00:01:14.549><c> count</c><00:01:14.850><c> the</c><00:01:15.000><c> number</c><00:01:15.030><c> of</c>

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

00:01:15.450 --> 00:01:18.770 align:start position:0%
which will just count the number of
cells<00:01:15.869><c> that</c><00:01:16.200><c> contain</c><00:01:16.530><c> each</c><00:01:16.860><c> size</c><00:01:17.189><c> if</c><00:01:17.659><c> you</c><00:01:18.659><c> had</c>

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

00:01:18.780 --> 00:01:20.929 align:start position:0%
cells that contain each size if you had
numerical<00:01:19.320><c> data</c><00:01:19.530><c> you</c><00:01:19.710><c> could</c><00:01:19.860><c> select</c><00:01:20.070><c> sum</c><00:01:20.670><c> and</c>

00:01:20.929 --> 00:01:20.939 align:start position:0%
numerical data you could select sum and
 

00:01:20.939 --> 00:01:22.609 align:start position:0%
numerical data you could select sum and
it<00:01:21.179><c> would</c><00:01:21.270><c> actually</c><00:01:21.420><c> add</c><00:01:21.689><c> up</c><00:01:21.899><c> the</c><00:01:22.049><c> values</c><00:01:22.439><c> of</c>

00:01:22.609 --> 00:01:22.619 align:start position:0%
it would actually add up the values of
 

00:01:22.619 --> 00:01:26.960 align:start position:0%
it would actually add up the values of
the<00:01:22.710><c> cells</c><00:01:22.890><c> to</c><00:01:23.130><c> create</c><00:01:23.250><c> a</c><00:01:23.429><c> subtotal</c><00:01:25.970><c> here</c>

00:01:26.960 --> 00:01:26.970 align:start position:0%
the cells to create a subtotal here
 

00:01:26.970 --> 00:01:28.550 align:start position:0%
the cells to create a subtotal here
we'll<00:01:27.240><c> select</c><00:01:27.450><c> the</c><00:01:27.780><c> column</c><00:01:28.079><c> where</c><00:01:28.229><c> we</c><00:01:28.350><c> want</c>

00:01:28.550 --> 00:01:28.560 align:start position:0%
we'll select the column where we want
 

00:01:28.560 --> 00:01:35.730 align:start position:0%
we'll select the column where we want
the<00:01:28.679><c> subtotal</c><00:01:29.159><c> to</c><00:01:29.280><c> appear</c><00:01:29.670><c> and</c><00:01:30.079><c> then</c><00:01:31.079><c> click</c><00:01:31.110><c> OK</c>

00:01:35.730 --> 00:01:35.740 align:start position:0%
 
 

00:01:35.740 --> 00:01:37.410 align:start position:0%
 
now<00:01:36.430><c> a</c><00:01:36.460><c> couple</c><00:01:36.790><c> of</c><00:01:36.940><c> things</c><00:01:37.000><c> have</c><00:01:37.390><c> happened</c>

00:01:37.410 --> 00:01:37.420 align:start position:0%
now a couple of things have happened
 

00:01:37.420 --> 00:01:40.890 align:start position:0%
now a couple of things have happened
here<00:01:37.960><c> each</c><00:01:38.920><c> t-shirt</c><00:01:39.400><c> size</c><00:01:39.850><c> is</c><00:01:40.180><c> now</c><00:01:40.390><c> in</c><00:01:40.600><c> its</c><00:01:40.750><c> own</c>

00:01:40.890 --> 00:01:40.900 align:start position:0%
here each t-shirt size is now in its own
 

00:01:40.900 --> 00:01:43.399 align:start position:0%
here each t-shirt size is now in its own
group<00:01:41.350><c> which</c><00:01:41.740><c> is</c><00:01:41.890><c> shown</c><00:01:42.070><c> by</c><00:01:42.190><c> this</c><00:01:42.250><c> bracket</c><00:01:42.820><c> and</c>

00:01:43.399 --> 00:01:43.409 align:start position:0%
group which is shown by this bracket and
 

00:01:43.409 --> 00:01:46.859 align:start position:0%
group which is shown by this bracket and
all<00:01:44.409><c> of</c><00:01:44.770><c> those</c><00:01:44.950><c> groups</c><00:01:45.340><c> are</c><00:01:45.610><c> inside</c><00:01:46.150><c> a</c><00:01:46.180><c> larger</c>

00:01:46.859 --> 00:01:46.869 align:start position:0%
all of those groups are inside a larger
 

00:01:46.869 --> 00:01:50.999 align:start position:0%
all of those groups are inside a larger
group<00:01:47.080><c> and</c><00:01:47.350><c> this</c><00:01:48.010><c> is</c><00:01:48.070><c> called</c><00:01:48.460><c> an</c><00:01:48.729><c> outline</c><00:01:50.009><c> the</c>

00:01:50.999 --> 00:01:51.009 align:start position:0%
group and this is called an outline the
 

00:01:51.009 --> 00:01:52.770 align:start position:0%
group and this is called an outline the
other<00:01:51.220><c> thing</c><00:01:51.610><c> that's</c><00:01:51.759><c> happened</c><00:01:52.210><c> is</c><00:01:52.390><c> that</c><00:01:52.600><c> each</c>

00:01:52.770 --> 00:01:52.780 align:start position:0%
other thing that's happened is that each
 

00:01:52.780 --> 00:01:55.590 align:start position:0%
other thing that's happened is that each
group<00:01:53.140><c> now</c><00:01:53.440><c> has</c><00:01:53.710><c> a</c><00:01:53.740><c> subtotal</c><00:01:54.340><c> under</c><00:01:54.670><c> it</c><00:01:54.790><c> so</c><00:01:55.479><c> we</c>

00:01:55.590 --> 00:01:55.600 align:start position:0%
group now has a subtotal under it so we
 

00:01:55.600 --> 00:01:57.060 align:start position:0%
group now has a subtotal under it so we
can<00:01:55.720><c> see</c><00:01:55.869><c> the</c><00:01:55.990><c> number</c><00:01:56.259><c> of</c><00:01:56.290><c> shirts</c><00:01:56.619><c> that</c><00:01:56.920><c> there</c>

00:01:57.060 --> 00:01:57.070 align:start position:0%
can see the number of shirts that there
 

00:01:57.070 --> 00:01:59.700 align:start position:0%
can see the number of shirts that there
are<00:01:57.190><c> in</c><00:01:57.399><c> each</c><00:01:57.550><c> size</c><00:01:57.909><c> and</c><00:01:58.270><c> at</c><00:01:59.170><c> the</c><00:01:59.259><c> very</c><00:01:59.470><c> bottom</c>

00:01:59.700 --> 00:01:59.710 align:start position:0%
are in each size and at the very bottom
 

00:01:59.710 --> 00:02:03.920 align:start position:0%
are in each size and at the very bottom
we<00:01:59.950><c> can</c><00:02:00.190><c> see</c><00:02:00.430><c> the</c><00:02:00.580><c> total</c>

00:02:03.920 --> 00:02:03.930 align:start position:0%
 
 

00:02:03.930 --> 00:02:06.050 align:start position:0%
 
to<00:02:04.440><c> make</c><00:02:04.590><c> the</c><00:02:04.740><c> spreadsheet</c><00:02:04.950><c> easier</c><00:02:05.670><c> to</c><00:02:05.820><c> read</c>

00:02:06.050 --> 00:02:06.060 align:start position:0%
to make the spreadsheet easier to read
 

00:02:06.060 --> 00:02:08.389 align:start position:0%
to make the spreadsheet easier to read
you<00:02:06.450><c> can</c><00:02:06.630><c> hide</c><00:02:06.900><c> the</c><00:02:07.080><c> details</c><00:02:07.320><c> of</c><00:02:07.800><c> each</c><00:02:07.980><c> group</c>

00:02:08.389 --> 00:02:08.399 align:start position:0%
you can hide the details of each group
 

00:02:08.399 --> 00:02:10.639 align:start position:0%
you can hide the details of each group
so<00:02:08.970><c> that</c><00:02:09.119><c> you</c><00:02:09.240><c> only</c><00:02:09.479><c> see</c><00:02:09.810><c> the</c><00:02:09.930><c> subtotals</c><00:02:10.560><c> and</c>

00:02:10.639 --> 00:02:10.649 align:start position:0%
so that you only see the subtotals and
 

00:02:10.649 --> 00:02:13.700 align:start position:0%
so that you only see the subtotals and
the<00:02:10.890><c> grand</c><00:02:11.130><c> total</c><00:02:11.870><c> you</c><00:02:12.870><c> can</c><00:02:13.020><c> hide</c><00:02:13.230><c> a</c><00:02:13.260><c> group</c><00:02:13.560><c> by</c>

00:02:13.700 --> 00:02:13.710 align:start position:0%
the grand total you can hide a group by
 

00:02:13.710 --> 00:02:15.980 align:start position:0%
the grand total you can hide a group by
clicking<00:02:13.920><c> the</c><00:02:14.190><c> minus</c><00:02:14.400><c> sign</c>

00:02:15.980 --> 00:02:15.990 align:start position:0%
clicking the minus sign
 

00:02:15.990 --> 00:02:22.030 align:start position:0%
clicking the minus sign
and<00:02:16.080><c> to</c><00:02:16.980><c> show</c><00:02:17.160><c> it</c><00:02:17.190><c> again</c><00:02:17.340><c> click</c><00:02:17.760><c> the</c><00:02:18.030><c> plus</c><00:02:18.270><c> sign</c>

00:02:22.030 --> 00:02:22.040 align:start position:0%
 
 

00:02:22.040 --> 00:02:24.670 align:start position:0%
 
you<00:02:22.700><c> can</c><00:02:22.849><c> also</c><00:02:23.060><c> hide</c><00:02:23.540><c> or</c><00:02:23.810><c> show</c><00:02:23.840><c> groups</c><00:02:24.349><c> by</c>

00:02:24.670 --> 00:02:24.680 align:start position:0%
you can also hide or show groups by
 

00:02:24.680 --> 00:02:29.530 align:start position:0%
you can also hide or show groups by
level<00:02:25.250><c> by</c><00:02:25.700><c> clicking</c><00:02:25.760><c> on</c><00:02:26.239><c> these</c><00:02:26.540><c> numbers</c>

00:02:29.530 --> 00:02:29.540 align:start position:0%
 
 

00:02:29.540 --> 00:02:31.300 align:start position:0%
 
the<00:02:29.780><c> highest</c><00:02:30.140><c> level</c><00:02:30.470><c> which</c><00:02:30.650><c> in</c><00:02:30.799><c> this</c><00:02:30.890><c> case</c><00:02:31.099><c> is</c>

00:02:31.300 --> 00:02:31.310 align:start position:0%
the highest level which in this case is
 

00:02:31.310 --> 00:02:33.899 align:start position:0%
the highest level which in this case is
three<00:02:31.730><c> will</c><00:02:32.269><c> show</c><00:02:32.510><c> all</c><00:02:32.780><c> of</c><00:02:32.989><c> your</c><00:02:33.110><c> data</c><00:02:33.290><c> and</c>

00:02:33.899 --> 00:02:33.909 align:start position:0%
three will show all of your data and
 

00:02:33.909 --> 00:02:36.729 align:start position:0%
three will show all of your data and
level<00:02:34.909><c> two</c><00:02:35.120><c> hides</c><00:02:35.480><c> the</c><00:02:35.720><c> details</c><00:02:36.079><c> of</c><00:02:36.260><c> each</c><00:02:36.349><c> size</c>

00:02:36.729 --> 00:02:36.739 align:start position:0%
level two hides the details of each size
 

00:02:36.739 --> 00:02:38.890 align:start position:0%
level two hides the details of each size
so<00:02:37.400><c> we</c><00:02:37.579><c> can</c><00:02:37.730><c> still</c><00:02:38.000><c> see</c><00:02:38.209><c> the</c><00:02:38.360><c> individual</c>

00:02:38.890 --> 00:02:38.900 align:start position:0%
so we can still see the individual
 

00:02:38.900 --> 00:02:42.220 align:start position:0%
so we can still see the individual
subtotals<00:02:39.530><c> and</c><00:02:40.120><c> then</c><00:02:41.120><c> level</c><00:02:41.480><c> one</c><00:02:41.750><c> will</c><00:02:42.019><c> hide</c>

00:02:42.220 --> 00:02:42.230 align:start position:0%
subtotals and then level one will hide
 

00:02:42.230 --> 00:02:45.380 align:start position:0%
subtotals and then level one will hide
those<00:02:42.590><c> so</c><00:02:43.069><c> we</c><00:02:43.189><c> only</c><00:02:43.400><c> see</c><00:02:43.610><c> the</c><00:02:43.970><c> total</c>

00:02:45.380 --> 00:02:45.390 align:start position:0%
those so we only see the total
 

00:02:45.390 --> 00:02:47.330 align:start position:0%
those so we only see the total
and<00:02:45.990><c> I'll</c><00:02:46.080><c> click</c><00:02:46.260><c> on</c><00:02:46.380><c> three</c><00:02:46.710><c> again</c><00:02:46.800><c> so</c><00:02:47.100><c> I</c><00:02:47.160><c> can</c>

00:02:47.330 --> 00:02:47.340 align:start position:0%
and I'll click on three again so I can
 

00:02:47.340 --> 00:02:52.160 align:start position:0%
and I'll click on three again so I can
see<00:02:47.550><c> everything</c>

00:02:52.160 --> 00:02:52.170 align:start position:0%
 
 

00:02:52.170 --> 00:02:54.110 align:start position:0%
 
if<00:02:52.230><c> you</c><00:02:52.890><c> decide</c><00:02:53.160><c> you</c><00:02:53.310><c> don't</c><00:02:53.550><c> want</c><00:02:53.730><c> part</c><00:02:54.090><c> of</c>

00:02:54.110 --> 00:02:54.120 align:start position:0%
if you decide you don't want part of
 

00:02:54.120 --> 00:02:55.460 align:start position:0%
if you decide you don't want part of
your<00:02:54.240><c> spreadsheet</c><00:02:54.450><c> to</c><00:02:54.750><c> collapse</c><00:02:55.050><c> you</c><00:02:55.290><c> can</c>

00:02:55.460 --> 00:02:55.470 align:start position:0%
your spreadsheet to collapse you can
 

00:02:55.470 --> 00:02:56.330 align:start position:0%
your spreadsheet to collapse you can
ungroup<00:02:55.680><c> it</c>

00:02:56.330 --> 00:02:56.340 align:start position:0%
ungroup it
 

00:02:56.340 --> 00:02:59.210 align:start position:0%
ungroup it
I'd<00:02:57.330><c> like</c><00:02:57.599><c> to</c><00:02:57.720><c> ungroup</c><00:02:58.140><c> the</c><00:02:58.440><c> small</c><00:02:58.770><c> t-shirts</c>

00:02:59.210 --> 00:02:59.220 align:start position:0%
I'd like to ungroup the small t-shirts
 

00:02:59.220 --> 00:03:03.130 align:start position:0%
I'd like to ungroup the small t-shirts
so<00:03:00.120><c> I'll</c><00:03:00.510><c> select</c><00:03:00.870><c> the</c><00:03:01.080><c> cells</c>

00:03:03.130 --> 00:03:03.140 align:start position:0%
so I'll select the cells
 

00:03:03.140 --> 00:03:06.300 align:start position:0%
so I'll select the cells
and<00:03:03.230><c> then</c><00:03:03.710><c> click</c><00:03:04.010><c> the</c><00:03:04.370><c> ungroup</c><00:03:04.940><c> command</c><00:03:05.390><c> and</c>

00:03:06.300 --> 00:03:06.310 align:start position:0%
and then click the ungroup command and
 

00:03:06.310 --> 00:03:13.360 align:start position:0%
and then click the ungroup command and
in<00:03:07.310><c> this</c><00:03:07.459><c> case</c><00:03:07.760><c> we</c><00:03:08.000><c> run</c><00:03:08.060><c> grouping</c><00:03:08.540><c> the</c><00:03:08.660><c> rows</c>

00:03:13.360 --> 00:03:13.370 align:start position:0%
 
 

00:03:13.370 --> 00:03:15.640 align:start position:0%
 
now<00:03:13.910><c> remember</c><00:03:14.420><c> that</c><00:03:14.450><c> all</c><00:03:14.810><c> of</c><00:03:15.019><c> the</c><00:03:15.140><c> groups</c><00:03:15.410><c> are</c>

00:03:15.640 --> 00:03:15.650 align:start position:0%
now remember that all of the groups are
 

00:03:15.650 --> 00:03:18.009 align:start position:0%
now remember that all of the groups are
inside<00:03:16.069><c> a</c><00:03:16.099><c> larger</c><00:03:16.640><c> group</c><00:03:16.849><c> so</c><00:03:17.599><c> we'll</c><00:03:17.780><c> need</c><00:03:17.959><c> to</c>

00:03:18.009 --> 00:03:18.019 align:start position:0%
inside a larger group so we'll need to
 

00:03:18.019 --> 00:03:20.170 align:start position:0%
inside a larger group so we'll need to
click<00:03:18.319><c> on</c><00:03:18.470><c> group</c><00:03:18.860><c> again</c><00:03:19.340><c> to</c><00:03:19.760><c> completely</c>

00:03:20.170 --> 00:03:20.180 align:start position:0%
click on group again to completely
 

00:03:20.180 --> 00:03:27.110 align:start position:0%
click on group again to completely
ungroup<00:03:20.780><c> it</c>

00:03:27.110 --> 00:03:27.120 align:start position:0%
 
 

00:03:27.120 --> 00:03:29.030 align:start position:0%
 
now<00:03:27.720><c> you</c><00:03:27.780><c> can</c><00:03:28.080><c> see</c><00:03:28.260><c> that</c><00:03:28.379><c> the</c><00:03:28.500><c> brackets</c><00:03:28.920><c> are</c>

00:03:29.030 --> 00:03:29.040 align:start position:0%
now you can see that the brackets are
 

00:03:29.040 --> 00:03:31.490 align:start position:0%
now you can see that the brackets are
gone<00:03:29.250><c> from</c><00:03:29.459><c> these</c><00:03:29.640><c> rows</c><00:03:29.970><c> and</c><00:03:30.300><c> they</c><00:03:31.290><c> won't</c>

00:03:31.490 --> 00:03:31.500 align:start position:0%
gone from these rows and they won't
 

00:03:31.500 --> 00:03:34.670 align:start position:0%
gone from these rows and they won't
collapse<00:03:31.830><c> when</c><00:03:32.129><c> you</c><00:03:32.220><c> change</c><00:03:32.459><c> the</c><00:03:32.550><c> level</c>

00:03:34.670 --> 00:03:34.680 align:start position:0%
collapse when you change the level
 

00:03:34.680 --> 00:03:37.160 align:start position:0%
collapse when you change the level
you<00:03:35.250><c> can</c><00:03:35.430><c> also</c><00:03:35.670><c> ungroup</c><00:03:36.390><c> everything</c><00:03:36.959><c> and</c>

00:03:37.160 --> 00:03:37.170 align:start position:0%
you can also ungroup everything and
 

00:03:37.170 --> 00:03:39.470 align:start position:0%
you can also ungroup everything and
remove<00:03:37.680><c> all</c><00:03:37.860><c> of</c><00:03:37.890><c> the</c><00:03:38.099><c> subtotals</c><00:03:38.670><c> by</c><00:03:39.120><c> going</c><00:03:39.360><c> to</c>

00:03:39.470 --> 00:03:39.480 align:start position:0%
remove all of the subtotals by going to
 

00:03:39.480 --> 00:03:43.780 align:start position:0%
remove all of the subtotals by going to
the<00:03:39.599><c> subtotal</c><00:03:40.200><c> command</c>

00:03:43.780 --> 00:03:43.790 align:start position:0%
 
 

00:03:43.790 --> 00:03:49.940 align:start position:0%
 
and<00:03:43.879><c> clicking</c><00:03:44.209><c> remove</c><00:03:44.780><c> all</c>

00:03:49.940 --> 00:03:49.950 align:start position:0%
 
 

00:03:49.950 --> 00:03:51.890 align:start position:0%
 
if<00:03:50.010><c> you</c><00:03:50.670><c> want</c><00:03:50.940><c> you</c><00:03:51.150><c> can</c><00:03:51.330><c> create</c><00:03:51.540><c> your</c><00:03:51.840><c> own</c>

00:03:51.890 --> 00:03:51.900 align:start position:0%
if you want you can create your own
 

00:03:51.900 --> 00:03:55.430 align:start position:0%
if you want you can create your own
groups<00:03:52.379><c> of</c><00:03:52.680><c> either</c><00:03:52.860><c> rows</c><00:03:53.220><c> or</c><00:03:53.520><c> columns</c><00:03:53.550><c> in</c><00:03:54.440><c> this</c>

00:03:55.430 --> 00:03:55.440 align:start position:0%
groups of either rows or columns in this
 

00:03:55.440 --> 00:03:57.080 align:start position:0%
groups of either rows or columns in this
example<00:03:55.830><c> I</c><00:03:56.040><c> don't</c><00:03:56.220><c> really</c><00:03:56.489><c> need</c><00:03:56.730><c> to</c><00:03:56.910><c> see</c>

00:03:57.080 --> 00:03:57.090 align:start position:0%
example I don't really need to see
 

00:03:57.090 --> 00:03:59.479 align:start position:0%
example I don't really need to see
people's<00:03:57.420><c> names</c><00:03:57.720><c> or</c><00:03:57.989><c> the</c><00:03:58.110><c> payment</c><00:03:58.440><c> dates</c><00:03:58.620><c> so</c>

00:03:59.479 --> 00:03:59.489 align:start position:0%
people's names or the payment dates so
 

00:03:59.489 --> 00:04:03.790 align:start position:0%
people's names or the payment dates so
I'll<00:03:59.819><c> select</c><00:04:00.209><c> those</c><00:04:00.510><c> columns</c>

00:04:03.790 --> 00:04:03.800 align:start position:0%
 
 

00:04:03.800 --> 00:04:08.790 align:start position:0%
 
and<00:04:03.890><c> then</c><00:04:04.730><c> click</c><00:04:04.940><c> the</c><00:04:05.150><c> group</c><00:04:05.390><c> command</c>

00:04:08.790 --> 00:04:08.800 align:start position:0%
 
 

00:04:08.800 --> 00:04:13.200 align:start position:0%
 
and<00:04:08.890><c> now</c><00:04:09.580><c> I</c><00:04:09.610><c> can</c><00:04:09.940><c> just</c><00:04:09.970><c> hide</c><00:04:10.330><c> this</c><00:04:10.540><c> group</c><00:04:12.210><c> so</c>

00:04:13.200 --> 00:04:13.210 align:start position:0%
and now I can just hide this group so
 

00:04:13.210 --> 00:04:15.000 align:start position:0%
and now I can just hide this group so
grouping<00:04:13.690><c> data</c><00:04:13.720><c> can</c><00:04:14.170><c> make</c><00:04:14.320><c> your</c><00:04:14.440><c> spreadsheets</c>

00:04:15.000 --> 00:04:15.010 align:start position:0%
grouping data can make your spreadsheets
 

00:04:15.010 --> 00:04:18.330 align:start position:0%
grouping data can make your spreadsheets
less<00:04:15.400><c> cluttered</c><00:04:15.970><c> more</c><00:04:16.690><c> organized</c><00:04:17.290><c> and</c><00:04:17.590><c> easier</c>

00:04:18.330 --> 00:04:18.340 align:start position:0%
less cluttered more organized and easier
 

00:04:18.340 --> 00:04:23.010 align:start position:0%
less cluttered more organized and easier
to<00:04:18.610><c> view</c><00:04:19.620><c> like</c><00:04:20.620><c> what</c><00:04:20.799><c> you</c><00:04:20.950><c> just</c><00:04:20.980><c> saw</c><00:04:21.840><c> rate</c><00:04:22.840><c> it</c>

00:04:23.010 --> 00:04:23.020 align:start position:0%
to view like what you just saw rate it
 

00:04:23.020 --> 00:04:26.670 align:start position:0%
to view like what you just saw rate it
add<00:04:23.530><c> a</c><00:04:23.590><c> comment</c><00:04:23.920><c> subscribe</c><00:04:24.640><c> to</c><00:04:24.940><c> our</c><00:04:25.210><c> chill</c><00:04:25.680><c> the</c>

00:04:26.670 --> 00:04:26.680 align:start position:0%
add a comment subscribe to our chill the
 

00:04:26.680 --> 00:04:28.430 align:start position:0%
add a comment subscribe to our chill the
freedom<00:04:27.130><c> to</c><00:04:27.250><c> learn</c>

00:04:28.430 --> 00:04:28.440 align:start position:0%
freedom to learn
 

00:04:28.440 --> 00:04:33.770 align:start position:0%
freedom to learn
what<00:04:29.040><c> you</c><00:04:29.250><c> want</c><00:04:29.750><c> when</c><00:04:30.750><c> you</c><00:04:30.960><c> want</c><00:04:32.780><c> absolutely</c>

00:04:33.770 --> 00:04:33.780 align:start position:0%
what you want when you want absolutely
 

00:04:33.780 --> 00:04:37.320 align:start position:0%
what you want when you want absolutely
free

00:04:37.320 --> 00:04:37.330 align:start position:0%
 
 

00:04:37.330 --> 00:04:40.930 align:start position:0%
 
GCF<00:04:38.330><c> learn</c><00:04:38.900><c> free.org</c>