Slicers

Apr 14 / Michelle Unger

To Filter or Slice - which should you choose?

You’ve mastered Pivot Tables and your filters are working great and you are able to see exactly the data you would like to. But could there be another, simpler way? Slicers are interactive buttons that you can place outside of your Pivot Table to make it easy to toggle through your data rather than creating and re-creating filters. 
Here’s how to create a slicer in 3 easy steps:

Step 1) Select the Pivot Chart

Step 2) Go to Pivot Chart Analyze and select Insert Slicer 

 Step 3) Because we want to see sales by location, select the Region field before clicking Ok 

All that is left is to move your slicer where it fits best, and change the color if you’d like. 

Watch the video to see the steps.
Created with