Slicers in Excel: Filter Tables and PivotTables With Buttons
A slicer is a panel of buttons that filters an Excel Table or PivotTable with one click, and always shows what's filtered. One slicer can also control several PivotTables at once, which makes simple dashboards easy. Excel TableTable Design → Insert Slicer PivotTablePivotTable Analyze → Insert Slicer Multi-selectCtrl + click Add a slicer to an … Read more