WEBVTT
Kind: captions
Language: en

00:00:01.149 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.149><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.120 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.760><c> life</c>

00:00:08.120 --> 00:00:08.130 align:start position:0%
 
 

00:00:08.130 --> 00:00:10.580 align:start position:0%
 
when<00:00:08.880><c> you</c><00:00:09.000><c> have</c><00:00:09.180><c> a</c><00:00:09.210><c> lot</c><00:00:09.570><c> of</c><00:00:09.780><c> different</c><00:00:10.140><c> Reds</c><00:00:10.380><c> in</c>

00:00:10.580 --> 00:00:10.590 align:start position:0%
when you have a lot of different Reds in
 

00:00:10.590 --> 00:00:12.560 align:start position:0%
when you have a lot of different Reds in
your<00:00:10.710><c> spreadsheet</c><00:00:11.250><c> you</c><00:00:11.790><c> may</c><00:00:11.970><c> want</c><00:00:12.210><c> to</c><00:00:12.270><c> sort</c>

00:00:12.560 --> 00:00:12.570 align:start position:0%
your spreadsheet you may want to sort
 

00:00:12.570 --> 00:00:14.860 align:start position:0%
your spreadsheet you may want to sort
the<00:00:12.780><c> data</c><00:00:12.960><c> so</c><00:00:13.320><c> you</c><00:00:13.350><c> can</c><00:00:13.620><c> view</c><00:00:13.860><c> it</c><00:00:13.920><c> more</c><00:00:14.220><c> easily</c>

00:00:14.860 --> 00:00:14.870 align:start position:0%
the data so you can view it more easily
 

00:00:14.870 --> 00:00:16.730 align:start position:0%
the data so you can view it more easily
sorting<00:00:15.870><c> can</c><00:00:16.049><c> reorder</c><00:00:16.470><c> things</c>

00:00:16.730 --> 00:00:16.740 align:start position:0%
sorting can reorder things
 

00:00:16.740 --> 00:00:19.850 align:start position:0%
sorting can reorder things
alphabetically<00:00:17.690><c> numerically</c><00:00:18.690><c> by</c><00:00:19.320><c> date</c><00:00:19.650><c> or</c>

00:00:19.850 --> 00:00:19.860 align:start position:0%
alphabetically numerically by date or
 

00:00:19.860 --> 00:00:23.110 align:start position:0%
alphabetically numerically by date or
even<00:00:20.670><c> in</c><00:00:20.820><c> a</c><00:00:20.910><c> custom</c><00:00:21.390><c> order</c><00:00:21.630><c> that</c><00:00:21.900><c> you</c><00:00:22.080><c> choose</c>

00:00:23.110 --> 00:00:23.120 align:start position:0%
even in a custom order that you choose
 

00:00:23.120 --> 00:00:25.610 align:start position:0%
even in a custom order that you choose
depending<00:00:24.120><c> on</c><00:00:24.270><c> your</c><00:00:24.390><c> preference</c><00:00:24.900><c> you</c><00:00:25.080><c> can</c>

00:00:25.610 --> 00:00:25.620 align:start position:0%
depending on your preference you can
 

00:00:25.620 --> 00:00:27.770 align:start position:0%
depending on your preference you can
either<00:00:25.710><c> sort</c><00:00:26.100><c> from</c><00:00:26.220><c> the</c><00:00:26.400><c> Home</c><00:00:26.610><c> tab</c><00:00:26.640><c> using</c><00:00:27.539><c> the</c>

00:00:27.770 --> 00:00:27.780 align:start position:0%
either sort from the Home tab using the
 

00:00:27.780 --> 00:00:31.040 align:start position:0%
either sort from the Home tab using the
sort<00:00:28.050><c> and</c><00:00:28.170><c> filter</c><00:00:28.230><c> drop-down</c><00:00:28.920><c> menu</c><00:00:29.370><c> or</c><00:00:30.050><c> you</c>

00:00:31.040 --> 00:00:31.050 align:start position:0%
sort and filter drop-down menu or you
 

00:00:31.050 --> 00:00:33.610 align:start position:0%
sort and filter drop-down menu or you
can<00:00:31.230><c> use</c><00:00:31.410><c> the</c><00:00:31.560><c> commands</c><00:00:31.950><c> in</c><00:00:32.099><c> the</c><00:00:32.160><c> data</c><00:00:32.460><c> tab</c><00:00:32.730><c> in</c>

00:00:33.610 --> 00:00:33.620 align:start position:0%
can use the commands in the data tab in
 

00:00:33.620 --> 00:00:36.410 align:start position:0%
can use the commands in the data tab in
this<00:00:34.620><c> example</c><00:00:35.010><c> I</c><00:00:35.400><c> have</c><00:00:35.699><c> a</c><00:00:35.730><c> worksheet</c><00:00:36.180><c> with</c><00:00:36.390><c> a</c>

00:00:36.410 --> 00:00:36.420 align:start position:0%
this example I have a worksheet with a
 

00:00:36.420 --> 00:00:38.750 align:start position:0%
this example I have a worksheet with a
list<00:00:36.780><c> of</c><00:00:36.930><c> t-shirt</c><00:00:37.410><c> orders</c><00:00:37.860><c> and</c><00:00:38.070><c> I'd</c><00:00:38.370><c> like</c><00:00:38.610><c> to</c>

