WEBVTT
Kind: captions
Language: en

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

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

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

00:00:10.680 --> 00:00:10.690 align:start position:0%
 
 

00:00:10.690 --> 00:00:13.000 align:start position:0%
 
filtering<00:00:11.690><c> is</c><00:00:11.840><c> a</c><00:00:11.900><c> great</c><00:00:12.200><c> feature</c><00:00:12.470><c> of</c><00:00:12.590><c> Excel</c>

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

00:00:13.010 --> 00:00:14.470 align:start position:0%
filtering is a great feature of Excel
that<00:00:13.190><c> gives</c><00:00:13.370><c> you</c><00:00:13.460><c> a</c><00:00:13.490><c> lot</c><00:00:13.670><c> of</c><00:00:13.730><c> control</c><00:00:13.910><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:15.820 align:start position:0%
that gives you a lot of control over
which<00:00:14.660><c> parts</c><00:00:15.020><c> of</c><00:00:15.110><c> your</c><00:00:15.170><c> worksheet</c><00:00:15.620><c> are</c>

00:00:15.820 --> 00:00:15.830 align:start position:0%
which parts of your worksheet are
 

00:00:15.830 --> 00:00:18.190 align:start position:0%
which parts of your worksheet are
displayed<00:00:16.250><c> you</c><00:00:17.210><c> can</c><00:00:17.330><c> use</c><00:00:17.450><c> it</c><00:00:17.600><c> to</c><00:00:17.720><c> show</c><00:00:17.900><c> only</c>

00:00:18.190 --> 00:00:18.200 align:start position:0%
displayed you can use it to show only
 

00:00:18.200 --> 00:00:20.080 align:start position:0%
displayed you can use it to show only
the<00:00:18.500><c> information</c><00:00:18.950><c> you</c><00:00:19.070><c> need</c><00:00:19.340><c> or</c><00:00:19.610><c> find</c>

00:00:20.080 --> 00:00:20.090 align:start position:0%
the information you need or find
 

00:00:20.090 --> 00:00:22.150 align:start position:0%
the information you need or find
something<00:00:20.450><c> specific</c><00:00:20.660><c> while</c><00:00:21.500><c> hiding</c><00:00:21.770><c> the</c><00:00:22.009><c> rest</c>

00:00:22.150 --> 00:00:22.160 align:start position:0%
something specific while hiding the rest
 

00:00:22.160 --> 00:00:24.940 align:start position:0%
something specific while hiding the rest
of<00:00:22.369><c> the</c><00:00:22.430><c> data</c><00:00:22.580><c> temporarily</c><00:00:23.800><c> now</c><00:00:24.800><c> it's</c>

00:00:24.940 --> 00:00:24.950 align:start position:0%
of the data temporarily now it's
 

00:00:24.950 --> 00:00:26.260 align:start position:0%
of the data temporarily now it's
important<00:00:25.369><c> that</c><00:00:25.400><c> you</c><00:00:25.520><c> have</c><00:00:25.730><c> a</c><00:00:25.759><c> header</c><00:00:26.029><c> row</c>

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

00:00:26.270 --> 00:00:28.150 align:start position:0%
important that you have a header row
because<00:00:26.840><c> the</c><00:00:26.869><c> filtering</c><00:00:27.350><c> tools</c><00:00:27.590><c> actually</c><00:00:28.010><c> get</c>

00:00:28.150 --> 00:00:28.160 align:start position:0%
because the filtering tools actually get
 

00:00:28.160 --> 00:00:29.920 align:start position:0%
because the filtering tools actually get
added<00:00:28.460><c> to</c><00:00:28.580><c> the</c><00:00:28.670><c> cells</c><00:00:28.910><c> in</c><00:00:29.119><c> the</c><00:00:29.330><c> header</c><00:00:29.480><c> row</c><00:00:29.570><c> in</c>

00:00:29.920 --> 00:00:29.930 align:start position:0%
added to the cells in the header row in
 

00:00:29.930 --> 00:00:31.810 align:start position:0%
added to the cells in the header row in
this<00:00:30.920><c> example</c><00:00:31.279><c> I</c><00:00:31.519><c> have</c><00:00:31.550><c> an</c><00:00:31.760><c> equipment</c>

00:00:31.810 --> 00:00:31.820 align:start position:0%
this example I have an equipment
 

00:00:31.820 --> 00:00:33.939 align:start position:0%
this example I have an equipment
checkout<00:00:32.629><c> log</c><00:00:32.900><c> and</c><00:00:33.170><c> there</c><00:00:33.650><c> are</c><00:00:33.739><c> a</c><00:00:33.769><c> lot</c><00:00:33.920><c> of</c>

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

00:00:33.949 --> 00:00:35.860 align:start position:0%
checkout log and there are a lot of
things<00:00:34.280><c> to</c><00:00:34.430><c> keep</c><00:00:34.550><c> track</c><00:00:34.850><c> of</c><00:00:35.090><c> so</c><00:00:35.449><c> I'd</c><00:00:35.570><c> like</c><00:00:35.720><c> to</c>

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

