Excel: Mastering Pivot Table Dashboards and Reports
1h 17mIntermediate2023-07-05
Authors
Jordan Goldmeier
Author, Entrepreneur, and Keynote Speaker
Course details
PivotTables are one of the most important features available in Microsoft Excel. They simplify data analysis, allowing you to create summaries and reports instantly, and they just got even better. The new Excel data model takes things a step further by letting you connect PivotTables to build out a miniature database. In this course, instructor Jordan Goldmeier shows you how to get up and running with PivotTable basics. Discover an approachable, foolproof way of thinking about PivotTables that allows you to build summaries across different column fields with ease from any dataset. Along the way, learn how to use PivotTable connections to create an interactive dashboard for replication and reuse.
Skills covered
SpreadsheetsMicrosoft ExcelData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Introduction to PivotTables
1. Working with PivotTables
- 02 - Creating your first PivotTable
- 03 - Counting with a PivotTable
- 04 - Averaging with a PivotTable
- 05 - Sum by quarter
- 06 - Running totals
- 07 - Month over month
2. PivotTable Tricks
- 08 - PivotTable tips
- 09 - Adding slicers
- 10 - Adding timelines
- 11 - PivotCharts
3. Excel Data Model
- 12 - What is a data model
- 13 - Creating a data model dashboard