Excel Skills for MIS Executive Jobs in India

There are 12,362 MIS Executive vacancies on Shine.com, 275+ on Foundit in Delhi alone, and 186+ on Glassdoor in Delhi — as of 2026. Every single one requires Advanced Excel. The salary range is ₹12,000–₹40,000/month, and the fastest way to get hired is to prove you can build reports, not just talk about formulas.

What Does an MIS Executive Actually Do?

MIS = Management Information System. An MIS Executive collects raw data from different departments, cleans it, summarizes it into reports, and sends it to management for decision-making. Everything happens in Excel.

Daily work includes:

• Daily/weekly/monthly sales reports
• Attendance and leave tracking
• Inventory and stock reports
• Expense summaries by department
• Dashboard creation for management review
• Data validation and error checking

The 15 Must-Know Formulas for MIS Jobs

Tier 1: Use Every Day (Non-Negotiable)

1. VLOOKUP / INDEX-MATCH — pull data from master tables. Every MIS report involves looking up employee names, product codes, or branch details from a master sheet.
2. SUMIFS — sum sales by region, by product, by date range. The most-used formula in MIS.
3. COUNTIFS — count entries matching multiple criteria (how many orders in Delhi in March?).
4. IF / Nested IF / IFS — categorize data. "If sales > 100000, Grade A. If > 50000, Grade B..."
5. TEXT — format dates and numbers for reports. =TEXT(A1,"MMM-YYYY") turns a date into "Jun-2026".

Tier 2: Use Weekly

6. CONCATENATE / TEXTJOIN — combine first name + last name, or build report headers dynamically.
7. LEFT / RIGHT / MID — extract parts of codes. Employee code "DL-MIS-0042" → extract branch "DL".
8. IFERROR — wrap every VLOOKUP to handle missing data gracefully.
9. NETWORKDAYS / WORKDAY — calculate working days for attendance and leave reports.
10. DATEDIF / EDATE — calculate tenure, age, or contract expiry dates.

Tier 3: Advanced (Senior MIS / Analyst Roles)

11. SUMPRODUCT — complex multi-condition calculations without Pivot Tables.
12. INDIRECT — dynamic sheet references for monthly reports (Sheet "Jan", "Feb", etc.).
13. OFFSET — dynamic ranges for charts that auto-update when data grows.
14. LARGE / SMALL / RANK — top 10 products, bottom 5 branches, rank employees.
15. AGGREGATE — like SUBTOTAL but ignores errors. Essential for messy real-world data.

Beyond Formulas: Other MIS Skills

Pivot Tables

Every MIS interview asks about Pivot Tables. They're the fastest way to summarize thousands of rows into a report. Practice: Insert → Pivot Table → drag fields into Rows, Columns, Values. Learn Pivot Charts too.

Conditional Formatting

Highlight cells that need attention — overdue items in red, targets met in green. Managers love color-coded reports.

Data Validation

Create dropdown lists to prevent data entry errors. Data → Validation → List. Used in every data entry template.

Keyboard Shortcuts

Speed matters in MIS work. Essential shortcuts:

• Ctrl+Shift+L — toggle filters
• Alt+= — autosum
• Ctrl+D — fill down
• Ctrl+; — insert today's date
• Ctrl+Shift+: — insert current time
• Alt+Enter — new line in a cell
• F4 — toggle absolute/relative reference

Sample MIS Interview Questions

1. "Create a monthly sales summary from this raw data using Pivot Tables."
2. "Use VLOOKUP to match employee names from the master list."
3. "Calculate the total sales for each region using SUMIFS."
4. "Find the top 5 products by revenue."
5. "This report has #N/A errors. How would you fix them?"
6. "Create a dropdown-based dashboard that shows data for the selected month."

How to Prepare in 30 Days

• Week 1: VLOOKUP, SUMIFS, COUNTIFS — practice 20 problems each
• Week 2: Pivot Tables, Conditional Formatting, IF functions
• Week 3: INDEX-MATCH, TEXT functions, Date functions
• Week 4: Mock tests — timed 30-minute sessions. Build a complete report from raw data.

Salary Expectations

• Fresher MIS Executive: ₹12,000–₹18,000/month
• 1-3 years experience: ₹18,000–₹30,000/month
• Senior MIS / MIS Analyst: ₹30,000–₹50,000/month
• MIS Manager: ₹50,000–₹80,000/month

The jump from fresher to experienced is almost entirely about Excel speed and accuracy. Companies don't teach you Excel — they expect you to already know it.