00:00:35.870 --> 00:00:38.520 align:start position:0%
things to keep track of so I'd like to
use<00:00:36.019><c> some</c><00:00:36.050><c> of</c><00:00:36.320><c> the</c><00:00:36.379><c> filters</c><00:00:36.710><c> to</c><00:00:36.890><c> simplify</c><00:00:37.370><c> it</c>

00:00:38.520 --> 00:00:38.530 align:start position:0%
use some of the filters to simplify it
 

00:00:38.530 --> 00:00:42.460 align:start position:0%
use some of the filters to simplify it
first<00:00:39.530><c> go</c><00:00:39.830><c> to</c><00:00:39.860><c> the</c><00:00:40.160><c> data</c><00:00:40.400><c> tab</c><00:00:40.670><c> and</c><00:00:41.440><c> click</c><00:00:42.440><c> the</c>

00:00:42.460 --> 00:00:42.470 align:start position:0%
first go to the data tab and click the
 

00:00:42.470 --> 00:00:45.219 align:start position:0%
first go to the data tab and click the
filter<00:00:43.010><c> command</c><00:00:43.309><c> and</c><00:00:43.900><c> you'll</c><00:00:44.900><c> see</c><00:00:45.080><c> these</c>

00:00:45.219 --> 00:00:45.229 align:start position:0%
filter command and you'll see these
 

00:00:45.229 --> 00:00:47.020 align:start position:0%
filter command and you'll see these
drop-down<00:00:45.799><c> arrows</c><00:00:46.220><c> added</c><00:00:46.610><c> to</c><00:00:46.699><c> your</c><00:00:46.790><c> header</c>

00:00:47.020 --> 00:00:47.030 align:start position:0%
drop-down arrows added to your header
 

00:00:47.030 --> 00:00:49.570 align:start position:0%
drop-down arrows added to your header
row<00:00:47.409><c> these</c><00:00:48.409><c> are</c><00:00:48.620><c> what</c><00:00:48.739><c> you'll</c><00:00:48.860><c> use</c><00:00:49.070><c> to</c><00:00:49.100><c> access</c>

00:00:49.570 --> 00:00:49.580 align:start position:0%
row these are what you'll use to access
 

00:00:49.580 --> 00:00:53.469 align:start position:0%
row these are what you'll use to access
all<00:00:49.820><c> of</c><00:00:49.850><c> the</c><00:00:50.150><c> filtering</c><00:00:50.540><c> options</c><00:00:52.299><c> here</c><00:00:53.299><c> you'll</c>

00:00:53.469 --> 00:00:53.479 align:start position:0%
all of the filtering options here you'll
 

00:00:53.479 --> 00:00:54.729 align:start position:0%
all of the filtering options here you'll
see<00:00:53.629><c> a</c><00:00:53.659><c> list</c><00:00:53.900><c> of</c><00:00:53.989><c> all</c><00:00:54.199><c> of</c><00:00:54.350><c> the</c><00:00:54.440><c> different</c>

00:00:54.729 --> 00:00:54.739 align:start position:0%
see a list of all of the different
 

00:00:54.739 --> 00:00:57.070 align:start position:0%
see a list of all of the different
values<00:00:55.040><c> that</c><00:00:55.070><c> appear</c><00:00:55.309><c> in</c><00:00:55.610><c> this</c><00:00:55.729><c> column</c><00:00:56.080><c> I'd</c>

00:00:57.070 --> 00:00:57.080 align:start position:0%
values that appear in this column I'd
 

00:00:57.080 --> 00:00:59.109 align:start position:0%
values that appear in this column I'd
like<00:00:57.470><c> to</c><00:00:57.619><c> just</c><00:00:57.949><c> view</c><00:00:58.190><c> the</c><00:00:58.339><c> laptops</c><00:00:58.820><c> and</c>

00:00:59.109 --> 00:00:59.119 align:start position:0%
like to just view the laptops and
 

00:00:59.119 --> 00:01:01.660 align:start position:0%
like to just view the laptops and
projectors<00:00:59.659><c> so</c><00:01:00.260><c> I'll</c><00:01:00.379><c> uncheck</c><00:01:00.589><c> this</c><00:01:01.070><c> box</c><00:01:01.129><c> to</c>

00:01:01.660 --> 00:01:01.670 align:start position:0%
projectors so I'll uncheck this box to
 

00:01:01.670 --> 00:01:04.810 align:start position:0%
projectors so I'll uncheck this box to
quickly<00:01:02.030><c> des</c><00:01:02.299><c> elect</c><00:01:02.629><c> everything</c><00:01:03.489><c> then</c><00:01:04.489><c> check</c>

00:01:04.810 --> 00:01:04.820 align:start position:0%
quickly des elect everything then check
 

00:01:04.820 --> 00:01:11.770 align:start position:0%
quickly des elect everything then check
laptop<00:01:05.540><c> and</c><00:01:05.799><c> projector</c><00:01:08.619><c> click</c><00:01:09.619><c> OK</c><00:01:09.950><c> and</c><00:01:10.780><c> now</c>

