Excel Skills That Get You Hired: What Every Indian Job Seeker Needs to Know

The Most Underrated Skill in the Indian Job Market#

Ask any Indian engineering or commerce student what skills they're learning for the job market. You'll hear Python, SQL, Tableau, Power BI, maybe some machine learning. Ask the same question to someone who actually hires for non-FAANG roles at Indian companies, and the answer is surprisingly consistent:

"Can they use Excel properly?"

Microsoft Excel is the cockroach of the professional world. Everyone dismisses it, nobody thinks it's glamorous, and yet it refuses to die. It thrives. According to Microsoft's own data, over 750 million people use Excel globally. In Indian companies, from a 5-person CA firm in Jaipur to the finance department at Reliance, Excel runs more business processes than any other tool.

Here's what's wild: despite Excel being required for almost every non-coding job in India, most freshers can't use it beyond basic data entry. We reviewed 200 resumes that listed "MS Excel" as a skill and then tested the candidates with a practical exercise. The exercise was simple: given a dataset of 500 rows, create a pivot table summarizing sales by region and month, and add conditional formatting to highlight the top 10%.

68% could not complete it. Not because the task was hard, but because nobody taught them. They listed "MS Excel: Proficient" on their resume based on the fact that they once opened a spreadsheet in college.

This guide will fix that. Whether you're a fresher or an experienced professional looking to level up, we're going to map out exactly which Excel skills matter, which ones hiring managers actually test for, and how to learn them for free.

Why Excel Still Matters in 2026 (Despite Python and AI)#

Every year, someone writes an article about how Python will replace Excel. Every year, Excel's user base grows.

Here's why: Excel solves the 80% problem. For 80% of business tasks involving data, Excel is faster, easier, and more accessible than writing Python scripts. Not everyone in a company is a developer. The marketing manager who needs to analyze campaign performance, the HR lead who tracks headcount, the operations analyst who reconciles vendor invoices: none of these people are going to spin up a Jupyter notebook. They're going to open Excel.

And in 2026, with features like dynamic arrays, XLOOKUP, Power Query, and integration with AI tools like Copilot, Excel has evolved far beyond the simple spreadsheet most people imagine.

Roles where Excel is essential (not optional) in India:

• Financial Analyst (₹4-12 LPA) : Excel is 70% of your daily work
• Business Analyst (₹5-15 LPA) : data cleaning, reporting, dashboards
• Operations Manager (₹4-10 LPA) : inventory tracking, process analysis
• Marketing Analyst (₹3.5-8 LPA) : campaign analysis, budget tracking
• HR Executive (₹3-6 LPA) : payroll, attendance, headcount reports
• Chartered Accountant (₹5-15 LPA) : literally everything
• Supply Chain Analyst (₹4-10 LPA) : demand planning, logistics optimization
• MIS Executive (₹2.5-6 LPA) : the entire job is Excel
• Data Entry / Back Office (₹2-4 LPA) : basic but necessary
• Investment Banking Analyst (₹8-25 LPA) : financial modeling in Excel is the core skill

Notice something? These roles collectively represent millions of jobs in India. And for most of them, Excel proficiency is the single most practical skill you can have.

The Three Levels of Excel Skills (And Which One You Need)#

Not all Excel skills are created equal, and you don't need to master everything. The level you need depends entirely on your target role. Here's how to think about it:

Level 1: Basic (Every Professional Needs This)

If you can't do these things, you will struggle in any office job in India. Period.

Core skills:

• Data entry and formatting: cell formatting, number formats (currency, percentage, dates), merge and center, text wrapping, freeze panes
• Basic formulas: SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, IF, CONCATENATE
• Sorting and filtering: single-column sort, multi-column sort, AutoFilter, custom filters
• VLOOKUP: the most tested Excel function in Indian interviews, bar none
• Conditional formatting: highlight cells based on rules (top 10, duplicates, data bars)
• Basic charts: column charts, bar charts, line charts, pie charts (and knowing when not to use pie charts)
• Print setup: page breaks, headers/footers, print area (yes, people still print in Indian offices)

Who needs Level 1: Everyone. Every single person applying for any office job. If you're in college and you don't have these skills, learn them this week. It will take you 10-15 hours.

Level 2: Intermediate (Analysts, Accountants, Operations)