00:00:38.750 --> 00:00:38.760 align:start position:0%
list of t-shirt orders and I'd like to
 

00:00:38.760 --> 00:00:42.110 align:start position:0%
list of t-shirt orders and I'd like to
sort<00:00:39.000><c> it</c><00:00:39.090><c> alphabetically</c><00:00:39.780><c> by</c><00:00:40.050><c> last</c><00:00:40.080><c> name</c><00:00:41.120><c> just</c>

00:00:42.110 --> 00:00:42.120 align:start position:0%
sort it alphabetically by last name just
 

00:00:42.120 --> 00:00:44.000 align:start position:0%
sort it alphabetically by last name just
click<00:00:42.300><c> any</c><00:00:42.570><c> cell</c><00:00:42.780><c> in</c><00:00:43.199><c> the</c><00:00:43.320><c> column</c><00:00:43.559><c> you</c><00:00:43.769><c> want</c><00:00:43.890><c> to</c>

00:00:44.000 --> 00:00:44.010 align:start position:0%
click any cell in the column you want to
 

00:00:44.010 --> 00:00:46.189 align:start position:0%
click any cell in the column you want to
sort<00:00:44.100><c> and</c><00:00:44.610><c> then</c><00:00:45.210><c> click</c><00:00:45.449><c> the</c><00:00:45.659><c> ascending</c>

00:00:46.189 --> 00:00:46.199 align:start position:0%
sort and then click the ascending
 

00:00:46.199 --> 00:00:49.930 align:start position:0%
sort and then click the ascending
command<00:00:46.620><c> that's</c><00:00:47.519><c> the</c><00:00:47.699><c> one</c><00:00:47.850><c> that</c><00:00:47.970><c> says</c><00:00:48.030><c> a</c><00:00:48.479><c> to</c><00:00:48.659><c> Z</c>

00:00:49.930 --> 00:00:49.940 align:start position:0%
command that's the one that says a to Z
 

00:00:49.940 --> 00:00:52.399 align:start position:0%
command that's the one that says a to Z
you'll<00:00:50.940><c> notice</c><00:00:51.330><c> that</c><00:00:51.510><c> when</c><00:00:51.690><c> we</c><00:00:51.809><c> sort</c><00:00:52.050><c> one</c>

00:00:52.399 --> 00:00:52.409 align:start position:0%
you'll notice that when we sort one
 

00:00:52.409 --> 00:00:55.399 align:start position:0%
you'll notice that when we sort one
column<00:00:52.860><c> Excel</c><00:00:53.850><c> also</c><00:00:54.059><c> reorders</c><00:00:55.019><c> the</c><00:00:55.229><c> other</c>

00:00:55.399 --> 00:00:55.409 align:start position:0%
column Excel also reorders the other
 

00:00:55.409 --> 00:00:57.680 align:start position:0%
column Excel also reorders the other
columns<00:00:55.949><c> so</c><00:00:56.190><c> that</c><00:00:56.309><c> each</c><00:00:56.519><c> row</c><00:00:56.909><c> still</c><00:00:57.360><c> has</c><00:00:57.540><c> the</c>

00:00:57.680 --> 00:00:57.690 align:start position:0%
columns so that each row still has the
 

00:00:57.690 --> 00:00:59.750 align:start position:0%
columns so that each row still has the
correct<00:00:57.989><c> information</c>

00:00:59.750 --> 00:00:59.760 align:start position:0%
correct information
 

00:00:59.760 --> 00:01:02.389 align:start position:0%
correct information
if<00:00:59.820><c> we</c><00:01:00.570><c> wanted</c><00:01:00.839><c> these</c><00:01:00.960><c> in</c><00:01:01.199><c> reverse</c><00:01:01.350><c> order</c><00:01:01.890><c> we</c>

00:01:02.389 --> 00:01:02.399 align:start position:0%
if we wanted these in reverse order we
 

00:01:02.399 --> 00:01:03.979 align:start position:0%
if we wanted these in reverse order we
could<00:01:02.550><c> click</c><00:01:02.789><c> the</c><00:01:02.969><c> descending</c><00:01:03.570><c> command</c>

00:01:03.979 --> 00:01:03.989 align:start position:0%
could click the descending command
 

00:01:03.989 --> 00:01:08.070 align:start position:0%
could click the descending command
that's<00:01:04.619><c> the</c><00:01:04.799><c> one</c><00:01:04.949><c> that</c><00:01:05.070><c> says</c><00:01:05.250><c> z2</c><00:01:05.880><c> eh</c>

00:01:08.070 --> 00:01:08.080 align:start position:0%
 
 

00:01:08.080 --> 00:01:10.680 align:start position:0%
 
now<00:01:08.830><c> this</c><00:01:09.130><c> method</c><00:01:09.370><c> doesn't</c><00:01:09.850><c> always</c><00:01:10.120><c> work</c><00:01:10.420><c> if</c>

00:01:10.680 --> 00:01:10.690 align:start position:0%
now this method doesn't always work if
 

00:01:10.690 --> 00:01:14.160 align:start position:0%
now this method doesn't always work if
your<00:01:10.810><c> spreadsheet</c><00:01:11.050><c> has</c><00:01:11.620><c> an</c><00:01:11.860><c> unusual</c><00:01:12.400><c> layout</c>

