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
Related courses
- Power BI: Dashboards for Beginners (2022)
- Business Analytics: Marketing Data (2022)
- CompTIA Data+ (DA0-001) Cert Prep: Domain 4.0 Visualization
- Microsoft Dynamics 365 Sales Essential Training
- Business Analytics: Sales Data (2020)
- Excel: Dashboards for Beginners
- Excel: PivotTables for Beginners
- Excel for Marketers
Related learn paths
- Prepare for the Excel Associate - Microsoft Office Specialist Exam for M365 Apps (MO-210)
- CSCMP Supply Chain Foundations: Customer Relationship Management Professional Certificate
- Technical Program Management
- Become a Data Analytics Specialist
- Explore a Career in Data Analysis
- Digital Marketing Professional Certificate by Content Marketing Institute
- Develop Your Data Analysis Skills
- Advance Your MS SQL Server Skills