Excel: Dashboards for Beginners (2022)
46mBeginner2022-03-07
Authors
Jordan Goldmeier
Author, Entrepreneur, and Keynote Speaker
Course details
Did you know that you can quickly create a dashboard in Excel even if you’re pressed for time? While many people assume that dashboards are complicated and limited to the most advanced Excel power users, it’s simply not true–all you need is a little practice. In this short course, Excel MVP Jordan Goldmeier demystifies dashboards and shows you how to create your first interactive dashboard in minutes.
Explore the basic components of a dashboard in Excel: tables, PivotTables, PivotCharts, slicers, and timelines. Learn how to plan a dashboard, create a summary table, build a time series chart, and then finalize your dashboard so it's ready to share with stakeholders. Jordan gives you quick, easy-to-use tips and techniques so you can start visualizing your data immediately.
Explore the basic components of a dashboard in Excel: tables, PivotTables, PivotCharts, slicers, and timelines. Learn how to plan a dashboard, create a summary table, build a time series chart, and then finalize your dashboard so it's ready to share with stakeholders. Jordan gives you quick, easy-to-use tips and techniques so you can start visualizing your data immediately.
Skills covered
SpreadsheetsMicrosoft ExcelData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
Introduction
- Transform the way you present data to leaders
- What is a dashboard
- What to know before starting
Excel Dashboard Components
- Store data in Excel tables
- Create PivotTables for data summaries
- Visualize data with PivotCharts
- Add interactivity with slicers and timelines
Creating Your First Dashboard
- Get familiar with the data
- Create a summary table
- Build impactful charts
- Add interactivity with slicers and timelines
- Lay it all out
Conclusion
- Continue your Excel dashboards journey