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
Related courses
- Excel Power Tools for FP&A: Power Query and PowerPivot
- Excel Formulas and Functions Quick Tips
- Excel PivotTables: Mastering PivotTables and PivotCharts
- AI-Powered Excel: Mastering Built-In Automation Features
- Practical Excel for the Intrepid Beginner
- Excel Data Visualization: Mastering 20+ Charts and Graphs
- Mastering Lookup Functions in Excel: Seven Powerful Formulas
- Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press
Related learn paths
- Prepare for the Excel Associate - Microsoft Office Specialist Exam for M365 Apps (MO-210)
- Master Microsoft Excel
- Advance Your Skills with Excel Formulas and Functions
- Become a Data Analyst
- Become a Power BI Specialist
- Develop Your Tableau Skills
- Getting Started as a Business Analyst
- Prepare for the PMI-ACP Certification