How to Use Slicers for Pivot Tables in Excel 2016
Don't forget to check out our main channel / howtech for more free how-to videos!
Join us on Facebook
/ howtechtv
Our App
http://bit.ly/how-tech
In this tutorial, we’re going to show you how to use slicers for pivot tables in Excel 2016.
First, we’ll need a pivot table. If you haven’t already, go under the Insert tab and click Pivot Table with your data selected or at least one cell of it selected.
After setting up the pivot table (we have specific tutorials on how to create a pivot table), go under the Analyze tab and click Insert Slicer.
Choose which piece of data to filter using the Slicer and click OK.
The Slicer is a visual filter, you can use it simply and stylishly to filter data.
This is a HowTech tutorial, visit our website and watch our videos for more.
Watch video How to Use Slicers for Pivot Tables in Excel 2016 online without registration, duration hours minute second in high quality. This video was added by user Excel, Word and PowerPoint Tutorials from Howtech 02 February 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,549 once and liked it 18 people.