Introduction
  • Introduction
  • Logical tests
  • IF Statements
  • VLOOKUP
  • INDEX and MATCH
  • S is for Super Power (summing with conditions attached)
  • Efficiency with Tables
  • Explaining Pivot tables in 10 minuites
  • Introducing Dynamic Arrays
  • Pivot table alternative using Dynamic Arrays (UNIQUE SORT AND TRANSPOSE)
  • The FILTER function
  • XLOOKUP
  • Conclusion