From the course: Excel Essential Training (Microsoft 365)

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Using filters

Using filters

From the course: Excel Essential Training (Microsoft 365)

Start my 1-month free trial Buy for my team

Using filters

“

- [Instructor] As you work with larger lists, there certainly will be times when you're saying I don't want to see all this data. I only want to see, for example, as we look at this list here, the people who work in a certain building or the people who have a certain job rating or the people who have a certain status or in a certain department. And we can use multiple fields as we do this. And the feature's called filtering. You can get to it by way of the home tab. And if you simply click with inside the data, and as always when you work with lists in Excel, make sure your list has no empty rows or columns. And in the previous movie, you might have seen some tips on how to ensure that. And on the Home tab, Sort and Filter, we'll also see this on the Data tab, we can start filtering. All this does initially is simply put arrows at the top of each column. And most people find this amazingly easy to work with. Let's imagine…

Contents