Why Excel Still Decides Who Gets Hired
The demand data, the roles and salaries, and exactly what the three test formats look like.
Get Set Up in One Evening
Versions compared, free access paths, and the Sharma Traders practice file you build yourself.
The 30-Day Job-Ready Plan
45 minutes a day, mapped chapter by chapter — plus the compressed 7-day version.
Cells, Ranges and References
The grammar of Excel, and the $-sign concept behind the most-asked interview trap.
Formatting That Earns Trust
Indian number formats, Tables (Ctrl+T), freeze panes and print setup done right.
The Core Formulas Every Test Asks For
From SUM to SUBTOTAL, with five business questions answered five ways.
Lookups Done Right
VLOOKUP, XLOOKUP, INDEX-MATCH and the two-way lookup that impresses.
Text, Dates and Error-Reading
The cleaning functions, the serial-number logic of dates, and every error decoded.
Cleaning Messy Data
The fixed professional sequence, applied end-to-end on the practice file.
Pivot Tables, Zero to Confident
The four areas, grouping, slicers, calculated fields — and the ten pivot tasks tests use.
Charts and the One-Page Dashboard
The right chart for each question, and the dashboard build reviewers reward.
Conditional Formatting and Data Validation
Rules that read the data, dropdowns that prevent errors, custom formula rules.
Power Query: The Refresh Button
Your first query in ten minutes, the transforms that matter, and the folder trick.
Speed: Shortcuts and the Test-Day Routine
The 24 shortcuts to memorise and the minute-by-minute test routine.
The Interview: 50 Questions, Answered
Foundations to judgement questions, with answers that survive follow-ups.
The Live Test: Tactics and Ten Timed Drills
How the round runs, what scores, and the drills with real task sheets.
AI Inside Excel: Copilot and Judgement
What Copilot really does (from Microsoft's docs), ten prompts to steal, and what not to do in a test.
Proof: Portfolio, Resume and Certificates
Resume lines that survive scrutiny, the MOS certificate question, and a one-workbook portfolio.
Your First Month on the Job
Surviving the inherited monster file, owning a recurring report, and what to learn next.
Appendices
A 62-function dictionary with syntax, three more practice datasets, the ten drill task sheets, and a 40-term glossary.