00:01:11.770 --> 00:01:11.780 align:start position:0%
laptop and projector click OK and now
 

00:01:11.780 --> 00:01:13.330 align:start position:0%
laptop and projector click OK and now
the<00:01:11.840><c> drop-down</c><00:01:12.350><c> arrow</c><00:01:12.409><c> has</c><00:01:12.799><c> changed</c><00:01:13.189><c> to</c><00:01:13.310><c> a</c>

00:01:13.330 --> 00:01:13.340 align:start position:0%
the drop-down arrow has changed to a
 

00:01:13.340 --> 00:01:14.890 align:start position:0%
the drop-down arrow has changed to a
different<00:01:13.549><c> icon</c><00:01:14.119><c> to</c><00:01:14.330><c> show</c><00:01:14.510><c> that</c><00:01:14.660><c> there</c><00:01:14.810><c> is</c><00:01:14.870><c> a</c>

00:01:14.890 --> 00:01:14.900 align:start position:0%
different icon to show that there is a
 

00:01:14.900 --> 00:01:18.220 align:start position:0%
different icon to show that there is a
filter<00:01:15.170><c> in</c><00:01:15.500><c> this</c><00:01:15.680><c> column</c><00:01:16.070><c> we</c><00:01:16.690><c> can</c><00:01:17.690><c> narrow</c><00:01:18.020><c> down</c>

00:01:18.220 --> 00:01:18.230 align:start position:0%
filter in this column we can narrow down
 

00:01:18.230 --> 00:01:20.140 align:start position:0%
filter in this column we can narrow down
this<00:01:18.410><c> data</c><00:01:18.620><c> even</c><00:01:19.040><c> further</c><00:01:19.310><c> by</c><00:01:19.640><c> adding</c><00:01:19.790><c> another</c>

00:01:20.140 --> 00:01:20.150 align:start position:0%
this data even further by adding another
 

00:01:20.150 --> 00:01:22.510 align:start position:0%
this data even further by adding another
filter<00:01:20.600><c> to</c><00:01:20.810><c> a</c><00:01:20.840><c> different</c><00:01:21.230><c> column</c><00:01:21.560><c> let's</c>

00:01:22.510 --> 00:01:22.520 align:start position:0%
filter to a different column let's
 

00:01:22.520 --> 00:01:24.040 align:start position:0%
filter to a different column let's
filter<00:01:22.730><c> by</c><00:01:23.000><c> the</c><00:01:23.060><c> date</c><00:01:23.300><c> that</c><00:01:23.480><c> the</c><00:01:23.570><c> items</c><00:01:23.870><c> were</c>

00:01:24.040 --> 00:01:24.050 align:start position:0%
filter by the date that the items were
 

00:01:24.050 --> 00:01:27.610 align:start position:0%
filter by the date that the items were
checked<00:01:24.080><c> out</c><00:01:25.570><c> this</c><00:01:26.570><c> shows</c><00:01:26.870><c> all</c><00:01:27.140><c> of</c><00:01:27.170><c> the</c><00:01:27.380><c> months</c>

00:01:27.610 --> 00:01:27.620 align:start position:0%
checked out this shows all of the months
 

00:01:27.620 --> 00:01:29.740 align:start position:0%
checked out this shows all of the months
that<00:01:27.680><c> appear</c><00:01:28.100><c> in</c><00:01:28.160><c> this</c><00:01:28.250><c> column</c><00:01:28.490><c> so</c><00:01:28.850><c> I'll</c>

00:01:29.740 --> 00:01:29.750 align:start position:0%
that appear in this column so I'll
 

00:01:29.750 --> 00:01:32.490 align:start position:0%
that appear in this column so I'll
uncheck<00:01:29.960><c> the</c><00:01:30.410><c> months</c><00:01:30.650><c> that</c><00:01:30.710><c> I</c><00:01:30.860><c> don't</c><00:01:31.190><c> want</c>

00:01:32.490 --> 00:01:32.500 align:start position:0%
uncheck the months that I don't want
 

00:01:32.500 --> 00:01:38.500 align:start position:0%
uncheck the months that I don't want
then<00:01:33.500><c> click</c><00:01:33.800><c> OK</c><00:01:36.550><c> to</c><00:01:37.550><c> get</c><00:01:37.700><c> rid</c><00:01:37.850><c> of</c><00:01:37.880><c> any</c><00:01:38.120><c> filter</c>

00:01:38.500 --> 00:01:38.510 align:start position:0%
then click OK to get rid of any filter
 

00:01:38.510 --> 00:01:41.830 align:start position:0%
then click OK to get rid of any filter
just<00:01:38.750><c> click</c><00:01:38.870><c> the</c><00:01:39.200><c> icon</c><00:01:39.350><c> again</c><00:01:39.680><c> and</c><00:01:40.840><c> select</c>

