Uploaded September 2026 | Updated September 2026, 2 weeks ago
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: 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: 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: freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news
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: 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: 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: freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news
![Pro Designer Gary Simon Talks Freelance + Career Tips [Podcast #123]](https://i.ytimg.com/vi/h4puc1P2VMA/mqdefault.jpg "Pro Designer Gary Simon Talks Freelance + Career Tips [Podcast #123]
Pro Designer Gary Simon Talks Freelance + Career Tips [Podcast #123]")
![There are 2 kinds of devs. One of them is screwed. Justin Searls interview [Podcast #210]](https://i.ytimg.com/vi/hP931079TMw/mqdefault.jpg "There are 2 kinds of devs. One of them is screwed. Justin Searls interview [Podcast #210]
Today Quincy Larson interviews Justin Searls. Hes a software engineer who cofounded a software agency 15 years ago thats still going – even after he figured out how to make a lot of money quickly and retire at age 38 once he had enough savings.
These days hes gone from solving problems for client to solving solving problems for himself by building open source software. Often using emerging tools like agents. He says he getting way more done now than ever before.
We talk about:
- How software development is ceasing to be a team sport and is now more about individual devs working directly for the people paying them
- How verifiability is everything - whether its agents contributing to your codebase or humans
- How someone just now entering the field can use emerging tools to get an edge over more experienced developers
Note that I dont edit or censor these interviews at all. Justin uses some pretty blunt language so you may not want to listen to this around young children.
Support for this podcast comes from the 10,113 kind folks who donate to our charity each month. Join them and support our mission at https://donate.freecodecamp.org
Get a freeCodeCamp tshirt for $20 with free shipping anywhere in the US: https://shop.freecodecamp.org
Links from our discussion:
- Justins website: https://justin.searls.co
- The Breaking Change podcast: https://justin.searls.co/casts
- Justins article Theres no AI in team: https://justin.searls.co/links/2025-08-03-there-is-no-ai-in-team/
- Justins article about how software is supply-constrained: https://justin.searls.co/links/2025-11-04-software-is-supply-constrained-for-now/
Community news section:
1. freeCodeCamp just published a course that will take you deep into the modern Kubernetes ecosystem. Youll implement advanced industry standards such as Gateway API for traffic management, CloudNativePG for managing PostgreSQL databases, and cert-manager for automated HTTPS security. By the end of the course, youll have the confidence to manage production-grade environments. (6 hour YouTube course): https://www.freecodecamp.org/news/master-kubernetes-through-production-ready-practice/
2. freeCodeCamp also published a comprehensive Notion course. Its not just a fancy notebook – you can use it as a full-blown operating system. You can code along at home and build your own task manager using Notions “Software Legos” philosophy. Then youll integrate your project with mail and calendar functionality, dashboards, and other advanced features. (12 hour YouTube course): https://www.freecodecamp.org/news/lean-notion-in-12-hours/
3. Learn how to guide agents to write secure code using a robust framework of rules and tests. Software engineer and recent podcast guest Sumit Saha shares his step-by-step process by building a Node.js shopping cart app using an agent. Instead of just using naive “one-shot” prompts, he leverages server-side validation and test-driven development. Well worth reading. (20 minute read): https://www.freecodecamp.org/news/how-to-guide-ai-with-rules-and-tests/
4. Learn the Python you need to know to build your own agents. This course starts by teaching you core Python syntax and best practices before moving on to NumPy, Pandas, and SQL. With these tools in your toolbelt, you can manage the data that fuels modern AI tools. (6 hour YouTube course): https://www.freecodecamp.org/news/learn-python-and-build-autonomous-agents/
5. Todays song of the week is from the UK band Unkle – 2003s hypnotic ballad What Are You to Me?. The groove is mostly heald together by accoustic guitar and piano on top of layers of synth bass and breakbeats. We also get some Soulful, laid back feel from the featured vocalist, Joel Cadbury of the band South. This song just melts into the background. I think youre going to like it. https://www.youtube.com/watch?v=lgrN2uQKq9k")