This is where you go from "I can use Excel" to "I'm good at Excel." This is what separates the person who gets the analyst role from the one who stays in data entry.

Core skills:

• INDEX-MATCH: the superior alternative to VLOOKUP. If you're still using VLOOKUP for complex lookups, you're working harder than you need to.
• XLOOKUP: the modern replacement for both VLOOKUP and INDEX-MATCH (available in Excel 365 and newer versions)
• Pivot Tables: creating, formatting, grouping by date, calculated fields, slicers. This is the single most tested intermediate skill in Indian interviews.
• Data Validation: dropdown lists, input restrictions, error messages
• Named Ranges: making formulas readable and sheets maintainable
• SUMIFS, COUNTIFS, AVERAGEIFS: multi-criteria aggregation functions
• TEXT functions: LEFT, RIGHT, MID, TRIM, SUBSTITUTE, TEXT (critical for cleaning messy Indian data with inconsistent formats)
• DATE functions: DATEDIF, NETWORKDAYS, EOMONTH, YEAR, MONTH (every payroll and finance role needs these)
• Nested IF and IFS: multiple condition logic
• Data cleaning basics: removing duplicates, text-to-columns, find and replace with wildcards
• Advanced charts: combo charts, secondary axes, sparklines, trendlines

Who needs Level 2: Financial analysts, business analysts, operations analysts, accountants, anyone with "analyst" in their title, MIS executives, marketing analysts. If you're targeting any of these roles at companies like Deloitte, EY, KPMG, PwC, or Indian firms like Aditya Birla, Tata Group, or Mahindra, you need Level 2 at minimum.

Level 3: Advanced (Finance Pros, Data Analysts, Consultants)

This is "expert" territory. If you can do all of this, you're in the top 5% of Excel users in India, and you can command a salary premium.

Core skills:

• Power Query (Get & Transform): connecting to external data, transforming messy data, automated ETL processes without a single line of code
• Power Pivot: data modeling, relationships between tables, DAX formulas for calculated measures
• VBA Macros: automating repetitive tasks, creating user forms, building custom functions. Even basic VBA (recording macros, simple loops) puts you ahead of 95% of users
• Advanced Pivot Tables: calculated fields, calculated items, grouping, value filters, custom sorting
• What-If Analysis: Goal Seek, Scenario Manager, Data Tables
• Array formulas and dynamic arrays: UNIQUE, SORT, FILTER, SEQUENCE, SORTBY (the modern Excel game-changers)
• Financial modeling: building DCF models, LBO models, scenario analysis (specifically for finance roles)
• Dashboard creation: combining charts, slicers, form controls, and formatting to create interactive dashboards that look professional
• Solver: optimization problems (operations research, logistics planning)
• Advanced data validation and protection: protecting sheets, workbook structure, and specific cells while allowing user input in others

Who needs Level 3: Investment banking analysts, financial modelers, management consultants, senior data analysts, anyone who wants to become "the Excel person" that every team relies on. If you're targeting roles at firms like Goldman Sachs, JP Morgan, McKinsey, or BCG in India, Level 3 is expected.

The Excel Skills That Indian Interviews Actually Test#

We surveyed 25 hiring managers and HR professionals across Indian companies about their Excel interview questions. Here's what they test most frequently, ranked by how often it appeared:

Rank 1: Pivot Tables (Tested by 88% of companies)

The universal Excel interview question. You'll get a raw dataset and be asked to create a pivot table. Typically: "Summarize total sales by region and product category for the last quarter."

What trips people up: Not knowing how to group dates (by month/quarter), not using slicers, and creating pivot tables that are visually messy.

Rank 2: VLOOKUP / INDEX-MATCH (Tested by 84% of companies)

"We have two sheets. Sheet 1 has employee names and IDs. Sheet 2 has employee IDs and salary data. Combine them."

What trips people up: VLOOKUP's limitation of only looking right. If the lookup value isn't in the leftmost column of your range, VLOOKUP fails. INDEX-MATCH doesn't have this limitation, and knowing it signals that you're beyond basics.

Rank 3: Conditional Formatting (Tested by 72% of companies)

"Highlight all sales figures above ₹50,000 in green and below ₹10,000 in red."

What trips people up: Not knowing how to create custom rules with formulas. Most people only know the preset rules.