00:01:41.830 --> 00:01:41.840 align:start position:0%
just click the icon again and select
 

00:01:41.840 --> 00:01:50.980 align:start position:0%
just click the icon again and select
clear<00:01:42.290><c> filter</c><00:01:48.970><c> so</c><00:01:49.970><c> that's</c><00:01:50.120><c> how</c><00:01:50.240><c> you</c><00:01:50.300><c> do</c><00:01:50.540><c> simple</c>

00:01:50.980 --> 00:01:50.990 align:start position:0%
clear filter so that's how you do simple
 

00:01:50.990 --> 00:01:53.080 align:start position:0%
clear filter so that's how you do simple
filtering<00:01:51.470><c> and</c><00:01:51.680><c> now</c><00:01:52.460><c> let's</c><00:01:52.670><c> look</c><00:01:52.790><c> at</c><00:01:52.940><c> some</c>

00:01:53.080 --> 00:01:53.090 align:start position:0%
filtering and now let's look at some
 

00:01:53.090 --> 00:01:56.710 align:start position:0%
filtering and now let's look at some
more<00:01:53.240><c> advanced</c><00:01:53.600><c> techniques</c><00:01:55.390><c> using</c><00:01:56.390><c> the</c><00:01:56.479><c> same</c>

00:01:56.710 --> 00:01:56.720 align:start position:0%
more advanced techniques using the same
 

00:01:56.720 --> 00:01:58.780 align:start position:0%
more advanced techniques using the same
menu<00:01:57.020><c> we</c><00:01:57.320><c> can</c><00:01:57.470><c> also</c><00:01:57.650><c> search</c><00:01:58.159><c> for</c><00:01:58.190><c> values</c><00:01:58.760><c> that</c>

00:01:58.780 --> 00:01:58.790 align:start position:0%
menu we can also search for values that
 

00:01:58.790 --> 00:02:01.360 align:start position:0%
menu we can also search for values that
appear<00:01:59.030><c> in</c><00:01:59.240><c> this</c><00:01:59.360><c> column</c><00:01:59.750><c> in</c><00:01:59.930><c> this</c><00:02:00.800><c> example</c><00:02:01.159><c> a</c>

00:02:01.360 --> 00:02:01.370 align:start position:0%
appear in this column in this example a
 

00:02:01.370 --> 00:02:02.649 align:start position:0%
appear in this column in this example a
lot<00:02:01.580><c> of</c><00:02:01.670><c> our</c><00:02:01.760><c> equipment</c><00:02:01.940><c> is</c><00:02:02.210><c> made</c><00:02:02.450><c> by</c><00:02:02.630><c> a</c>

00:02:02.649 --> 00:02:02.659 align:start position:0%
lot of our equipment is made by a
 

00:02:02.659 --> 00:02:05.440 align:start position:0%
lot of our equipment is made by a
company<00:02:03.020><c> called</c><00:02:03.110><c> saris</c><00:02:03.830><c> so</c><00:02:04.580><c> if</c><00:02:04.820><c> we</c><00:02:04.970><c> enter</c><00:02:05.150><c> that</c>

00:02:05.440 --> 00:02:05.450 align:start position:0%
company called saris so if we enter that
 

00:02:05.450 --> 00:02:07.810 align:start position:0%
company called saris so if we enter that
here<00:02:06.070><c> Excel</c><00:02:07.070><c> will</c><00:02:07.250><c> look</c><00:02:07.430><c> for</c><00:02:07.580><c> a</c><00:02:07.610><c> match</c>

00:02:07.810 --> 00:02:07.820 align:start position:0%
here Excel will look for a match
 

00:02:07.820 --> 00:02:10.119 align:start position:0%
here Excel will look for a match
anywhere<00:02:08.299><c> in</c><00:02:08.509><c> these</c><00:02:08.659><c> cells</c><00:02:09.019><c> and</c><00:02:09.349><c> then</c><00:02:09.860><c> list</c>

00:02:10.119 --> 00:02:10.129 align:start position:0%
anywhere in these cells and then list
 

00:02:10.129 --> 00:02:12.970 align:start position:0%
anywhere in these cells and then list
only<00:02:10.340><c> those</c><00:02:10.640><c> results</c><00:02:10.849><c> below</c><00:02:11.650><c> to</c><00:02:12.650><c> apply</c><00:02:12.769><c> the</c>

00:02:12.970 --> 00:02:12.980 align:start position:0%
only those results below to apply the
 

00:02:12.980 --> 00:02:15.870 align:start position:0%
only those results below to apply the
filter<00:02:13.370><c> just</c><00:02:13.640><c> click</c><00:02:13.760><c> OK</c>

00:02:15.870 --> 00:02:15.880 align:start position:0%
filter just click OK
 

00:02:15.880 --> 00:02:18.100 align:start position:0%
filter just click OK
for<00:02:16.880><c> a</c><00:02:16.910><c> little</c><00:02:17.030><c> more</c><00:02:17.300><c> control</c><00:02:17.660><c> you</c><00:02:17.810><c> can</c><00:02:17.960><c> use</c>

