From the course: Excel: Managing and Analyzing Data

Unlock the full course today

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

Filter table data interactively with slicers

Filter table data interactively with slicers - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Filter table data interactively with slicers

“

- Let's look at slicers. They are a valuable way of filtering your data. They make filtering easy. You don't have to deal with those drop down arrows and click boxes and whatnot like you do in the auto filter. So, let's get into it. My cursor is in the data set and in order to use slicers the data does have to be in a table. All right, format as table, let's grab that style. The table does have hitters and let's scroll down and make sure that we have all of our data here. Yes, we do. And click okay. And then get rid of the filter buttons. Now with the cursor in the data set, I'm going to go to insert slicer. Now we have to pick which column we want to have a slicer for. If we pick the first or last name there's going to be too many in the slicer. So, you got to be strategic about how you pick what you want a slicer for. We want one for state. We want one for method of payment and tax receipt sent. Okay.…

Contents