Excel Tip: Use a Pivot Table Slicer if you want to filter data in a Pivot Table. You can quickly change the filter criteria by clicking on the slicer buttons, without having to open the drop-down menus or use the filter dialog box. An example of a slicer is shown below where I am filtering on Sales Rep. On the left side is data for all the sales reps. On the right side I filtered data for Vicki Jones.
Contact me at firstname.lastname@example.org or 561-289-9484 for support on creating Pivot Table Slicers. Whether you need advice on cleaning up your Excel data, creating formulas or solving formula issues, count on me!