Excel skills for jobs:
what employers test in 2027

Despite BI tools and AI, Excel remains the everyday data tool in most Indian offices — in operations, finance, sales, HR and analytics. That is why job descriptions from MIS executive to data analyst list it, and why so many employers test it practically instead of trusting a CV line.

AmbitionBox's skill-based listings for data analysts, updated in October 2026, show roughly 15,200 Excel-tagged jobs and another 2,900 tagged "Advanced Excel".¹ MIS analyst roles, which are Excel-heavy, typically paid ₹4.2–4.7 lakh,² while roles that add SQL and BI tools pay more — Excel is the entry ticket, not the ceiling.

Excel-tagged data analyst jobs on AmbitionBox (Oct 2026)

~15,200

Jobs tagged "Advanced Excel" in the same listings

~2,900

Typical MIS analyst pay in India (AmbitionBox)

₹4.2–4.7 lakh

A typical practical Excel test

20 min

Table: Excel depth expected by role (editorial summary based on common job descriptions)

Table: How Excel is tested in hiring (editorial summary)

"What's the difference between relative and absolute references?"

Relative references change when copied; absolute references ($A$1) stay fixed. Mixed references fix only the row or column. Give the example of a tax rate in one cell used across a column.

"VLOOKUP, INDEX/MATCH or XLOOKUP?"

XLOOKUP where available — it looks in any direction, defaults to exact match and handles not-found values. INDEX/MATCH works in older versions and is robust to inserted columns. VLOOKUP is simple but can't look left and breaks when columns move.

"Count orders from Mumbai over ₹10,000."

=COUNTIFS(city_range,"Mumbai",amount_range,">10000").

"How would you summarise 50,000 sales rows by region and month?"

Convert to a table, insert a PivotTable, put region in rows, date (grouped by month) in columns and sales in values; add a slicer if needed.

"A SUM returns zero though there are numbers. Why?"

The numbers are probably stored as text; convert them with VALUE, Text to Columns or Paste Special multiply by 1.

"How do you highlight overdue tasks?"

Conditional formatting with a formula rule comparing the due date to TODAY().

"How do you remove duplicates but keep a record?"

Copy the data first or use UNIQUE in current Excel; Remove Duplicates changes the data in place.

"What is an Excel table and why use one?"

A structured range (Ctrl+T) that expands automatically, keeps formulas consistent and makes PivotTables and references easier to maintain.

Table: How Excel expectations have changed (editorial summary)

• A verified Excel test — timed, with a credential you can link.
• One practical workbook — messy data cleaned, summarised with a PivotTable and charted.
• No hard-coded numbers — assumptions in clearly labelled cells.
• A short note — the question the workbook answers.
• Microsoft Office Specialist if your target employers ask for it — Certiport runs the official exams.⁶

"Advanced Excel" is on nearly every CV, so be specific: "Excel — PivotTables, XLOOKUP, COUNTIFS/SUMIFS, conditional formatting, Power Query basics." Then show use: "Built a weekly delivery-delay report in Excel used by 6 city managers; cut report preparation from 4 hours to 30 minutes."

Copilot can now write formulas and suggest PivotTables from a prompt. That makes understanding more valuable: you need to know whether the formula does what you asked and whether the data underneath is clean. The World Economic Forum names analytical thinking as the most-wanted core skill,⁷ and in a spreadsheet that looks like checking totals against a known number before sending anything.

1. Week 1: Foundations — References, core formulas, formatting, tables. Practise on a real dataset daily.
2. Week 2: Lookups and conditional formulas — XLOOKUP, VLOOKUP, INDEX/MATCH, COUNTIFS, SUMIFS.
3. Week 3: PivotTables and charts — Ten PivotTables from different questions; build one clean chart per PivotTable.
4. Week 4: Test conditions — Timed practice workbooks, then take the Microsoft Excel Fundamentals Certification and fix weak spots.

Next steps: the Advanced Excel test for analyst roles, Excel for Business Analysis for finance and business roles, and SQL Fundamentals to move into data analysis. Our Advanced Excel guide covers the next level.

Task: "Total delayed shipments by city, find each shipment's customer name, flag anything over five days late."

1. Convert to a table — Select the data and press Ctrl+T, so formulas and PivotTables expand with new rows.
2. Fix dates — If some dates are left-aligned text, use Data → Text to Columns or DATEVALUE so they calculate.
3. Days late — Add a column: =[@[Delivered]]-[@[Promised]].
4. Customer name — =XLOOKUP([@[CustomerID]], Customers[ID], Customers[Name], "Not found").
5. Delayed by city — Insert a PivotTable with City in rows and a count of shipments filtered to Days late > 0 (or add a "Delayed" yes/no column and use it as a filter).
6. Flag — Conditional formatting on Days late with the rule "greater than 5".

Before handing it in, check one city's count manually with COUNTIFS. That last check is what interviewers remember.

1. Messy-to-clean — Download a messy public dataset (data.gov.in has many CSVs), fix text numbers, dates and duplicates, and convert it to an Excel table.
2. Ten PivotTables — Ask ten different questions of the same data and answer each with a PivotTable in under two minutes.
3. Lookup drill — Match a 2,000-row list to a master sheet with XLOOKUP, then with VLOOKUP and INDEX/MATCH; deliberately break each and fix it.
4. Exception report — Use COUNTIFS, SUMIFS and conditional formatting to flag late, over-budget or missing items.
5. Twenty-minute test — Set a timer and complete a five-task workbook; check every total against the source.

Excel is an entry point, and the roles it opens grow in pay as you add SQL, BI tools and business ownership. Typical pay on AmbitionBox, October 2026:

Table: Roles that rely on Excel and their typical pay in India (AmbitionBox, October 2026; indicative)

• Not checking results against a quick manual total.
• Merged cells and blank rows inside data.
• Approximate-match lookups by accident.
• Slow mouse-only work — learn a few shortcuts (Ctrl+T, Ctrl+Shift+L, F4, Alt+=).
• Over-formatting instead of answering the question.

Job-listing and pay figures come from AmbitionBox's data analyst and MIS analyst pages (read October 2026). Excel function references are Microsoft Support pages; certification details come from Certiport. Market context comes from the World Economic Forum. Test formats and the history table are editorial summaries. Science of Apps publishes the free certification linked here; it is not affiliated with Microsoft. Last reviewed October 2026.

• Cell reference — the address of a cell used in a formula, such as B2.
• Absolute reference — a reference that doesn't change when copied, written with $.
• Lookup — finding a value in one table based on a matching key in another.
• PivotTable — a tool that summarises many rows by categories without formulas.
• Excel table — a structured range with headers that expands as data is added.
• Conditional formatting — formatting that changes automatically based on a cell's value.