Microsoft Excel PivotTables Explained

Learn how to master Microsoft Excel PivotTables in this comprehensive 49-minute tutorial. Explore the creation of PivotTables from scratch, understand their elements, and discover techniques for pivoting fields, adding totals, formatting numbers and errors, selecting report layouts, and applying formatting styles. Practice your new skills with included exercises and downloadable Excel files. Navigate through various topics using provided timestamps, covering everything from basic explanations to advanced features like grouping data and customizing layouts. Perfect for Excel 2021 and Excel 365 users looking to enhance their data analysis capabilities.

- Intro
- PivotTables Explained
- Creating PivotTables from Scratch
- Pivoting the PivotTable Fields
- Subtotals and Grand Totals
- Number Formatting
- Show Values As and Summarize Values By
- Grouping PivotTable Data
- Formatting Error Values and Empty Cells
- Choosing a Report Layout
- Applying PivotTable Styles
- Exercise 06