Overview
Learn how to create and manipulate PivotTables in Microsoft Excel 2021/Excel 365. The course covers creating PivotTables from scratch, pivoting fields, adding totals, formatting numbers, choosing report layouts, applying styles, and more. The teaching method includes step-by-step tutorials and exercises to practice the learned skills. This course is intended for individuals looking to enhance their data analysis and reporting skills using Excel PivotTables.
Syllabus
- 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
Taught by
Simon Sez IT