This is a review of Mynda Treacy's online Excel Dashboard course, which she opens 3-4 times each year, on her website -- My Online Training Hub.
NOTE: There is only a 2 week registration period for each session, and then registration closes for a few months. If you want to register, don't delay!
You can also attend Mynda's free live webinar on Creating Excel Dashboards, which is also available 3-4 times each year.
Here are the top reasons that I recommend Mynda Treacy's Excel Dashboard Course
If that's the kind of dashboard training that you want, sign up now.
This course is not for Excel beginners, because the fast pace could be overwhelming. Lots of material is covered, very quickly.
It's designed for Excel users who are beyond the basics, and who enjoy learning by seeing a demo, then practising the new skills.
I've been through the entire Excel Dashboard Course, and the content is excellent. Here are the key techniques that you'll learn:
The Excel Dashboard Course moves at a brisk pace, and you will get the most value from it, if you have basic skills in the following areas. You can click the links in the list below, to see a tutorial on my site. Mynda also has optional tutorials for general Excel skills, so you can follow those, after you enroll in the course.
You can see the course details and a sample video here: Excel Dashboard Course Registration is only open for two weeks, and if you sign up in the first week, you can get a 20% discount.
To get an overview of dashboards, and to see Mynda's engaging teaching style, enroll in the free one-hour webinar (click the image below).
There's a 30 day money back guarantee, so you can try the Excel Dashboard Course risk free.
Before deciding whether to recommend the course to you, I went through all the dashboard videos and Excel sample files, and you can read about my experience, below.
Note: The course might change over time, so please check the current outline for the latest content. -- Excel Dashboard Course
Session 2: Getting Your Data Ready
Session 5: Interactive Controls
Session 7: Automating Your Dashboard
Session 8: Putting It All Together
Session 9: Distributing your Dashboard
Session 10: Bonus: Tour de France Dashboard
The registration email gave me the link to the login screen, along with my username and password. The website opened to the Excel Dashboard course welcome page.
The page showed the course syllabus, with details on each session, and the time for each topic in the sessions. In addition to the Dashboard content, you can go to Excel training material too, if you need more details on some of the topics.
I like the clean layout of the Syllabus page -- it's very easy to see what lies ahead, and where to get started.
Most of the videos are quite short, so you can do a bit of the course, and come back later to do more, without having to restart a long video. However, I noticed that the Tutorial links didn't change colour after I used them. That would make it easier to remember which lessons you've completed -- a minor change they could make to improve this course.
I clicked the Introduction link, which took me to the Session 1 page. Again, the layout was clean and easy to follow.
Below the navigation buttons, there are links for the session downloads, and a space where you can ask questions or leave comments. So, if you're stuck on something, you can ask a question right away. Mynda will monitor the comments for 6 weeks, while the course is live. After that, you can still post comments, and discuss the course with other students.
For the Introduction, there is a PowerPoint download, with the session notes. You can keep this for review later, and add your own notes, or print out the slides. This is a nice feature , so you don't have to log in later, and watch the video again. You can just check your notes for a quick memory jog.
When I clicked the link for the Introduction video, it opened a new window in Firefox. There were a few seconds of music, and then Mynda introduced herself. Her voice is clear, and easy to understand. You won't need your volume set very high to hear the lesson. If you're doing the course at the office, set the volume quite low before you start the video, and adjust it higher, if necessary. You don't want to startle your co-worker in the next cubicle!
There are play, pause and rewind buttons in the video viewer, so you can stop or go back to review something that you missed. You could have both the video and the PowerPoint file open, side by side, and jot down notes and questions as you watch the video.
As promised in the syllabus, Mynda explains how the course will run, and shows us a typical Excel dashboard. She tells us that the course will have a fast pace, and she assumes that you have the Excel skills.
You'll watch the videos to get an overview of the material, then work with the sample files to practise your new skills. If you need a refresher on specific Excel topics, you can review those topics in the Excel videos, then come back to the Dashboard videos.
The key part of this session is the list of questions to ask, before you start working on a dashboard. You'll save time, and reduce frustration, by following this advice. The answers to those questions will help you with the next step, which is sourcing the data for the dashboard.
That video was 8:47 in length, but the time passed very quickly.
After watching the Introduction, I clicked the Go To the Next Session button, to go to Session 2. Impatient, I almost clicked it again, because it didn't seem to work. However, the Session 2 page has a Go To the Next Session button in the same place! So, be sure to read the page heading, before you click that button again. Don't be an impatient button clicker, like me!
There is a PowerPoint presentation to download for this session, and no Excel file.
In this session Mynda shares her tips on good and bad design, and where to find more resources. There is a PowerPoint presentation to download for this session, and no Excel file.
Good design is key to getting your dashboard's message across. She shows us a heat map that shows where the most important information should go in the layout, and where the less important data should go.
She shows examples of bad charts, and talks about ways to improve them. Mynda also shows better charts, and gives tips for improving those too. Colour is important, and she shows examples of using it for effect.
She summarizes the design principles, then add a few more tips on design, and adds a link to a website for more examples.
The first three sessions were short and sweet. Now we're into the meat of the course, and session 4 has 22 dashboard videos, 16 related Excel videos. There is an Excel workbook to download, in either Excel 2007 or Excel 2010 format. I'll use the Excel 2010 workbook. There's no PowerPoint presentation this time, so I guess we can make our notes in the Excel file.
When I opened the file in Excel 2010, I got a Protected View warning, because the file was downloaded from the Internet. If you get that, just click the Enable Editing button, and the file will work correctly.
The file is well organized, with a menu sheet that takes you to each part of the lesson. You can also check the boxes when you have watched the video for that lesson. At the right side of the menu, there is a place for notes.
On the lesson sheets, you'll find all the charts and data from the videos, plus notes to remind you of the tips and tricks. When you finish a lesson, click one of the Back to Menu buttons, to find the next lesson.
This video is longer than most of the others, at just over 13 minutes. It covers display principles, such as which chart types work best for different data types.
We see an example of when to use a secondary axis, and a couple of ways to set them up.
Mynda shows simple ways of smoothing data in charts, with easy to apply techniques. There were a couple of steps that I didn't follow completely, so this will be something to explore in the sample file later. When the course is underway, remember that you can ask questions in any lesson, if you're confused.
Sparklines are new feature in Excel 2010, and there's lots to say about them -- this video is one of the longer ones, at 15:34.
We see a couple of simple formatting tricks for highlighting and annotating specific data in a chart. This is helpful for a static chart, but won't be useful in an interactive chart where the values might change frequently.
Mynda shows formulas and conditional formatting that indicate changes in data.
Useful formulas and tips for highlighting top values in a chart.
We see the steps for setting up the chart, and formatting the series and labels.
NOTE: In a later video, Mynda shows a more efficient way to select the data for this chart.
Mynda shows a histogram and explains how to set one up, using formulas to analyze the data.
We see several examples of charts that show variance in a chart, and learn which scenarios are best shown in the different chart types.
Mynda shows how to set up our data to show a target range and the actual results, for comparison.
This is another long video at 12:47 in length. Mynda explains how to create vertical and horizontal bullet graphs which were invented by Stephen Few.
Written instructions for creating bullet graphs can be daunting, with a long list of detailed steps. It was helpful to see the chart built in just a few seconds, and then you can follow the step-by-step instructions in the Excel file, for practice. And it was nice to see Mynda give credit to Jon Peltier for his instructions on building a horizontal bullet graph.
The Sparkline feature in Excel 2010 can show win/loss data, but doesn't handle draws. Mynda shows a workaround for this, using conditional formatting.
This video starts with a Sparkline example, but Mynda assures us that other versions can use the dynamic range tips too.
Even if you're not using sparklines, this is a very powerful technique.
This short video shows how to create text on a chart that will automatically update if the data changes. I use this tip in many of my charts, and it's a good reminder to use this technique.
Building on the previous tip, this video shows how to create more complex text labels on a chart. This is another good tip, and vital for charts in an interactive dashboard. The tip should include an option for zero values though. It might be a rare occurrence, but should be handled. Also, if only the first part of the text is variable, the remaining text could just be tacked on as a standard setting.
This is a nice trick for including symbols in chart labels, and one that I haven't used before. Again though, it should also handle zero values, and that would only need a minor tweak to the technique. The warning at the end of the video was interesting, and of course I tried to find a workaround. I was partially successful, but the results weren't as nice as in the sample file.
When I tried to insert the symbols, I couldn't see a subset option, so that part was confusing. I finally figured out that I had to select Unicode in the drop down list at the bottom right, and then everything worked as promised. But in Excel, never say never! ;-)
This quick video shows a more efficient way to select the data for the example shown in Video 7
Since I first went through the course, Mynda has added 5 new videos in this section:
I watched a couple of the optional Excel videos, and they covered basic information for features that were used in the Dashboard videos. You might not need to watch any of these, but check the titles and take a peek at anything that doesn't sound familiar. You might learn a few new tricks!
There are 16 videos in this session, and a sample Excel file in either Excel 2007 or Excel 2010 format. The workbook has macros, so enable them if you want to test the macros.
Remember, there is a spot for comments, below the download links. It's interesting to read the questions and answers, and you can add any comments of your own.
Some of the videos show techniques that don't use programming, so these are perfect if you're working in an environment where macros are a problem.
We see how to set up our Ribbon, so we're ready to start using Forms Controls. Mynda shows the steps in both Excel 2007 and 2010.
This video demonstrates a clever use of a check box, so users can quickly modify a dashboard chart. Mynda shows how to set it up, explains how it works, and suggests other uses.
We see how to use a List Box to select an item to see in an interactive chart. This builds on the technique that we learned in the previous video, and takes us beyond the Yes/No option that a check box provides.
The video shows us how to add option buttons, and set them up to control the chart display. This technique is better for a short list of items, and use List Boxes for more than a few items.
I was confused by the grouping that Mynda showed, which she mentioned was only available in Excel 2007. Then, as she explained the grouping, I saw that it was something different than Group Boxes, which are covered in the next video.
However, with all the fiddling it takes to set these up, I'll stick with List Boxes.
This is the next step in working with Option Buttons, if you need to control different sets of data.
In this video we see a simple but effective example of using a scroll bar to control the chart display in a dashboard. I hadn't thought about this use before, and it makes good sense. In some workbooks I'd use a different function, but this function works well in this small example.
We see how to add a button to the worksheet, and make it run a macro. One quibble is that typing something on the button doesn't change its name, it changes its caption. Mynda mentions referring to the Excel videos for more information, but I don't see any listed on the Session page. Checking back on the main menu, I can see that the Excel macro training has links in Session 7.: Automating your Dashboard.
In this video we see how to add a combo box, so users can select items from a drop down list. This adds a very small control to the dashboard, which can affect the display in multiple charts. We learn how to use one of Excel's most powerful functions, to work with the combo box results.
Then we see how to record and revise a macro, and set the combo box to run the revised macro.
We'll look at Slicers for Excel 2010, in a later video, but this technique save dashboard real estate, and can be used in older versions too.
Since I first went through the Dashboard course, Mynda has added 8 new videos to this section.
This session covers my favourite Excel topic -- Pivot Tables. There are 5 videos, two Excel files to download, and a long list of Excel tutorials on related topics. The Slicers video and workbook are only applicable if you're using Excel 2010, and some of the pivot chart features are different in earlier versions.
I did not do any of the optional Excel lessons for this session, but there is a great list of topics, related to analysing the data.
We see how to create a pivot chart, and filter to show different data. If you're using Excel 2007, use the filters on the PivotChart Filter Pane. We see how to move the chart, and a quicker way would be to right-click on the chart, and click the Move command.
The Slicers feature is only available in Excel 2010, so you can skip this video if you're using Excel 2010. Download the workbook though, so you'll have it as a reference when you upgrade to a newer version.
I'm very familiar with the GETPIVOTDATA function, but watched this video anyway. It's interesting to see how someone else uses Excel's features and functions, and I might learn some new tricks.
Mynda gives a good explanation of how the function works, and shows how to modify it, to be flexible. To demonstrate the flexibility, Mynda selects values from a drop down list on the worksheet. She doesn't mention that those lists were created with data validation, but you can see the example in the workbook.
Data validation isn't one of the topics in the optional Excel videos for this session, but you're probably familiar with that technique anyway.
Since I first went through the Dashboard course, Mynda has added 2 new videos to this section
There are 3 videos in this session, and five related Excel videos on working with macros. There is no sample file for the dashboard video.
Mynda goes through the steps of connecting to an Access database, and displaying the data in Excel.
Since I first went through the Dashboard course, Mynda has added 2 new videos to this section
This session looks exciting -- we're finally putting all the pieces together, to create a dashboard. There are 9 dashboard videos, and a sample Excel file to download.
This video is a short review of the design principles that we learned at the start of the course.
Mynda shows the dashboard that we're going to build, and points out the new types of charts that we'll be including. We get a tour of the sample workbook, which is nicely laid out, and a good model to follow.
She calls one chart a waterfall chart, but refers to it as a pyramid chart in the next video. So, just ignore that minor slipup -- they don't have a different kind of waterfall chart in Australia.
This video shows us how to build a pyramid chart, starting with the data layout, and detailing the formatting steps.
Mynda uses an array formula to summarize the data for one of the dashboard charts, and explains how the formula works. She then creates the chart, and formats it, reminding us of the dashboard design principles.
We see how to create a worksheet data table, using array formulas and database formulas. It's not mentioned in the video, but for any of the database functions, the criteria range needs a heading in its heading row that exactly matches one of the data table headings.
This is a good example of using a database function, and it's important to understand how to set up the criteria range.
We see how to create a pivot table, and use the Rank feature to show a country's rank on the dashboard. The Rank function is only available in Excel 2010 pivot tables, not in earlier versions.
This video shows how to create a scatter chart from the data, and highlight the data point for the selected country. Mynda gives tips on formatting the chart, to make it easier to read, and prevent distorting the data.
We learn how to create another worksheet table that uses database functions to summarize the data. This time the database column headings are pointed out in the criteria heading row. We also use SUMIFS to summarize data, and created a column chart.
There were a couple of fumbles while creating the column chart, but that might help you avoid those problems in your own charts. Some of the charts could be created more easily if the top left heading cell were left blank.
This video shows the final steps in formatting the dashboard. Mynda gives tips and shortcuts for putting all the pieces together.
Note: When you align the charts, they line up with the one that's furthest to the left -- it doesn't matter in which order the charts are selected.
The video is title "Formatting Quickly", but you can see that you'll still have to do some tweaking to get the layout exactly the way you want it.
When I went through the course, this section had one video tutorial, that covered publishing tips. Now this section contains 5 videos.
This section has been added since I went through the course, and it contains 5 videos:
The final challenge is to download a workbook with sample data, and a set of instructions. This assignment is optional, but you should take advantage of it. Create a dashboard, then send it to Mynda for her review and feedback.
Since I went through the course, Mynda has added 2 videos to this section:
At the bottom of the Syllabus page there are links to download more files.
You can see the course details and a sample video here: Excel Dashboard Course Registration is only open for two weeks, and if you sign up in the first week, you can get a 20% discount.
To get an overview of dashboards, and to see Mynda's engaging teaching style, enroll in the free one-hour webinar (click the image below).
There's a 30 day money back guarantee, so you can try the Excel Dashboard Course risk free.
Last updated: August 14, 2022 8:36 PM