A slicer is a control that lets a user filter aPivot Tableor anExcel Tableusing buttons.
A slicer provides the same function as using filter controls to filter a list.
However, instead of drop-down menus, slicers provide large, friendly buttons that are always visible.
The buttons are created automatically based on values in the data.
In the example shown, the slicer is set up to filter on the Department field in the data.
