freeCodeCamp.org: Excel Formulas & Functions – Full Course

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