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/30

  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
  7. Check what is in a cell: IS functionsPro

Lookups0/23

  1. Find values with VLOOKUP
  2. The modern way: XLOOKUPPro
  3. INDEX and MATCHPro
  4. Look across: HLOOKUPPro
  5. Look up in ranges: prices, tiers, sizesPro

Text0/19

  1. Join text
  2. Cut text apartPro
  3. Clean up messy textPro
  4. Find text: FIND, SEARCH, TEXTBEFORE, TEXTAFTERPro

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

Pivot & filters0/15

  1. Sort and filter a list
  2. Your first pivot tablePro
  3. Pivot tables: average, biggest, countPro

Pro moves0/12

  1. Multiply and add: SUMPRODUCT
  2. Top and bottom: LARGE, SMALL, MEDIANPro
  3. Round to steps: CEILING, FLOOR, EVENPro

Shortcuts0/18

  1. Fly around the sheet
  2. Select without the mousePro
  3. Edit and format with keysPro

Projects0/20

  1. Project: a monthly budget
  2. Project: a sales reportPro
  3. Project: clean up a customer listPro
  4. Project: a job interview taskPro