Lesson 3.1 Understanding PivotTables
PivotTables allow users to summarize large datasets quickly and interactively.
Key Components
- Rows: Categories grouped together
- Columns: Sub-categories
- Values: Numerical summaries (SUM, COUNT, AVERAGE)
- Filters: Restrict data shown
What PivotTables Help With
- Summarizing sales by region
- Calculating average purchase value
- Identifying trends across categories
Steps to Create a PivotTable
- Select dataset
- Insert → PivotTable
- Drag fields into Rows, Columns, Values, and Filters
Customize layout and formatting