Home

Early access · pre-order

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.

Pre-order for ₹299Enter ₹299 at checkout · one-time · released by 30 November 2026 · 7-day refund

What you'll learn

  1. 1

    Lookups that don't break

    VLOOKUP, XLOOKUP and INDEX MATCH, exact match, and the #N/A traps interviewers set.

  2. 2

    SUMIFS and COUNTIFS

    Multi-condition totals and counts, dates and "not equal" criteria.

  3. 3

    IF logic

    Nested IF, IFS, AND/OR and IFERROR, without spaghetti formulas.

  4. 4

    Pivot tables in 15 minutes

    Build, group and filter a pivot the way a timed test expects.

  5. 5

    Cleaning messy data

    TRIM, text splits, duplicates and dates stored as text.

  6. 6

    Interview traps

    Absolute references, hidden spaces, wrong ranges: the mistakes that cost marks.

  7. 7

    Finance formulas

    Variance, growth, CAGR, PMT and NPV, explained in plain words.

  8. 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:

  1. 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.
  2. Lock the table range. Write $A$2:$C$11 so the range doesn't slide when you copy the formula down.
  3. 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 ₹299

Frequently 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.