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

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…

Contents