Excel remains one of the most widely used and powerful tools in the tech and business worlds, but truly mastering its formulas and functions can sometimes feel overwhelming. To help you become a true spreadsheet power user, we just published a comprehensive new course on the freeCodeCamp.org YouTube channel.

This course is taught by Sergio, a former Amazon software engineer and the creator of Formula Wars. Sergio credits his early Excel skills with helping him land an investment banking internship and ultimately sparking his path into software engineering. Now, he is bringing a highly practical, code-style interactive approach to learning Excel. You will immediately reinforce spreadsheet concepts through quizzes and hands-on practice problems.

What You Will Learn

  • Core Mechanics & Error Handling
    Understand how Excel evaluates formulas, cell referencing, and how to troubleshoot common errors.

  • Logic & Branching
    Master conditional functions like IF, AND, OR, and IFS.

  • Aggregation
    Learn how to summarize your data using conditional aggregation functions.

  • Modern Lookups
    Get hands-on with XLOOKUP, the "Swiss Army knife" of Excel lookups, along with INDEX and XMATCH.

  • Data Manipulation
    Clean and format messy data using text normalization and date functions.

  • Dynamic Arrays
    Finish strong by mastering modern dynamic array functions like FILTER, SORT, and UNIQUE that will put you ahead of 99% of Excel users.

You can watch the full course right now on the freeCodeCamp.org YouTube channel (2-hour watch).