![how to use slicers in excel 2016 how to use slicers in excel 2016](https://i0.wp.com/easysimplesmart.com/wp-content/uploads/2019/09/add-a-slicer-to-a-pivot-table.png)
Finally, for example, the output should look like this after the slicing. Now, if you want to get the values for Illinois state at the Qtr-2, then click on the Illinois and Qtr- 2 buttons. Thus, you can insert a slicer into the pivot table and filter it accordingly.
#HOW TO USE SLICERS IN EXCEL 2016 HOW TO#
![how to use slicers in excel 2016 how to use slicers in excel 2016](https://i.ytimg.com/vi/03pHDwMeDdg/maxresdefault.jpg)
![how to use slicers in excel 2016 how to use slicers in excel 2016](https://i.ytimg.com/vi/zYCLAg3SFaU/maxresdefault.jpg)
A Slicer makes your job easy to filter data in a Pivot table.