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.
Subscribe to our newsletter
Thank you! Watch your inbox for some great things from us!