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 strong 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
- Strong 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 (Kolkata)
🏢 People Power
📍 Kolkata