WEBVTT
Kind: captions
Language: en

00:00:10.570 --> 00:00:12.790 align:start position:0%
 
filtering<00:00:11.570><c> is</c><00:00:11.780><c> a</c><00:00:11.840><c> great</c><00:00:12.230><c> feature</c><00:00:12.440><c> of</c><00:00:12.680><c> Excel</c>

00:00:12.790 --> 00:00:12.800 align:start position:0%
filtering is a great feature of Excel
 

00:00:12.800 --> 00:00:14.470 align:start position:0%
filtering is a great feature of Excel
that<00:00:13.160><c> gives</c><00:00:13.340><c> you</c><00:00:13.430><c> a</c><00:00:13.460><c> lot</c><00:00:13.730><c> of</c><00:00:13.760><c> control</c><00:00:14.270><c> over</c>

00:00:14.470 --> 00:00:14.480 align:start position:0%
that gives you a lot of control over
 

00:00:14.480 --> 00:00:16.120 align:start position:0%
that gives you a lot of control over
which<00:00:14.900><c> parts</c><00:00:15.260><c> of</c><00:00:15.380><c> your</c><00:00:15.440><c> spreadsheet</c><00:00:15.770><c> are</c>

00:00:16.120 --> 00:00:16.130 align:start position:0%
which parts of your spreadsheet are
 

00:00:16.130 --> 00:00:18.250 align:start position:0%
which parts of your spreadsheet are
displayed<00:00:16.660><c> it's</c><00:00:17.660><c> a</c><00:00:17.779><c> little</c><00:00:17.990><c> bit</c><00:00:18.110><c> like</c>

00:00:18.250 --> 00:00:18.260 align:start position:0%
displayed it's a little bit like
 

00:00:18.260 --> 00:00:20.080 align:start position:0%
displayed it's a little bit like
outlining<00:00:18.770><c> and</c><00:00:19.010><c> grouping</c><00:00:19.400><c> but</c><00:00:19.730><c> it's</c><00:00:19.939><c> even</c>

00:00:20.080 --> 00:00:20.090 align:start position:0%
outlining and grouping but it's even
 

00:00:20.090 --> 00:00:22.120 align:start position:0%
outlining and grouping but it's even
more<00:00:20.360><c> powerful</c><00:00:20.599><c> and</c><00:00:21.080><c> it</c><00:00:21.439><c> actually</c><00:00:21.800><c> makes</c><00:00:21.950><c> it</c><00:00:22.040><c> a</c>

00:00:22.120 --> 00:00:22.130 align:start position:0%
more powerful and it actually makes it a
 

00:00:22.130 --> 00:00:23.800 align:start position:0%
more powerful and it actually makes it a
little<00:00:22.400><c> bit</c><00:00:22.550><c> easier</c><00:00:22.939><c> to</c><00:00:23.210><c> narrow</c><00:00:23.420><c> down</c><00:00:23.630><c> your</c>

00:00:23.800 --> 00:00:23.810 align:start position:0%
little bit easier to narrow down your
 

00:00:23.810 --> 00:00:26.500 align:start position:0%
little bit easier to narrow down your
data<00:00:23.960><c> in</c><00:00:24.200><c> different</c><00:00:24.439><c> ways</c><00:00:25.330><c> now</c><00:00:26.330><c> it's</c>

00:00:26.500 --> 00:00:26.510 align:start position:0%
data in different ways now it's
 

00:00:26.510 --> 00:00:27.939 align:start position:0%
data in different ways now it's
important<00:00:26.960><c> that</c><00:00:26.990><c> you</c><00:00:27.110><c> have</c><00:00:27.199><c> a</c><00:00:27.380><c> header</c><00:00:27.680><c> row</c>

00:00:27.939 --> 00:00:27.949 align:start position:0%
important that you have a header row
 

00:00:27.949 --> 00:00:30.250 align:start position:0%
important that you have a header row
because<00:00:28.550><c> the</c><00:00:28.760><c> filters</c><00:00:29.150><c> actually</c><00:00:29.690><c> get</c><00:00:29.869><c> added</c>

00:00:30.250 --> 00:00:30.260 align:start position:0%
because the filters actually get added
 

00:00:30.260 --> 00:00:33.200 align:start position:0%
because the filters actually get added
to<00:00:30.440><c> the</c><00:00:30.560><c> cells</c><00:00:30.800><c> in</c><00:00:31.010><c> the</c><00:00:31.250><c> header</c><00:00:31.430><c> row</c>

