Learn Excel Formulas and Functions

<p>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.</p> <p>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.</p> <p><strong>What You Will Learn</strong></p> <ul> <li><p><strong>Core Mechanics &amp; Error Handling</strong><br>Understand how Excel evaluates formulas, cell referencing, and how to troubleshoot common errors.</p> </li> <li><p><strong>Logic &amp; Branching</strong><br>Master conditional functions like <code>IF</code>, <code>AND</code>, <code>OR</code>, and <code>IFS</code>.</p> </li> <li><p><strong>Aggregation</strong><br>Learn how to summarize your data using conditional aggregation functions.</p> </li> <li><p><strong>Modern Lookups</strong><br>Get hands-on with <code>XLOOKUP</code>, the "Swiss Army knife" of Excel lookups, along with <code>INDEX</code> and <code>XMATCH</code>.</p> </li> <li><p><strong>Data Manipulation</strong><br>Clean and format messy data using text normalization and date functions.</p> </li> <li><p><strong>Dynamic Arrays</strong><br>Finish strong by mastering modern dynamic array functions like <code>FILTER</code>, <code>SORT</code>, and <code>UNIQUE</code> that will put you ahead of 99% of Excel users.</p> </li> </ul> <p>You can watch the full course right now on <a href="https://youtu.be/gvhsKtjAmgc">the freeCodeCamp.org YouTube channel</a> (2-hour watch).</p> <div class="embed-wrapper"><iframe width="560" height="315" src="https://www.youtube.com/embed/gvhsKtjAmgc" style="aspect-ratio: 16 / 9; width: 100%; height: auto;" title="YouTube video player" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen="" loading="lazy"></iframe></div>