Course Introduction
  • Introduction
  • Download the exercises and reference sheet
  • Exercise 1 - Navigation Maze
  • Exercise 2 - Paint by Number
  • Exercise 3 - Paste Special
  • Exercise 4 - Pick and Pop (a paste special game)
  • Formatting quiz!
  • Exercise 5 - Basic Functions
  • Exercise 6 - Dragging and Locking Cells
  • Exercise 7 - Rapid Function Practice
  • Exercise 8 - Lookup and Conditional Functions
  • Exercise 9 - Nesting Formulas, and data filtering
  • Exercise 10 - Pivot tables and Charts
  • Exercise 11 - Working with data
  • Exercise 11 answers - Working with data, and combining your knowledge
  • The end!