00:01:14.160 --> 00:01:14.170 align:start position:0%
your spreadsheet has an unusual layout
 

00:01:14.170 --> 00:01:16.320 align:start position:0%
your spreadsheet has an unusual layout
watch<00:01:14.920><c> what</c><00:01:15.159><c> happens</c><00:01:15.490><c> when</c><00:01:15.700><c> I</c><00:01:15.729><c> try</c><00:01:15.820><c> to</c><00:01:16.030><c> sort</c>

00:01:16.320 --> 00:01:16.330 align:start position:0%
watch what happens when I try to sort
 

00:01:16.330 --> 00:01:19.060 align:start position:0%
watch what happens when I try to sort
the<00:01:16.450><c> data</c><00:01:16.659><c> here</c><00:01:16.990><c> on</c><00:01:17.080><c> the</c><00:01:17.170><c> right</c>

00:01:19.060 --> 00:01:19.070 align:start position:0%
the data here on the right
 

00:01:19.070 --> 00:01:21.529 align:start position:0%
the data here on the right
see<00:01:20.070><c> how</c><00:01:20.219><c> the</c><00:01:20.280><c> header</c><00:01:20.520><c> row</c><00:01:20.640><c> is</c><00:01:20.969><c> in</c><00:01:21.090><c> created</c><00:01:21.450><c> in</c>

00:01:21.529 --> 00:01:21.539 align:start position:0%
see how the header row is in created in
 

00:01:21.539 --> 00:01:24.440 align:start position:0%
see how the header row is in created in
the<00:01:21.630><c> sort</c><00:01:21.840><c> by</c><00:01:22.049><c> mistake</c><00:01:22.409><c> in</c><00:01:22.729><c> a</c><00:01:23.729><c> situation</c><00:01:24.299><c> like</c>

00:01:24.440 --> 00:01:24.450 align:start position:0%
the sort by mistake in a situation like
 

00:01:24.450 --> 00:01:27.080 align:start position:0%
the sort by mistake in a situation like
this<00:01:24.689><c> you</c><00:01:25.409><c> might</c><00:01:25.619><c> need</c><00:01:25.770><c> to</c><00:01:25.950><c> manually</c><00:01:26.670><c> select</c>

00:01:27.080 --> 00:01:27.090 align:start position:0%
this you might need to manually select
 

00:01:27.090 --> 00:01:29.330 align:start position:0%
this you might need to manually select
the<00:01:27.210><c> cells</c><00:01:27.450><c> you</c><00:01:27.600><c> want</c><00:01:27.710><c> instead</c><00:01:28.710><c> of</c><00:01:28.829><c> relying</c><00:01:29.100><c> on</c>

00:01:29.330 --> 00:01:29.340 align:start position:0%
the cells you want instead of relying on
 

00:01:29.340 --> 00:01:32.029 align:start position:0%
the cells you want instead of relying on
Excel<00:01:29.759><c> to</c><00:01:29.969><c> do</c><00:01:30.119><c> it</c><00:01:30.240><c> for</c><00:01:30.479><c> you</c><00:01:30.659><c> this</c><00:01:31.530><c> is</c><00:01:31.770><c> called</c>

00:01:32.029 --> 00:01:32.039 align:start position:0%
Excel to do it for you this is called
 

00:01:32.039 --> 00:01:34.760 align:start position:0%
Excel to do it for you this is called
sorting<00:01:32.549><c> a</c><00:01:32.610><c> cell</c><00:01:32.819><c> range</c><00:01:33.409><c> select</c><00:01:34.409><c> the</c><00:01:34.560><c> cell</c>

00:01:34.760 --> 00:01:34.770 align:start position:0%
sorting a cell range select the cell
 

00:01:34.770 --> 00:01:36.950 align:start position:0%
sorting a cell range select the cell
range<00:01:35.009><c> you</c><00:01:35.250><c> want</c><00:01:35.369><c> to</c><00:01:35.490><c> store</c><00:01:35.789><c> including</c><00:01:36.060><c> the</c>

00:01:36.950 --> 00:01:36.960 align:start position:0%
range you want to store including the
 

00:01:36.960 --> 00:01:39.499 align:start position:0%
range you want to store including the
header<00:01:37.140><c> row</c><00:01:37.229><c> if</c><00:01:37.590><c> you</c><00:01:37.740><c> have</c><00:01:37.950><c> one</c><00:01:38.219><c> then</c><00:01:38.880><c> click</c>

00:01:39.499 --> 00:01:39.509 align:start position:0%
header row if you have one then click
 

00:01:39.509 --> 00:01:42.199 align:start position:0%
header row if you have one then click
the<00:01:39.659><c> sort</c><00:01:39.929><c> command</c><00:01:39.990><c> and</c><00:01:40.590><c> a</c><00:01:41.159><c> dialog</c><00:01:41.640><c> box</c><00:01:41.909><c> will</c>

00:01:42.199 --> 00:01:42.209 align:start position:0%
the sort command and a dialog box will
 

00:01:42.209 --> 00:01:44.480 align:start position:0%
the sort command and a dialog box will
appear<00:01:42.240><c> and</c><00:01:42.860><c> first</c><00:01:43.860><c> you'll</c><00:01:44.069><c> want</c><00:01:44.219><c> to</c><00:01:44.250><c> check</c>

