Job Responsibilities
- Prepare and maintain daily, weekly, and monthly MIS reports.
- Collect and analyze data from different departments.
- Create reports and dashboards using Advanced Microsoft Excel.
- Use Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, IF formulas, SUMIFS, COUNTIFS, and other advanced formulas.
- Perform data cleaning, sorting, filtering, and validation.
- Prepare charts and presentations for management.
- Maintain accurate databases and ensure data confidentiality.
- Identify data errors and discrepancies and correct them.
- Coordinate with different departments for report collection and updates.
Required Skills
- Advanced MS Excel is mandatory.
- Strong knowledge of:
- Pivot Tables & Pivot Charts
- VLOOKUP / XLOOKUP
- INDEX-MATCH
- IF, SUMIF/SUMIFS, COUNTIF/COUNTIFS
- Data Validation
- Conditional Formatting
- Advanced Excel formulas and functions
- Charts and Dashboard preparation
- Good knowledge of MS Word and PowerPoint.
- Good analytical and data management skills.
- Strong attention to detail and accuracy.
Pay: ₹18,000.00 - ₹20,000.00 per month
Work Location: In person
