Select a table or PivotTable
Go to the Insert tab
Click Slicer
Choose the field or fields you want to filter by
Click OK
Drag and resize the slicer as needed
Click a button in the slicer to filter the data
Hold Ctrl and click multiple buttons to select more than one item
Click the Clear Filter button in the slicer to remove filters
Use the Slicer tab or Slicer Tools tab to change slicer settings
Click Report Connections or PivotTable Connections to connect the slicer to multiple PivotTables
Use the Style options to change the slicer appearance
Delete the slicer by selecting it and pressing Delete