00:01:44.480 --> 00:01:44.490 align:start position:0%
appear and first you'll want to check
 

00:01:44.490 --> 00:01:46.600 align:start position:0%
appear and first you'll want to check
the<00:01:44.700><c> box</c><00:01:44.939><c> that</c><00:01:45.149><c> says</c><00:01:45.270><c> my</c><00:01:45.990><c> data</c><00:01:46.289><c> has</c><00:01:46.530><c> headers</c>

00:01:46.600 --> 00:01:46.610 align:start position:0%
the box that says my data has headers
 

00:01:46.610 --> 00:01:49.730 align:start position:0%
the box that says my data has headers
then<00:01:47.610><c> use</c><00:01:48.179><c> the</c><00:01:48.390><c> drop</c><00:01:48.630><c> down</c><00:01:48.840><c> menu</c><00:01:49.200><c> on</c><00:01:49.229><c> the</c><00:01:49.500><c> left</c>

00:01:49.730 --> 00:01:49.740 align:start position:0%
then use the drop down menu on the left
 

00:01:49.740 --> 00:01:51.699 align:start position:0%
then use the drop down menu on the left
to<00:01:50.009><c> choose</c><00:01:50.399><c> the</c><00:01:50.610><c> column</c><00:01:50.969><c> you</c><00:01:51.000><c> want</c><00:01:51.179><c> to</c><00:01:51.299><c> sort</c><00:01:51.360><c> by</c>

00:01:51.699 --> 00:01:51.709 align:start position:0%
to choose the column you want to sort by
 

00:01:51.709 --> 00:01:55.190 align:start position:0%
to choose the column you want to sort by
then<00:01:52.709><c> select</c><00:01:53.130><c> a</c><00:01:53.250><c> sorting</c><00:01:53.640><c> order</c><00:01:53.849><c> in</c><00:01:54.200><c> this</c>

00:01:55.190 --> 00:01:55.200 align:start position:0%
then select a sorting order in this
 

00:01:55.200 --> 00:01:58.270 align:start position:0%
then select a sorting order in this
example<00:01:55.619><c> we'll</c><00:01:55.950><c> choose</c><00:01:56.270><c> largest</c><00:01:57.270><c> to</c><00:01:57.450><c> smallest</c>

00:01:58.270 --> 00:01:58.280 align:start position:0%
example we'll choose largest to smallest
 

00:01:58.280 --> 00:02:01.429 align:start position:0%
example we'll choose largest to smallest
when<00:01:59.280><c> you're</c><00:01:59.429><c> done</c><00:01:59.549><c> click</c><00:01:59.880><c> OK</c><00:02:00.270><c> and</c><00:02:00.479><c> the</c><00:02:01.200><c> range</c>

00:02:01.429 --> 00:02:01.439 align:start position:0%
when you're done click OK and the range
 

00:02:01.439 --> 00:02:03.669 align:start position:0%
when you're done click OK and the range
will<00:02:01.590><c> be</c><00:02:01.649><c> sorted</c><00:02:02.099><c> by</c><00:02:02.220><c> the</c><00:02:02.280><c> selected</c><00:02:02.849><c> column</c>

00:02:03.669 --> 00:02:03.679 align:start position:0%
will be sorted by the selected column
 

00:02:03.679 --> 00:02:05.929 align:start position:0%
will be sorted by the selected column
notice<00:02:04.679><c> that</c><00:02:04.829><c> the</c><00:02:04.979><c> rest</c><00:02:05.189><c> of</c><00:02:05.399><c> the</c><00:02:05.520><c> worksheet</c>

00:02:05.929 --> 00:02:05.939 align:start position:0%
notice that the rest of the worksheet
 

00:02:05.939 --> 00:02:08.569 align:start position:0%
notice that the rest of the worksheet
wasn't<00:02:06.569><c> affected</c><00:02:06.959><c> by</c><00:02:07.110><c> our</c><00:02:07.259><c> sort</c><00:02:07.590><c> now</c>

00:02:08.569 --> 00:02:08.579 align:start position:0%
wasn't affected by our sort now
 

00:02:08.579 --> 00:02:10.639 align:start position:0%
wasn't affected by our sort now
sometimes<00:02:09.209><c> the</c><00:02:09.420><c> default</c><00:02:09.750><c> sorting</c><00:02:10.200><c> options</c>

00:02:10.639 --> 00:02:10.649 align:start position:0%
sometimes the default sorting options
 

00:02:10.649 --> 00:02:12.680 align:start position:0%
sometimes the default sorting options
won't<00:02:11.039><c> work</c><00:02:11.340><c> for</c><00:02:11.640><c> what</c><00:02:11.760><c> you</c><00:02:11.790><c> have</c><00:02:12.030><c> in</c><00:02:12.180><c> mind</c><00:02:12.209><c> for</c>

00:02:12.680 --> 00:02:12.690 align:start position:0%
won't work for what you have in mind for
 

00:02:12.690 --> 00:02:15.410 align:start position:0%
won't work for what you have in mind for
example<00:02:13.620><c> if</c><00:02:14.250><c> we</c><00:02:14.549><c> sort</c><00:02:14.819><c> the</c><00:02:14.910><c> columns</c><00:02:15.329><c> that</c>

