RPIT Computers · Ramarpan Creations LLP
From Zero to Excel Master
at RPIT
A 40-question, story-driven practice course built on one real 1,000-student dataset — the same course every RPIT trainee completes before their first client visit.
Prologue
Day 1, 9:30 AM — Orientation
““This isn't a textbook,” her trainer tells her, sliding the workbook across the desk. “Every one of these forty is something a real client has actually asked us for — sorted, phrased so you can't just wing it, and checkable, so you'll know the moment you get one wrong instead of finding out three weeks later at a client's office.””
What's covered
Basic → Advanced, in one workbook
Five chapters, forty questions, one linked dataset (Marks / Fees / Contact).
Chapter 1 · Day 1, morning · Level 1 — Basic
Learning to see the data
“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 trainer says. Most client calls RPIT gets aren't about formulas at all — …
Open Marks. Row 1 is already frozen (View → Freeze Panes). Unfreeze it, scroll down, notice the headers disappear — then re-freeze it yourself (click …
Using the AutoFilter arrow on the Class column, filter Marks to show only rows where Class = 10. Read the row count Excel shows at the bottom-left sta…
Chapter 2 · Day 2 · Level 2 — Intermediate
Making the sheet answer back
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 chapter where COUNTIF, SUMIF and their multi-condition cousins (COUNTIFS, SU…
In a spare cell: =COUNTIF(Marks!N:N,"FAIL")…
=COUNTIFS(Marks!C:C,10,Marks!N:N,"PASS")…
Chapter 3 · Day 3 · Level 3 — Advanced
Judgment calls
“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 where Aditi replaces a working VLOOKUP with INDEX/MATCH not because the…
Fees column B currently uses =VLOOKUP(A2,Marks!$A$2:$B$1001,2,FALSE()) to pull Student Name. Rewrite it as an INDEX/MATCH that returns the exact same …
Find the highest-Percentage student in each of the 12 classes, either with =MAXIFS(Marks!$L$2:$L$1001,Marks!$C$2:$C$1001,{class}) for the value, or an…
Chapter 4 · Day 4 · Level 4 — Expert
The client walk-through
Thursday is presentation day. RPIT's clients — school administrators, coaching-class owners, shop managers — don't want to see 1,000 rows. They want one sheet that tells them what's going on, and they want to be able to …
Insert → PivotTable from the Marks table. Rows = Class, Columns = Section, Values = Average of Percentage. Format the value area as a percentage.…
Insert a second PivotTable from Fees: Rows = Payment Mode, Values = Sum of Fee Paid and Count of Student ID.…
Chapter 5 · Day 5 · Bonus — Cross-Sheet Challenge
The certification challenge
The last two questions get no scaffolding. No column-by-column instructions, no “use this function.” Just a real business question — which struggling students have already paid their full fee, and can we hand a parent on…
On a new sheet, build one formula (or one small formula-driven block) that identifies every student where Marks!Result = "FAIL" AND Fees!Fee Status = …
Design a one-page printable report-card layout on a new sheet: one input cell for a Student ID, and every other field pulled automatically from Marks,…
Self-check, built in
Every question has a verified answer
Q11 — How many students failed?
Expected result — 16 students failed (out of 1,000).
=COUNTIF(Marks!N:N,"FAIL")
All 40 results were recalculated against the real 1,000-row workbook — not estimated.
Epilogue
Friday, 6 PM — Certified
“Forty questions in, Aditi's workbook looks nothing like the clean file she started with — it has her own PivotTables, a dashboard sheet, a protected Marks tab, and a cross-sheet formula she had to think about twice before it worked. That's deliberate. The workbook a trainee ends the week with is never the one they were handed.”
Start free
Get the workbook and questions
Download the practice workbook, the 40-question PDF with answer key, or read the full course online.
rpit.in · youtube.com/@RPITtech · [email protected]