Excel Interview Crack Pack — real questions from Razorpay, Flipkart, Cred, Deloitte, TCS
Stop preparing for 2018's interview. Modern Excel (XLOOKUP, FILTER, LET, LAMBDA, Power Query, Copilot) + company-tagged questions+ 3 dashboards you can show interviewers on Day 1. The interview-prep pack everyone else forgot to ship.
- 250 questions tagged by company — Razorpay, Flipkart, Cred, TCS, Deloitte, HDFC and 24 more
- Modern Excel covered (LET, LAMBDA, FILTER, Power Query, Copilot) — competitors are stuck on VLOOKUP
- 3 portfolio dashboards (Sales KPI / HR Headcount / Financial Model) — drop your name, show interviewers
- 5 case studies + 3 mock interview transcripts — what a 30-min Excel round actually looks like
You're preparing for the 2018 interview.
Interviewers moved on.
GeeksforGeeks. InterviewBit. Free YouTube. They all teach the same VLOOKUP / IF / Pivot Table answers from 2018. Product companies asked you about XLOOKUP in 2024, LET in 2025, and LAMBDA today. Here's the gap.
Modern replacement with default fallback (no IFERROR needed), reverse search, multi-column return. Razorpay specifically asks 'why not XLOOKUP?' when candidates suggest VLOOKUP.
LET names intermediate values for readability + performance. LAMBDA helpers (BYROW, MAP, REDUCE) replace 5-deep IF chains. Cred Engineering uses these heavily.
Multi-file consolidation, refreshable transforms, M-language steps. Microsoft India, Accenture, Razorpay all ask Power Query in Round 1.
Formula-driven aggregation without Pivot Cache. FILTER + SORTBY + UNIQUE replace half the pivots. Cred + Microsoft ask this in 2026.
10 patterns. 90% of Excel interviews.
From 100+ real Glassdoor / AmbitionBox / Medium interview reports.
Each pattern is covered with multiple worked Qs, real answers, and "what NOT to say" for each.
7 modules. 250 questions. Indian companies tagged on every one.
Every question has: the question · the answer · the formula · what NOT to say · common follow-ups · real-world scenario.
Formula Deep Dives
60 questionsVLOOKUP · XLOOKUP · INDEX-MATCH · SUMIFS / COUNTIFS / AVERAGEIFS · IF / IFS / IFERROR · Text & Date functions · SUMPRODUCT
Pivot Tables
50 questionsPivot basics · Grouping · Calculated fields · Slicers + Timelines · Layout · Filtering · CF on Pivots · GETPIVOTDATA · Performance
Power Query
40 questionsImports · Common transforms · Merging + Appending · Pivot/Unpivot · M language · Parameters + functions · Query Folding
Modern Excel
30 questionsFILTER · SORT/SORTBY · UNIQUE · SEQUENCE · LET · LAMBDA + helpers · XLOOKUP advanced · Dynamic arrays · GROUPBY / PIVOTBY
CF + Data Validation
30 questionsCF basics · Highlight rules · Formula-based CF · The absolute-vs-relative trap · DV cascading dropdowns · Named Ranges · Tables
Charts + Visualization
25 questionsChart selection theory · Combo / dual-axis · Dynamic interactive charts · Sparklines · Pivot Charts · Data storytelling
AI Copilot
15 questionsCopilot fundamentals · Prompts for analysis · Formula writing · Visualization · Interview ethics · Boundaries + limits · 5 answer scripts
3 sample questions — see the format
Every question in the pack reads exactly like this. Real interview context. Direct answers. Why-it-works explanation.
Given a 50,000-row transaction sheet and a customer master sheet, enrich every transaction with the customer's city using ONE formula. Why not VLOOKUP?
XLOOKUP with a default fallback. =XLOOKUP(B2, CustomerMaster[ID], CustomerMaster[City], "Unknown")
VLOOKUP can't look left, requires sorted data for approx match, and breaks if columns shift. XLOOKUP handles all three cases with cleaner syntax and built-in IFERROR.
Rewrite this nested IF using LET so the customer_score isn't computed 3 times: =IF(SUMIFS(Tx,Cust,A2)>50000,"GOLD",IF(SUMIFS(Tx,Cust,A2)>20000,"SILVER","BRONZE"))
=LET(score, SUMIFS(Tx, Cust, A2), IF(score>50000, "GOLD", IF(score>20000, "SILVER", "BRONZE")))
LET evaluates SUMIFS once and reuses. 3× faster on 50K rows. Cred's data team uses this pattern for fraud-flag heuristics. Showing LET fluency signals modern Excel proficiency.
Given sales by product ID, find IDs contributing 80% of revenue (Pareto). Build it in Excel.
Sort desc → running cumulative SUM → divide by grand total → FILTER where cumulative ≤ 80%. With FILTER + SORTBY in modern Excel, becomes single formula chain.
Asked verbatim per Medium AmEx interview report. Tests both formula chops and analytical thinking. Modern Excel solution (FILTER) is 3 lines; classic Excel takes 7 columns.
...and 247 more, plus 150 role-specific add-ons.
3 dashboards you can show interviewers on Day 1
Indian buyers report that "I have no portfolio" is the #1 fresher gap. We ship the portfolio.
Sales KPI Dashboard
6-region revenue table · top 5 products · MoM trend chart · region × product heatmap · 4 KPI cards. SUMIFS-driven, every cell defensible.
HR Headcount + Attrition Dashboard
Function-wise headcount · attrition by function · tenure distribution · gender ratio donut · 80-employee sample. COUNTIFS / AVERAGEIFS based.
Financial Forecasting Model
3-statement linking · sensitivity table · scenario manager (best/base/worst) · NPV/IRR · INDEX-CHOOSE-OFFSET toggles. Walk an interviewer through any cell.
Drop your name into A1, replace placeholder data with your work (or use the included realistic Indian sample), bring on USB. The cell formulas are standard — you can walk an interviewer through any cell.
What a 30-min Excel round actually sounds like
3 mock transcripts in the pack. Read them like a play. Learn the conversation rhythm interviewers want.
[Interviewer]: Open this file. You'll see 12 monthly sales CSVs. Combine them into one model that refreshes when I drop in next month's file. You have 25 minutes. Talk me through your steps. [Candidate]: Got it. I'll use Power Query — Data tab → Get Data → From Folder → point at this folder. That gives me a list of all 12 files. Now I need to expand the binary content... [Interviewer]: Why Power Query and not just copy-paste? [Candidate]: Three reasons. One: when next month's file lands, I just refresh — no manual work. Two: Power Query handles schema differences (if one file has an extra column). Three: M-language steps document the transformation, so anyone on your team can audit it. Copy-paste is a one-time fix; this is a reusable pipeline. [Interviewer]: Walk me through what's happening in this 'Filtered Rows' step. [Candidate]: That's Table.SelectRows. It keeps rows where Extension equals ".csv". If you dropped a .xlsx in this folder, this step would exclude it. M-code is...
Full transcripts: Razorpay Ops 30-min Excel test · Cred BA Round 1 Pareto case · Deloitte FA 3-statement linking.
Is this the right pack for you?
30-second honest checklist.
This IS for you if...
- ✓You're interviewing for analyst / BA / MIS / financial analyst / HR Ops roles in the next 30 days
- ✓You know Excel basics but freeze on syntax under interview pressure
- ✓You've never built a portfolio dashboard you can SHOW interviewers
- ✓You're switching from service co → product co and don't know what Razorpay/Cred actually asks
- ✓Your last interview prep was a free GeeksforGeeks list and it didn't help
- ✓You want answers, not lectures — you don't have 60 hours for a Udemy course
This is NOT for you if...
- ✕You don't know what VLOOKUP does (try our Excel Master Pack ₹199 first)
- ✕You're preparing for the next 12 months — buy a course instead
- ✕You want live 1-on-1 coaching
- ✕You're applying for non-analyst roles where Excel is incidental
- ✕You're not interviewing in India
vs Free YouTube · Topmate · GFG · Coursera
Honest comparison. Pick what fits your situation.
Free content teaches Excel. This pack preps you for the interview. Different products.
What you get for ₹349
Every piece listed. Standalone value next to each.
₹349. The pack everyone else forgot to ship.
Less than two pizzas. Lifetime access. Free updates twice a year.
"Didn't help? Refund." promise
Buy. Read every question. Open the dashboards. Watch the mock transcripts. If 7 days from now you don't feel this gave you a real edge — email support@learnandexcel.in with the word "refund." We send your ₹349 back. You keep all the files. Zero questions, zero forms.
Questions buyers ask before clicking
Plain answers. No marketing-speak.
Tags are anchored to publicly-reported interview experiences on Glassdoor India, AmbitionBox, and Medium / LinkedIn interview write-ups (sources cited in the pack appendix). For instance: the Pareto 80-20 question is documented as asked at Amazon India BIE per a Medium AmEx article; the multi-file Power Query consolidation pattern is documented at Razorpay Ops / Microsoft India; the XLOOKUP-over-VLOOKUP scenario is documented at Razorpay BA. Where we infer (e.g. "TCS asks formula recall"), we say so. No fake quotes.
Three concrete differences: (1) GFG's list is generic, no India-company tags — we say "this was asked at Razorpay" with context. (2) GFG is stuck on VLOOKUP/Pivot — we cover XLOOKUP, FILTER, LET, LAMBDA, Power Query, Copilot which are increasingly asked in 2026 product-co interviews. (3) GFG has no portfolio dashboards — we ship 3 .xlsx dashboards you can show interviewers as your work.
Honest answer: this is interview-prep, not learn-Excel. If you don't yet know VLOOKUP, SUMIFS, and basic Pivots, start with our ₹199 Excel Master Pack first — that builds the foundation. Then come back to this pack 4-6 weeks before your interview. The 7-day prep plan included helps a refresher; the 14-day plan handles a deeper review.
One mega-PDF (250 Qs + 150 role add-ons + 5 case studies + scripts), 3 .xlsx portfolio dashboards (drop in your data, edit the company name in A1, take to interview), 3 cheat sheet PDFs, plus a separate 7-day and 14-day prep plan PDF. Total ~50MB. All instant download.
Yes — tested in Microsoft 365, Excel 2019/2021, Google Sheets, LibreOffice Calc 7.x. The dashboards use standard formulas (SUMIFS, COUNTIFS, INDEX-MATCH, XLOOKUP). No VBA, no Power Query in the dashboards themselves (Power Query is covered in the question bank but the .xlsx dashboards are pure-formula so they open anywhere).
Yes — that's literally the point. The dashboards ship with placeholder branding ("Your Company") and placeholder data. You replace "Your Company" with your current/previous employer's name, replace placeholder data with anonymised real data (or our included realistic Indian sample), and bring it on a USB / send a sample screenshot in your portfolio. The cell formulas are standard — you can walk an interviewer through any cell.
FY 2026-27 edition. Includes modern Excel functions (XLOOKUP, FILTER, LET, LAMBDA, GROUPBY, Copilot) that older prep materials don't cover. We update twice a year — once after Budget (Feb) and once after summer hiring cycle (Sep). Update lands free in your inbox.
We can't guarantee an offer — too many factors outside our control. What we can guarantee: if within 7 days of buying you don't feel this pack gave you a real edge, email support@learnandexcel.in with the word "refund" and we'll send your ₹349 back. You keep the files. Zero questions.
Honest answer: we're a new brand in this category and we'd rather have 10,000 people prepping with our pack than 1,500 paying ₹1,999. The ₹2,499 MRP reflects what comparable depth costs on Topmate / Udemy / Coursera. ₹349 reflects what we want fresh Indian analysts to be able to spend. After launch month, the price moves up.
We email about once a month when we ship new question banks or related products (Power BI Interview Prep, BA Toolkit, etc.). Every email has one-click unsubscribe. The ₹349 pack is complete on its own — nothing in it says "unlock this by buying more."
Walk in with company-tagged answers.
Walk out with the offer.
250 real questions. 3 portfolio dashboards. Modern Excel covered. Mock transcripts. One-time ₹349. Less than your last lunch with friends.
Instant download · Lifetime updates · 7-day refund · Excel Interview Crack Pack — 400 Real Qs