In my recruiter years between 2018 and 2024, I personally screened 1,200+ Excel test attempts across data analyst, business analyst, consulting analyst, and operations roles. The failure rate was brutal — about 70% of freshers failed the first Excel test. The bar is not high. Most just hadn’t practiced the right things.
This post is the exact Excel prep playbook I now run mentees through before interviews. Built on real test exercises I’ve seen at companies like Deloitte, PwC, Bain, Genpact, ZS Associates, Accenture Strategy, EY, KPMG, Razorpay, Zomato, and Flipkart. By the end, you’ll know what to drill, in what order, and to what standard.
What level of Excel do Indian job interviews actually test?
Let me set the bar honestly. Most fresher Excel tests cover 4 layers: basic functions, lookups, summarization (pivots), and 1 simple chart. Senior analyst roles add Power Query and basic VBA. Niche finance roles add scenario analysis and what-if. The expert “Excel guru” image is irrelevant — nobody is expected to know all 480 Excel functions.
What recruiters actually want to see: can you take a messy CSV, clean it in 30 minutes, summarize it into 3 key insights, and present those insights in 2 charts or 1 pivot table? That’s the test. The functions are means to that end.
The 8 Excel functions you MUST know cold
Drill these to muscle memory. You should be able to write each one in under 30 seconds without Googling.
1. VLOOKUP and XLOOKUP
VLOOKUP is still tested in 90% of interviews because of legacy systems. XLOOKUP is the modern replacement (Excel 365). Learn both. The standard interview ask: “Given two tables — orders and customers — pull customer name and city into the orders table using their customer ID.”
2. INDEX-MATCH
The pre-XLOOKUP workhorse. Some interviewers specifically ask “do this without VLOOKUP” to test depth. Practice typing it without thinking: =INDEX(return_range, MATCH(lookup_value, lookup_range, 0))
3. SUMIFS and COUNTIFS
The two most-tested conditional aggregation functions. “How many orders from Bengaluru in March?” → =COUNTIFS(City:City, "Bengaluru", Month:Month, "March"). “Total revenue from Premium customers?” → =SUMIFS(Revenue:Revenue, Tier:Tier, "Premium").
4. IF / IFS / nested IF
Tier classification questions. “Mark orders above Rs. 10,000 as ‘High Value’, Rs. 5,000-10,000 as ‘Mid’, below 5,000 as ‘Low’.” → =IFS(A2>10000, "High", A2>5000, "Mid", TRUE, "Low").
5. TEXT functions: LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE
For cleaning messy text data. Phone numbers with country codes, names with extra spaces, IDs embedded in long strings. Memorize these 6.
6. DATE functions: TODAY, DATEDIF, EOMONTH, WEEKDAY
Cohort analysis, customer tenure, day-of-week trends. =DATEDIF(start_date, TODAY(), "Y") gives years between dates.
7. IFERROR
Wrap every lookup formula in IFERROR for production-quality work. =IFERROR(VLOOKUP(...), "Not Found"). Recruiters notice when you do this. They notice harder when you don’t and your sheet shows #N/A all over.
8. UNIQUE / SORT / FILTER (Dynamic Arrays)
Excel 365’s modern functions. Get unique values, sort and filter without copy-paste. Most interview machines now have 365. Practice with these — they make you look senior.
How important are Pivot Tables in Excel interviews?
Critical. Roughly 80% of fresher analyst interviews have a pivot table task. The standard ask: “Summarize this sales data by region and product category, showing total revenue and order count.” A confident candidate builds this in 90 seconds. A nervous candidate takes 8 minutes and asks for help. Practice until you’re the first kind.
Cover these specific pivot features: Filters, Rows, Columns, Values. Sum, Average, Count, % of Grand Total, % of Row Total. Grouping by date (months, quarters, years). Adding calculated fields. Refreshing data after source change.
What does a typical Indian fresher Excel interview test look like?
Here’s a real test I administered at my last recruiting firm in 2024 — anonymized. Time: 60 minutes. Dataset: 8,000 rows of e-commerce order data with messy formatting.
| Task | Skill Tested | Time Expected |
|---|---|---|
| 1. Clean phone numbers (remove +91, spaces, special chars) | SUBSTITUTE, LEFT, RIGHT | 5 min |
| 2. Calculate customer tenure in years from signup date | DATEDIF, TODAY | 3 min |
3. Tier customers: A (>Rs. 50k LTV), B (Rs. 20-50k), C (| IFS, SUMIFS | 7 min | |
| 4. Pivot: revenue by category x month, top 5 categories | Pivot Table, sort filter | 10 min |
| 5. Conditional format: highlight late deliveries in red | Conditional formatting | 5 min |
| 6. Build a line chart of monthly revenue trend | Charts | 5 min |
| 7. Write 3 key insights in 5 bullet points | Communication | 15 min |
Total: 50 minutes of work, 10 minutes buffer. Pass criteria: complete 6 of 7 tasks correctly. The candidates who passed weren’t the fastest typists. They were the ones who didn’t panic at the messy data and worked systematically.
How should I practice Excel in 30 days?
The 30-day plan I give mentees. 90 minutes daily, no exceptions. Pair this with our 30-day skill learning framework for the full structure.
| Week | Focus | Daily Output |
|---|---|---|
| 1 (Day 1-7) | The 8 core functions; pivot table basics | 1 practice file per day |
| 2 (Day 8-14) | Advanced pivots, dynamic arrays, conditional formatting | 1 mini dashboard per day |
| 3 (Day 15-21) | Power Query, data cleaning workflows, charts | 1 cleaning project per day |
| 4 (Day 22-30) | Full interview-style mock tests on Kaggle datasets | 1 full mock per day |
Where to find practice datasets: Kaggle.com (free, search “retail sales”, “e-commerce”, “HR analytics”), data.gov.in for Indian-context datasets, and the official Excel sample workbooks Microsoft provides.
What’s the difference between Excel and Google Sheets for interviews?
Excel is what 95% of Indian corporate interviews still use. Google Sheets is increasingly accepted in startups and tech companies (Razorpay, Zerodha, smaller product cos). The formulas are 90% identical with minor syntax differences. If you’re targeting startups specifically, learn both. For everyone else, master Excel first — Sheets becomes intuitive after.
How do I show Excel skills on my resume?
Don’t just write “Proficient in Excel.” Every fresher writes that. Instead, be specific about what you can do.
And critically, pair your Excel resume claim with our complete resume writing guide and the interview preparation guide so the rest of your resume holds up to the same standard.
The 5 mistakes that fail you in Excel interviews
- Hardcoding values instead of cell references. Writing
=A2*0.18when 0.18 is the GST rate. Use a named cell or another reference. Recruiters hate hardcodes. - Not using IFERROR. Showing #N/A in your final sheet looks unprofessional. Wrap all lookups in IFERROR.
- Manual sorting instead of pivot tables. If the answer requires aggregation, use a pivot. Manual sort+filter is a junior move.
- Panic at messy data. Real interview datasets have extra spaces, mixed case, blank rows, inconsistent date formats. Don’t freeze. Use TRIM, CLEAN, PROPER, and Power Query to handle systematically.
- Skipping the insight summary. Most candidates rush the calculations and skip the 3-bullet insight summary. Recruiters care about the insight more than the formula. Always reserve 10 minutes for analysis at the end.
How do I add Power Query as a differentiator?
Power Query is the single biggest “next level” skill you can add. Only about 8% of freshers I’ve interviewed knew Power Query. It instantly bumps you from “average fresher” to “interesting candidate.” Spend the last week of your prep on this.
What to learn: connecting to a CSV/Excel source, removing blanks, splitting columns, merging queries (like SQL JOIN), unpivoting columns, and refreshing data. That’s 80% of real-world Power Query use. The Microsoft Learn module covers all of this for free in 4 hours.
FAQ
How many hours of Excel practice do I need for an interview?
40 hours of focused, deliberate practice gets a beginner to the level needed for 85% of fresher Excel rounds. Distribute as 90 minutes/day across 30 days. Beyond 40 hours you’re optimizing, not learning. After 40 hours, switch focus to one substantial dashboard project.
Is VBA worth learning for fresher interviews?
Not for general analyst roles. Worth it for specialized operations or BFSI roles where automation is core. If your target job description mentions VBA explicitly, spend 10 hours on basic macros. Otherwise, time better spent on Power Query.
Should I use shortcuts during the interview test?
Yes, but only ones you’ve practiced. Don’t try a new shortcut for the first time during the test. Master these 10: Ctrl+T (table), Ctrl+Shift+L (filter), Alt+= (autosum), Ctrl+; (today’s date), Ctrl+D (copy down), F4 (lock reference / repeat), Ctrl+Shift+Arrow (select to end), Alt+N+V (insert pivot), Ctrl+Page Up/Down (switch sheets), F2 (edit cell).
Which Excel certifications are worth doing?
Microsoft Office Specialist Excel Associate (Rs. 4,500 exam) carries the most credibility, but it’s optional. The LinkedIn Learning Excel certificate (free with 1-month trial) is fine for resume listing. Skip random Udemy Excel certs — they’re padding. Pair any cert with a real dashboard project. See our free certifications guide for context.
Can I use ChatGPT during Excel interview tests?
Almost always no. 90% of in-office tests are on isolated machines with no internet. Some remote tests allow Google but explicitly ban AI tools. Even when AI is allowed, recruiters watch for blind copy-paste. Build the muscle to do it yourself first; use AI as a sanity check, not a crutch.
Final word from Ananya
Excel is the most leverage-able skill on an Indian fresher resume in 2026. 30 days of focused practice. 8 core functions. Pivot tables. Power Query as your differentiator. A dashboard project to showcase it. Do this, and the Excel round of any analyst, consulting, banking, or operations interview becomes a confidence-building round instead of an elimination round. Start tonight with one practice file.