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.

Requrements




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
Robust 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

📌 Advanced Excel Kolkata (India)
🏢 Kirti Lifestyle
📍 India