00:00:33.200 --> 00:00:33.210 align:start position:0%
to the cells in the header row
 

00:00:33.210 --> 00:00:35.479 align:start position:0%
to the cells in the header row
in<00:00:33.270><c> this</c><00:00:34.050><c> example</c><00:00:34.440><c> I</c><00:00:34.710><c> have</c><00:00:35.280><c> an</c><00:00:35.430><c> equipment</c>

00:00:35.479 --> 00:00:35.489 align:start position:0%
in this example I have an equipment
 

00:00:35.489 --> 00:00:38.060 align:start position:0%
in this example I have an equipment
checkout<00:00:36.180><c> log</c><00:00:36.450><c> and</c><00:00:36.719><c> there</c><00:00:37.559><c> are</c><00:00:37.680><c> a</c><00:00:37.710><c> lot</c><00:00:37.829><c> of</c>

00:00:38.060 --> 00:00:38.070 align:start position:0%
checkout log and there are a lot of
 

00:00:38.070 --> 00:00:39.889 align:start position:0%
checkout log and there are a lot of
things<00:00:38.370><c> to</c><00:00:38.520><c> keep</c><00:00:38.610><c> track</c><00:00:38.670><c> of</c><00:00:39.149><c> so</c><00:00:39.480><c> I'd</c><00:00:39.690><c> like</c><00:00:39.840><c> to</c>

00:00:39.889 --> 00:00:39.899 align:start position:0%
things to keep track of so I'd like to
 

00:00:39.899 --> 00:00:43.850 align:start position:0%
things to keep track of so I'd like to
use<00:00:40.050><c> some</c><00:00:40.230><c> filters</c><00:00:40.829><c> to</c><00:00:41.100><c> simplify</c><00:00:41.610><c> it</c><00:00:42.350><c> first</c><00:00:43.350><c> go</c>

00:00:43.850 --> 00:00:43.860 align:start position:0%
use some filters to simplify it first go
 

00:00:43.860 --> 00:00:47.209 align:start position:0%
use some filters to simplify it first go
to<00:00:43.920><c> the</c><00:00:44.129><c> data</c><00:00:44.370><c> tab</c><00:00:44.460><c> and</c><00:00:45.649><c> click</c><00:00:46.649><c> the</c><00:00:46.860><c> filter</c>

00:00:47.209 --> 00:00:47.219 align:start position:0%
to the data tab and click the filter
 

00:00:47.219 --> 00:00:49.730 align:start position:0%
to the data tab and click the filter
command

00:00:49.730 --> 00:00:49.740 align:start position:0%
 
 

00:00:49.740 --> 00:00:52.070 align:start position:0%
 
you'll<00:00:50.400><c> see</c><00:00:50.640><c> these</c><00:00:50.820><c> drop-down</c><00:00:51.180><c> arrows</c><00:00:51.720><c> added</c>

00:00:52.070 --> 00:00:52.080 align:start position:0%
you'll see these drop-down arrows added
 

00:00:52.080 --> 00:00:53.690 align:start position:0%
you'll see these drop-down arrows added
to<00:00:52.170><c> your</c><00:00:52.260><c> header</c><00:00:52.440><c> row</c>

00:00:53.690 --> 00:00:53.700 align:start position:0%
to your header row
 

00:00:53.700 --> 00:00:55.670 align:start position:0%
to your header row
and<00:00:53.790><c> you'll</c><00:00:54.270><c> use</c><00:00:54.330><c> these</c><00:00:54.720><c> to</c><00:00:54.960><c> access</c><00:00:55.410><c> all</c><00:00:55.620><c> of</c>

00:00:55.670 --> 00:00:55.680 align:start position:0%
and you'll use these to access all of
 

00:00:55.680 --> 00:00:59.420 align:start position:0%
and you'll use these to access all of
the<00:00:56.010><c> filtering</c><00:00:56.430><c> options</c>

00:00:59.420 --> 00:00:59.430 align:start position:0%
 
 

00:00:59.430 --> 00:01:01.760 align:start position:0%
 
here<00:01:00.330><c> you'll</c><00:01:00.570><c> see</c><00:01:00.660><c> a</c><00:01:00.840><c> list</c><00:01:01.110><c> of</c><00:01:01.290><c> all</c><00:01:01.500><c> of</c><00:01:01.680><c> the</c>

