Excel Skills Employers Want: From Basics to Advanced

Last updated: 8 October 2026 · By the Asuraa Team

Quick answer: Employers want Excel users who can clean data, summarise it with PivotTables, look up values across sheets and present results accurately. For most fresher roles, that means confident use of SUMIFS, COUNTIFS, XLOOKUP or VLOOKUP, IF logic and PivotTables; analyst roles add Power Query and dashboards. Note that Microsoft says XLOOKUP is not available in Excel 2016 or 2019, so learn VLOOKUP and INDEX-MATCH too.

Key takeaways

• Most fresher roles in India expect intermediate Excel: IF logic, COUNTIFS, SUMIFS, lookups, text and date functions, and PivotTables.
• Microsoft says XLOOKUP can search in either direction and needs no column index number, but it is not available in Excel 2016 or Excel 2019.
• Microsoft's documentation says SUMIFS accepts up to 127 range and criteria pairs and puts the sum range first, unlike SUMIF.
• Power Query records data-cleaning steps in the M language so the same transformations can be refreshed on new data, in both Excel and Power BI Desktop.
• Microsoft lists the MO-200 Excel Associate (Office 2019) exam at 50 minutes, covering worksheets, cells and ranges, tables, formulas and functions, and charts.

Excel is still the most common data tool in Indian offices. Analysts, MIS executives, finance and operations teams, HR, sales and even software teams use it every day, and many interview processes for analyst and business roles include an Excel task. The skills employers want fall into clear levels, and you can climb them in a few weeks of focused practice.

Which Excel skills do employers want?

Employers want you to clean data, summarise it, look things up across sheets, and present results clearly, all quickly and without errors. In practice that breaks into three levels:

If you can do everything in the intermediate row confidently and fast, you will clear most Excel screening rounds for fresher roles.

Which Excel formulas should you learn first?

Learn the lookup and conditional-aggregation formulas first, because they solve most everyday business questions. A suggested order:

1. SUM, AVERAGE, COUNT, COUNTA, MIN, MAX with correct absolute ($A$1) and relative references.
2. IF, nested IF and IFS, combined with AND and OR, for categorising data.
3. COUNTIFS and SUMIFS for totals that meet several conditions. Microsoft's SUMIFS documentation says you can use up to 127 range and criteria pairs, and warns that the sum range is the first argument in SUMIFS but the third in SUMIF, a common source of errors.
4. XLOOKUP for finding values in another table. According to Microsoft Support, XLOOKUP can search in either direction, uses separate lookup and return ranges so you need no column number, and lets you set a value to show when nothing is found. It is not available in Excel 2016 or 2019.
5. VLOOKUP and INDEX with MATCH, because many companies still run older Excel versions and older workbooks are full of them.
6. Text and date functions: TRIM, LEFT, RIGHT, MID, TEXT, CONCAT or TEXTJOIN, DATE, EOMONTH, NETWORKDAYS, DATEDIF.
7. IFERROR to keep reports clean.

How do PivotTables help in a job?

PivotTables let you summarise thousands of rows in seconds without writing formulas, which is why they appear in almost every Excel interview. Microsoft's PivotTable guide describes them as a way to calculate, summarise and analyse data to spot comparisons, patterns and trends, and recommends source data in columns with a single header row.

Skills to practise:

• Build a PivotTable from an Excel Table so it picks up new rows on refresh.
• Group dates by month, quarter and year.
• Show values as percentage of total, running totals and differences from the previous period.
• Add slicers and timelines for interactive filtering.
• Create a PivotChart and a small dashboard from two or three PivotTables.

What is Power Query and why does it matter?

Power Query is Excel's built-in tool for importing and cleaning data in repeatable steps, and it is the skill that most separates advanced users from intermediate ones. Microsoft's Power Query overview says it connects to many data sources, records each transformation (removing columns, filtering, merging, appending, unpivoting) as a step in the M language, and lets you refresh the query to apply the same steps to new data. It is available in Excel for Windows and Mac and in Power BI Desktop.

That last point matters for your career: if you learn Power Query in Excel, you have already learned a large part of Power BI. If BI roles interest you, read How to Learn Power BI for Jobs.

A typical use case: every month, your manager sends five regional sales files with slightly different layouts. With Power Query, you combine and clean them once, and next month you only click Refresh.

How are Excel skills tested in interviews?

