WEBVTT Kind: captions Language: en 00:00:11.360 --> 00:00:15.000 Filtering is a great feature of Excel that gives you a lot of control over which parts 00:00:15.000 --> 00:00:17.180 of your worksheet are displayed. 00:00:17.180 --> 00:00:21.500 You can use it to show only the information you need (or find something specific), while 00:00:21.500 --> 00:00:23.830 hiding the rest of the data temporarily. 00:00:23.830 --> 00:00:28.149 Now, it's important that you have a header row because the filtering tools actually get 00:00:28.149 --> 00:00:30.180 added to the cells in the header row. 00:00:30.180 --> 00:00:34.570 In this example, I have an equipment checkout log, and there are a lot of things to keep 00:00:34.570 --> 00:00:38.610 track of, so I'd like to use some of the filters to simplify it. 00:00:38.610 --> 00:00:43.870 First, go to the Data tab… and click the Filter command. 00:00:43.870 --> 00:00:48.440 And you'll see these drop-down arrows added to your header row. 00:00:48.440 --> 00:00:53.079 These are what you'll use to access all of the filtering options. 00:00:53.079 --> 00:00:57.170 Here you'll see a list of all of the different values that appear in this column. 00:00:57.170 --> 00:01:03.210 I'd like to just view the laptops and projectors, so I'll uncheck this box to quickly deselect 00:01:03.210 --> 00:01:09.600 everything… then check Laptop… and Projector. 00:01:09.600 --> 00:01:14.760 Click OK… and now the drop-down arrow has changed to a different icon to show that there 00:01:14.760 --> 00:01:17.650 is a filter in this column. 00:01:17.650 --> 00:01:22.510 We can narrow down this data even further by adding another filter to a different column. 00:01:22.510 --> 00:01:26.610 Let's filter by the date that the items were checked out. 00:01:26.610 --> 00:01:29.610 This shows all of the months that appear in this column. 00:01:29.610 --> 00:01:37.510 So I'll uncheck the months that I don't want… then click OK. 00:01:37.510 --> 00:01:49.939 To get rid of any filter, just click the icon again… and select Clear Filter. 00:01:49.939 --> 00:01:52.400 So that's how you do simple filtering. 00:01:52.400 --> 00:01:56.220 Now let's look at some more advanced techniques. 00:01:56.220 --> 00:02:00.100 Using the same menu, you can also search for values that appear in this column. 00:02:00.100 --> 00:02:04.530 In this example, a lot of our equipment is made by a company called Saris. 00:02:04.530 --> 00:02:06.830 So if we enter that here… 00:02:06.830 --> 00:02:12.620 Excel will look for a match anywhere in these cells, and then list only those results below. 00:02:12.620 --> 00:02:14.100 To apply the filter, just click OK. 00:02:14.100 --> 00:02:20.080 For a little more control, you can use text filters instead. 00:02:20.080 --> 00:02:26.580 You can access these from the same menu… under Text Filters. 00:02:26.580 --> 00:02:30.990 Here you can filter information that fits more specific criteria; for example, cells 00:02:30.990 --> 00:02:36.709 that contain a certain number of characters, or data that doesn't contain a word that you 00:02:36.709 --> 00:02:37.709 specify. 00:02:37.709 --> 00:02:43.081 In this example, we're going to choose Does Not Contain… and then enter "laptop" to 00:02:43.081 --> 00:02:49.740 exclude anything that contains this word (including laptops and laptop travel bags). 00:02:49.740 --> 00:02:54.569 Click OK… and Excel will re-filter the data. 00:02:54.569 --> 00:03:01.819 Next, let's say that I only want to show items where the ID number is between 3000 and 6000. 00:03:01.819 --> 00:03:08.030 I can click the drop-down arrow… and go to Number Filters. 00:03:08.030 --> 00:03:13.519 There are a lot of different options here, but for what I need, I'm going to choose Between. 00:03:13.519 --> 00:03:20.050 Now I can type in whatever values I want in these two fields. 00:03:20.050 --> 00:03:24.819 So this will show rows that are greater than or equal to 3000… and less than or equal 00:03:24.819 --> 00:03:28.599 to 6000. 00:03:28.599 --> 00:03:35.980 Click OK… and now all of these values are between 3000 and 6000. 00:03:35.980 --> 00:03:39.870 Date filters are really cool because they can display data from a certain time period, 00:03:39.870 --> 00:03:44.319 such as last year, next quarter, between two dates, and more. 00:03:44.319 --> 00:03:50.260 In this example, I'd like to find out which items were checked out this week. 00:03:50.260 --> 00:03:56.019 All you have to do is go to Date Filters… and you'll find many options to choose from. 00:03:56.019 --> 00:03:57.950 I'll select This Week. 00:03:57.950 --> 00:04:03.300 At this point, we have 3 different filters applied to the worksheet. 00:04:03.300 --> 00:04:06.959 So it's filtering out most of the items and just showing the ones that meet all of the 00:04:06.959 --> 00:04:09.080 criteria. 00:04:09.080 --> 00:04:12.690 If you'd like to remove any of the filters, you can clear them one by one like I showed 00:04:12.690 --> 00:04:18.680 you before… or you can turn off filtering all together—just click the Filter command 00:04:18.680 --> 00:04:21.709 again. 00:04:21.709 --> 00:04:24.889 As you can see, filtering can narrow things down really quickly. 00:04:24.889 --> 00:04:28.409 And it gives you so many different options, you can probably find a use for it with any 00:04:28.409 --> 00:04:28.909 worksheet.