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.

Types of filters

Types of filters

- [Instructor] What kinds of data can you filter? Well, there are a few filter types and they all really depend on the kind of data you have in your columns. You can filter dates, which this column A has. You can filter text, which these three columns have. And you can filter numbers which the sales amount column has. We're going to walk you through the details of each of these filters. First of all, I want to filter these dates. So I'm going to go ahead and go to the data tab and click filter. And then click the filter button. Down here you've got some check boxes. Of course, we don't want to select all. We only want a subset of these rows. And we could choose 2018, to just show 2018 sales, click okay. And you see that subset of just the 2018 rows coming back. You could also, of course, dig deeper and you could click the plus sign under 2018. And uncheck the 2018 box. And maybe just select these January and February items here. Click okay, and now we only have January and February of…

Contents