00:02:18.100 --> 00:02:18.110 align:start position:0%
for a little more control you can use
 

00:02:18.110 --> 00:02:20.770 align:start position:0%
for a little more control you can use
text<00:02:18.470><c> filters</c><00:02:18.890><c> instead</c><00:02:19.360><c> you</c><00:02:20.360><c> can</c><00:02:20.480><c> access</c>

00:02:20.770 --> 00:02:20.780 align:start position:0%
text filters instead you can access
 

00:02:20.780 --> 00:02:24.310 align:start position:0%
text filters instead you can access
these<00:02:20.990><c> from</c><00:02:21.200><c> the</c><00:02:21.350><c> same</c><00:02:21.590><c> menu</c><00:02:22.810><c> under</c><00:02:23.810><c> text</c>

00:02:24.310 --> 00:02:24.320 align:start position:0%
these from the same menu under text
 

00:02:24.320 --> 00:02:27.790 align:start position:0%
these from the same menu under text
filters<00:02:25.690><c> here</c><00:02:26.690><c> you</c><00:02:26.840><c> can</c><00:02:26.990><c> filter</c><00:02:27.200><c> information</c>

00:02:27.790 --> 00:02:27.800 align:start position:0%
filters here you can filter information
 

00:02:27.800 --> 00:02:30.220 align:start position:0%
filters here you can filter information
that<00:02:27.950><c> fits</c><00:02:28.070><c> more</c><00:02:28.430><c> specific</c><00:02:29.030><c> criteria</c><00:02:29.600><c> for</c>

00:02:30.220 --> 00:02:30.230 align:start position:0%
that fits more specific criteria for
 

00:02:30.230 --> 00:02:31.840 align:start position:0%
that fits more specific criteria for
example<00:02:30.650><c> cells</c><00:02:30.980><c> that</c><00:02:31.130><c> contain</c><00:02:31.460><c> a</c><00:02:31.520><c> certain</c>

00:02:31.840 --> 00:02:31.850 align:start position:0%
example cells that contain a certain
 

00:02:31.850 --> 00:02:33.850 align:start position:0%
example cells that contain a certain
number<00:02:32.240><c> of</c><00:02:32.270><c> characters</c><00:02:32.570><c> or</c><00:02:33.320><c> data</c><00:02:33.770><c> that</c>

00:02:33.850 --> 00:02:33.860 align:start position:0%
number of characters or data that
 

00:02:33.860 --> 00:02:35.920 align:start position:0%
number of characters or data that
doesn't<00:02:34.460><c> contain</c><00:02:34.790><c> a</c><00:02:34.850><c> word</c><00:02:35.180><c> that</c><00:02:35.330><c> you</c><00:02:35.420><c> specify</c>

00:02:35.920 --> 00:02:35.930 align:start position:0%
doesn't contain a word that you specify
 

00:02:35.930 --> 00:02:38.590 align:start position:0%
doesn't contain a word that you specify
in<00:02:36.520><c> this</c><00:02:37.520><c> example</c><00:02:37.850><c> we're</c><00:02:38.120><c> going</c><00:02:38.300><c> to</c><00:02:38.390><c> choose</c>

00:02:38.590 --> 00:02:38.600 align:start position:0%
in this example we're going to choose
 

00:02:38.600 --> 00:02:42.460 align:start position:0%
in this example we're going to choose
does<00:02:39.020><c> not</c><00:02:39.200><c> contain</c><00:02:39.620><c> and</c><00:02:40.510><c> then</c><00:02:41.510><c> enter</c><00:02:41.870><c> laptop</c>

00:02:42.460 --> 00:02:42.470 align:start position:0%
does not contain and then enter laptop
 

00:02:42.470 --> 00:02:44.710 align:start position:0%
does not contain and then enter laptop
to<00:02:43.100><c> exclude</c><00:02:43.520><c> anything</c><00:02:44.000><c> that</c><00:02:44.150><c> contains</c><00:02:44.450><c> this</c>

00:02:44.710 --> 00:02:44.720 align:start position:0%
to exclude anything that contains this
 

00:02:44.720 --> 00:02:47.920 align:start position:0%
to exclude anything that contains this
word<00:02:44.960><c> including</c><00:02:45.830><c> laptops</c><00:02:46.340><c> and</c><00:02:46.640><c> laptop</c><00:02:47.480><c> travel</c>

00:02:47.920 --> 00:02:47.930 align:start position:0%
word including laptops and laptop travel
 

00:02:47.930 --> 00:02:48.750 align:start position:0%
word including laptops and laptop travel
bags

00:02:48.750 --> 00:02:48.760 align:start position:0%
bags
 

00:02:48.760 --> 00:02:53.080 align:start position:0%
bags
click<00:02:49.760><c> OK</c><00:02:50.060><c> and</c><00:02:50.890><c> Excel</c><00:02:51.890><c> will</c><00:02:52.310><c> refill</c><00:02:52.790><c> Terr</c><00:02:52.970><c> the</c>

