Follow the steps below to use Slicers for any tables or Pivot tables. After creating slicers, you can choose any of the items from the slicer to filter the table.
Use slicers in Excel to quickly and easily filter pivot tables. Connect multiple slicers to multiple pivot tables to create awesome reports.