Table of Contents
Want to understand Power BI from a High Level View?
*** Watch our video and step by step guide below ***
Mynda Treacy is an Excel MVP since 2014 who resides in sunny Queensland, Australia and is an expert in Excel Power BI and Excel Dashboards.
In 2009 she started an online training website called MyOnlineTrainingHub.com, where they provide free and paid online training tutorials and courses on Microsoft Excel, Outlook and Word.
Mynda has trained over 5,000 people from all over the world and today she focuses on Excel online courses covering Power BI, Excel Dashboards, Power Query, Power Pivot and General Excel.
You can subscribe to the show on iTunes to get automatic updates so you don’t miss out on these awesome interviews and Excel insights!
Mynda’s Free Excel Webinars
- Power BI is Microsoft’s latest business intelligence (BI) & data visualization tool enables you to quickly develop stunning interactive dashboards.
- Excel Dashboards provide insight, analysis and alerts by displaying key trends, comparisons and data in interactive reports.
Mynda’s Online Excel Courses
- Power BI is Microsoft’s latest business intelligence (BI) & data visualization tool enables you to quickly develop stunning interactive dashboards.
- Excel Dashboards provide insight, analysis and alerts by displaying key trends, comparisons and data in interactive reports.
- Power Query allows you to get data from almost any source (a database, the web, Excel, Sharepoint, Salesforce, OData etc), then clean, transform, merge and append data to your query.
- Power Pivot imports millions of rows of data, creates relationships between different data sources, and builds interactive reports.
- Excel Expert is designed to take you from zero to hero so you can confidently list ‘Advanced Excel Skills’ on your resume/CV.
- Pivot Tables allow you to quickly summarise and analyse large amounts of data – with just a few clicks of your mouse.
Mynda’s Excel Favorites
- Keyboard Shortcuts:
- Excel Tip: ALT+ENTER to add a line break in your cell or formula bar
- Function: VLOOKUP
- Excel Add-Ins: PasteBuddy
- Online Learning Resource: PeltierTech, Contextures, MyExcelOnline, ExcelGuru
- Excel Books:
- Excel Tables on Amazon
- Excel Tables on Ebook PDF
- Excel Outside The Box on Amazon
- Excel Outside The Box on Ebook PDF
- This Isn’t Excel, It’s Magic! on Amazon
- M is for Data Monkey on Amazon
- M is for Data Monkey on Ebook PDF
- Dashboards For Excel on Amazon
Interview Links
- PowerBi.com to download Power BI for Desktop for free & start using its AWESOME POWER!!!!
- UNLOCK EXCEL Conference in Australia where Mynda will present
- Tableau to analyse your data the paid way
- Qlik to analyse your data the expensive way
Connect with Mynda
Listen to the MyExcelOnline Podcast on your favorite platform!
Free Resources!
-
- Excel Tutorial Blog: Learn all the essential tips to get you up and running and using Excel to its full potential. Choose from Formulas, Pivot Tables, Charts, Analysis, Shortcuts, Macros plus more >> CLICK HERE TO VIEW
- Free Excel Webinars: Learn the power of Pivot Tables and Power Query with our free webinars. CLICK HERE TO VIEW NOW
Thanks for Listening!
Thank you for joining me this week. If you have some feedback that you’d like to share, then please leave a note in the comment section below!
If you enjoyed this episode, please share it using the social media buttons you see at the bottom of the post.
Also, please leave an honest review for The MyExcelOnline Podcast on iTunes! Ratings and reviews are extremely helpful and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.
If you have any questions you can send me an email to [email protected]
Don’t forget to subscribe to the show on iTunes to get automatic updates so you don’t miss out on these awesome interviews and Excel insights!
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.