Excel Dashboard Training: 7 Places to Learn About Dashboards

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

Dashboards help you become more productive as they give you a quick view of the key performance indicators in one place.

This saves time since you can immediately access and see the information in one place.

That’s why if you want to learn about dashboards, there are plenty of places for you to start.

In this article, you’ll find seven places, both free and paid, to learn about Excel dashboards.

Kasper Langmann, Co-founder of Spreadsheeto

Let’s start!

*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.

My Online Training Hub Free Webinar

Starting with the best free resource you can possibly find, this free webinar series by My Online Training Hub on how to create a dashboard will certainly fill you up with what you need.

Here, you will find three webinar videos:

  1. Creating interactive Excel dashboards
  2. Dashboards using Power Query and Power Pivot
  3. Power BI dashboards for Excel users
Free webinar series by My Online Training Hub on how to create a dashboard

Each video is about an hour long so it would take you about three hours to watch all this content.

Kasper Langmann, Co-founder of Spreadsheeto

The third one, Power BI dashboards, is great if you’re already familiar with Power BI. Otherwise, you might want to skip that one.

Creative Venus Excel Training

Creative Venus shared an awesome Microsoft Office 365 Excel video on YouTube on how to create a dashboard.

Since it’s on YouTube, you get to watch this for free! It’s 33 minutes long with relaxing music as background.

How to create beautiful analytics dashboard in Microsoft Excel

In the video, they shared how to create a basic website performance dashboard that looks really good using Microsoft Excel.

Take note, however, that the video is a run-through on how they created one and that there’s no one talking in the background.

Kasper Langmann, Co-founder of Spreadsheeto

But there’s no need to worry since you will be able to see everything including how they formatted the elements on the dashboard.

Mellon Training – Excel Dashboards Tutorial

This is another free YouTube video by Mellon Training on how to make an Excel Dashboard. Unlike the one earlier, this has a voice-over instruction.

The instructions here are a bit advanced since the trainer used Pivot Charts and Pivot Tables to make the dashboard more functional.

Step by step instructions to make an Excel Dashboard

This video is also a bit shorter with an almost 12-minute runtime. But this is definitely packed with step-by-step instructions on how to make an Excel dashboard.

Kasper Langmann, Co-founder of Spreadsheeto

Tutorialspoint: Learn Excel Dashboard

If you prefer a text-based approach, this Excel dashboard tutorial by Tutorialspoint will blow your mind.

What they have is a comprehensive guide divided into more than 10 sections to help you create a dashboard easily. They also have a list of useful resources to aid you in your learning process.

Excel dashboard tutorial by Tutorialspoint

Depending on how fast you read and learn, this guide could take you from 3 hours to 10 hours.

Definitely check it out if you want to learn about Excel dashboards inside out.

Kasper Langmann, Co-founder of Spreadsheeto

My Online Training Hub Excel Dashboard Course

If you want to take it up a notch and go beyond free resources, there are also awesome paid courses that teach how to create an Excel dashboard.

One of them is My Online Training Hub’s paid course on how to make amazing Excel dashboards. If you liked their free webinar series, you would definitely dig this out.

How to make amazing Excel dashboards by My Online Training Hub

As expected, this is a comprehensive course that will take you from getting your data ready into using 3D Maps and Power Maps.

Kasper Langmann, Co-founder of Spreadsheeto

This course also has optional related Excel lessons such as conditional formatting and macros.

All in all, this will take you more or less 15 hours to finish the course, which starts at $199.

The Small Man

Moving on, there’s also The Small man’s Excel Dashboard Course that costs $299.

It’s a self-paced course that enables you to build a number of Excel dashboards that will take your calculations to stunning reports.

The Small man’s Excel Dashboard Course

The course has 8 modules that cover most of the methodology and will help you create a fully functional dashboard from scratch.

Kasper Langmann, Co-founder of Spreadsheeto

Depending on your knowledge with Excel, this course will take you anywhere from 5 hours to 10 hours.

Corporate Finance Institute

Corporate Finance Institute also has a paid course called “Excel Dashboards & Data Visualization” which only costs $97.

What’s great about this course is that it will show you in-depth on how to build a custom Excel dashboard using professional data visualization techniques.

Excel Dashboards & Data Visualization course by Corporate Finance Institute

Once you complete all the video lessons, quizzes, and final assessments and reach an 80% passing grade, you will earn a certificate.

Kasper Langmann, Co-founder of Spreadsheeto

All in all, this course will approximately take you 6 hours to complete. If you’re curious, check out their free previews and see if you like how the lessons are being taught.

Wrapping things up…

Knowing how to create your own Excel dashboard will definitely help you save time and understand your data reports quicker.

Of course, you don’t have to build a dashboard from scratch. There are a lot of awesome dashboard templates online that you can download and apply.

What’s important is you know the basics of creating a dashboard so you could tweak an existing dashboard to your liking or create your own according to your own designs.

Kasper Langmann, Co-founder of Spreadsheeto