Excel Formulas & Functions – Full Course

From the creator

Master Excel formulas & functions. Learn the theory first, then immediately put it into practice with the free companion Formula Wars quiz and practice problem material. To gain access to this companion material for free, signup here: https://formulawars.com/signup/excel-formulas-and-functions-course-unlocked/ ✏️ Course from @formula_wars 📚 Course Content 👋 (0:00:00) Course Intro 📘 (0:05:08) Lesson 1 - Part 1: Arithmetic, Comparison, and Text Operators 📘 (0:08:31) Lesson 1 - Part 2: How Excel Evaluates a Formula 📘 (0:13:34) Lesson 2: Relative, Absolute, and Mixed Cell Referencing 📘 (0:18:42) Lesson 3: Function Structure 📘 (0:23:58) Lesson 4: Error Basics 📘 (0:28:59) Lesson 5: Logic Functions 📘 (0:34:38) Lesson 6: Core Aggregation Functions 🧩 (0:38:47) Core Practice Problem 📘 (0:42:41) Lesson 7: Conditional Aggregation 📘 (0:49:25) Lesson 8: Lookup Functions 📘 (1:06:21) Lesson 9 - Part 1: Text Normalization & Comparison 📘 (1:11:49) Lesson 9 - Part 2: Text Searching & Extraction 📘 (1:15:10) Lesson 10: Date Foundations 📘 (1:23:54) Lesson 11: Dynamic Array Functions 🏁 (1:40:40) Course Wrap Up ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp 🎉 Thanks to our Champion and Sponsor supporters: 👾 @omerhattapoglu1158 👾 @goddardtan 👾 @akihayashi6629 👾 @kikilogsin 👾 @anthonycampbell2148 👾 @tobymiller7790 👾 @rajibdassharma497 👾 @CloudVirtualizationEnthusiast 👾 @adilsoncarlosvianacarlos 👾 @martinmacchia1564 👾 @ulisesmoralez4160 👾 @_Oscar_ 👾 @jedi-or-sith2728 👾 @justinhual1290 -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

Choose to Build with AI
Matched to AI Education

AI Maker Residence at KOKO

The third AI workshop taught by our legendary teacher, Nick Sarafa. In one of the last events we did an asset manager raised an additional £25M on their fund within a space of 9 months. This is a full-day hands-on training workshop for purposeful co-creation with AI using Claude Code. Imagine having access to hundreds of billions of dollars of computing power and knowing exactly how to make it work for you through the power of super intelligence. One person did.

◆ Fri 09 Oct 2026 ◆ KOKO Cafe, London ◆ With Nick Sarafa
AI Maker Residence at KOKO
Live event
AI Maker Residence at KOKO
Fri 09 Oct 2026

More like this

Running one yourself?

List your AI event,
wherever it is.

A meetup, a workshop, a hackathon, a conference. Any city, or online. Tell us about it and it lands in front of people already learning this stuff.