00:02:15.410 --> 00:02:15.420 align:start position:0%
example if we sort the columns that
 

00:02:15.420 --> 00:02:17.750 align:start position:0%
example if we sort the columns that
contain<00:02:15.630><c> the</c><00:02:16.049><c> t-shirt</c><00:02:16.470><c> sizes</c><00:02:16.980><c> in</c><00:02:17.250><c> ascending</c>

00:02:17.750 --> 00:02:17.760 align:start position:0%
contain the t-shirt sizes in ascending
 

00:02:17.760 --> 00:02:21.080 align:start position:0%
contain the t-shirt sizes in ascending
order<00:02:18.060><c> the</c><00:02:19.049><c> order</c><00:02:19.319><c> will</c><00:02:19.470><c> be</c><00:02:19.590><c> large</c><00:02:20.090><c> medium</c>

00:02:21.080 --> 00:02:21.090 align:start position:0%
order the order will be large medium
 

00:02:21.090 --> 00:02:24.259 align:start position:0%
order the order will be large medium
small<00:02:21.680><c> then</c><00:02:22.680><c> extra</c><00:02:23.190><c> large</c><00:02:23.400><c> because</c><00:02:23.940><c> the</c>

00:02:24.259 --> 00:02:24.269 align:start position:0%
small then extra large because the
 

00:02:24.269 --> 00:02:26.020 align:start position:0%
small then extra large because the
column<00:02:24.630><c> is</c><00:02:24.750><c> being</c><00:02:24.959><c> sorted</c><00:02:25.290><c> alphabetically</c>

00:02:26.020 --> 00:02:26.030 align:start position:0%
column is being sorted alphabetically
 

00:02:26.030 --> 00:02:28.460 align:start position:0%
column is being sorted alphabetically
you<00:02:27.030><c> know</c><00:02:27.180><c> would</c><00:02:27.359><c> be</c><00:02:27.540><c> better</c><00:02:27.810><c> if</c><00:02:28.019><c> the</c><00:02:28.200><c> sizes</c>

00:02:28.460 --> 00:02:28.470 align:start position:0%
you know would be better if the sizes
 

00:02:28.470 --> 00:02:30.470 align:start position:0%
you know would be better if the sizes
were<00:02:28.769><c> listed</c><00:02:29.190><c> in</c><00:02:29.280><c> a</c><00:02:29.370><c> more</c><00:02:29.579><c> logical</c><00:02:29.850><c> order</c>

00:02:30.470 --> 00:02:30.480 align:start position:0%
were listed in a more logical order
 

00:02:30.480 --> 00:02:33.860 align:start position:0%
were listed in a more logical order
in<00:02:31.019><c> other</c><00:02:31.170><c> words</c><00:02:31.470><c> small</c><00:02:32.010><c> medium</c><00:02:32.880><c> large</c><00:02:33.030><c> then</c>

00:02:33.860 --> 00:02:33.870 align:start position:0%
in other words small medium large then
 

00:02:33.870 --> 00:02:36.650 align:start position:0%
in other words small medium large then
extra<00:02:34.230><c> large</c><00:02:34.470><c> for</c><00:02:34.769><c> this</c><00:02:35.760><c> we'll</c><00:02:36.359><c> need</c><00:02:36.389><c> to</c>

00:02:36.650 --> 00:02:36.660 align:start position:0%
extra large for this we'll need to
 

00:02:36.660 --> 00:02:40.580 align:start position:0%
extra large for this we'll need to
create<00:02:36.870><c> a</c><00:02:37.049><c> custom</c><00:02:37.440><c> sort</c><00:02:38.510><c> to</c><00:02:39.510><c> begin</c><00:02:39.870><c> click</c><00:02:40.560><c> the</c>

00:02:40.580 --> 00:02:40.590 align:start position:0%
create a custom sort to begin click the
 

00:02:40.590 --> 00:02:43.190 align:start position:0%
create a custom sort to begin click the
sort<00:02:41.010><c> command</c><00:02:41.040><c> and</c><00:02:41.609><c> on</c><00:02:42.120><c> the</c><00:02:42.269><c> right</c><00:02:42.480><c> you</c><00:02:43.019><c> can</c>

00:02:43.190 --> 00:02:43.200 align:start position:0%
sort command and on the right you can
 

00:02:43.200 --> 00:02:44.990 align:start position:0%
sort command and on the right you can
see<00:02:43.410><c> that</c><00:02:43.440><c> it's</c><00:02:43.680><c> ordering</c><00:02:44.190><c> the</c><00:02:44.280><c> column</c><00:02:44.670><c> from</c><00:02:44.819><c> A</c>

00:02:44.990 --> 00:02:45.000 align:start position:0%
see that it's ordering the column from A
 

00:02:45.000 --> 00:02:48.259 align:start position:0%
see that it's ordering the column from A
to<00:02:45.090><c> Z</c><00:02:45.389><c> if</c><00:02:45.810><c> we</c><00:02:46.650><c> click</c><00:02:46.859><c> this</c><00:02:47.069><c> drop-down</c><00:02:47.459><c> menu</c><00:02:48.090><c> and</c>

00:02:48.259 --> 00:02:48.269 align:start position:0%
to Z if we click this drop-down menu and
 

