Great Canadian Training Company color logo

Microsoft Excel Dashboards
(2013, 2016, 2019, 2021, 365)

What You'll Learn in Microsoft Excel Dashboards

Course Length:

6 hours (1 day)

Learning Objectives

Upon successful completion of this course, you will be able to create dashboards in Microsoft Excel. You will:


  • Create range names and advanced formulas
  • Automate workbook functionality
  • Apply conditional logic
  • Visualize data by using basic charts
  • Create trendline and sparkline charts
  • Use Pivot Tables, Pivot Charts, and slicers to create a dashboard

Target Student

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to summarize table data by using functions, charts, and Pivot Tables and display those elements in a dashboard format.

Course Outline

Section 1: Using Names in Formulas and Functions

Examine Dashboards

Use Range Names in Formulas

Use Specialized Functions

Section 2: Automating Workbook Functionality

Apply Data Validation

Work with Forms and Controls

Section 3: Applying Conditional Logic

Use Lookup Functions

Combine Functions

Section 4: Visualizing Data with Basic Charts

Create Charts

Modify and Format Charts

Section 5: Using Advanced Charting Techniques

Create Dual-Axis Charts and Trendlines

Create Sparklines

Section 6: Analyzing Data with Pivot Tables, Pivot Charts, and Slicers

Create a Pivot Table

Analyze Pivot Table Data

Present Data with Pivot Charts

Filter Data by Using Slicers

A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Microsoft Excel Dashboards

Upcoming Classes

All Public classes are held online
with a live instructor

No dates have been scheduled for this class. Please contact us for more information or request a private class.

I want to talk to someone about private or customized training

Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference