Back to Courses
Excel
EXC1607
Microsoft Excel Dashboards Training
In this one-day Microsoft Excel Dashboards training class, students will learn how to create dashboards in Microsoft Excel to enable actionable insights from data. Students will see how to use tables with sorting and filtering to select data, how to create charts and implement best practices for chart design in Excel, how to use formulas, functions and perform data validation on their data and use PivotTables and PivotCharts in Excel to visually display data trends. The course wraps up by showing students how to pull all of these components together in a dashboard that can help support quick, timely business decisions based on data.
Duration
1 Day
Versions
Excel 2019, 2021 and 365
$295.00
Live, Instructor-Led Training
Up to One Year Access to Recorded Course
Hands-On Exercises
Certificate of Completion
Six Months of Post-Class Instructor Support
Course Audience
This course is for any student who wants to learn more about creating dashboards using Microsoft Excel.
Learning Objectives
Upon successful completion of this class, students will be able to:
- Perform data analysis fundamentals
- Visualize data with Excel
- Analyze data with formulas and functions
- Analyze data with PivotTables
- Present visual insights with dashboards in Excel
Course Syllabus
- Data Analysis Fundamentals
- Introduction to Data Science
- Create and Modify Tables
- Sort and Filter Data
- Visualizing Data with Excel
- Visualize Data with Charts
- Modify and Format Charts
- Apply Best Practices in Chart Design
- Analyzing Data with Formulas and Functions
- Analyze Data with Formulas and Named Ranges
- Analyze Data with Functions
- Implement Data Validation, Forms, and Controls
- Create Conditional Visualizations with Lookup Functions
- Analyzing Data with PivotTables
- Create a PivotTable
- Analyze PivotTable Data
- Presenting Visual Insights with Dashboards in Excel
- Visualize Data with PivotCharts
- Filter Data Using Slicers and Timelines
- Create a Dashboard in Excel
- Appendix A: Using Lookup Functions
Prerequisites
Some previous experience using Excel to create worksheets is helpful in this class.
Certification
This course does not align to a specific exam or certification.
Frequently Asked Questions
Available Sessions
Select a session to enroll
Mon, Jun 29, 2026
Live Online
10:00 AM - 5:00 PM ET
Mon, Jul 27, 2026
Live Online
10:00 AM - 5:00 PM ET
Mon, Aug 24, 2026
Live Online
10:00 AM - 5:00 PM ET
Mon, Sep 21, 2026
Live Online
10:00 AM - 5:00 PM ET
Training a team?
Get custom pricing for groups of 5 or more.