We are looking for an Advanced Excel expert who can manage large volumes of data, prepare MIS reports, create dashboards, and automate regular reporting processes. The candidate must have very robust hands-on knowledge of Advanced Excel and be highly comfortable working with formulas, Pivot Tables, Power Query and data analysis.

Key Responsibilities
Prepare daily, weekly and monthly MIS reports and dashboards.
Manage and analyse large datasets using Advanced Excel.
Create and maintain complex Excel sheets, trackers and management reports.
Use Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF formulas, TEXT functions, etc.
Work extensively with Power Query for data cleaning, transformation and consolidation.
Develop automated reports using Macros/VBA wherever required.
Identify data discrepancies and ensure accuracy of reports.
Prepare management dashboards and provide meaningful data insights.




Automate repetitive Excel-based reporting and processes.
Coordinate with different departments to collect and validate data.

Mandatory Skills
Advanced Excel – Excellent/Expert level is mandatory
Robust knowledge of Pivot Tables, Advanced Formulas & Data Analysis
Power Query
VBA/Macros
MIS Reporting & Dashboard preparation
Excellent attention to detail and numerical accuracy
Solid analytical and problem-solving skills

Pay: ₹20,000.00 - ₹30,000.00 per month

Application Question(s)
How would you rate your Advanced Excel skills out of 10? Please mention your expertise in Pivot Tables, XLOOKUP/VLOOKUP, Power Query, and VBA/Macros.
Have you independently created and automated MIS reports/dashboards using Advanced Excel?

Work Location: In person

📌 Advanced Excel / Mis Executive Rash Bihari Avenue
🏢 People Power
📍 Rash Bihari Avenue