ðŸ§
Module 4: Complex Formulas, Functions & Cell References
Complex formulas, introduction to functions, and understanding absolute and relative cell references.
3
Lessons
50
Minutes
Practice
Files Included
Intermediate
Level
Lessons
Complete each lesson in order. Watch the video, review the notes, and finish the challenge.
Lesson 112 min
Complex Formulas & Order of Operations
Use PEMDAS and parentheses to control calculation order when building multi-step formulas such as subtotals and tax.
✔ Includes Practice File
Lesson 225 min
Relative & Absolute Cell References
Learn how relative, absolute, and mixed references behave when formulas are copied, and how to reference cells across worksheets.
✔ Includes Practice File
Lesson 335 min
Working with Functions
Learn how to use Excel functions including SUM, AVERAGE, COUNT, MAX, MIN, COUNTA, and NETWORKDAYS. Understand syntax, arguments, and how to insert functions using AutoSum and the Function Library.
✔ Includes Practice File