Excel Formulas and Functions: A Practical Course

Build a foundation in Excel formulas and functions, from basic operators and cell references to lookups and dynamic arrays. Lessons pair explanations with spreadsheet examples, quizzes, and practical exercises on the Formula Wars platform; the focus is formulas and functions rather than Excel features such as dashboard design.

Timestamps are not provided in the supplied transcript.
■ Formula foundations
- Operators, formula evaluation, cell references, function arguments, and error handling
- Logical functions, aggregation, and conditional summaries
■ Lookups and data shaping
- XLOOKUP, XMATCH with INDEX, and legacy lookup functions
- Text and date functions, plus dynamic arrays including FILTER, SORT, SORTBY, and UNIQUE
■ Guided practice
- Worked examples, quizzes, and exercises using Formula Wars

Designed for learners building practical Excel skills, the course offers a path from core concepts to more involved formula problems. Use the course link in the description to access the accompanying materials, then work through the lessons, quizzes, and practice problems.