00:01:01.760 --> 00:01:01.770 align:start position:0%
here you'll see a list of all of the
 

00:01:01.770 --> 00:01:03.230 align:start position:0%
here you'll see a list of all of the
different<00:01:02.070><c> values</c><00:01:02.220><c> that</c><00:01:02.670><c> appear</c><00:01:02.790><c> in</c><00:01:03.030><c> this</c>

00:01:03.230 --> 00:01:03.240 align:start position:0%
different values that appear in this
 

00:01:03.240 --> 00:01:06.290 align:start position:0%
different values that appear in this
column<00:01:03.660><c> I'd</c><00:01:03.890><c> like</c><00:01:04.890><c> to</c><00:01:05.040><c> just</c><00:01:05.370><c> view</c><00:01:05.610><c> the</c><00:01:05.790><c> laptops</c>

00:01:06.290 --> 00:01:06.300 align:start position:0%
column I'd like to just view the laptops
 

00:01:06.300 --> 00:01:08.840 align:start position:0%
column I'd like to just view the laptops
and<00:01:06.600><c> projectors</c><00:01:07.350><c> so</c><00:01:08.100><c> I'll</c><00:01:08.340><c> leave</c><00:01:08.580><c> those</c>

00:01:08.840 --> 00:01:08.850 align:start position:0%
and projectors so I'll leave those
 

00:01:08.850 --> 00:01:11.950 align:start position:0%
and projectors so I'll leave those
checked<00:01:09.300><c> and</c><00:01:09.570><c> uncheck</c><00:01:10.440><c> everything</c><00:01:10.620><c> else</c><00:01:11.070><c> and</c>

00:01:11.950 --> 00:01:11.960 align:start position:0%
checked and uncheck everything else and
 

00:01:11.960 --> 00:01:15.179 align:start position:0%
checked and uncheck everything else and
then<00:01:12.960><c> click</c><00:01:13.170><c> OK</c>

00:01:15.179 --> 00:01:15.189 align:start position:0%
then click OK
 

00:01:15.189 --> 00:01:17.669 align:start position:0%
then click OK
and<00:01:15.850><c> now</c><00:01:16.030><c> the</c><00:01:16.090><c> drop-down</c><00:01:16.719><c> arrow</c><00:01:16.780><c> has</c><00:01:17.200><c> changed</c>

00:01:17.669 --> 00:01:17.679 align:start position:0%
and now the drop-down arrow has changed
 

00:01:17.679 --> 00:01:19.349 align:start position:0%
and now the drop-down arrow has changed
to<00:01:17.859><c> a</c><00:01:17.890><c> different</c><00:01:18.280><c> icon</c><00:01:18.399><c> to</c><00:01:18.850><c> show</c><00:01:19.060><c> that</c><00:01:19.210><c> there</c>

00:01:19.349 --> 00:01:19.359 align:start position:0%
to a different icon to show that there
 

00:01:19.359 --> 00:01:22.550 align:start position:0%
to a different icon to show that there
is<00:01:19.479><c> a</c><00:01:19.509><c> filter</c><00:01:19.960><c> in</c><00:01:20.170><c> this</c><00:01:20.350><c> column</c>

00:01:22.550 --> 00:01:22.560 align:start position:0%
is a filter in this column
 

00:01:22.560 --> 00:01:24.289 align:start position:0%
is a filter in this column
we<00:01:23.130><c> can</c><00:01:23.280><c> narrow</c><00:01:23.460><c> down</c><00:01:23.640><c> this</c><00:01:23.820><c> data</c><00:01:24.030><c> even</c>

00:01:24.289 --> 00:01:24.299 align:start position:0%
we can narrow down this data even
 

00:01:24.299 --> 00:01:26.600 align:start position:0%
we can narrow down this data even
further<00:01:24.750><c> by</c><00:01:25.080><c> adding</c><00:01:25.440><c> a</c><00:01:25.500><c> filter</c><00:01:25.860><c> to</c><00:01:25.890><c> another</c>

00:01:26.600 --> 00:01:26.610 align:start position:0%
further by adding a filter to another
 

00:01:26.610 --> 00:01:29.210 align:start position:0%
further by adding a filter to another
column<00:01:27.170><c> let's</c><00:01:28.170><c> filter</c><00:01:28.380><c> by</c><00:01:28.650><c> the</c><00:01:28.710><c> date</c><00:01:28.950><c> that</c><00:01:29.100><c> the</c>

