PivotTables & PivotCharts

Summary

A drag-and-drop way to summarize large datasets — grouping, aggregating and cross-tabulating without writing a single formula, and the fastest way to answer 'break this down by X' questions.

• 1Build a PivotTable summarizing a sample sales dataset by region and month.
• 2Practice adding calculated fields inside a PivotTable.
• 3Turn your PivotTable into a PivotChart and note how it updates automatically.