Excel: Mastering Pivot Table Dashboards and Reports

Excel: Mastering Pivot Table Dashboards and Reports

1h 17mIntermediate2023-07-05

Authors

Jordan Goldmeier

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

Introduction

  • Introduction to PivotTables

Working with PivotTables

  • Creating your first PivotTable
  • Counting with a PivotTable
  • Averaging with a PivotTable
  • Sum by quarter
  • Running totals
  • Month over month

PivotTable Tricks

  • PivotTable tips
  • Adding slicers
  • Adding timelines
  • PivotCharts

Excel Data Model

  • What is a data model
  • Creating a data model dashboard
40,000 Toman