00:02:53.080 --> 00:02:53.090 align:start position:0%
click OK and Excel will refill Terr the
 

00:02:53.090 --> 00:02:56.860 align:start position:0%
click OK and Excel will refill Terr the
data<00:02:54.490><c> next</c><00:02:55.490><c> let's</c><00:02:55.850><c> say</c><00:02:56.060><c> I</c><00:02:56.090><c> only</c><00:02:56.360><c> want</c><00:02:56.570><c> to</c><00:02:56.780><c> show</c>

00:02:56.860 --> 00:02:56.870 align:start position:0%
data next let's say I only want to show
 

00:02:56.870 --> 00:02:58.720 align:start position:0%
data next let's say I only want to show
items<00:02:57.320><c> where</c><00:02:57.530><c> the</c><00:02:57.620><c> ID</c><00:02:57.830><c> number</c><00:02:58.370><c> is</c><00:02:58.550><c> between</c>

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

00:02:58.730 --> 00:03:02.680 align:start position:0%
items where the ID number is between
3000<00:02:59.690><c> and</c><00:02:59.830><c> 6000</c><00:03:00.830><c> I</c><00:03:01.090><c> can</c><00:03:02.090><c> click</c><00:03:02.300><c> the</c><00:03:02.420><c> drop</c><00:03:02.660><c> down</c>

00:03:02.680 --> 00:03:02.690 align:start position:0%
3000 and 6000 I can click the drop down
 

00:03:02.690 --> 00:03:08.140 align:start position:0%
3000 and 6000 I can click the drop down
arrow<00:03:02.900><c> and</c><00:03:03.940><c> go</c><00:03:04.940><c> to</c><00:03:05.000><c> number</c><00:03:05.540><c> filters</c><00:03:07.030><c> there</c><00:03:08.030><c> are</c>

00:03:08.140 --> 00:03:08.150 align:start position:0%
arrow and go to number filters there are
 

00:03:08.150 --> 00:03:09.760 align:start position:0%
arrow and go to number filters there are
a<00:03:08.180><c> lot</c><00:03:08.300><c> of</c><00:03:08.330><c> different</c><00:03:08.780><c> options</c><00:03:08.900><c> here</c><00:03:09.320><c> but</c><00:03:09.350><c> for</c>

00:03:09.760 --> 00:03:09.770 align:start position:0%
a lot of different options here but for
 

00:03:09.770 --> 00:03:12.540 align:start position:0%
a lot of different options here but for
what<00:03:09.890><c> I</c><00:03:09.920><c> need</c><00:03:10.190><c> I'm</c><00:03:10.370><c> going</c><00:03:10.550><c> to</c><00:03:10.670><c> choose</c><00:03:10.880><c> between</c>

00:03:12.540 --> 00:03:12.550 align:start position:0%
what I need I'm going to choose between
 

00:03:12.550 --> 00:03:15.280 align:start position:0%
what I need I'm going to choose between
now<00:03:13.550><c> I</c><00:03:13.580><c> can</c><00:03:13.850><c> type</c><00:03:14.030><c> in</c><00:03:14.209><c> whatever</c><00:03:14.480><c> values</c><00:03:14.990><c> I</c><00:03:15.110><c> want</c>

00:03:15.280 --> 00:03:15.290 align:start position:0%
now I can type in whatever values I want
 

00:03:15.290 --> 00:03:20.530 align:start position:0%
now I can type in whatever values I want
in<00:03:15.500><c> these</c><00:03:15.650><c> two</c><00:03:15.890><c> fields</c><00:03:19.090><c> so</c><00:03:20.090><c> this</c><00:03:20.209><c> will</c><00:03:20.360><c> show</c>

00:03:20.530 --> 00:03:20.540 align:start position:0%
in these two fields so this will show
 

00:03:20.540 --> 00:03:22.509 align:start position:0%
in these two fields so this will show
rows<00:03:20.810><c> that</c><00:03:20.989><c> are</c><00:03:21.050><c> greater</c><00:03:21.470><c> than</c><00:03:21.590><c> or</c><00:03:21.950><c> equal</c><00:03:21.980><c> to</c>

00:03:22.509 --> 00:03:22.519 align:start position:0%
rows that are greater than or equal to
 

00:03:22.519 --> 00:03:27.600 align:start position:0%
rows that are greater than or equal to
3000<00:03:23.239><c> and</c><00:03:23.360><c> less</c><00:03:24.110><c> than</c><00:03:24.320><c> or</c><00:03:24.560><c> equal</c><00:03:24.590><c> to</c><00:03:24.890><c> 6000</c>

00:03:27.600 --> 00:03:27.610 align:start position:0%
3000 and less than or equal to 6000
 

00:03:27.610 --> 00:03:31.810 align:start position:0%
3000 and less than or equal to 6000
click<00:03:28.610><c> OK</c><00:03:28.970><c> and</c><00:03:29.769><c> now</c><00:03:30.769><c> all</c><00:03:31.040><c> of</c><00:03:31.070><c> these</c><00:03:31.280><c> values</c><00:03:31.670><c> are</c>

