MIS Executive – Advanced Excel Specialist

Location: Sector 67, Noida

Experience: 4–6 Years

Employment Type: Full-Time (Work from Office)

About the Role

We are looking for a detail-oriented and analytical MIS Executive with strong expertise in Advanced Microsoft Excel. The candidate will be responsible for managing business data, preparing MIS reports, analyzing sales and operational performance, and developing automated Excel-based reporting systems to support management decision-making.

Key Responsibilities

1. Prepare, maintain, and analyze daily, weekly, and monthly MIS reports.
2. Handle large volumes of data using Advanced Excel.
3. Develop automated Excel reports and dashboards for management.
4. Prepare sales performance, customer-wise, product-wise, and employee-wise reports.
5. Use Excel formulas and functions to analyze and interpret business data.
6. Identify data discrepancies, maintain data accuracy, and ensure proper documentation.
7. Consolidate data from multiple sources and prepare meaningful management reports.
8. Create energetic dashboards and performance trackers.
9. Coordinate with different departments to collect and validate business information.
10.



Identify opportunities to improve reporting processes through Excel automation.

Required Technical Skills – Advanced Excel The candidate must have practical working knowledge of:

- Advanced Excel formulas: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH.
- SUMIFS, COUNTIFS, IF, nested IF, IFERROR, AND, OR.
- Pivot Tables and Pivot Charts.
- Conditional Formatting and Data Validation.
- Advanced Filter, Sorting and Data Cleaning.
- Dashboard Creation and Data Visualization.
- MIS Reporting and automated report preparation.

Preferred Skills

- Strong analytical and problem-solving abilities.
- Excellent attention to detail and accuracy.
- Ability to handle large datasets efficiently.
- Good understanding of business and sales reporting.
- Strong coordination and communication skills.
- Ability to work independently and meet reporting deadlines.

Qualification

- Graduate in any discipline.
- Candidates with a background in Commerce, Finance, Statistics will be preferred.
- Candidates with strong practical knowledge of Advanced Excel and MIS reporting will be given preference.

📌 MIS Executive (New Delhi)
🏢 DECOMAX LIFESTYLE PRIVATE
📍 New Delhi