How to Learn Excel for a Job Interview
Exactly which Excel skills employers test in interviews — and a practical 7-day study plan to go from nervous to confident.
Why Excel Still Matters in Job Interviews in 2026
If you’ve been applying for jobs in finance, operations, HR, sales, logistics, or any data-related role, you’ve likely seen “proficiency in MS Excel” listed as a requirement. It’s not decorative — employers increasingly use Excel tests as part of their screening process, sometimes before you even get a face-to-face interview.
And the stakes are real. Many candidates lose opportunities not because they lack the right experience, but because they can’t confidently use the spreadsheet tool sitting on every office computer. The good news: Excel is learnable, testable, and with the right preparation, passable in a week.
This guide is written specifically for job seekers in India — freshers, working professionals changing roles, and anyone facing an upcoming Excel assessment.
Excel appears in over 3 lakh job listings on Indian job portals. Roles from data entry to MIS analyst to finance executive all require it — and the higher the role, the more advanced the test.
What Employers Actually Test in an Excel Interview
Most Excel interview tests fall into three categories:
1. Written / Multiple Choice Questions
Fast to answer — “Which formula finds a value in a table?” or “What does Ctrl+Shift+End do?” These test conceptual knowledge. You can prepare for these in a day by reviewing formula definitions and keyboard shortcuts.
2. Practical / Hands-On Test
The most common format. You’re given a real spreadsheet and asked to complete tasks — clean data, write a VLOOKUP, build a Pivot Table, create a chart. This is what most people fail to prepare for properly.
3. Take-Home Task
For senior roles — you get raw data (like sales figures or HR records) and are asked to produce a one-page analysis. This tests not just formula knowledge but your ability to draw insights and present them clearly.
⚠️ Don’t rely on memorising answers. Employers specifically design practical tests to catch people who’ve only studied theory. You must actually practice in Excel, not just read about it.
Excel Skills Tested by Job Level
Different roles test different things. Know which level applies to your target job:
| Job Role | Level | Key Skills Tested |
|---|---|---|
| Data Entry, Admin, Secretary | Basic | Sum, Count, Copy-Paste, Sort, Filter, basic formatting |
| Sales Executive, HR, Operations | Intermediate | IF, VLOOKUP, SUMIF, basic Pivot Tables, Charts |
| MIS Executive, Finance Analyst | Intermediate+ | INDEX-MATCH, SUMIFS, COUNTIFS, Pivot Charts, Dashboards |
| Data Analyst, Senior Finance, Manager | Advanced | Power Query, Macros, advanced Pivot Tables, complex formulas |
Top Excel Formulas to Know for Any Interview
These are the formulas that appear most often in Indian Excel interview tests, in order of how commonly they’re tested:
1. VLOOKUP — Still the most tested formula
Find a value in one column and return a corresponding value from another.
Example: Find the salary of an employee based on their Employee ID in another sheet.
Always use FALSE as the last argument unless you’re told the data is sorted. Using TRUE (approximate match) on unsorted data returns wrong results — and interviewers know this mistake.
2. IF and nested IF
Return different values based on a condition.
3. SUMIF and SUMIFS
Sum values that meet one or more conditions — very common in sales and finance tests.
4. COUNTIF and COUNTIFS
Count cells that meet conditions — used in HR and operations data.
5. INDEX and MATCH — more powerful than VLOOKUP
Can look up values in any direction (left, right, up, down) — asked in intermediate to advanced tests.
6. XLOOKUP — the modern replacement for VLOOKUP
Available in Microsoft 365 / Office 2021. If the company uses a recent Excel version, this may appear.
7. TEXT and date functions
Common in HR data tests — extracting day, month, year from dates.
Pivot Tables — The #1 Most Tested Skill
If there’s one thing you absolutely must know before an Excel interview, it’s Pivot Tables. Almost every intermediate and advanced Excel test includes at least one Pivot Table task.
Employers use it to instantly separate people who have genuinely worked with data from people who only know formulas on paper.
What you need to be able to do:
- Insert a Pivot Table from a data range
- Drag fields to Rows, Columns, Values, and Filters
- Change the summary function (Sum → Count → Average)
- Add a Slicer to filter data interactively
- Group date data by Month and Year
- Create a Pivot Chart from a Pivot Table
Download any sales dataset (many free ones on Kaggle or government data portals). Insert a Pivot Table that shows total sales by Region and by Month. Then add a Slicer for Product Category. If you can do this comfortably without looking anything up, you’ll pass most interview Pivot Table tests.
7-Day Study Plan to Pass Your Excel Interview
You don’t need months — one focused week is enough to go from basics to interview-ready for most roles. Here’s the plan:
Foundation & Core Formulas
SUM, COUNT, AVERAGE, IF, SUMIF, COUNTIF. Practice on dummy data you create yourself.
2 hrs/dayLookup Formulas
VLOOKUP, INDEX-MATCH, XLOOKUP. Build a mini employee database and look up values from it.
2 hrs/dayPivot Tables & Charts
Build 3 different Pivot Tables from real data. Add Slicers and create a Pivot Chart.
2 hrs/dayMock Test
Download a free Excel practice test online. Complete it under time pressure — no looking things up.
1–2 hrsKeyboard Shortcuts
Ctrl+C/V/Z, Ctrl+Shift+L (filter), Alt+= (AutoSum), F4 (lock reference). Speed matters in timed tests.
10 min/dayConditional Formatting
Often appears in basic and intermediate tests. Highlight duplicates, create data bars, apply rules.
30 minCommon Mistakes to Avoid
1. Studying only theory, not practicing
Reading about VLOOKUP and typing a VLOOKUP are completely different. Your fingers need to know where to click, not just your brain. Always practice in the actual Excel application.
2. Using absolute vs relative references incorrectly
One of the most common errors in practical tests. If you drag a formula down and it breaks, you’ve likely forgotten to lock a reference with $. Example: =VLOOKUP(A2,$D$2:$F$100,2,FALSE) — the table array should be locked.
3. Not knowing your Excel version
XLOOKUP works in Microsoft 365 and Office 2021+ but not in older versions. Before a test, check which Excel version the company uses. If they’re on Office 2016, XLOOKUP won’t work — use VLOOKUP or INDEX-MATCH instead.
4. Panic-scrolling during timed tests
Use Ctrl+End to jump to the last used cell and understand the data quickly. Use Ctrl+F to find specific values. These shortcuts save minutes when you’re under pressure.
5. Ignoring data cleaning tasks
Many practical tests include messy data — extra spaces, mixed formats, duplicates. Know how to use Remove Duplicates, Text to Columns, TRIM(), and PROPER() to clean data quickly.
Want personalised interview prep coaching?
We offer one-on-one Excel coaching specifically focused on what your target industry tests — finance, operations, HR, IT, and more.
Final Checklist Before Your Excel Interview
Use this list the day before your interview to confirm you’re ready:
- VLOOKUP and INDEX-MATCH — can write from memory, know when to use each
- IF, SUMIFS, COUNTIFS — confident with multiple criteria
- Pivot Table — can insert, arrange fields, group by date, add Slicer
- Charts — can create a column/bar/line chart and format it cleanly
- Absolute references ($) — know when to lock rows, columns, or both
- Data cleaning — TRIM, Remove Duplicates, Text to Columns
- Conditional formatting — can highlight cells based on rules
- Keyboard shortcuts — at least 10 core shortcuts memorised
- Practised under time pressure — done at least one timed mock test
- Know the Excel version the company uses — check before the interview
You Can Do This
Excel interviews feel intimidating because most people have never been formally taught Excel — they’ve picked it up gradually, inconsistently, and never tested themselves under pressure. That’s not a skill gap, it’s a preparation gap.
One focused week, practicing in the actual tool with real data, will put you ahead of the majority of candidates who only know they “should” practice but never actually sit down and do it.
If you want structure, accountability, and a trainer who knows exactly what your target industry tests — that’s what our individual Excel coaching sessions are designed for. You tell us the role and company type, we build the session around what they test.