Hi Everybody, I’m excited to share with you a Microsoft Excel MVP, Mynda Treacy’s, highly acclaimed Excel Dashboard course. More details are below.
Learn how to make interactive Excel Dashboards like the one below which is based on Olympics data spanning 1896 to 2012. Actually it’s 3 dashboards in one file with tabs (like a browser) to allow you to navigate between them!
Free Excel Dashboard Webinars
If you’re not sure what a dashboard is or how these skills might be relevant to you, then you can catch a replay of one or both of Mynda’s FREE Excel Dashboard Webinars.
Here’s what Ben said about Mynda’s webinar:
“”I consider myself quite good at Excel, but your mastery of it leaves me in the ashes.
The Dashboard presentation was dazzling.
Webinar 1 – Excel Dashboard for Excel 2007/2010/2013/2016/2019/365
The first webinar will teach you how to use Excel to build this interactive dashboard below, no additional software or add-ins are required, just plain old Excel and some data.
Webinar 2 – Excel Dashboard for Excel 2010/2013/2016/2019/365 using Power Query and Power Pivot
If you have Excel 2010, 2013, 2016, 2019 or Office 365* then this webinar will showcase how you can use Excel’s Power Query tool to get data from multiple sources, mash it up with Power Pivot, analyze it in PivotTables to create this interactive Excel Dashboard.
*Power Query is available with all versions of Excel 2010, 2013, 2016, 2019, and Office 365. Power Pivot is available with the desktop version of Excel 2010 and Excel 2013/2016 Office Professional, Office 2019, Office 365, or in the standalone versions of Excel 2013/2016. Power Query and Power Pivot are not available for Mac.
What members are saying about the course:
Mynda continues to receive amazing feedback from people who have joined the course, including these ones:
“Mynda, I love this course. I am beginning the second time through the videos. Thank you for creating an excellent dashboard course. I’ve learned so much and I’m sure that watching again will allow me to ingrain more of the techniques into my brain. I’ve posted my first dashboard to our intranet using the OneDrive method that you sent to us.
Your detailed explanation of many the formulae has really helped me. I was having difficulty grasping the concept of INDEX/MATCH until you explained it so clearly.
I’m actually looking forward to reviewing these videos many times.
And perhaps the feedback all Excel teachers want to hear:
“Recently, I have done a very simple dashboard for my commercial director about the sales in retail chains. I made some interactive controls stuff like scroll bar and option buttons in it. In reality, it`s quite impossible to impress him by something. But when he saw the dashboard he immediately started using it and became very happy.
Eventually, he even let me go from work after lunch on that day, so I was able to come to the country side and spent a great time there.
Who is the course for?
If your work requires the preparation of reports in Excel (or you’d like it to) then this course is for you.
Mynda teaches you some simple rules (that most people don’t know), which you can use in all of your Excel work that will get your job done more quickly and efficiently (like Dmitry), and of course she’ll teach you how to make killer dashboards including animated charts and other cool interactive elements.
Click here for more information and a sample video from the course (it’s worth watching just to learn this tip).
Loads of people have already enrolled in this class and are on their way to making some killer dashboards.
If you’re ready to take your Excel skills to the next level so you can impress your clients, get that promotion, or a new job, or you’d just like to get your work done more quickly so you can go home early like Dmitry :-), then click here.
Disclosure: I make a small commission for students who join Mynda’s course, but as you know I don’t just recommend anything and everything. It has to be of outstanding quality and value, and something I can genuinely recommend. After all, if doesn’t live up to what I’ve promised you’ll think poorly of me too and I don’t want that.