00:03:31.810 --> 00:03:31.820 align:start position:0%
click OK and now all of these values are
 

00:03:31.820 --> 00:03:36.610 align:start position:0%
click OK and now all of these values are
between<00:03:32.209><c> 3000</c><00:03:32.930><c> and</c><00:03:32.989><c> 6000</c><00:03:34.959><c> date</c><00:03:35.959><c> filters</c><00:03:36.410><c> are</c>

00:03:36.610 --> 00:03:36.620 align:start position:0%
between 3000 and 6000 date filters are
 

00:03:36.620 --> 00:03:37.690 align:start position:0%
between 3000 and 6000 date filters are
really<00:03:36.920><c> cool</c><00:03:37.100><c> because</c><00:03:37.310><c> they</c><00:03:37.519><c> can</c><00:03:37.550><c> display</c>

00:03:37.690 --> 00:03:37.700 align:start position:0%
really cool because they can display
 

00:03:37.700 --> 00:03:40.150 align:start position:0%
really cool because they can display
data<00:03:38.180><c> from</c><00:03:38.390><c> a</c><00:03:38.540><c> certain</c><00:03:38.840><c> time</c><00:03:39.050><c> period</c><00:03:39.260><c> such</c><00:03:39.980><c> as</c>

00:03:40.150 --> 00:03:40.160 align:start position:0%
data from a certain time period such as
 

00:03:40.160 --> 00:03:43.150 align:start position:0%
data from a certain time period such as
last<00:03:40.430><c> year</c><00:03:40.790><c> next</c><00:03:41.480><c> quarter</c><00:03:41.989><c> between</c><00:03:42.769><c> two</c><00:03:42.980><c> dates</c>

00:03:43.150 --> 00:03:43.160 align:start position:0%
last year next quarter between two dates
 

00:03:43.160 --> 00:03:45.880 align:start position:0%
last year next quarter between two dates
and<00:03:43.430><c> more</c><00:03:43.760><c> in</c><00:03:44.019><c> this</c><00:03:45.019><c> example</c><00:03:45.410><c> I'd</c><00:03:45.709><c> like</c><00:03:45.739><c> to</c>

00:03:45.880 --> 00:03:45.890 align:start position:0%
and more in this example I'd like to
 

00:03:45.890 --> 00:03:47.560 align:start position:0%
and more in this example I'd like to
find<00:03:46.190><c> out</c><00:03:46.310><c> which</c><00:03:46.610><c> items</c><00:03:46.970><c> were</c><00:03:47.060><c> checked</c><00:03:47.150><c> out</c>

00:03:47.560 --> 00:03:47.570 align:start position:0%
find out which items were checked out
 

00:03:47.570 --> 00:03:51.310 align:start position:0%
find out which items were checked out
this<00:03:47.930><c> week</c><00:03:49.060><c> all</c><00:03:50.060><c> you</c><00:03:50.420><c> have</c><00:03:50.540><c> to</c><00:03:50.660><c> do</c><00:03:50.810><c> is</c><00:03:51.019><c> go</c><00:03:51.260><c> to</c>

00:03:51.310 --> 00:03:51.320 align:start position:0%
this week all you have to do is go to
 

00:03:51.320 --> 00:03:53.860 align:start position:0%
this week all you have to do is go to
date<00:03:51.800><c> filters</c><00:03:52.250><c> and</c><00:03:52.489><c> you'll</c><00:03:53.450><c> find</c><00:03:53.660><c> many</c>

00:03:53.860 --> 00:03:53.870 align:start position:0%
date filters and you'll find many
 

00:03:53.870 --> 00:03:55.150 align:start position:0%
date filters and you'll find many
options<00:03:54.320><c> to</c><00:03:54.380><c> choose</c><00:03:54.500><c> from</c>

00:03:55.150 --> 00:03:55.160 align:start position:0%
options to choose from
 

00:03:55.160 --> 00:03:58.990 align:start position:0%
options to choose from
I'll<00:03:55.400><c> select</c><00:03:56.360><c> this</c><00:03:56.900><c> week</c>

00:03:58.990 --> 00:03:59.000 align:start position:0%
I'll select this week
 

00:03:59.000 --> 00:04:01.280 align:start position:0%
I'll select this week
at<00:04:00.000><c> this</c><00:04:00.150><c> point</c><00:04:00.360><c> we</c><00:04:00.569><c> have</c><00:04:00.720><c> three</c><00:04:01.110><c> different</c>

00:04:01.280 --> 00:04:01.290 align:start position:0%
at this point we have three different
 

00:04:01.290 --> 00:04:03.440 align:start position:0%
at this point we have three different
filters<00:04:01.800><c> applied</c><00:04:02.129><c> to</c><00:04:02.160><c> the</c><00:04:02.310><c> worksheet</c><00:04:02.400><c> so</c><00:04:03.300><c> it's</c>