00:01:29.210 --> 00:01:29.220 align:start position:0%
column let's filter by the date that the
 

00:01:29.220 --> 00:01:31.399 align:start position:0%
column let's filter by the date that the
items<00:01:29.549><c> were</c><00:01:29.760><c> checked</c><00:01:29.790><c> out</c>

00:01:31.399 --> 00:01:31.409 align:start position:0%
items were checked out
 

00:01:31.409 --> 00:01:33.590 align:start position:0%
items were checked out
this<00:01:32.009><c> shows</c><00:01:32.280><c> all</c><00:01:32.579><c> of</c><00:01:32.609><c> the</c><00:01:32.850><c> months</c><00:01:33.090><c> that</c><00:01:33.270><c> appear</c>

00:01:33.590 --> 00:01:33.600 align:start position:0%
this shows all of the months that appear
 

00:01:33.600 --> 00:01:35.809 align:start position:0%
this shows all of the months that appear
in<00:01:33.630><c> this</c><00:01:33.960><c> column</c><00:01:34.229><c> so</c><00:01:35.100><c> I'll</c><00:01:35.249><c> uncheck</c><00:01:35.429><c> the</c>

00:01:35.809 --> 00:01:35.819 align:start position:0%
in this column so I'll uncheck the
 

00:01:35.819 --> 00:01:38.470 align:start position:0%
in this column so I'll uncheck the
months<00:01:36.060><c> that</c><00:01:36.240><c> I</c><00:01:36.270><c> don't</c><00:01:36.569><c> want</c>

00:01:38.470 --> 00:01:38.480 align:start position:0%
months that I don't want
 

00:01:38.480 --> 00:01:40.750 align:start position:0%
months that I don't want
you<00:01:38.930><c> can</c><00:01:39.110><c> also</c><00:01:39.230><c> click</c><00:01:39.590><c> the</c><00:01:39.770><c> plus</c><00:01:40.010><c> sign</c><00:01:40.310><c> next</c><00:01:40.340><c> to</c>

00:01:40.750 --> 00:01:40.760 align:start position:0%
you can also click the plus sign next to
 

00:01:40.760 --> 00:01:42.310 align:start position:0%
you can also click the plus sign next to
the<00:01:40.880><c> month</c><00:01:41.060><c> if</c><00:01:41.270><c> you</c><00:01:41.600><c> want</c><00:01:41.780><c> to</c><00:01:41.870><c> filter</c><00:01:42.050><c> by</c><00:01:42.260><c> the</c>

00:01:42.310 --> 00:01:42.320 align:start position:0%
the month if you want to filter by the
 

00:01:42.320 --> 00:01:44.740 align:start position:0%
the month if you want to filter by the
specific<00:01:43.040><c> dates</c>

00:01:44.740 --> 00:01:44.750 align:start position:0%
specific dates
 

00:01:44.750 --> 00:01:48.720 align:start position:0%
specific dates
and<00:01:44.840><c> then</c><00:01:45.320><c> click</c><00:01:45.530><c> okay</c>

00:01:48.720 --> 00:01:48.730 align:start position:0%
 
 

00:01:48.730 --> 00:01:51.000 align:start position:0%
 
to<00:01:49.360><c> get</c><00:01:49.510><c> rid</c><00:01:49.720><c> of</c><00:01:49.840><c> the</c><00:01:49.930><c> filter</c><00:01:50.290><c> just</c><00:01:50.620><c> click</c><00:01:50.890><c> on</c>

00:01:51.000 --> 00:01:51.010 align:start position:0%
to get rid of the filter just click on
 

00:01:51.010 --> 00:02:01.180 align:start position:0%
to get rid of the filter just click on
the<00:01:51.100><c> icon</c><00:01:51.550><c> and</c><00:01:51.760><c> select</c><00:01:52.750><c> clear</c><00:01:53.350><c> filter</c>

00:02:01.180 --> 00:02:01.190 align:start position:0%
 
 

00:02:01.190 --> 00:02:04.000 align:start position:0%
 
so<00:02:02.190><c> that's</c><00:02:02.400><c> how</c><00:02:02.550><c> you</c><00:02:02.610><c> do</c><00:02:02.850><c> simple</c><00:02:03.300><c> filtering</c>

00:02:04.000 --> 00:02:04.010 align:start position:0%
so that's how you do simple filtering
 

