MIS Executive (Advanced Excel)

Job Title: MIS Executive (Advanced Excel)

Company: Trustwell Management Services Private Limited
Location: Andheri East Mumbai India
Job Type: Full-time

About the Company

Trustwell Management Services Private Limited is India's leading advisory company specializing in providing comprehensive services to investors and corporates. We assist investors with investment recovery and ownership issue resolution while helping corporates achieve their business objectives through specialized advisory services.

Job Summary

We are looking for a highly skilled MIS Executive with strong expertise in Microsoft Excel and Google Sheets. The ideal candidate should be proficient in handling large datasets consolidating multiple files creating automated reports and developing meaningful MIS dashboards. The role requires strong logical thinking and hands-on experience with Excel functions lookups pivot tables and summary report generation.

Key Responsibilities

• Consolidate and merge data from multiple Excel files and sources to create accurate MIS reports.
• Design maintain and automate daily weekly and monthly MIS reports.
• Use advanced Excel formulas and functions to clean validate and analyze data.
• Create and maintain Pivot Tables Pivot Charts Summary Sheets and Dashboards for management reporting.
• Perform data reconciliation and validation to ensure accuracy and consistency.
• Develop reporting logic to transform raw data into actionable business insights.
• Generate performance productivity and operational reports for management review.
• Prepare customized reports based on business requirements.
• Coordinate with internal teams to collect verify and analyze data.
• Maintain organized reporting structures and documentation for MIS processes.
• Identify trends exceptions and opportunities through data analysis.

Required Skills & Qualifications

• Bachelor's degree in any discipline (preferred: Computer Science Information Technology Commerce or related field).
• Strong proficiency in Microsoft Excel is mandatory.
• Hands-on experience with:
  • VLOOKUP HLOOKUP XLOOKUP
  • INDEX-MATCH
  • IF IFS SUMIF SUMIFS COUNTIF COUNTIFS
  • TEXT DATE and Logical Functions
  • Data Validation
  • Conditional Formatting
  • Pivot Tables & Pivot Charts
  • Advanced Filtering and Sorting
  • Dashboard Creation
  • Data Consolidation & Summary Sheet Preparation
• Good understanding of reporting logic and data interpretation.
• Working knowledge of Google Sheets.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and accuracy.
• Ability to work independently in a fast-paced environment.

Preferred Candidate Profile

• Experience handling large datasets and MIS reporting.
• Strong logical and analytical mindset.
• Ability to create management-friendly reports and dashboards.
• Experience in process automation using Excel formulas and reporting techniques.

Compensation

Salary: 40000 – 50000 per month

Experience Required

MIS Reporting / Excel MIS: Minimum 2 Years (Preferred)

Work Location

Andheri East Mumbai (Work from Office)

Required Skills:

Microsoft Excel Google Sheets VLOOKUP HLOOKUP XLOOKUP INDEX-MATCH IF IFS SUMIF SUMIFS COUNTIF COUNTIFS TEXT DATE Logical Functions Data Validation Conditional Formatting Pivot Tables Pivot Charts Advanced Filtering Sorting Dashboard Creation Data Consolidation Summary Sheet Preparation Reporting Logic Data Interpretation Analytical Skills Problem-Solving Attention to Detail MIS Reporting Process Automation