Excel is usually tested through a short practical task, conceptual questions, or both. For freshers in analyst, MIS and operations roles, common formats are:

• Live task (20-45 minutes): you get a dataset and questions such as "total sales by region and month", "find the top five products", or "flag orders delivered late". You are judged on accuracy, speed and how clean the output is.
• Formula questions: "What is the difference between VLOOKUP and XLOOKUP?", "How would you count unique customers?", "What does the $ sign do in a formula?"
• Scenario questions: "Two sheets have customer IDs with extra spaces. How would you match them?" (TRIM, then a lookup, or Power Query).
• Dashboard task for analyst roles: build a one-page summary with PivotTables, charts and slicers.

Practise by timing yourself on public datasets. Our data analyst interview questions and business analyst interview questions include more examples.

Is an Excel certification worth it?

An Excel certification can help a fresher with no work experience show baseline skills, but a practical test or portfolio usually counts for more. The Microsoft Office Specialist: Excel Associate (Office 2019) certification, exam MO-200, covers managing worksheets and workbooks, managing data cells and ranges, managing tables, formulas and functions, and charts, according to Microsoft Learn, which lists the exam at 50 minutes.

Note what is missing from that list: Power Query and PivotTable-based analysis are not among its listed skill areas. So treat the certification as proof of fundamentals, and show advanced skills through a project.

How can you build job-ready Excel skills in four weeks?

Practise on real-looking business data every day and finish with a project. A simple four-week plan:

Put the final dashboard in your portfolio and describe it on your resume with the techniques used. Our guide to data analyst portfolio projects shows how to present it.

What do most guides on Excel skills get wrong?

Most guides list fifty formulas and suggest you memorise them. Employers care far more about whether you can structure messy data and get a correct answer quickly. Clean source data in an Excel Table, a sensible layout and a quick sanity check of totals will impress an interviewer more than an obscure function.

Many guides also skip version differences. XLOOKUP and dynamic arrays are not available in Excel 2016 or 2019, and many Indian offices still run older versions, so know VLOOKUP and INDEX-MATCH too. Finally, list Excel specifically on your resume, such as "PivotTables, Power Query, XLOOKUP, SUMIFS", rather than "MS Office". See how to list skills on a resume for examples.

FAQ

What Excel skills should I put on my resume?

Name specific skills rather than writing 'MS Office'. For most fresher roles, list SUMIFS and COUNTIFS, XLOOKUP or VLOOKUP, INDEX-MATCH, PivotTables, conditional formatting, data validation and charts. For analyst roles, add Power Query and dashboards. Back each skill with a project line, because interviewers often test exactly what you list.

What is considered advanced Excel?

Advanced Excel usually means Power Query for repeatable data cleaning, dynamic array functions such as FILTER, UNIQUE and SORT, data model and Power Pivot basics, what-if analysis, interactive dashboards and awareness of macros or automation. Employers hiring data, finance and business analysts often expect at least Power Query and strong PivotTable skills.

Should I learn VLOOKUP or XLOOKUP?

Learn both. XLOOKUP is more flexible: it searches in either direction, needs no column number and handles not-found results neatly. But Microsoft notes it is unavailable in Excel 2016 and 2019, which many offices still use, so you will meet VLOOKUP and INDEX-MATCH in older workbooks and interviews.

How is Excel tested in job interviews?

Commonly through a 20 to 45 minute practical task on a dataset, such as totalling sales by region and month, finding top products or flagging late orders, plus questions on formulas and references. Analyst roles may ask for a one-page dashboard. Accuracy, speed and a clean, readable output matter most.

Is the Microsoft Excel certification useful for freshers?

It can show baseline skills when you have no work experience. Microsoft lists the MO-200 Excel Associate (Office 2019) exam at 50 minutes, covering worksheets, cells and ranges, tables, formulas and functions, and charts. It does not list Power Query among its skill areas, so demonstrate advanced skills through a project as well.

How long does it take to learn Excel for a job?

With an hour or two of daily practice, most people can reach job-ready intermediate level in about four weeks: formulas and lookups in the first two weeks, PivotTables in the third and Power Query with a dashboard in the fourth. Practising on realistic business data matters more than the number of hours.

Final thoughts

Excel skill is judged by what you can do with messy data under time pressure, not by how many functions you can name. Master lookups, conditional totals and PivotTables, then add Power Query and a dashboard project. When your resume is ready, check how well it matches a target role with the Asuraa AI resume reviewer.