00:02:04.010 --> 00:02:06.620 align:start position:0%
so that's how you do simple filtering
now<00:02:05.010><c> let's</c><00:02:05.310><c> look</c><00:02:05.460><c> at</c><00:02:05.580><c> some</c><00:02:05.820><c> more</c><00:02:05.850><c> advanced</c>

00:02:06.620 --> 00:02:06.630 align:start position:0%
now let's look at some more advanced
 

00:02:06.630 --> 00:02:08.820 align:start position:0%
now let's look at some more advanced
techniques

00:02:08.820 --> 00:02:08.830 align:start position:0%
 
 

00:02:08.830 --> 00:02:10.950 align:start position:0%
 
when<00:02:09.340><c> you</c><00:02:09.430><c> click</c><00:02:09.640><c> the</c><00:02:09.790><c> drop-down</c><00:02:10.060><c> box</c><00:02:10.479><c> you</c><00:02:10.840><c> can</c>

00:02:10.950 --> 00:02:10.960 align:start position:0%
when you click the drop-down box you can
 

00:02:10.960 --> 00:02:12.720 align:start position:0%
when you click the drop-down box you can
actually<00:02:11.140><c> search</c><00:02:11.650><c> for</c><00:02:11.680><c> values</c><00:02:12.280><c> that</c><00:02:12.400><c> appear</c>

00:02:12.720 --> 00:02:12.730 align:start position:0%
actually search for values that appear
 

00:02:12.730 --> 00:02:14.570 align:start position:0%
actually search for values that appear
in<00:02:12.760><c> this</c><00:02:12.910><c> column</c>

00:02:14.570 --> 00:02:14.580 align:start position:0%
in this column
 

00:02:14.580 --> 00:02:16.460 align:start position:0%
in this column
in<00:02:14.640><c> this</c><00:02:15.150><c> example</c><00:02:15.540><c> a</c><00:02:15.780><c> lot</c><00:02:15.990><c> of</c><00:02:16.020><c> our</c><00:02:16.170><c> equipment</c>

00:02:16.460 --> 00:02:16.470 align:start position:0%
in this example a lot of our equipment
 

00:02:16.470 --> 00:02:19.250 align:start position:0%
in this example a lot of our equipment
is<00:02:16.740><c> made</c><00:02:16.950><c> by</c><00:02:17.100><c> a</c><00:02:17.130><c> company</c><00:02:17.520><c> called</c><00:02:17.610><c> saris</c><00:02:18.300><c> so</c><00:02:19.140><c> if</c>

00:02:19.250 --> 00:02:19.260 align:start position:0%
is made by a company called saris so if
 

00:02:19.260 --> 00:02:21.560 align:start position:0%
is made by a company called saris so if
we<00:02:19.410><c> type</c><00:02:19.620><c> that</c><00:02:19.680><c> then</c><00:02:20.640><c> the</c><00:02:20.760><c> list</c><00:02:21.000><c> below</c><00:02:21.210><c> it</c><00:02:21.420><c> will</c>

00:02:21.560 --> 00:02:21.570 align:start position:0%
we type that then the list below it will
 

00:02:21.570 --> 00:02:26.170 align:start position:0%
we type that then the list below it will
only<00:02:21.780><c> display</c><00:02:22.170><c> those</c><00:02:22.560><c> items</c>

00:02:26.170 --> 00:02:26.180 align:start position:0%
 
 

00:02:26.180 --> 00:02:30.070 align:start position:0%
 
and<00:02:26.269><c> then</c><00:02:27.200><c> click</c><00:02:27.409><c> okay</c>

00:02:30.070 --> 00:02:30.080 align:start position:0%
 
 

00:02:30.080 --> 00:02:32.470 align:start position:0%
 
now<00:02:30.860><c> let's</c><00:02:31.190><c> say</c><00:02:31.400><c> that</c><00:02:31.580><c> I</c><00:02:31.610><c> only</c><00:02:31.910><c> want</c><00:02:32.150><c> to</c><00:02:32.390><c> show</c>

00:02:32.470 --> 00:02:32.480 align:start position:0%
now let's say that I only want to show
 

00:02:32.480 --> 00:02:34.870 align:start position:0%
now let's say that I only want to show
items<00:02:33.020><c> where</c><00:02:33.320><c> the</c><00:02:33.470><c> ID</c><00:02:33.650><c> number</c><00:02:34.160><c> is</c><00:02:34.340><c> between</c>

00:02:34.870 --> 00:02:34.880 align:start position:0%
items where the ID number is between
 