Rank 4: IF / Nested IF / IFS (Tested by 68% of companies)

"Create a grading system: above 90 is A, 80-90 is B, 70-80 is C, below 70 is D."

What trips people up: Nesting more than 3 levels of IF. The IFS function (available in Excel 2019+) makes this much cleaner.

Rank 5: SUMIFS / COUNTIFS (Tested by 56% of companies)

"What's the total sales for the North region in Q3?"

What trips people up: Getting the criteria range and criteria arguments in the wrong order.

Bonus: Data Cleaning (Increasingly common)

"Here's a messy dataset. Clean it up." This tests TRIM, SUBSTITUTE, text-to-columns, removing duplicates, and handling inconsistent data formats. This is increasingly common because Indian companies deal with messy data constantly: names in different formats, dates in DD-MM-YYYY vs MM-DD-YYYY, phone numbers with and without country codes.

Free Resources to Learn Excel (Ranked by Quality)#

You do not need to pay for an Excel course. The free resources available in 2026 are better than most paid ones. Here's our honest ranking:

1. Excel Jet (Free, Best Reference)

ExcelJet has the cleanest, most concise formula explanations on the internet. Every function has a page with syntax, examples, and common use cases. Bookmark this site. Use it as a reference whenever you're stuck on a formula.

2. YouTube: Chandoo and Leila Gharani

Chandoo is an Indian Excel expert with a massive following. His tutorials are practical, clearly explained, and cover everything from basics to Power Query and dashboards. Leila Gharani is another excellent channel that focuses on modern Excel features like dynamic arrays and XLOOKUP.

Between these two channels, you have 500+ hours of free, high-quality Excel training.

3. NPTEL / SWAYAM

NPTEL offers free courses on data analysis and spreadsheet skills taught by IIT professors. The courses include certification (for a small fee) that looks good on resumes from an Indian context. The content is dry compared to YouTube, but the structure and certification are valuable.

4. Microsoft's Own Training

Microsoft's Excel help center has step-by-step guides for every feature. It's not exciting to read, but it's accurate and always up to date.

5. Practice Datasets

This is critical: you cannot learn Excel by watching videos alone. You need to practice with real data.

• Kaggle: Download free datasets (Indian census data, IPL statistics, stock market data) and practice building pivot tables, charts, and dashboards
• data.gov.in: Indian government open data. Messy, real-world data that's perfect for practicing data cleaning
• Your own data: Track your personal expenses in Excel for a month. Build a budget dashboard. This gives you a portfolio piece AND a practical skill

How to Showcase Excel Skills on Your Resume#

Listing "MS Excel: Advanced" on your resume means nothing. Every third resume has it, and most of those people can barely make a bar chart. Here's how to actually showcase Excel skills in a way that gets noticed:

Method 1: Specific Skill Keywords in Your Skills Section

Instead of "MS Excel," write:

Data Analysis: Advanced MS Excel (Pivot Tables, INDEX-MATCH, XLOOKUP, Power Query,
VBA Macros, Dynamic Arrays, Dashboard Design)

This does two things: it tells the recruiter your specific skill level, and it triggers ATS keyword matches if the job description mentions any of these features.

Method 2: Bullet Points That Show Impact

In your experience or project section:

• "Built automated monthly sales dashboard using Pivot Tables and Power Query, reducing report preparation time from 4 hours to 20 minutes"
• "Developed VBA macro to automate invoice processing for 200+ vendors, eliminating 15 hours of manual work per month"
• "Created financial model in Excel for startup fundraising, projecting 3-year revenue scenarios across best, base, and worst case"
• "Cleaned and standardized a dataset of 50,000+ customer records using Power Query, reducing duplicate entries by 23%"

These bullets prove skill through outcomes, not claims.

Method 3: Portfolio Projects

If you're a fresher with no work experience, create Excel projects and host screenshots or walkthroughs on your GitHub, LinkedIn, or personal website.

Project ideas:

• IPL Analytics Dashboard: Download IPL data from Kaggle, build a pivot table dashboard with slicers for team, season, and venue. Add charts showing top scorers, win percentages, and toss impact.
• Personal Finance Tracker: Build a complete budget tracking workbook with monthly income/expense tracking, category-wise breakdowns, and trend charts.
• Stock Portfolio Analyzer: Pull historical stock data, calculate returns, build a portfolio comparison dashboard.
• Sales Report Automation: Take any sample sales dataset, clean it with Power Query, build a pivot table summary, and create a one-page executive dashboard.

