Discover an approachable, foolproof way of thinking about and using PivotTables in Microsoft Excel.
Overview
Syllabus
Introduction
- Introduction to PivotTables
- Creating your first PivotTable
- Counting with a PivotTable
- Averaging with a PivotTable
- Sum by quarter
- Running totals
- Month over month
- PivotTable tips
- Adding slicers
- Adding timelines
- PivotCharts
- What is a data model?
- Creating a data model dashboard
Taught by
Jordan Goldmeier