FormulaCamp
Completed
← Full curriculum
Track 3 · Beginner

Formula Basics

How formulas work, operators, relative, absolute and mixed references, links between sheets, and errors.

14 free lessons

0 of 14 completed · about 4.3 h

Start

14 lessons left until your certificate

First Formulas

  1. 1Your First FormulaFreelesson15 min
  2. 2Arithmetic and PercentagesFreelesson15 min
  3. 3Practice: The BasicsFreepractice20 min

References

  1. 4Absolute References ($)Freelesson15 min
  2. 5Mixed ReferencesFreelesson15 min
  3. 6Named RangesFreelesson15 min
  4. 7Practice: Absolute and Mixed ReferencesFreepractice20 min

Sheets and Errors

  1. 8References Between SheetsFreelesson15 min
  2. 9Links to Other WorkbooksFreelesson20 min
  3. 10Formula Errors and How to Fix ThemFreelesson20 min
  4. 11IFERROR and Checking FunctionsFreelesson15 min
  5. 12Circular References and Iterative CalculationFreelesson20 min
  6. 13Practice: Several SheetsFreepractice20 min

Project P02

  1. 14Project: Payroll SheetFreeproject30 min