Free Online Excel Tutorials from ExcelIsFun:
The ExcelIsFun YouTube channel contains hundreds of free Excel video tutorials that cover a wide range of advanced topics. The videos are clear, well-explained, and help you learn by actually working through examples. Some advanced topics covered include VBA, PivotTables, Power Query, Dashboarding, financial modeling techniques and more. Having both a video and written component help reinforce the lessons. The channel has been teaching Excel skills to hundreds of thousands of users for over a decade so it’s a very reliable resource.
In addition to the videos, the ExcelIsFun website at excelisfun.com contains free written tutorials and downloadable Excel workbooks for many of the topics covered in the videos. Being able to read explanations and follow along in your own workbook is extremely valuable for learning complex functions and techniques.
LinkedIn Learning Excel Courses:
Previously known as Lynda.com, LinkedIn Learning offers thousands of video tutorials taught by industry experts on a wide variety of software and business topics. They have several in-depth courses focused exclusively on Excel that are well worth the reasonable subscription cost. Courses like “Excel Skills for Business” and “Excel Data Analysis” delve into advanced functions, formulas, charts, automation through VBA and data modeling techniques.
Since the platform is focused on professional and career development, the courses teach practical skills that you can directly apply on the job. Unlike many free resources, there is no filler – every lesson is focused on helping you master valuable Excel topics. The videos can also be sped up to 1.5x or 2x speeds to efficiently learn complex skills.
Udemy Excel Courses:
Udemy has hundreds of Excel courses available on every topic imaginable. While many are quite basic, they do offer some in-depth courses taught by experts that focus exclusively on advanced features. Courses like “Advanced Excel” by Justin Bishop and “Financial Modeling in Excel” by Wall Street Prep both run 10+ hours and teach Skills like Power Pivot, Power Query, macros, financial functions and more in great detail with real-world examples.
What makes Udemy courses valuable is that they are more structured learning experiences compared to random YouTube videos. Every course has hours of high-definition video lessons, downloadable course files and instructors that are available to provide assistance. While courses sometimes cost $10-200, they are often discounted to $10-20 during frequent sales, providing excellent value for the hours of learning.
Excel Exposure – Website and Blog:
Run by working professional Joel Lee, Excel Exposure is a great free resource for advanced Excel topics. The blog contains hundreds of in-depth written tutorials on functions, automation, reporting and analysis techniques. It cuts through the filler to focus only on practical skills.
What sets Excel Exposure apart is that Joel also provides the step-by-step workbook examples that accompany each tutorial. This is extremely valuable for learning complex functions and formulas – you can’t just read about them, you need to try them out in your own files. The ability to download and follow along with the working samples makes it easy to absorb advanced Excel skills.
Coursera Excel Courses:
Coursera partners with top universities to offer online courses on just about any topic. They have some wonderful advanced Excel courses available absolutely free for audit as well as for a small fee if you need a verified certificate of completion.
Classes like “Data Analysis with Excel” from the University of Toronto are extremely comprehensive – taking dozens of hours to walk through cases studies, functions and formulas to perform powerful data analysis and visualization. Since the courses come from reputed institutions, you know the material and skills are very applicable in professional settings.
By leveraging free resources like ExcelIsFun YouTube tutorials, Excel Exposure tutorials and blogs, and Udemy’s frequent low-cost advanced Excel courses, anyone can learn best practices for automation, visualization, analysis and all the most useful advanced Excel skills from experienced instructors. Moving between video, written and hands-on workbook examples makes complex topics easy to understand and apply in your own work. I hope these resources provide a great starting point for your Excel learning journey!