Ravindra BagaleCourses & study guides Track your progress

Broken-Sheet Challenges

Friends, real office files break in small ways: wrong $, circular refs, stale names, unrefreshed pivots, typed-over formulas, mixed currency, fiscal-year traps. Each challenge gives a tiny .xlsx. Find the bugs, fix them, then open hints.

Workbooks: Download buttons pull practice .xlsx files from our public cards bucket (safe made-up data).
About this data: Every workbook uses made-up practice names (Indian + foreign), cities, and INR/USD labels. Not real sales, payroll, or freight. Safe for class and self-study.

Why → What → How

Why: Interviews and junior analyst work reward people who can debug a sheet, not only write a new formula from a blank cell.

What: A hub of downloadable broken workbooks with tiny examples, 12 practice tasks with hints, a quiz, and an in-browser formula checker where it fits. Ends with assessment and oral meta challenges.

How:

  1. Pick a challenge below.
  2. Download the broken .xlsx and open it in Excel or LibreOffice Calc.
  3. Find every bug before you peek at hints.
  4. Fix the sheet; compare with the solution steps (and optional fixed file).
  5. Use the on-page checker where available, then the quiz.

Ravindra Bagale’s Tip

Do not race to the solution. Write one sentence for each bug you see — that habit sticks in interviews.

See also: Excel practice hub · Functions · Certificate