From the course: Excel: Filtering Data for Beginners
Unlock this course with a free trial
Join today to access over 22,400 courses taught by industry experts.
Advanced filters - Microsoft Excel Tutorial
From the course: Excel: Filtering Data for Beginners
Advanced filters
- [Instructor] Sometimes you need more than what's available in Excel's custom filter dialogue boxes. In fact, you might be wondering if you can do more than two criteria, like the ones shown here. And indeed you can. I'm going to show you how. So I'm going to go ahead and I'm going to cancel this, and now I'm going to show you something called Advanced Filter. And it's called Advanced, but it's really not that difficult. In fact, I'm going to clear the Filter buttons from this dataset. And Advanced Filter is here. But the thing to keep in mind is, you don't click this and then enter criteria to filter by, you actually create your criteria here, in the worksheet, and then you apply the filter through this dialogue box. So let me show you what I'm talking about. I'm going to go ahead and select the first row here, and then I'm going to go to the Home tab, and then click the insert button. And I'm going to insert six rows here. And then I'm going to copy these cells here, and Ctrl + C…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.