Back to Courses
Microsoft Excel Dashboards Training
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
  1. Data Analysis Fundamentals
    • Introduction to Data Science
    • Create and Modify Tables
    • Sort and Filter Data
  2. Visualizing Data with Excel
    • Visualize Data with Charts
    • Modify and Format Charts
    • Apply Best Practices in Chart Design
  3. 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
  4. Analyzing Data with PivotTables
    • Create a PivotTable
    • Analyze PivotTable Data
  5. Presenting Visual Insights with Dashboards in Excel
    • Visualize Data with PivotCharts
    • Filter Data Using Slicers and Timelines
    • Create a Dashboard in Excel
  6. 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.