Excel Interview Crash Course
Learn the 8 skills Excel interview tests check, in about 2 hours. Short lessons, worked examples and live practice on a real sheet.
What you'll learn
- 1
Lookups that don't break
VLOOKUP, XLOOKUP and INDEX MATCH, exact match, and the #N/A traps interviewers set.
- 2
SUMIFS and COUNTIFS
Multi-condition totals and counts, dates and "not equal" criteria.
- 3
IF logic
Nested IF, IFS, AND/OR and IFERROR, without spaghetti formulas.
- 4
Pivot tables in 15 minutes
Build, group and filter a pivot the way a timed test expects.
- 5
Cleaning messy data
TRIM, text splits, duplicates and dates stored as text.
- 6
Interview traps
Absolute references, hidden spaces, wrong ranges: the mistakes that cost marks.
- 7
Finance formulas
Variance, growth, CAGR, PMT and NPV, explained in plain words.
- 8
Speed with shortcuts
The 15 shortcuts that make you look fluent when someone watches you work.
Try the first lesson free
Lesson 1 sample: lookups that don't break
Interviewers love lookups because one small mistake gives a wrong answer that looks right. Three rules cover most questions:
- Always use exact match. End VLOOKUP with
FALSE(or 0). Without it, Excel guesses the nearest value from a sorted list and can return the wrong row silently. - Lock the table range. Write
$A$2:$C$11so the range doesn't slide when you copy the formula down. - Count columns from the table, not the sheet. The column number in VLOOKUP starts at 1 for the first column of your range.
Try it now. Click cells on the sheet to build your formula:
Next, a two-condition total, the second most common interview task:
That's the style of all 8 lessons: a short explanation, then practice that checks your actual formula. Enter ₹299 at checkout.
Pre-order for ₹299Frequently asked questions
When do I get the lessons?
This is an early-access pre-order. All 8 lessons are released by 30 November 2026 and sent to the email you pay with. Lessons go live one by one as they are finished.
What if it isn't for me?
Email privacy@excelinterviewtest.com within 7 days of the release and you get a full refund, no questions asked. If the lessons aren't released by the date, you get a refund automatically.
How is it different from the free test?
The free test tells you what you got wrong. The course teaches each skill step by step, with a short explanation, a worked example and live practice on the same sheet, so you know how to answer next time.
Is the price one-time?
Yes. ₹299 once, no subscription. Early buyers keep access to every future lesson.
How do I pay?
Through Razorpay: UPI, cards, net banking or wallets. This site never sees your card details.