Free course · Basic to Advanced · No sign-up
One real, linked, 1,000-student workbook (Marks, Fees & Contact) and 40 story-driven practice questions that go from your first AutoFilter to PivotTables, Power Query and macros — with a fully verified answer key, so you know the moment you get one wrong instead of finding out at a client's office.
The exact 1,000-student, 3-sheet dataset (Marks / Fees / Contact) every question is built around. Branded, formula-driven, zero errors.
Download the workbook (.xlsx)Print-ready PDF: every question with the trainee story behind it, plus a fully verified answer key at the end.
Download the PDFPrefer to browse before downloading? The full course — questions, story and answer key — is also available as a web page with jump-to-answer links.
Open the web version → Or flip through the slide deck →Every RPIT trainee works through this exact course before their first client visit. The questions follow Aditi, a new hire, from her first Monday morning to a Friday-evening certification — the same forty questions, in the same order, that turn "I know some Excel" into "clients trust me with their spreadsheets."
Chapter 1 · Day 1, morning · Level 1 — Basic
“Before you write a single formula, I want you to be able to answer questions about this data using nothing but your eyes and the ribbon,” Aditi's tra…
Chapter 2 · Day 2 · Level 2 — Intermediate
By Tuesday, Aditi has stopped scrolling through 1,000 rows to answer a question — she's started making the sheet answer it for her. This is the chapte…
Chapter 3 · Day 3 · Level 3 — Advanced
“Two formulas can both return the right answer today and only one of them is still right in six months,” her trainer warns before Chapter 3. This is w…
Chapter 4 · Day 4 · Level 4 — Expert
Thursday is presentation day. RPIT's clients — school administrators, coaching-class owners, shop managers — don't want to see 1,000 rows. They want o…
Chapter 5 · Day 5 · Bonus — Cross-Sheet Challenge
The last two questions get no scaffolding. No column-by-column instructions, no “use this function.” Just a real business question — which struggling …
Every core Excel skill this course touches — nothing here is padding.
| Concept | Covered by |
|---|---|
| Sorting, filtering, custom number formats | Chapter 1 (Q1–Q6) |
| Core functions — SUM, AVERAGE, COUNT, MAX, MIN | Chapter 1 (Q7) |
| Relative vs. absolute references ($) | Chapter 1 (Q8) |
| Basic charts | Chapter 1 (Q10) |
| Conditional aggregation — COUNTIF/S, SUMIF/S, AVERAGEIF/S | Chapter 2 (Q11–Q16) |
| Conditional formatting | Chapter 2 (Q17) |
| Error handling — IFERROR | Chapter 2 (Q18) |
| Named ranges | Chapter 2 (Q19) |
| Lookups — VLOOKUP → INDEX/MATCH → XLOOKUP | Chapter 3 (Q21) / Chapter 4 (Q37) |
| Array logic — SUMPRODUCT | Chapter 3 (Q24) |
| Data validation with a custom formula | Chapter 3 (Q25) |
| What-if analysis — Goal Seek, Data Table, Scenario Manager | Chapter 3 (Q26, Q28, Q29) |
| Text functions — TEXT, LEFT/RIGHT/MID | Chapter 1 (Q9) / Chapter 3 (Q27) |
| PivotTables, Pivot Charts, Slicers | Chapter 4 (Q31–Q34) |
| Dashboards, Power Query, Macros | Chapter 4 (Q35–Q38) |
| Sheet/cell protection | Chapter 3 (Q30) |
| Cross-sheet, no-helper-column formulas | Chapter 5 (Q39–Q40) |
Yes. The workbook, the PDF and the web version are all free for personal learning, study and classroom use. Commercial use (resale, paid courses, redistribution on a paid platform) needs written permission — write to [email protected].
The workbook is built and verified in Excel (2007-era formulas throughout, so it works on old and new versions alike). Most questions work fine in Google Sheets too, except the Excel-only features called out explicitly — Power Query, macros, and true PivotTable Slicers.
Yes. XLOOKUP needs Microsoft 365 or Excel 2021+, so that one question is marked optional — the INDEX/MATCH version from Question 21 already solves the same problem and works on every version.
Yes — all 40 questions, with the expected numeric result, the exact formula, and (for the PivotTable/macro/Power Query questions) a step-by-step correctness check. Every number was recalculated against the real 1,000-row workbook, not estimated.
Anyone going from zero or basic Excel to job-ready — it's the same 40 questions RPIT Computers hands every new trainee in Mumbai before their first client visit.
