Lessons

Beginner

• How a spreadsheet is laid out: Learn what cells, rows, columns and ranges are.
• Your first formula: Write formulas that do math with your cells.
• Using functions: Let built-in functions such as SUM and AVERAGE do the work.
• Copying formulas and the $ sign: Find out why formulas change when copied, and how to control it.

Intermediate

• Making decisions with IF: Show different results depending on your data.
• Adding and counting by category: Total or count only the rows you care about.
• Looking things up: Pull a value from a table with XLOOKUP and friends.
• Cleaning up text: Fix messy names, codes and spacing.
• Working with dates: Do math with dates and pull out their parts.

Advanced

• Understanding error messages: Learn what errors mean and how to fix them.
• Formulas that fill many cells: Use UNIQUE, FILTER and SORT to build live lists.
• Finance formulas: Value loans and projects using the time value of money.