Doing More with PivotTables

Do more with pivot tables in Excel, like manipulating data. This Excel pivot table tutorial covers slicers, filters, and pivot charts.

Slicers

Slicers make filtering data in PivotTables even easier. Slicers are basically just filters but are easier and faster to use, allowing you to instantly pivot your data. If you frequently filter your PivotTables, you may want to consider using slicers instead of filters.

To add a slicer:

  1. Select any cell in the PivotTable.
  2. From the Analyze tab, click the Insert Slicer command.
    insert slicer command
  3. A dialog box will appear. Check the box next to the desired field. In our example, we'll select Salesperson, then click OK.
    field dialog box
  4. The slicer will appear next to the PivotTable. Each selected item will be highlighted in blue. In the example below, the slicer contains all eight salespeople, but only five of them are currently selected.
    slicer and pivottable
  5. Just like filters, only selected items are used in the PivotTable. When you select or deselect an item, the PivotTable will instantly reflect the change. Try selecting different items to see how they affect the PivotTable. Press and hold the Ctrl key on your keyboard to select multiple items at once.
    adjusting the pivottable

You can also click the Filter icon in the top-right corner of the slicer to select all items at once.