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.
REQUIREMENTS:
- 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
- Strong analytical and problem-solving skills
Pay: ₹25,000.00 - ₹30,000.00 per month
Application Question(s):
- Do you know Excel, Pivot Table etc.?
Experience:
- MIS Executive: 2 years (Required)
Work Location: In person
