--- title: Excel Formulas & Functions – Full Course | daily.dev description: A comprehensive, free video course teaches Excel formulas and functions from the ground up, taught by a former Amazon software engineer who now runs an... canonical: https://daily.dev/posts/excel-formulas-functions-full-course-8bbpkcxkz twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Excel Formulas & Functions – Full Course | daily.dev og:description: A comprehensive, free video course teaches Excel formulas and functions from the ground up, taught by a former Amazon software engineer who now runs an... og:url: https://daily.dev/posts/excel-formulas-functions-full-course-8bbpkcxkz og:image: https://api.daily.dev/og/posts/8BBPKCxkZ.png og:image:alt: Excel Formulas & Functions – Full Course 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. # Excel Formulas & Functions – Full Course **[freeCodeCamp](https://daily.dev/sources/freecodecamp)** · 101 min read · 0 upvotes · 0 comments ## Summary A comprehensive, free video course teaches Excel formulas and functions from the ground up, taught by a former Amazon software engineer who now runs an interactive Excel practice platform called Formula Wars. Topics progress from basic operators, formula evaluation order, and cell referencing (relative, absolute, mixed), through error handling (IFERROR, IFNA), logical functions (IF, AND, OR, NOT, IFS), aggregation and conditional aggregation (SUMIFS, COUNTIFS, AVERAGEIFS), lookup functions (XLOOKUP, XMATCH, INDEX, legacy VLOOKUP/HLOOKUP/MATCH), text manipulation (TRIM, SUBSTITUTE, REPLACE, TEXT, EXACT), and text extraction (FIND, SEARCH, LEFT, RIGHT, MID, LEN). Each lesson pairs with browser-based quizzes and practice problems on Formula Wars, with a free tier covering all course content and a paid pro tier unlocking additional advanced problems and an AI formula tutor. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What's the difference between IFERROR and IFNA in Excel? IFERROR catches any Excel error type and replaces it with a fallback value, while IFNA only catches the #N/A error specifically, letting other error types like #DIV/0 or #VALUE pass through unhandled. In lookup-heavy models, IFNA is often preferred because it preserves the distinction between a lookup returning no result versus a broken formula elsewhere. _Developers building spreadsheet-driven tools can find similar formula deep dives curated on daily.dev._ ### How does XLOOKUP handle duplicate values differently based on search mode? XLOOKUP's search mode argument controls which duplicate match it returns: the default mode of 1 searches first-to-last and returns the earliest matching record, while search mode -1 searches last-to-first and returns the most recent matching record. For example, looking up a SKU that appears three times with different statuses returns the first chronological entry by default, or the last one with search mode -1. _Anyone comparing lookup functions across tools can track these formula nuances on daily.dev._ ### Why does XLOOKUP make VLOOKUP and HLOOKUP obsolete? XLOOKUP replaces VLOOKUP and HLOOKUP because it can search in any direction (left, right, up, or down), return either a single value or an entire spill range, and includes a built-in fallback argument for when no match is found. VLOOKUP and HLOOKUP are restricted to searching the first column or first row respectively and lack these flexible options, though they still appear in existing workbooks. _Teams deciding which spreadsheet functions to standardize on can follow tooling comparisons via daily.dev._ ## Similar posts on daily.dev - [Fix Common Google Sheets Mistakes \(and a Few Easy Wins\)](https://daily.dev/posts/fix-common-google-sheets-mistakes-and-a-few-easy-wins--cv2wbo9ol) · Atomic Spin · 0 upvotes · 0 comments - [Advanced Excel‑Style Data Analysis with React Spreadsheet Formulas](https://daily.dev/posts/advanced-excel-style-data-analysis-with-react-spreadsheet-formulas-gdty5mgb4) · Syncfusion · 0 upvotes · 0 comments --- Tags: [#data-analysis](https://daily.dev/tags/data-analysis) [View this post on daily.dev](https://daily.dev/posts/excel-formulas-functions-full-course-8bbpkcxkz) ```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":"Excel Formulas & Functions – Full Course","url":"https://daily.dev/posts/excel-formulas-functions-full-course-8bbpkcxkz","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/excel-formulas-functions-full-course-8bbpkcxkz"},"datePublished":"2026-09-01T15:25:38.286Z","dateModified":"2026-09-01T15:26:02.880Z","description":"A comprehensive, free video course teaches Excel formulas and functions from the ground up, taught by a former Amazon software engineer who now runs an...","image":"https://i.ytimg.com/vi/gvhsKtjAmgc/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/gvhsKtjAmgc/sddefault.jpg","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/excel-formulas-functions-full-course-8bbpkcxkz","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"data-analysis","timeRequired":"PT101M","video":{"@type":"VideoObject","name":"Excel Formulas & Functions – Full Course","description":"A comprehensive, free video course teaches Excel formulas and functions from the ground up, taught by a former Amazon software engineer who now runs an...","thumbnailUrl":"https://i.ytimg.com/vi/gvhsKtjAmgc/sddefault.jpg","uploadDate":"2026-09-01T15:25:38.286Z","duration":"PT101M","url":"https://api.daily.dev/r/8BBPKCxkZ","embedUrl":"https://www.youtube.com/embed/gvhsKtjAmgc"}} {"@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":"Excel Formulas & Functions – Full Course"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/excel-formulas-functions-full-course-8bbpkcxkz#faq","mainEntity":[{"@type":"Question","name":"What's the difference between IFERROR and IFNA in Excel?","acceptedAnswer":{"@type":"Answer","text":"IFERROR catches any Excel error type and replaces it with a fallback value, while IFNA only catches the #N/A error specifically, letting other error types like #DIV/0 or #VALUE pass through unhandled. In lookup-heavy models, IFNA is often preferred because it preserves the distinction between a lookup returning no result versus a broken formula elsewhere. Developers building spreadsheet-driven tools can find similar formula deep dives curated on daily.dev."}},{"@type":"Question","name":"How does XLOOKUP handle duplicate values differently based on search mode?","acceptedAnswer":{"@type":"Answer","text":"XLOOKUP's search mode argument controls which duplicate match it returns: the default mode of 1 searches first-to-last and returns the earliest matching record, while search mode -1 searches last-to-first and returns the most recent matching record. For example, looking up a SKU that appears three times with different statuses returns the first chronological entry by default, or the last one with search mode -1. Anyone comparing lookup functions across tools can track these formula nuances on daily.dev."}},{"@type":"Question","name":"Why does XLOOKUP make VLOOKUP and HLOOKUP obsolete?","acceptedAnswer":{"@type":"Answer","text":"XLOOKUP replaces VLOOKUP and HLOOKUP because it can search in any direction (left, right, up, or down), return either a single value or an entire spill range, and includes a built-in fallback argument for when no match is found. VLOOKUP and HLOOKUP are restricted to searching the first column or first row respectively and lack these flexible options, though they still appear in existing workbooks. Teams deciding which spreadsheet functions to standardize on can follow tooling comparisons via daily.dev."}}]} ```