ExcelHero

Your workbook

Basics0/39

  1. Cells, rows and columns
  2. Your first formulas
  3. Add things up with SUM
  4. Copy a formula down
  5. Average, lowest, highest
  6. Count cells
  7. Round numbers
  8. Percentages
  9. Fixed references with $

Conditions0/18

  1. Add with a condition: SUMIF
  2. Count with a condition: COUNTIFPro
  3. Average with a conditionPro
  4. Several conditions, comparisons, wildcardsPro

Logic0/25

  1. Make decisions with IF
  2. Combine tests: AND, OR, NOTPro
  3. More than two answers: IFSPro
  4. Pick from a list: SWITCH and CHOOSEPro
  5. Fix broken formulasPro
  6. Catch errors with IFERRORPro

Lookups0/14

  1. Find values with VLOOKUP
  2. The modern way: XLOOKUPPro
  3. INDEX and MATCHPro

Text0/14

  1. Join text
  2. Cut text apartPro
  3. Clean up messy textPro

Dates0/14

  1. Work with dates
  2. Date mathsPro
  3. Workdays and deadlinesPro

Dynamic arrays0/10

  1. Lists that build themselves: UNIQUE and SORT
  2. Pick rows with FILTERPro

Pro moves0/7

  1. Multiply and add: SUMPRODUCT
  2. Top and bottom: LARGE, SMALL, MEDIANPro

Projects0/15

  1. Project: a monthly budget
  2. Project: a sales reportPro
  3. Project: clean up a customer listPro