00:02:48.269 --> 00:02:51.259 align:start position:0%
to Z if we click this drop-down menu and
select<00:02:48.500><c> custom</c><00:02:49.500><c> list</c><00:02:49.769><c> we</c><00:02:50.760><c> can</c><00:02:50.910><c> enter</c><00:02:51.150><c> the</c>

00:02:51.259 --> 00:02:51.269 align:start position:0%
select custom list we can enter the
 

00:02:51.269 --> 00:02:54.020 align:start position:0%
select custom list we can enter the
t-shirt<00:02:51.660><c> sizes</c><00:02:52.139><c> in</c><00:02:52.260><c> the</c><00:02:52.349><c> order</c><00:02:52.590><c> we</c><00:02:52.680><c> want</c><00:02:53.030><c> so</c>

00:02:54.020 --> 00:02:54.030 align:start position:0%
t-shirt sizes in the order we want so
 

00:02:54.030 --> 00:02:55.990 align:start position:0%
t-shirt sizes in the order we want so
I'll<00:02:54.420><c> click</c><00:02:54.660><c> in</c><00:02:54.720><c> the</c><00:02:54.840><c> box</c><00:02:55.109><c> and</c><00:02:55.319><c> start</c><00:02:55.590><c> typing</c>

00:02:55.990 --> 00:02:56.000 align:start position:0%
I'll click in the box and start typing
 

00:02:56.000 --> 00:03:01.339 align:start position:0%
I'll click in the box and start typing
small<00:02:57.260><c> medium</c><00:02:58.260><c> large</c><00:02:58.700><c> and</c><00:02:59.840><c> extra-large</c><00:03:00.840><c> and</c>

00:03:01.339 --> 00:03:01.349 align:start position:0%
small medium large and extra-large and
 

00:03:01.349 --> 00:03:05.150 align:start position:0%
small medium large and extra-large and
I'm<00:03:02.130><c> pressing</c><00:03:02.370><c> enter</c><00:03:02.819><c> after</c><00:03:02.970><c> each</c><00:03:03.239><c> one</c><00:03:04.160><c> when</c>

00:03:05.150 --> 00:03:05.160 align:start position:0%
I'm pressing enter after each one when
 

00:03:05.160 --> 00:03:06.680 align:start position:0%
I'm pressing enter after each one when
you<00:03:05.280><c> done</c><00:03:05.459><c> with</c><00:03:05.579><c> your</c><00:03:05.730><c> list</c><00:03:05.970><c> click</c><00:03:06.419><c> the</c><00:03:06.569><c> Add</c>

00:03:06.680 --> 00:03:06.690 align:start position:0%
you done with your list click the Add
 

00:03:06.690 --> 00:03:08.290 align:start position:0%
you done with your list click the Add
button

00:03:08.290 --> 00:03:08.300 align:start position:0%
button
 

00:03:08.300 --> 00:03:09.820 align:start position:0%
button
make<00:03:08.480><c> sure</c><00:03:08.660><c> that</c><00:03:08.810><c> your</c><00:03:08.960><c> list</c><00:03:09.140><c> is</c><00:03:09.320><c> selected</c>

00:03:09.820 --> 00:03:09.830 align:start position:0%
make sure that your list is selected
 

00:03:09.830 --> 00:03:12.460 align:start position:0%
make sure that your list is selected
over<00:03:09.950><c> here</c><00:03:10.310><c> on</c><00:03:10.430><c> the</c><00:03:10.550><c> left</c><00:03:10.760><c> then</c><00:03:11.690><c> click</c><00:03:11.720><c> OK</c><00:03:12.410><c> to</c>

00:03:12.460 --> 00:03:12.470 align:start position:0%
over here on the left then click OK to
 

00:03:12.470 --> 00:03:16.960 align:start position:0%
over here on the left then click OK to
confirm<00:03:12.710><c> and</c><00:03:13.250><c> ok</c><00:03:13.970><c> again</c><00:03:14.210><c> and</c><00:03:15.910><c> now</c><00:03:16.910><c> the</c>

00:03:16.960 --> 00:03:16.970 align:start position:0%
confirm and ok again and now the
 

00:03:16.970 --> 00:03:20.200 align:start position:0%
confirm and ok again and now the
worksheet<00:03:17.480><c> is</c><00:03:17.660><c> sorted</c><00:03:18.050><c> the</c><00:03:18.170><c> way</c><00:03:18.320><c> we</c><00:03:18.500><c> want</c><00:03:19.210><c> the</c>

00:03:20.200 --> 00:03:20.210 align:start position:0%
worksheet is sorted the way we want the
 

00:03:20.210 --> 00:03:21.790 align:start position:0%
worksheet is sorted the way we want the
only<00:03:20.330><c> problem</c><00:03:20.780><c> with</c><00:03:20.900><c> this</c><00:03:21.080><c> is</c><00:03:21.140><c> that</c><00:03:21.470><c> every</c>

00:03:21.790 --> 00:03:21.800 align:start position:0%
only problem with this is that every
 

00:03:21.800 --> 00:03:24.130 align:start position:0%
only problem with this is that every
other<00:03:21.830><c> column</c><00:03:22.550><c> is</c><00:03:22.760><c> completely</c><00:03:23.570><c> out</c><00:03:23.720><c> of</c><00:03:23.750><c> order</c>

