Just a quick reminder that the awesome Excel Dashboard Course, by Microsoft Excel MVP, Mynda Treacy, will be closing on Thursday, Aug 23, 8pm in Los Angeles, to be exact.
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/365
The first webinar will teach you how to use Excel to build this interactive dashboard below, no additional software or add-ins required, just plain old Excel and some data.
Webinar 2 – Excel Dashboard for Excel 2010/2013/2016/365 using Power Query and Power Pivot
If you have Excel 2010, 2013, 2016 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, analyse it in PivotTables to create this interactive Excel Dashboard.
*Power Query is available with all versions of Excel 2010, 2013 and 2016. Power Pivot is available with the desktop version of Excel 2010 and Excel 2013/2016 Office Professional, 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 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 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.