Excel Formulas & Functions – Full Course

Value of the Information & Strength of the Argument

The course provides high value by combining theoretical explanations with immediate practical application through the Formula Wars platform. The argumentation is solid, as the instructor builds concepts step-by-step, using clear examples and analogies. The emphasis on understanding the underlying mental model of formula evaluation is particularly valuable for learners. The course also highlights the importance of relative, absolute, and mixed references, which are crucial for building robust spreadsheets. The inclusion of modern functions like XLOOKUP and dynamic arrays adds contemporary relevance. The argumentation is logical and well-structured, making complex topics accessible.

Scientific Rigor, Source Quality, Title Accuracy

The scientific rigor is adequate for a tutorial course. The instructor, with a background as a software engineer at Amazon, demonstrates expertise. The content is accurate and follows standard Excel documentation. The course does not cite external sources but relies on the instructor’s knowledge and the official Excel behavior. The title accurately reflects the content, and the course is well-organized with clear lesson objectives. The companion material on Formula Wars is a unique feature that enhances learning. No external sources are cited, but the course itself serves as a primary source of instruction.

The title accurately reflects the content: a comprehensive course on Excel formulas and functions.

8/10

The course is well-structured, logically sequenced, and taught by an experienced software engineer. It covers fundamental concepts accurately and provides practical examples. The content is reliable for beginners, though it does not delve into advanced edge cases or alternative methods.

Markers derived by PSI from the transcript: the creator did not define chapters.

• 00:00Course introduction and overview
• 05:08Lesson 1: Arithmetic, Comparison, and Text Operators
• 08:31Lesson 1 Part 2: How Excel Evaluates a Formula
• 13:34Lesson 2: Relative, Absolute, and Mixed Cell Referencing
• 18:42Lesson 3: Function Structure
• 23:58Lesson 4: Error Basics
• 28:59Lesson 5: Logic Functions
• 34:38Lesson 6: Core Aggregation Functions
• 38:47Core Practice Problem
• 42:41Lesson 7: Conditional Aggregation
• 49:25Lesson 8: Lookup Functions
• 1:06:21Lesson 9 Part 1: Text Normalization & Comparison
• 1:11:49Lesson 9 Part 2: Text Searching & Extraction
• 1:15:10Lesson 10: Date Foundations
• 1:23:54Lesson 11: Dynamic Array Functions
• 1:40:40Course Wrap Up

• Formula Wars - Course Companion Material — Companion practice problems and quizzes for the course
• freeCodeCamp News — Articles on programming and technology
• Scrimba — Interactive coding platform mentioned as a sponsor
• freeCodeCamp — Main platform for learning to code

• Microsoft Excel Help Center — Official documentation for Excel functions and features