--- title: Learn Excel Formulas and Functions | daily.dev description: A free two-hour YouTube course from freeCodeCamp.org teaches Excel formulas and functions, taught by Sergio, a former Amazon software engineer and creator of... canonical: https://daily.dev/posts/learn-excel-formulas-and-functions-tkwwefb3a twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Learn Excel Formulas and Functions | daily.dev og:description: A free two-hour YouTube course from freeCodeCamp.org teaches Excel formulas and functions, taught by Sergio, a former Amazon software engineer and creator of... og:url: https://daily.dev/posts/learn-excel-formulas-and-functions-tkwwefb3a og:image: https://api.daily.dev/og/posts/tkwwEFB3a.png og:image:alt: Learn Excel Formulas and Functions og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Learn Excel Formulas and Functions **[freeCodeCamp](https://daily.dev/sources/freecodecamp)** · 2 min read · 0 upvotes · 0 comments ## Summary A free two-hour YouTube course from freeCodeCamp.org teaches Excel formulas and functions, taught by Sergio, a former Amazon software engineer and creator of Formula Wars. The course covers core mechanics and error handling, conditional logic functions like IF, AND, OR, and IFS, conditional aggregation, modern lookup functions such as XLOOKUP, INDEX, and XMATCH, data cleaning with text and date functions, and dynamic array functions including FILTER, SORT, and UNIQUE. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What is XLOOKUP used for in Excel and how is it different from other lookup functions? XLOOKUP is described as the modern, versatile replacement for older lookup approaches in Excel, often called the Swiss Army knife of Excel lookups. It is typically covered alongside INDEX and XMATCH as part of modern lookup techniques, offering more flexible searching than older functions like VLOOKUP. _Developers building Excel-based tools can track lookup function tips and comparisons on daily.dev._ ### What are Excel dynamic array functions like FILTER, SORT, and UNIQUE used for? FILTER, SORT, and UNIQUE are dynamic array functions that let you extract, reorder, and deduplicate data ranges directly within formulas without manual steps. Mastering these functions is considered an advanced skill that puts a spreadsheet user ahead of the vast majority of typical Excel users. _Anyone leveling up spreadsheet automation skills can follow more data-manipulation content on daily.dev._ --- Tags: [#career](https://daily.dev/tags/career), [#data-analysis](https://daily.dev/tags/data-analysis) [View this post on daily.dev](https://daily.dev/posts/learn-excel-formulas-and-functions-tkwwefb3a) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Learn Excel Formulas and Functions","url":"https://daily.dev/posts/learn-excel-formulas-and-functions-tkwwefb3a","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/learn-excel-formulas-and-functions-tkwwefb3a"},"datePublished":"2026-09-01T19:20:54.438Z","dateModified":"2026-09-01T19:21:15.945Z","description":"A free two-hour YouTube course from freeCodeCamp.org teaches Excel formulas and functions, taught by Sergio, a former Amazon software engineer and creator of...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/af61adb548232fce7b3ee6e6b87f8363?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/af61adb548232fce7b3ee6e6b87f8363?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"freeCodeCamp","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"freeCodeCamp","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1628412854/logos/freecodecamp","url":"https://daily.dev/sources/freecodecamp"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/learn-excel-formulas-and-functions-tkwwefb3a","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"career,data-analysis","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"freeCodeCamp","item":"https://daily.dev/sources/freecodecamp"},{"@type":"ListItem","position":3,"name":"Learn Excel Formulas and Functions"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/learn-excel-formulas-and-functions-tkwwefb3a#faq","mainEntity":[{"@type":"Question","name":"What is XLOOKUP used for in Excel and how is it different from other lookup functions?","acceptedAnswer":{"@type":"Answer","text":"XLOOKUP is described as the modern, versatile replacement for older lookup approaches in Excel, often called the Swiss Army knife of Excel lookups. It is typically covered alongside INDEX and XMATCH as part of modern lookup techniques, offering more flexible searching than older functions like VLOOKUP. Developers building Excel-based tools can track lookup function tips and comparisons on daily.dev."}},{"@type":"Question","name":"What are Excel dynamic array functions like FILTER, SORT, and UNIQUE used for?","acceptedAnswer":{"@type":"Answer","text":"FILTER, SORT, and UNIQUE are dynamic array functions that let you extract, reorder, and deduplicate data ranges directly within formulas without manual steps. Mastering these functions is considered an advanced skill that puts a spreadsheet user ahead of the vast majority of typical Excel users. Anyone leveling up spreadsheet automation skills can follow more data-manipulation content on daily.dev."}}]} ```