We don’t know what we don’t know. The best way is to learn something new is to explore the web (or world), and/or learn from experts.
Sometimes we just don’t know, or even don’t expect what Excel could do for us.
If you’ve ever felt like:
“My Excel reports take way too long to update each month/week”
“I spend hours collating and cleaning data, updating formulas and charts and then no one reads my reports anyway, what’s the point?”
“If I could just impress the boss I’d get that pay rise/promotion I deserve”
“I need to get my Excel skills up to date so I can stand out from the crowd of other job applicants”
“I’m not sure how to approach setting up my Excel workbook the right way, so it’s easy to build and maintain”
Then you should spend a few hours in the coming days to watch the three webinars (Yes, I recommend you to watch all three webinars) by Mynda. You will find the time worthy spent as you will learn many time-saver techniques in using Excel; and learn something about Power BI.
Free Excel Dashboard Webinars
If you’re not sure what a dashboard is, or how these skills might be relevant to you, and help you overcome the challenges above, then you can attend one or both of Mynda’s FREE Excel Dashboard Webinars.
Webinar 1 – Excel Dashboard for Excel 2010/2013/2016
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 using Power Query and Power Pivot
Excel is evolving; in the last couple of years Microsoft have added new tools like Power Query and Power Pivot, to name a couple.
Embracing these new tools will not only enable you to get your work done more quickly, but also since less than 1% of Excel users know these tools you’re going to have a huge competitive edge in the workplace.
It’s easy to ignore these developments and continue doing things the way you always have, but that won’t get you ahead in your career, but you know that right?
If you have Excel 2010, 2013 or 2016* 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 ProPlus, or in the standalone versions of Excel 2013/2016. Power Query and Power Pivot are not available for Mac.
What people are saying about the webinars
Over 30,000 people have attended Mynda’s Excel Dashboard webinars and this is what some of them had to say:
“Thank you! This webinar has already saved tremendous time and effort. I tried some of the techniques you illustrated for a cumbersome report update that I can see will cut our preparation time by 2/3’s or more. ….awesome! Many thanks!!!!”
“WOW, just WOW
Can’t type more now – am trying to create a dashboard. Thank you Mynda!”
“The webinar was fantastic! I really enjoyed every moment. As you said, it was fast paced, but I am so excited to go back and review the presentation. We have been trying to get a dashboard started for my department and this really motivated me to take the lead. Thank you so much!”
“Oh. My. God. I know nothing! My jaw dropped a couple of times as you casually mentioned a way to manipulate PivotTable data. That’s the problem with being largely self-taught – there are huge gaps in my knowledge.”
If you’ve seen Mynda’s free Dashboard Webinars and you’re ready to take your dashboard skills to the next level then check out Mynda’s Online Excel Dashboard course.
Bonus 20% Off
If you register by Thursday, May 10 it’s 20% off.
Disclosure: I make a small commission for students who join Mynda’s course via my site (at no additional cost to you), 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. Oh, and just watching the course videos won’t transform your career, as if you won’t become a Master Chef by just reading cookbooks. You have to actually put it into practice, but then you know that.