From the course: Excel: Setting Up a Database (Microsoft 365)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use slicers to facilitate table filtering

Use slicers to facilitate table filtering

From the course: Excel: Setting Up a Database (Microsoft 365)

Start my 1-month free trial

Use slicers to facilitate table filtering

“

- In Excel 2010, a new feature is introduced but only for pivot tables, it's called a slicer. And in 2013, it was added to tables. You can only get to this feature when you have a table. And a slicer is a different way of doing filtering. It's not a tool for adding data or changing data, but it certainly lets you analyze data in a totally different way than the standard filter. And its main feature that a filter lacks is this idea that sometimes when you're looking at filter data you want to be reminded of what you are not seeing. And so in this list here called "Employee's Table", we're going to add a slicer, is by way of the Insert tab on the ribbon. Slicer. And we can do this for any number of different fields. Sometimes the problem is getting these on the screens at the same time as having your data and not having too much clutter. I'm going to insert slicers for building and department, status, job rating. Okay…

Contents