00:02:34.880 --> 00:02:38.350 align:start position:0%
items where the ID number is between
3000<00:02:35.720><c> and</c><00:02:35.780><c> 4000</c><00:02:36.560><c> I</c><00:02:36.940><c> can</c><00:02:37.940><c> click</c><00:02:38.150><c> on</c><00:02:38.270><c> the</c>

00:02:38.350 --> 00:02:38.360 align:start position:0%
3000 and 4000 I can click on the
 

00:02:38.360 --> 00:02:40.840 align:start position:0%
3000 and 4000 I can click on the
drop-down<00:02:38.600><c> box</c><00:02:38.990><c> for</c><00:02:39.320><c> this</c><00:02:39.410><c> column</c><00:02:39.770><c> and</c><00:02:39.920><c> go</c><00:02:40.790><c> to</c>

00:02:40.840 --> 00:02:40.850 align:start position:0%
drop-down box for this column and go to
 

00:02:40.850 --> 00:02:43.500 align:start position:0%
drop-down box for this column and go to
number<00:02:41.390><c> filters</c>

00:02:43.500 --> 00:02:43.510 align:start position:0%
number filters
 

00:02:43.510 --> 00:02:45.089 align:start position:0%
number filters
there<00:02:43.989><c> are</c><00:02:44.110><c> a</c><00:02:44.200><c> lot</c><00:02:44.379><c> of</c><00:02:44.500><c> different</c><00:02:44.769><c> options</c>

00:02:45.089 --> 00:02:45.099 align:start position:0%
there are a lot of different options
 

00:02:45.099 --> 00:02:51.010 align:start position:0%
there are a lot of different options
here<00:02:45.340><c> and</c><00:02:45.580><c> I'll</c><00:02:45.730><c> click</c><00:02:45.939><c> on</c><00:02:46.090><c> between</c>

00:02:51.010 --> 00:02:51.020 align:start position:0%
 
 

00:02:51.020 --> 00:02:53.260 align:start position:0%
 
now<00:02:51.590><c> I</c><00:02:51.620><c> can</c><00:02:51.830><c> type</c><00:02:52.010><c> in</c><00:02:52.160><c> whatever</c><00:02:52.370><c> values</c><00:02:52.880><c> I</c><00:02:53.030><c> want</c>

00:02:53.260 --> 00:02:53.270 align:start position:0%
now I can type in whatever values I want
 

00:02:53.270 --> 00:02:59.900 align:start position:0%
now I can type in whatever values I want
here

00:02:59.900 --> 00:02:59.910 align:start position:0%
 
 

00:02:59.910 --> 00:03:02.600 align:start position:0%
 
so<00:03:00.840><c> this</c><00:03:01.020><c> will</c><00:03:01.200><c> show</c><00:03:01.230><c> rows</c><00:03:01.710><c> that</c><00:03:02.010><c> are</c><00:03:02.070><c> greater</c>

00:03:02.600 --> 00:03:02.610 align:start position:0%
so this will show rows that are greater
 

00:03:02.610 --> 00:03:06.020 align:start position:0%
so this will show rows that are greater
than<00:03:02.730><c> or</c><00:03:03.180><c> equal</c><00:03:03.210><c> to</c><00:03:03.720><c> 3000</c><00:03:04.500><c> and</c><00:03:04.670><c> less</c><00:03:05.670><c> than</c><00:03:05.880><c> or</c>

00:03:06.020 --> 00:03:06.030 align:start position:0%
than or equal to 3000 and less than or
 

00:03:06.030 --> 00:03:12.880 align:start position:0%
than or equal to 3000 and less than or
equal<00:03:06.360><c> to</c><00:03:06.540><c> 4000</c>

00:03:12.880 --> 00:03:12.890 align:start position:0%
 
 

00:03:12.890 --> 00:03:14.559 align:start position:0%
 
and<00:03:13.010><c> now</c><00:03:13.610><c> you</c><00:03:13.670><c> can</c><00:03:13.850><c> see</c><00:03:14.000><c> that</c><00:03:14.150><c> all</c><00:03:14.330><c> of</c><00:03:14.450><c> these</c>

00:03:14.559 --> 00:03:14.569 align:start position:0%
and now you can see that all of these
 

00:03:14.569 --> 00:03:19.790 align:start position:0%
and now you can see that all of these
values<00:03:14.780><c> are</c><00:03:15.140><c> between</c><00:03:15.290><c> 3,000</c><00:03:16.160><c> and</c><00:03:16.250><c> 4,000</c>

