Session Five: Pivot Tables
Download sample files for the Session Five sample lessons|
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction and Objectives | [PDF] | [Video] |
 |
| Lesson 5‑1: Create a one dimensional pivot table report from a table | [PDF] | [Video] |
|
| Lesson 5‑2: Create a grouped pivot table report |
 |
||
| Lesson 5‑3: Understand pivot table rows and columns | |||
| Lesson 5‑4: Use an external data source | |||
| Lesson 5‑5: Apply a simple filter and sort to a pivot table | |||
| Lesson 5‑6: Use report filter fields | |||
| Lesson 5‑7: Use report filter fields to automatically create multiple pages | |||
| Lesson 5‑8: Format a pivot table using PivotTable styles | |||
| Lesson 5‑9: Create a custom PivotTable style | |||
| Lesson 5‑10: Understand pivot table report layouts | |||
| Lesson 5‑11: Add/remove subtotals and apply formatting to pivot table fields | |||
| Lesson 5‑12: Display multiple summations within a single pivot table | |||
| Lesson 5‑13: Add a calculated field to a pivot table | |||
| Lesson 5‑14: Add a calculated item to a pivot table | |||
| Lesson 5‑15: Group by Text | |||
| Lesson 5‑16: Group by Date | |||
| Lesson 5‑17: Group by numeric value ranges | |||
| Lesson 5‑18: Show row data by percentage of total rather than value | |||
| Lesson 5‑19: Create a pivot chart from a pivot table | |||
| Lesson 5-20: Embed multiple pivot tables onto a worksheet | |||
| Session 5: Exercise | [PDF] |
|
|
| Session 5 Exercise Answers | |||