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.


As you learned in our previous lesson, Intro to PivotTables, PivotTables can be used to summarize and analyze almost any type of data. To help you manipulate your PivotTable—and gain even more insight into your data—Excel offers three additional tools: filters, slicers, and PivotCharts.

Optional: Download our practice workbook.

Watch the video below to learn more about enhancing PivotTables.


Sometimes you may want focus on a certain section of your data. Filters can be used to narrow down the data in your PivotTable, so you can view only the information you need.

To add a filter:

In the example below, we'll filter out certain salespeople to determine how their individual sales are impacting each region.

    dragging a field
    enabling select multiple items
  3. Uncheck the box next to any item you don't want to include in the PivotTable. In our example, we'll uncheck the boxes for a few salespeople, then click OK.
    unchecking/deselecting items
  4. The PivotTable will adjust to reflect the changes.
    filtered pivottable