00:03:19.790 --> 00:03:19.800 align:start position:0%
 
 

00:03:19.800 --> 00:03:27.940 align:start position:0%
 
to<00:03:19.920><c> clear</c><00:03:20.190><c> these</c><00:03:20.340><c> filters</c>

00:03:27.940 --> 00:03:27.950 align:start position:0%
 
 

00:03:27.950 --> 00:03:30.740 align:start position:0%
 
now<00:03:28.950><c> the</c><00:03:29.010><c> date</c><00:03:29.370><c> filters</c><00:03:29.910><c> are</c><00:03:30.180><c> really</c><00:03:30.570><c> cool</c>

00:03:30.740 --> 00:03:30.750 align:start position:0%
now the date filters are really cool
 

00:03:30.750 --> 00:03:32.840 align:start position:0%
now the date filters are really cool
because<00:03:30.990><c> they</c><00:03:31.170><c> can</c><00:03:31.500><c> use</c><00:03:31.710><c> the</c><00:03:31.920><c> current</c><00:03:32.310><c> date</c><00:03:32.580><c> to</c>

00:03:32.840 --> 00:03:32.850 align:start position:0%
because they can use the current date to
 

00:03:32.850 --> 00:03:36.080 align:start position:0%
because they can use the current date to
filter<00:03:33.180><c> data</c><00:03:34.040><c> I'd</c><00:03:35.040><c> like</c><00:03:35.280><c> to</c><00:03:35.400><c> find</c><00:03:35.670><c> out</c><00:03:35.820><c> which</c>

00:03:36.080 --> 00:03:36.090 align:start position:0%
filter data I'd like to find out which
 

00:03:36.090 --> 00:03:38.940 align:start position:0%
filter data I'd like to find out which
items<00:03:36.450><c> were</c><00:03:36.540><c> checked</c><00:03:36.900><c> out</c><00:03:37.080><c> this</c><00:03:37.440><c> week</c>

00:03:38.940 --> 00:03:38.950 align:start position:0%
items were checked out this week
 

00:03:38.950 --> 00:03:41.550 align:start position:0%
items were checked out this week
if<00:03:39.010><c> we</c><00:03:39.580><c> go</c><00:03:39.790><c> to</c><00:03:39.849><c> the</c><00:03:40.090><c> date</c><00:03:40.300><c> filters</c><00:03:40.780><c> we</c><00:03:41.319><c> have</c>

00:03:41.550 --> 00:03:41.560 align:start position:0%
if we go to the date filters we have
 

00:03:41.560 --> 00:03:43.770 align:start position:0%
if we go to the date filters we have
many<00:03:41.980><c> different</c><00:03:42.340><c> options</c><00:03:42.430><c> and</c><00:03:43.000><c> I'll</c><00:03:43.540><c> select</c>

00:03:43.770 --> 00:03:43.780 align:start position:0%
many different options and I'll select
 

00:03:43.780 --> 00:03:49.160 align:start position:0%
many different options and I'll select
this<00:03:44.500><c> week</c>

00:03:49.160 --> 00:03:49.170 align:start position:0%
 
 

00:03:49.170 --> 00:03:51.260 align:start position:0%
 
finally<00:03:50.160><c> if</c><00:03:50.340><c> you'd</c><00:03:50.550><c> like</c><00:03:50.670><c> to</c><00:03:50.819><c> clear</c><00:03:51.060><c> all</c><00:03:51.240><c> of</c>

00:03:51.260 --> 00:03:51.270 align:start position:0%
finally if you'd like to clear all of
 

00:03:51.270 --> 00:03:52.820 align:start position:0%
finally if you'd like to clear all of
the<00:03:51.510><c> filters</c><00:03:51.750><c> and</c><00:03:52.110><c> get</c><00:03:52.470><c> rid</c><00:03:52.620><c> of</c><00:03:52.650><c> these</c>

00:03:52.820 --> 00:03:52.830 align:start position:0%
the filters and get rid of these
 

00:03:52.830 --> 00:03:54.920 align:start position:0%
the filters and get rid of these
drop-down<00:03:53.160><c> arrows</c><00:03:53.670><c> you</c><00:03:54.150><c> can</c><00:03:54.209><c> just</c><00:03:54.540><c> click</c><00:03:54.780><c> the</c>

