Tabellab
Menu
Courses Guides Pricing Log in Start free

Case 1: Lookups with XLOOKUP, INDEX/MATCH and Tier Tables

Lesson 1 of 812 minLab

All lessons
  1. Case 1: Lookups with XLOOKUP, INDEX/MATCH and Tier TablesLab12 minFree
  2. Case 2: SUMIFS and COUNTIFS ReportLab12 minFree
  3. Case 3: IF, IFS, AND and OR LogicLab12 min Pro
  4. Case 4: Percentages, Growth and the Classic TrapsLab12 min Pro
  5. Case 5: Text Cleanup and ConcatenationLab12 min Pro
  6. Case 6: Date Calculations with EOMONTH, NETWORKDAYS and DATEDIFLab12 min Pro
  7. Case 7: Pivot-Style Summary with FormulasLab12 min Pro
  8. Case 8: Final Mixed AssessmentLab25 min Pro

You are not signed in — the lab works, but your progress is not saved. Start free

Loading the spreadsheet…
Next lesson →