Analyze data with a PivotTable

Excel

A PivotTable is an interactive table that makes it simple to summarize and analyze large amounts of data in different ways. Watch this series of videos to learn how.

Before you begin

1. Introduction (1:13)

2. Prepare the sheet and create a PivotTable (1:09)

3. Explore the PivotTable tools (1:28)

4. Change the PivotTable summary (1:10)

5. Change the summary function and filter (1:19)

6. Format and update the PivotTable (1:22)

Analyze data with a PivotTable

Learning Objectives

Requirements

Practice file