00:03:54.920 --> 00:03:54.930 align:start position:0%
drop-down arrows you can just click the
 

00:03:54.930 --> 00:03:58.430 align:start position:0%
drop-down arrows you can just click the
filter<00:03:55.319><c> command</c><00:03:55.680><c> again</c>

00:03:58.430 --> 00:03:58.440 align:start position:0%
 
 

00:03:58.440 --> 00:03:59.960 align:start position:0%
 
your<00:03:58.530><c> spreadsheet</c><00:03:59.010><c> will</c><00:03:59.190><c> go</c><00:03:59.430><c> back</c><00:03:59.610><c> to</c><00:03:59.640><c> showing</c>

00:03:59.960 --> 00:03:59.970 align:start position:0%
your spreadsheet will go back to showing
 

00:03:59.970 --> 00:04:03.140 align:start position:0%
your spreadsheet will go back to showing
everything<00:04:01.220><c> so</c><00:04:02.220><c> you</c><00:04:02.310><c> can</c><00:04:02.490><c> see</c><00:04:02.670><c> how</c><00:04:02.790><c> quickly</c>

00:04:03.140 --> 00:04:03.150 align:start position:0%
everything so you can see how quickly
 

00:04:03.150 --> 00:04:05.780 align:start position:0%
everything so you can see how quickly
filtering<00:04:03.780><c> can</c><00:04:03.960><c> narrow</c><00:04:04.230><c> things</c><00:04:04.560><c> down</c><00:04:04.650><c> and</c><00:04:05.130><c> it</c>

00:04:05.780 --> 00:04:05.790 align:start position:0%
filtering can narrow things down and it
 

00:04:05.790 --> 00:04:07.490 align:start position:0%
filtering can narrow things down and it
gives<00:04:05.940><c> you</c><00:04:06.060><c> so</c><00:04:06.360><c> many</c><00:04:06.480><c> different</c><00:04:06.600><c> options</c><00:04:07.080><c> you</c>

00:04:07.490 --> 00:04:07.500 align:start position:0%
gives you so many different options you
 

00:04:07.500 --> 00:04:09.650 align:start position:0%
gives you so many different options you
can<00:04:07.770><c> probably</c><00:04:08.100><c> find</c><00:04:08.460><c> a</c><00:04:08.610><c> use</c><00:04:08.820><c> for</c><00:04:09.090><c> it</c><00:04:09.150><c> with</c><00:04:09.390><c> any</c>

00:04:09.650 --> 00:04:09.660 align:start position:0%
can probably find a use for it with any
 

00:04:09.660 --> 00:04:14.660 align:start position:0%
can probably find a use for it with any
spreadsheet<00:04:11.420><c> like</c><00:04:12.420><c> what</c><00:04:12.630><c> you</c><00:04:12.780><c> just</c><00:04:12.810><c> saw</c><00:04:13.670><c> rate</c>

00:04:14.660 --> 00:04:14.670 align:start position:0%
spreadsheet like what you just saw rate
 

00:04:14.670 --> 00:04:17.500 align:start position:0%
spreadsheet like what you just saw rate
it<00:04:14.850><c> add</c><00:04:15.360><c> a</c><00:04:15.420><c> comment</c><00:04:15.750><c> subscribe</c><00:04:16.470><c> to</c><00:04:16.920><c> our</c><00:04:17.040><c> chill</c>

00:04:17.500 --> 00:04:17.510 align:start position:0%
it add a comment subscribe to our chill
 

00:04:17.510 --> 00:04:20.110 align:start position:0%
it add a comment subscribe to our chill
the<00:04:18.510><c> freedom</c><00:04:18.930><c> to</c><00:04:19.080><c> learn</c>

00:04:20.110 --> 00:04:20.120 align:start position:0%
the freedom to learn
 

00:04:20.120 --> 00:04:25.480 align:start position:0%
the freedom to learn
what<00:04:20.870><c> you</c><00:04:21.079><c> want</c><00:04:21.580><c> when</c><00:04:22.580><c> you</c><00:04:22.610><c> want</c><00:04:24.490><c> absolutely</c>

00:04:25.480 --> 00:04:25.490 align:start position:0%
what you want when you want absolutely
 

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

00:04:29.140 --> 00:04:29.150 align:start position:0%
 
 

00:04:29.150 --> 00:04:32.780 align:start position:0%
 
GCF<00:04:30.150><c> learn</c><00:04:30.750><c> free.org</c>