If you want to see how well your Excel skills keywords are matching with job descriptions in your target roles, check out JobRise's ATS Score Checker. It specifically flags when your skills section is missing keywords that the job description is looking for.

Excel Interview Questions (With Answers)#

These are real questions asked in Indian company interviews. We collected them from candidates who recently interviewed at Deloitte, EY, Accenture, HDFC Bank, and several Indian startups.

Question 1: What is the difference between VLOOKUP and INDEX-MATCH?

Good answer: "VLOOKUP searches for a value in the first column of a range and returns a value from a specified column. Its limitation is that it can only look to the right. INDEX-MATCH is a combination of two functions: MATCH finds the position of a value, and INDEX returns the value at that position. INDEX-MATCH can look in any direction, handles column insertions better, and is faster on large datasets."

Question 2: How would you remove duplicates from a dataset?

Good answer: "Multiple approaches. Simplest: select the data range, go to Data tab, click Remove Duplicates, and select which columns to check. For more control, I'd use Power Query, which lets you remove duplicates while keeping a log of what was removed. For a formula-based approach in newer Excel, I'd use the UNIQUE function with dynamic arrays."

Question 3: What is the difference between a relative and absolute cell reference?

Good answer: "A relative reference like A1 changes when you copy the formula to a different cell. An absolute reference like $A$1 stays fixed. You can also mix them: $A1 locks the column but not the row, and A$1 locks the row but not the column. This is essential when building formulas that need to reference a fixed header row or lookup column."

Question 4: How would you create a dropdown list in a cell?

Good answer: "Through Data Validation. Select the cell, go to Data tab, click Data Validation, choose 'List' from the Allow dropdown, and either type the values separated by commas or reference a range of cells containing the values. For dynamic dropdowns that update when data changes, I'd use a named range based on an OFFSET-COUNTA formula or a Table reference."

Question 5: What is Power Query and when would you use it?

Good answer: "Power Query is Excel's built-in ETL (Extract, Transform, Load) tool. I'd use it when I need to import data from external sources, clean messy data, or combine data from multiple files. For example, if I receive monthly sales reports as separate CSV files and need to combine them into one analysis, Power Query can automate the entire import, cleaning, and consolidation process. The steps are recorded, so next month I just refresh the query."

Question 6: Can you explain what a Pivot Table is and create one?

