Job Description:
We are looking for a skilled MIS Executive with strong knowledge of Advanced Excel to manage data, prepare MIS reports, and ensure data accuracy.
Key Responsibilities:
Prepare daily, weekly, and monthly MIS reports.
Work on VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, and COUNTIFS.
Create Pivot Tables, dashboards, and reports.
Perform data matching, reconciliation, and analysis.
Use Power Query for data cleaning, consolidation, and automation.
Handle large datasets and maintain data accuracy.
Automate repetitive tasks using Excel Macros/VBA (preferred).
Provide timely reports and administrative support to management.
Required Skills:
Strong knowledge of Advanced Excel.
Experience in MIS reporting and data analysis.
Good analytical and problem-solving skills.
Attention to detail and accuracy.
Knowledge of Power Query and VBA is an added advantage.
Qualification: Graduate in any stream.
Experience: As per company requirements.