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.
In the example below, we'll filter out certain salespeople to determine how their individual sales are impacting each region.