Excel Dashboards in an Hour

Learn how to create interactive Excel Dashboards in one hour. No special add-ins or tools required, just Excel.

4.51 (14354 reviews)
Excel Dashboards in an Hour
1 hour
Sep 2017
last update
regular price

What you will learn

Create Interactive Excel Dashboards that will wow your boss and colleagues.

Be able to build Dashboards that are quick and easy to update, in fact they can update themselves (imagine being able to confidently say that in an interview), at the click of a button if you set them up right (I show you how).

Know which chart to choose for your data.


Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. They can be created to summarize important information and are excellent for sharing a “snapshot" view among teams.

In this mini-course I’m going to teach you a handful of the most powerful techniques so you can get some fast results. I’ve taught this course in various forms and the feedback has been incredible. Here are just a few:

"10 minutes in and I feel like I can save hours" - Alex

"I consider myself quite good at Excel, but your mastery of it leaves me in the ashes. The dashboard presentation was dazzling." - Ben

"Wow! I am so excited to try this myself! Thank you so much for sharing your skills." - Lyn

Very dense information that in just one hour you represented what I have spent days reading books about this subject. - Khalid

"I've been using Excel for over 10 years and I'd like to take the time to say thank you. That was definitely one of the best courses I've ever taken.

It was incredibly informative, insightful and taught me a few tips and tricks that will surely aid me in producing automated dashboards. Thank you for sharing the course materials.

Nothing short of excellent! " - Amanta

You too can master the creation of Interactive Excel Dashboards and learn to build Dashboard Reports from the ground up.

  • Design and Display Principles
  • Interactive Controls
  • Automating your Dashboard so it updates in seconds

Impressive Content that Will Provide Insight, Analysis and Alerts Dashboards are fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

Excel Dashboard students should have access to the PC version of Excel 2010 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel. Pivot Table and Chart knowledge is helpful, but expertise is not necessary to take this course.

Contents and Overview This course includes 9 lectures and just over 1 hour of content in order to give students a working knowledge of utilizing Excel to create interactive Excel Dashboards to communicate their data.

Included are the Excel Dashboard workbook and PowerPoint presentation from the course which contain notes on where you can find more resources. You can use the workbook to practice what you learn and as a quick reference guide later on.

The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep the report informative and relevant. Analyzing and automating information for a fully functional and complete dashboard. 

Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets, among a host of other tips that can be used in day to day Excel work.


Interactive Excel Dashboards in One Hour

Dashboard Design Tips
Data Sources
Building Dashboards Part 1
Building Dashboards Part 2
Building Dashboards Part 3
Interactivity with Slicers
Dynamic Titles
Recap Design & Layout
Automatic Updates
Course Wrap & Materials


Excel Dashboards in an Hour - Screenshot_01Excel Dashboards in an Hour - Screenshot_02Excel Dashboards in an Hour - Screenshot_03Excel Dashboards in an Hour - Screenshot_04


July 20, 2023
It's helping me map out a dashboard for my weekly meeting with the Operations Department. They currently use an Excel sheet with too many colors and its very confusing.
July 8, 2023
nice details about charts , formulas inpivot tables, and charts in the cells, and formulas for charts in cells
July 7, 2023
it was good, gave me a good idea about dashboards and cleared all misconceptions i had about it. However i need to be well aware of the basic raw stuff that went into making of this interative dashboard
June 8, 2023
It´s an introductory course, but is very helpfull. The instructor is very professional and tech you step by step the procedure that it´s need to create an impressive Dashboard. After this everyone have the skill tocreate an amazing Dashboard.
May 31, 2023
My experience in learning how to create a dashboard was very pleasent .I learned why and how a dashboard in excel is created and how it looks. Thank you for creating this course to get the total overview of the same.
May 11, 2023
Beautifully explained , while viewing I created Dashboard parallelly. Thank You Instructor (Mynda Treacy)
April 29, 2023
This course was very informative. I realized that one doesn't have to have in-depth excel formulas and functions knowledge to take advantage of dashboards.
April 29, 2023
Thank you for this quick refresher! I had forgotten some of these tips and it was clearly communicated for easy retention.
April 21, 2023
This course was super helpful! I have learnt a lot and have been able to build some dashboards basis this! Thank you!
April 1, 2023
Amazing experience building an Excel dashboard. The course was really short and to the point. Exactly what we need since we're too occupied with other tasks as well. Thank You so much, Mynda.
February 15, 2023
A perfect quick guide to Excel dashboards, highly recommended to get a quick grasp of making dashboards for presentations or company performance.
February 3, 2023
It's easy to understand. I am a beginner to the dashboard, after watching your course, i can understand it. Very useful!!
December 29, 2022
I extremely loved this course, the instructor explained it really well can't wait to build more dashboards.
December 20, 2022
Thanks a lot, I got useful informative. But in some part, the explanation a little bit fast, I understand it
December 7, 2022
Very good and clear course. Very interesting the interactive dashboard and other excel courses from Mynda Treacy.



Excel Dashboards in an Hour - Price chart


Excel Dashboards in an Hour - Ratings chart

Enrollment distribution

Excel Dashboards in an Hour - Distribution chart

Related Topics

udemy ID
course created date
course indexed date
course submited by