Tabellab
Menu
Courses Guides Pricing Log in Start free
Intermediate

Excel Interview Test Practice

Eight timed-style mini cases like real pre-employment Excel tests: lookups, SUMIFS, IF logic, percentages, text, dates and pivot summaries, every cell graded with feedback on the classic traps.

8 lessons 8 labs 1.8 h Certificate

Start the course Unlock all courses

The first 2 lessons are free — no account needed.

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