WEBVTT Kind: captions Language: en 00:00:11.259 --> 00:00:13.309 Filtering is a great feature of Excel that gives 00:00:13.309 --> 00:00:14.309 you a lot of control 00:00:14.309 --> 00:00:17.660 over which parts of your spreadsheet are displayed. 00:00:17.660 --> 00:00:19.750 It's a little bit like outlining and grouping, but 00:00:19.750 --> 00:00:22.090 it's even more powerful, and it actually makes it 00:00:22.090 --> 00:00:26.380 a little easier to narrow down your data in different ways. 00:00:26.380 --> 00:00:28.079 Now it's important that you have a header row 00:00:28.079 --> 00:00:29.259 because the filters 00:00:29.259 --> 00:00:32.169 actually get added to the cells in the header row. 00:00:32.169 --> 00:00:37.399 In this example, I have an equipment checkout log, 00:00:37.399 --> 00:00:39.399 and there are a lot of things to keep track up, 00:00:39.399 --> 00:00:42.670 so I'd like to use some filters to simplify it. 00:00:42.670 --> 00:00:50.399 First, go to the Data tab, and click the Filter command. 00:00:50.399 --> 00:00:52.230 You'll see these drop-down arrows added to your 00:00:52.230 --> 00:00:54.149 header row, 00:00:54.149 --> 00:00:57.269 and you'll use these to access all of the filtering options. 00:00:57.269 --> 00:01:04.589 Here, you'll see a list of all of the different values that appear in this column. 00:01:04.589 --> 00:01:09.979 I'd like to just view the Laptops and Projectors, so I'll leave those checked 00:01:09.979 --> 00:01:12.820 and uncheck everything else. 00:01:12.820 --> 00:01:15.870 And then click OK. 00:01:15.870 --> 00:01:19.180 Now the drop-down arrow has changed to a different icon to show that 00:01:19.180 --> 00:01:23.110 there is a filter in this column. 00:01:23.110 --> 00:01:25.040 We can narrow down this data even further by 00:01:25.040 --> 00:01:27.020 adding a filter to another column. 00:01:27.020 --> 00:01:30.900 Let's filter by the date that the items were checked out. 00:01:30.900 --> 00:01:33.950 This shows all of the months that appear in this 00:01:33.950 --> 00:01:35.100 column. 00:01:35.100 --> 00:01:38.930 So I'll uncheck the months that I don't want. 00:01:38.930 --> 00:01:41.300 You can also click the plus sign next to the month 00:01:41.300 --> 00:01:45.210 if you want to filter by the specific dates. 00:01:45.210 --> 00:01:46.210 Then click OK. 00:01:46.210 --> 00:01:52.030 To get rid of the filter, just click on the icon 00:01:52.030 --> 00:02:02.159 and select "Clear Filter". 00:02:02.159 --> 00:02:04.970 So that's how you do simple filtering. 00:02:04.970 --> 00:02:09.220 Now let's look at some more advanced techniques. 00:02:09.220 --> 00:02:11.290 When you click the drop-down box, you can actually 00:02:11.290 --> 00:02:13.610 search for values that appear in this column. 00:02:13.610 --> 00:02:17.040 In this example, a lot of our equipment is made by 00:02:17.040 --> 00:02:19.060 a company called "Saris". 00:02:19.060 --> 00:02:21.650 So if we type that, then the list below it will 00:02:21.650 --> 00:02:27.069 only display those items. 00:02:27.069 --> 00:02:30.840 And then click OK. 00:02:30.840 --> 00:02:33.299 Now let's say that I only want to show items where 00:02:33.299 --> 00:02:37.659 the ID number is between 3000 and 4000. 00:02:37.659 --> 00:02:39.829 I can click on the drop-down box for this column 00:02:39.829 --> 00:02:43.980 and go to Number Filters. 00:02:43.980 --> 00:02:45.620 There are a lot of different options here, and 00:02:45.620 --> 00:02:51.629 I'll click on Between. 00:02:51.629 --> 00:02:54.569 I can type in whatever values I want here. 00:02:54.569 --> 00:03:03.249 So this will show rows that are greater than or 00:03:03.249 --> 00:03:13.510 equal to 3000 and less than or equal to 4000. 00:03:13.510 --> 00:03:15.109 And now you can see that all of these values are 00:03:15.109 --> 00:03:19.389 between 3000 and 4000. 00:03:19.389 --> 00:03:23.860 I'm just going to clear these filters. 00:03:23.860 --> 00:03:31.480 The Date Filters are really cool because they can 00:03:31.480 --> 00:03:33.959 use the current date to filter data. 00:03:33.959 --> 00:03:37.269 I'd like to find out which items were checked out 00:03:37.269 --> 00:03:39.419 this week. 00:03:39.419 --> 00:03:43.430 If we go to the Date Filters, we have many different options. 00:03:43.430 --> 00:03:47.549 I'll select This Week. 00:03:47.549 --> 00:03:51.999 Finally, if you'd like to clear all of the filters 00:03:51.999 --> 00:03:54.180 and get rid of these drop-down arrows, 00:03:54.180 --> 00:03:58.409 you can just click the Filter command again, 00:03:58.409 --> 00:04:00.779 and your spreadsheet will go back to showing everything. 00:04:00.779 --> 00:04:05.689 You can see how quickly filtering can narrow things down, 00:04:05.689 --> 00:04:07.720 and it gives you so many different options, 00:04:07.720 --> 00:04:32.249 you can probably find a use for it with any spreadsheet.