00:03:24.130 --> 00:03:24.140 align:start position:0%
other column is completely out of order
 

00:03:24.140 --> 00:03:26.680 align:start position:0%
other column is completely out of order
what<00:03:25.100><c> I</c><00:03:25.130><c> would</c><00:03:25.370><c> really</c><00:03:25.640><c> like</c><00:03:25.850><c> is</c><00:03:26.300><c> if</c><00:03:26.540><c> the</c>

00:03:26.680 --> 00:03:26.690 align:start position:0%
what I would really like is if the
 

00:03:26.690 --> 00:03:28.960 align:start position:0%
what I would really like is if the
homeroom<00:03:27.170><c> numbers</c><00:03:27.560><c> were</c><00:03:28.100><c> organized</c><00:03:28.640><c> within</c>

00:03:28.960 --> 00:03:28.970 align:start position:0%
homeroom numbers were organized within
 

00:03:28.970 --> 00:03:32.260 align:start position:0%
homeroom numbers were organized within
each<00:03:29.360><c> t-shirt</c><00:03:29.810><c> size</c><00:03:30.260><c> I</c><00:03:30.590><c> can</c><00:03:31.520><c> do</c><00:03:31.850><c> this</c><00:03:32.060><c> by</c>

00:03:32.260 --> 00:03:32.270 align:start position:0%
each t-shirt size I can do this by
 

00:03:32.270 --> 00:03:35.050 align:start position:0%
each t-shirt size I can do this by
sorting<00:03:32.660><c> by</c><00:03:32.810><c> multiple</c><00:03:33.320><c> levels</c><00:03:33.740><c> this</c><00:03:34.700><c> will</c><00:03:34.910><c> let</c>

00:03:35.050 --> 00:03:35.060 align:start position:0%
sorting by multiple levels this will let
 

00:03:35.060 --> 00:03:37.570 align:start position:0%
sorting by multiple levels this will let
us<00:03:35.090><c> sort</c><00:03:35.450><c> first</c><00:03:35.750><c> by</c><00:03:35.960><c> t-shirt</c><00:03:36.470><c> size</c><00:03:36.740><c> and</c><00:03:37.100><c> then</c>

00:03:37.570 --> 00:03:37.580 align:start position:0%
us sort first by t-shirt size and then
 

00:03:37.580 --> 00:03:40.720 align:start position:0%
us sort first by t-shirt size and then
by<00:03:37.790><c> homeroom</c><00:03:38.680><c> click</c><00:03:39.680><c> the</c><00:03:39.830><c> sort</c><00:03:40.100><c> command</c><00:03:40.160><c> and</c>

00:03:40.720 --> 00:03:40.730 align:start position:0%
by homeroom click the sort command and
 

00:03:40.730 --> 00:03:42.460 align:start position:0%
by homeroom click the sort command and
you'll<00:03:41.060><c> notice</c><00:03:41.270><c> the</c><00:03:41.510><c> different</c><00:03:41.900><c> options</c><00:03:42.080><c> at</c>

00:03:42.460 --> 00:03:42.470 align:start position:0%
you'll notice the different options at
 

00:03:42.470 --> 00:03:44.110 align:start position:0%
you'll notice the different options at
the<00:03:42.560><c> top</c><00:03:42.800><c> of</c><00:03:43.010><c> the</c><00:03:43.100><c> dialog</c><00:03:43.550><c> box</c>

00:03:44.110 --> 00:03:44.120 align:start position:0%
the top of the dialog box
 

00:03:44.120 --> 00:03:46.720 align:start position:0%
the top of the dialog box
you<00:03:44.750><c> can</c><00:03:44.930><c> add</c><00:03:45.200><c> a</c><00:03:45.230><c> level</c><00:03:45.710><c> to</c><00:03:45.800><c> the</c><00:03:45.950><c> sort</c><00:03:46.220><c> the</c>

00:03:46.720 --> 00:03:46.730 align:start position:0%
you can add a level to the sort the
 

00:03:46.730 --> 00:03:49.060 align:start position:0%
you can add a level to the sort the
leader<00:03:46.940><c> level</c><00:03:47.180><c> or</c><00:03:47.510><c> even</c><00:03:48.020><c> use</c><00:03:48.230><c> the</c><00:03:48.410><c> arrows</c><00:03:48.770><c> to</c>

00:03:49.060 --> 00:03:49.070 align:start position:0%
leader level or even use the arrows to
 

00:03:49.070 --> 00:03:51.400 align:start position:0%
leader level or even use the arrows to
change<00:03:49.280><c> the</c><00:03:49.460><c> level</c><00:03:49.760><c> order</c>

00:03:51.400 --> 00:03:51.410 align:start position:0%
change the level order
 

00:03:51.410 --> 00:03:54.600 align:start position:0%
change the level order
in<00:03:51.470><c> this</c><00:03:52.280><c> example</c><00:03:52.670><c> we</c><00:03:52.910><c> want</c><00:03:53.060><c> to</c><00:03:53.180><c> add</c><00:03:53.240><c> a</c><00:03:53.390><c> level</c>

00:03:54.600 --> 00:03:54.610 align:start position:0%
in this example we want to add a level
 

