A curated selection of high-quality, free educational resources designed to help professionals master data analysis, automation, and visualization in Excel and Google Sheets. These courses cover everything from basic formulas to advanced scripting, catering to various skill levels.
Get targeted exposure with custom position pinning and highlighted placement.
A comprehensive four-course specialization that progresses from beginner to advanced topics. It covers core Excel functions, data modeling, and complex calculations, offering a structured learning path recognized by many employers.
An extensive video series created by Mike Girvin that focuses on bridging the gap between Excel and Google Sheets. It provides practical tips for syncing data, leveraging cloud features, and maintaining spreadsheet integrity.
Offers audit-free access to foundational courses from institutions like Wharton and Microsoft. Learners can explore spreadsheets, basic functions, and business analytics without paying, though certificates require payment.
While broader in scope, this program includes significant modules on Google Sheets and data analysis. Professionals can audit individual courses to learn specific spreadsheet skills used in real-world data projects.
Official tutorials from Microsoft covering essential features like PivotTables, charts, and conditional formatting. These resources are ideal for users seeking quick, accurate guidance on specific tool functions directly from the source.
Focuses on connecting Google Sheets with data visualization tools like Looker Studio. It teaches professionals how to automate reporting workflows and create dynamic dashboards for business intelligence.
Periodically offers free access to highly-rated courses on nested formulas, VLOOKUP, and XLOOKUP. These classes provide practical examples for financial modeling and data manipulation tasks common in corporate environments.
A technical guide for professionals looking to extend sheet functionality using JavaScript-based Apps Script. It covers automating repetitive tasks, integrating with other Google services, and building custom menus.
Focuses on transforming raw data into actionable insights using Excel and Power BI. Learners gain skills in data cleaning, analysis, and visualization, which are crucial for modern business reporting roles.
An introductory guide that explains the interface, basic functions, and collaboration features of Google Sheets. It is designed for newcomers to understand how to work effectively in a shared, cloud-based environment.
Provides limited free access to professional-grade financial modeling techniques. It teaches professionals how to build dynamic models for valuation, budgeting, and forecasting using advanced Excel structures.
A blog and resource hub offering deep dives into PivotTables, Slicers, and Data Models. It provides step-by-step tutorials for creating interactive reports and summarizing large datasets efficiently in Excel.
The official documentation for all Google Sheets functions, including syntax and examples. It serves as an essential reference for professionals needing to understand complex array formulas and date functions.
Offers a free trial period for professional courses on data cleaning and analysis techniques. Learners can explore statistical functions and data visualization methods used in corporate data analysis workflows.
Covers building add-ons, automating workflows, and integrating APIs within Google Sheets. It is suitable for developers who want to enhance productivity through code-driven spreadsheet management.
While not a course, this resource offers extensive guides on creating effective charts in Excel and Sheets. It helps professionals avoid common visualization errors and communicate data insights clearly to stakeholders.
Debbie Jones provides extensive tips on keyboard shortcuts and time-saving techniques in Excel. These resources help professionals increase their speed and efficiency when navigating and manipulating large spreadsheets.
Official Microsoft Office Online tutorials that cover advanced features in both Excel and Sheets. It includes lessons on array formulas, dynamic ranges, and interoperability between different spreadsheet platforms.
Provides free practice exams and certification guides for popular Excel credentials. It helps professionals assess their knowledge and prepare for industry-recognized certifications through self-paced testing.
An introductory course focusing on using Excel for business analytics and decision-making. It covers descriptive statistics, forecasting, and basic data analysis techniques relevant to business roles.