Best Online Excel & VBA Courses (2022)
Choices, Choices, & MORE Choices!
With so many educational options available on the internet these days, it can be overwhelming to try and find the perfect course that is going to take your Excel skills to the next level. A good rule of thumb that I always use with any internet purchase is: you get what you pay for!
Sure you can search through an online “course mall” like Udemy or Lynda but honestly, how much are you expecting to get out of a $10 course? I’ve found through the vast array of courses I’ve taken over the years in photography, website building, business development, and yes Excel too….that the most beneficial & high-quality courses come directly from the teachers themselves.
Why is this you might be wondering? Because the success of their students correlates directly with the success of their business. They aren’t relying on cheap marketing tactics to sell their courses to as many people as possible. They are targeting people who want to invest in themselves and at the same time are able to satisfy those students’ high expectations.
So, I’ve gone ahead and created this post to round up some of the best quality courses currently available on topics like creating dashboards, mastering Pivot Tables, and figuring out how to write custom VBA code. I know that search engines can sometimes not show quality results because companies with large budgets are able to pay Google for search rankings. My intent is to have an easy to find course directory that will serve as a good starting point for laying out a bunch of choices for the Excel course that is right for you!
Leave Your Own Review
Have you already taken one of these online courses? Let us all know what you thought of the course in the comments section at the end of this post! I will definitely admit I have not taken all of these courses (although I was granted access to view the course modules included in them so I could ensure the quality of the content). An honest review from you would be so helpful in helping others decide on the right course for them, so take a few minutes and let us know how your experience went!
DISCLAIMER: I always want to be fully transparent with you, so I’m letting you know that some of the course creators listed below are willing to pay me a small referral fee for sending you in their direction. This in no way influenced my decision to add them to the list, as I even turned down listing a few courses because I did not believe their quality of content was worth including to this list. So if you want to send a few “thank you” dollars my way to help support this website, click the links in this article instead of manually typing in their web address.
Increasing Your Overall Excel Skills
Xtreme Pivot Tables Course
This Excel course is taught by John Michaloudis of MyExcelOnline.com. I can easily say this course is the most comprehensive educational tool on Pivot Tables. If you want to know all things Pivot Tables, this would be the course you want to check out with 14-Modules of content. Learn More About This Online Excel Course…
John also hosts free online training webinars on Pivot Tables. Sign up for one here.
Cost: $100-$300
Instructor Accent: Australian
Guarantee: 30-day money back
Become An Excel Ninja
This course is taught by Rishabh Pugalia of YodaLearning.com. His course has the objective of taking you from an Excel beginner to an advanced user with 11 hours of video training. The training covers helpful shortcuts, formulas, and hidden tricks to help make you a NINJA as work. Learn More About This Online Excel Course…
Cost: $100
Instructor Accent: Indian
Guarantee: 30-day money back
Core Formulas
This Excel course is taught by Dave Bruns of ExcelJet.com. Dave worked in the online education space for quite a few years before starting his own business. His training covers everything you need to know about using Excel formulas effectively. This includes Referencing, Dynamic Named Ranges, working with text & dates, statistics, lookups, and much more! Learn More About This Online Excel Course…
Cost: $200
Instructor Accent: American
Guarantee: 30-day money back
Creating Interactive Dashboards
Excel Dashboard Course
A course taught by Excel MVP Mynda Treacy of MyOnlineTrainingHub.com. This training includes over 9 hours of video tutorials plus another 3 hours of (optional) related Excel training that will fill in any gaps in your Excel knowledge on topics like PivotTables, Lookup functions, Macros and more. Five different Excel dashboards are given to you with lots of techniques built-in that you can take with you and incorporate into your own dashboard spreadsheets. Learn More About This Online Excel Course…
Cost: $200-$400 (plus bundling options)
Instructor Accent: Australian
Guarantee: 30-day money back
Excel School & Dashboards
This online course is taught by Excel MVP Chandoo who runs one of the top Excel blogs in the world Chandoo.org. This “school” was designed to not only cover all the Excel basics that any analyst needs to become Awesome in Excel, it also has a Dashboard building component that takes your Excel skills to another level! This offering has over 24 hours of general Excel lessons covering formulas, conditional formatting, Pivot Tables, Charts, and much more. But it also has 8 hours of video dedicated solely to creating dashboards. Learn More About This Online Excel Course…
Cost: $100-$300
Instructor Accent: Indian
Guarantee: 30-day money back
Learning Automation With VBA Macro Coding
VBA Pro Course
This is a course taught by Excel MVP Jon Acampora of ExcelCampus.com. Jon has put together a 10-Module course covering all aspects of learning how to write VBA code to automate your Excel work. Some module topics include Coding 101, Looping, Error Handling, & even creating your own custom add-ins.
This course is not currently accepting students, but you can join the waiting list and enjoy a few free lessons while you wait for the course to open. I try to let my email subscribers know when I hear Jon is enrolling new students. Learn More About This Online Excel Course…
Cost: $300-$400
Instructor Accent: American
Guarantee: 30-day money back
Excel Macros for Beginners Course
This is a course taught by Allen Wyatt who has operated an Excel tips newsletter for over 18 years at ExcelRibbon.Tips.Net. This 15-Module course covers absolutely everything about VBA including topics that cover understanding VBA functions, searching and replacing, debugging your macros, and much more. Learn More About This Online Excel Course…
Cost: $250-$450
Instructor Accent: American
Guarantee: 30-day money back
Power Query/Power Pivot
Power Pivot Course
A course taught by Excel MVP Mynda Treacy of MyOnlineTrainingHub.com. This training includes over 5 hours of video training covering how you can use Power Pivot to manage enormous amounts of data right inside of Excel. You will learn how to:
- Import millions of rows of data from virtually any source
- Create relationships
- Build Interactive Reports
- Write in this DAX (Data Analysis Expressions) formula language
Learn More About This Online Excel Course…
Cost: $150-$400 (plus bundling options)
Instructor Accent: Australian
Guarantee: 30-day money back
Power Query & Data Cleansing Course
This course is taught by Excel MVP Oz du Soleil and John Michaloudis of MyExcelOnline.com. These two combine their Excel expertise to show you how to clean ugly raw data and use Excel’s Power Query tool to automate the cleansing so you can repeat your clean-ups with a click of a button. Learn More About This Online Excel Course…
John & Oz also host free online training webinars on Data Cleansing. Sign up for one here.
Cost: $100-$300 (plus bundling options)
Instructor Accent: American/Australian
Guarantee: 30-day money back
Excel Power Query Course
A course taught by Excel MVP Mynda Treacy of MyOnlineTrainingHub.com. This training includes over 4 hours of video training covering how you can use Power Query to pull in your data, clean your data, and report out your data through an automated system within Excel. The best part is there is no VBA coding required to automate these tasks! Learn More About This Online Excel Course…
Cost: $100-$300 (plus bundling options)
Instructor Accent: Australian
Guarantee: 30-day money back
Did I Miss Any Great Online Excel-based Courses?
If you have taken an amazing Excel course recently that didn’t make it on this list, please let us all know where you took it and what you liked about it. I would like to keep course recommendations to actual students and not course creators, so if I see any signs of self-promotion in the comments section I will block you 🙂
Hopefully, this information was helpful and will guide you to the course that fits your needs! Until next time!
Learn my best Excel chart design hacks. These will turn your ugly charts into professionally crafted graphics, leaving your boss speechless!!!
Keep Learning
Chris Newman
Chris is a finance professional and Excel MVP recognized by Microsoft since 2016. With his expertise, he founded TheSpreadsheetGuru blog to help fellow Excel users, where he shares his vast creative solutions & expertise. In addition, he has developed over 7 widely-used Excel Add-ins that have been embraced by individuals and companies worldwide.