00:03:54.610 --> 00:03:57.160 align:start position:0%
in this example we want to add a level
now<00:03:55.610><c> we</c><00:03:55.670><c> just</c><00:03:55.910><c> have</c><00:03:56.120><c> to</c><00:03:56.270><c> select</c><00:03:56.450><c> the</c><00:03:56.750><c> homeroom</c>

00:03:57.160 --> 00:03:57.170 align:start position:0%
now we just have to select the homeroom
 

00:03:57.170 --> 00:03:59.290 align:start position:0%
now we just have to select the homeroom
column<00:03:57.620><c> and</c><00:03:57.800><c> we'll</c><00:03:58.610><c> leave</c><00:03:58.820><c> the</c><00:03:58.850><c> other</c><00:03:59.000><c> two</c>

00:03:59.290 --> 00:03:59.300 align:start position:0%
column and we'll leave the other two
 

00:03:59.300 --> 00:04:01.330 align:start position:0%
column and we'll leave the other two
fields<00:03:59.690><c> the</c><00:03:59.840><c> way</c><00:03:59.960><c> they</c><00:04:00.140><c> are</c><00:04:00.350><c> sorting</c><00:04:01.310><c> the</c>

00:04:01.330 --> 00:04:01.340 align:start position:0%
fields the way they are sorting the
 

00:04:01.340 --> 00:04:04.960 align:start position:0%
fields the way they are sorting the
values<00:04:01.910><c> from</c><00:04:02.600><c> smallest</c><00:04:02.960><c> to</c><00:04:03.170><c> largest</c><00:04:03.850><c> and</c><00:04:04.850><c> when</c>

00:04:04.960 --> 00:04:04.970 align:start position:0%
values from smallest to largest and when
 

00:04:04.970 --> 00:04:07.630 align:start position:0%
values from smallest to largest and when
you<00:04:05.060><c> click</c><00:04:05.240><c> OK</c><00:04:05.690><c> you'll</c><00:04:06.650><c> see</c><00:04:06.770><c> that</c><00:04:07.070><c> within</c><00:04:07.220><c> each</c>

00:04:07.630 --> 00:04:07.640 align:start position:0%
you click OK you'll see that within each
 

00:04:07.640 --> 00:04:10.030 align:start position:0%
you click OK you'll see that within each
t-shirt<00:04:08.030><c> size</c><00:04:08.540><c> the</c><00:04:09.050><c> homeroom</c><00:04:09.470><c> numbers</c><00:04:09.860><c> are</c>

00:04:10.030 --> 00:04:10.040 align:start position:0%
t-shirt size the homeroom numbers are
 

00:04:10.040 --> 00:04:13.510 align:start position:0%
t-shirt size the homeroom numbers are
listed<00:04:10.220><c> in</c><00:04:10.490><c> numerical</c><00:04:11.090><c> order</c><00:04:11.270><c> as</c><00:04:12.070><c> you</c><00:04:13.070><c> can</c><00:04:13.280><c> see</c>

00:04:13.510 --> 00:04:13.520 align:start position:0%
listed in numerical order as you can see
 

00:04:13.520 --> 00:04:15.250 align:start position:0%
listed in numerical order as you can see
there<00:04:13.940><c> are</c><00:04:14.030><c> a</c><00:04:14.090><c> lot</c><00:04:14.300><c> of</c><00:04:14.330><c> different</c><00:04:14.870><c> ways</c><00:04:15.050><c> of</c>

00:04:15.250 --> 00:04:15.260 align:start position:0%
there are a lot of different ways of
 

00:04:15.260 --> 00:04:17.110 align:start position:0%
there are a lot of different ways of
sorting<00:04:15.620><c> your</c><00:04:15.710><c> data</c><00:04:15.950><c> depending</c><00:04:16.700><c> on</c><00:04:16.790><c> how</c><00:04:17.060><c> you</c>

00:04:17.110 --> 00:04:17.120 align:start position:0%
sorting your data depending on how you
 

00:04:17.120 --> 00:04:19.449 align:start position:0%
sorting your data depending on how you
want<00:04:17.269><c> to</c><00:04:17.450><c> organize</c><00:04:17.840><c> it</c><00:04:17.870><c> so</c><00:04:18.260><c> take</c><00:04:18.739><c> some</c><00:04:18.980><c> time</c><00:04:19.190><c> to</c>

00:04:19.449 --> 00:04:19.459 align:start position:0%
want to organize it so take some time to
 

00:04:19.459 --> 00:04:20.770 align:start position:0%
want to organize it so take some time to
experiment<00:04:19.850><c> with</c><00:04:20.150><c> the</c><00:04:20.269><c> different</c><00:04:20.299><c> options</c>

00:04:20.770 --> 00:04:20.780 align:start position:0%
experiment with the different options
 

00:04:20.780 --> 00:04:22.990 align:start position:0%
experiment with the different options
and<00:04:21.260><c> find</c><00:04:21.680><c> the</c><00:04:21.769><c> ones</c><00:04:21.950><c> that</c><00:04:22.100><c> best</c><00:04:22.400><c> suit</c><00:04:22.700><c> your</c>

00:04:22.990 --> 00:04:23.000 align:start position:0%
and find the ones that best suit your
 

00:04:23.000 --> 00:04:25.270 align:start position:0%
and find the ones that best suit your
needs