Excel Skills for Data Analyst Jobs in India — 2026 Roadmap

Data Analyst is one of the fastest-growing job roles in India. Among 12 million+ job listings analyzed on Indeed, Excel was cited as the most in-demand skill — roughly 8x more than Python and 9x more than SQL. Before you learn Python or Tableau, you need to master Excel. Here's the complete roadmap.

Why Excel First?

Every data analyst interview starts with an Excel test. Companies like TCS, Infosys, Accenture, and startups use platforms like Mercer Mettl and iMocha to test Excel proficiency before they even ask about SQL or Python.

Excel is also where most Indian companies still do their analysis. Your manager won't ask for a Python script — they'll ask for an Excel report by 4 PM.

The Data Analyst Excel Roadmap

Phase 1: Foundation (Week 1-3)

Every data analyst needs these formulas without thinking.

Data Cleaning

• TRIM — remove extra spaces from imported data
• CLEAN — remove non-printable characters
• SUBSTITUTE — replace characters (fix inconsistent data)
• VALUE / NUMBERVALUE — convert text numbers to actual numbers
• UPPER / LOWER / PROPER — standardize text case
• Find & Replace (Ctrl+H) — bulk data fixes

Basic Aggregation

• SUM, AVERAGE, COUNT, COUNTA, COUNTBLANK
• MAX, MIN, LARGE, SMALL
• SUMIF, COUNTIF, AVERAGEIF — single-condition aggregation

Logical Functions

• IF, AND, OR, NOT
• IFERROR, IFNA — essential for error handling in lookups
• IFS, SWITCH — modern alternatives to nested IF

Phase 2: Core Analyst Skills (Week 4-8)

Lookups — The #1 Interview Topic

• VLOOKUP — learn this first, understand its limitations
• INDEX-MATCH — learn this second, use it as your primary tool
• XLOOKUP — if using Excel 365

Multi-Condition Analysis

• SUMIFS, COUNTIFS, AVERAGEIFS — multi-criteria aggregation
• SUMPRODUCT — the Swiss Army knife. Handles conditions that SUMIFS can't (OR logic, calculated criteria, array operations)

Date Intelligence

• YEAR, MONTH, DAY, WEEKDAY — extract date components
• DATEDIF — calculate age, tenure, duration
• NETWORKDAYS, WORKDAY — business day calculations
• EOMONTH — end of month (for monthly reporting)
• TEXT(date, "MMM-YYYY") — format dates for reports

Pivot Tables

This is non-negotiable. Every data analyst uses Pivot Tables daily.

• Basic Pivot: rows, columns, values, filters
• Calculated fields
• Grouping dates (by month, quarter, year)
• Pivot Charts
• Slicers for interactive dashboards

Phase 3: Advanced (Week 9-14)

Array Formulas & Dynamic Arrays

• UNIQUE — extract unique values
• SORT / SORTBY — sorted lists without manual sorting
• FILTER — extract filtered data with a formula
• SEQUENCE — generate number series
• LET — name intermediate calculations (cleaner formulas)

Data Visualization

• Conditional Formatting — color scales, data bars, icon sets
• Charts — column, line, combo, waterfall
• Sparklines — mini-charts inside cells
• Dashboard design — layout, color, readability

Power Query (Get & Transform)

This separates intermediate users from analysts. Power Query lets you:

• Import data from multiple sources (CSV, web, databases)
• Clean and transform data with repeatable steps
• Merge (join) tables like SQL
• Unpivot data for analysis
• Refresh with one click when source data updates

What Interviews Actually Test

Based on analysis of Excel assessment tests used by Indian companies:

1. VLOOKUP / INDEX-MATCH — present in 90%+ of tests
2. SUMIFS / COUNTIFS — present in 80%+ of tests
3. Pivot Tables — asked in every practical round
4. IF with AND/OR — conditional logic problems
5. Data cleaning — given messy data, clean it using formulas
6. Chart creation — "visualize this data appropriately"

Salary Expectations — Data Analyst (India, 2026)

• Fresher (0-1 yr): ₹2.5–₹4.5 LPA
• Junior (1-3 yr): ₹4.5–₹8 LPA
• Mid-level (3-5 yr): ₹8–₹15 LPA
• Senior (5+ yr): ₹15–₹30 LPA

The jump from fresher to junior level is primarily about Excel + SQL skills. Python and Tableau come later.

After Excel: The Full Stack

Once you're confident with Excel (8-12 weeks of daily practice), add these in order:

1. SQL — querying databases (most analyst work is SQL + Excel)
2. Tableau / Power BI — interactive dashboards
3. Python (Pandas) — automation and large-scale analysis
4. Statistics basics — mean, median, correlation, regression

But don't skip Excel. It's your foundation. A data analyst who can't do INDEX-MATCH in their sleep won't survive the first week.