Slicers, available with tables, make it faster and easier to filter data with vivid displays. This video explains how to use slicers to filter data with appealing, easy-to-read visuals.
- 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, that's enough for now. … And I'm going to move these around and resize them. …
Share this video
Embed this video
Video: Use slicers to facilitate table filtering