Good answer: (At this point, they'll give you a dataset and expect you to actually create one.) "A Pivot Table is a data summarization tool that lets you reorganize and analyze large datasets without formulas. I can drag fields to Rows, Columns, Values, and Filters areas to create different views of the data. Let me demonstrate with this dataset." Then actually create it, add slicers, group dates by month, and format it cleanly.

Certifications That Indian Employers Actually Value#

Let's be honest: most Excel certifications don't carry much weight compared to demonstrated skills in an interview. But if you want credentials on your resume, here are the ones that Indian employers recognize:

Microsoft Office Specialist (MOS): Excel Expert

The official Microsoft certification. Costs approximately ₹5,000-7,000 to take the exam in India. Recognized globally and signals that you've been tested on advanced features. Worth it if you're targeting MNC roles.

IIBF / ICAI Certifications (For Finance Roles)

If you're in banking or accounting, certifications from the Indian Institute of Banking and Finance or the Institute of Chartered Accountants of India that include Excel/data analysis components carry more weight than generic Excel certs.

Google Sheets Certification (Free Alternative)

Google offers free certifications through Skillshop. While it's for Google Sheets rather than Excel, the skills are transferable, and "Google certified" looks good on a resume for startups and tech companies that use Google Workspace.

The Best "Certification": A Portfolio Project

Honestly? A well-documented Excel dashboard project on your LinkedIn or portfolio website is worth more than any certificate. It's proof of skill, not proof of passing a test.

Excel vs. Google Sheets: What Should You Learn?#

Quick answer: learn both, but prioritize based on your target companies.

Learn Excel if you're targeting:

• Traditional Indian companies (Tata, Reliance, Aditya Birla, Mahindra)
• Banks and financial institutions (HDFC, ICICI, SBI, Kotak)
• Big 4 consulting firms (Deloitte, EY, PwC, KPMG)
• Manufacturing and FMCG companies
• Government and PSU roles

Learn Google Sheets if you're targeting:

• Startups (most Indian startups use Google Workspace)
• Tech companies
• D2C brands
• Remote-first companies

The core skills (formulas, pivot tables, charts) transfer between the two. The differences are mainly in advanced features: Excel has Power Query, VBA, and Power Pivot. Google Sheets has Apps Script, better real-time collaboration, and native integration with Google's ecosystem.

For a deeper look at what other skills you should list on your resume alongside Excel, read our complete guide to resume skills for freshers in 2026.

The 30-Day Excel Learning Plan#

If you're starting from zero, here's a realistic plan to get to Level 2 (intermediate) in 30 days, spending about 1 hour per day:

Week 1: Foundations

• Day 1-2: Cell formatting, number formats, basic navigation
• Day 3-4: SUM, AVERAGE, COUNT, MAX, MIN, IF
• Day 5-6: VLOOKUP (practice with real datasets until it's automatic)
• Day 7: Sorting, filtering, conditional formatting

Week 2: Intermediate Formulas

• Day 8-9: INDEX-MATCH (the upgrade from VLOOKUP)
• Day 10-11: SUMIFS, COUNTIFS, AVERAGEIFS
• Day 12-13: TEXT functions (LEFT, RIGHT, MID, TRIM, CONCATENATE)
• Day 14: DATE functions and data validation

Week 3: Pivot Tables and Charts

• Day 15-16: Pivot Tables basics (creating, formatting, grouping)
• Day 17-18: Pivot Tables advanced (calculated fields, slicers, filtering)
• Day 19-20: Charts (column, bar, line, combo charts, formatting)
• Day 21: Advanced charts (secondary axes, sparklines, trendlines)

Week 4: Projects and Practice

• Day 22-24: Build a complete sales dashboard project (data cleaning, pivot tables, charts, formatting)
• Day 25-27: Practice with 3 different datasets from Kaggle
• Day 28-29: Mock interview questions (all the ones listed above)
• Day 30: Create a portfolio piece and add it to your resume

By Day 30, you'll be genuinely better at Excel than 80% of people who claim "MS Excel: Advanced" on their resume. And unlike them, you'll have the projects to prove it.

Make Sure Your Excel Skills Get Past the ATS#

Here's the final piece: even if you have excellent Excel skills, they need to be visible to ATS (Applicant Tracking Systems) that scan your resume before any human sees it.

If the job description says "Advanced Excel" and your resume says "MS Office," that's a keyword mismatch. If the JD mentions "Pivot Tables" and you just wrote "Data Analysis," the ATS may not connect the dots.

Use the exact phrases from the job description. If it says "VLOOKUP," write "VLOOKUP." If it says "Power Query," write "Power Query." ATS systems are literal, not intelligent.

To check exactly how your Excel skills keywords are matching against specific job descriptions, use our ATS Resume Score Checker. Upload your resume, paste the job description, and get a keyword-by-keyword analysis of what's matching and what's missing. It takes 30 seconds and could be the difference between your resume reaching a human or getting filtered out.

You can also explore our full Job Preparation Toolkit for resume building, cover letter generation, and more tools designed specifically for Indian job seekers.

Key Takeaways#

• Excel is not optional for most non-coding roles in India. It is the foundation of professional data work.
• Three levels: Basic (every professional), Intermediate (analysts, accountants), Advanced (finance, consulting). Know which level your target role requires.
• Pivot Tables are the most tested skill in Indian interviews. If you learn nothing else, learn pivot tables.
• Free resources are enough. Chandoo, ExcelJet, and Kaggle datasets will get you further than any paid course.
• Show, don't tell. Replace "MS Excel: Advanced" with specific skills (XLOOKUP, Power Query, VBA) and impact-driven bullet points.
• Build a portfolio project. One well-made Excel dashboard is worth more than a certificate.
• Match your resume keywords to the job description. ATS systems are literal.

Excel isn't sexy. It doesn't get you followers on Twitter/X. Nobody builds a personal brand around pivot tables. But in the Indian job market, it quietly gets more people hired than almost any other single skill. Learn it properly. Your career will thank you.