00:04:03.440 --> 00:04:03.450 align:start position:0%
filters applied to the worksheet so it's
 

00:04:03.450 --> 00:04:05.300 align:start position:0%
filters applied to the worksheet so it's
filtering<00:04:03.870><c> out</c><00:04:03.989><c> most</c><00:04:04.290><c> of</c><00:04:04.410><c> the</c><00:04:04.530><c> items</c><00:04:04.830><c> and</c><00:04:05.069><c> just</c>

00:04:05.300 --> 00:04:05.310 align:start position:0%
filtering out most of the items and just
 

00:04:05.310 --> 00:04:06.740 align:start position:0%
filtering out most of the items and just
showing<00:04:05.489><c> the</c><00:04:05.670><c> ones</c><00:04:05.849><c> that</c><00:04:05.940><c> meet</c><00:04:06.090><c> all</c><00:04:06.420><c> of</c><00:04:06.480><c> the</c>

00:04:06.740 --> 00:04:06.750 align:start position:0%
showing the ones that meet all of the
 

00:04:06.750 --> 00:04:10.160 align:start position:0%
showing the ones that meet all of the
criteria<00:04:06.900><c> if</c><00:04:08.209><c> you'd</c><00:04:09.209><c> like</c><00:04:09.330><c> to</c><00:04:09.480><c> remove</c><00:04:09.750><c> any</c><00:04:09.959><c> of</c>

00:04:10.160 --> 00:04:10.170 align:start position:0%
criteria if you'd like to remove any of
 

00:04:10.170 --> 00:04:11.960 align:start position:0%
criteria if you'd like to remove any of
the<00:04:10.290><c> filters</c><00:04:10.500><c> you</c><00:04:10.860><c> can</c><00:04:10.890><c> clear</c><00:04:11.370><c> them</c><00:04:11.550><c> one</c><00:04:11.819><c> by</c>

00:04:11.960 --> 00:04:11.970 align:start position:0%
the filters you can clear them one by
 

00:04:11.970 --> 00:04:15.410 align:start position:0%
the filters you can clear them one by
one<00:04:12.000><c> like</c><00:04:12.390><c> I</c><00:04:12.510><c> showed</c><00:04:12.660><c> you</c><00:04:12.720><c> before</c><00:04:13.550><c> or</c><00:04:14.550><c> you</c><00:04:15.269><c> can</c>

00:04:15.410 --> 00:04:15.420 align:start position:0%
one like I showed you before or you can
 

00:04:15.420 --> 00:04:17.810 align:start position:0%
one like I showed you before or you can
turn<00:04:15.569><c> off</c><00:04:15.750><c> filtering</c><00:04:16.229><c> altogether</c><00:04:16.739><c> just</c><00:04:17.010><c> click</c>

00:04:17.810 --> 00:04:17.820 align:start position:0%
turn off filtering altogether just click
 

00:04:17.820 --> 00:04:22.039 align:start position:0%
turn off filtering altogether just click
the<00:04:18.000><c> filter</c><00:04:18.359><c> command</c><00:04:18.479><c> again</c><00:04:20.630><c> as</c><00:04:21.630><c> you</c><00:04:21.870><c> can</c><00:04:21.900><c> see</c>

00:04:22.039 --> 00:04:22.049 align:start position:0%
the filter command again as you can see
 

00:04:22.049 --> 00:04:23.900 align:start position:0%
the filter command again as you can see
filtering<00:04:22.740><c> can</c><00:04:22.889><c> narrow</c><00:04:23.100><c> things</c><00:04:23.370><c> down</c><00:04:23.460><c> really</c>

00:04:23.900 --> 00:04:23.910 align:start position:0%
filtering can narrow things down really
 

00:04:23.910 --> 00:04:25.640 align:start position:0%
filtering can narrow things down really
quickly<00:04:24.210><c> and</c><00:04:24.510><c> it</c><00:04:24.990><c> gives</c><00:04:25.169><c> you</c><00:04:25.290><c> so</c><00:04:25.500><c> many</c>

00:04:25.640 --> 00:04:25.650 align:start position:0%
quickly and it gives you so many
 

00:04:25.650 --> 00:04:27.260 align:start position:0%
quickly and it gives you so many
different<00:04:25.949><c> options</c><00:04:26.100><c> you</c><00:04:26.520><c> can</c><00:04:26.639><c> probably</c><00:04:26.910><c> find</c>

00:04:27.260 --> 00:04:27.270 align:start position:0%
different options you can probably find
 

00:04:27.270 --> 00:04:33.790 align:start position:0%
different options you can probably find
a<00:04:27.419><c> use</c><00:04:27.570><c> for</c><00:04:27.600><c> it</c><00:04:27.840><c> with</c><00:04:28.080><c> any</c><00:04:28.260><c> worksheet</c>

00:04:33.790 --> 00:04:33.800 align:start position:0%
 
 

00:04:33.800 --> 00:04:35.860 align:start position:0%
 
you