MS Excel Expert

Excel Expert – Job Profile

Job Title: Excel Expert / MIS Executive
Department: HR / Administration / MIS
Location: Head Office / Site
Experience: 2–5 Years
Employment Type: Full-Time

Job Summary

We are looking for an Excel Expert / MIS Executive with strong knowledge of Microsoft Excel to manage data, prepare MIS reports, maintain records, and provide accurate management reports for day-to-day business operations.

Key Responsibilities

• Prepare daily, weekly, and monthly MIS reports.
• Maintain employee, attendance, payroll, leave, and other administrative data.
• Prepare salary sheets, attendance sheets, overtime calculations, and manpower reports.
• Develop and maintain Excel-based dashboards and automated reports.
• Consolidate data from multiple Excel files and prepare management summaries.
• Perform data validation, reconciliation, and error checking.
• Prepare reports using Pivot Tables, Pivot Charts, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF formulas, etc.
• Use Conditional Formatting, Data Validation, Filters, Sorting, and Advanced Excel functions.
• Handle large datasets and ensure accuracy and confidentiality.
• Create professional Excel formats, trackers, templates, and management reports.
• Coordinate with HR, Accounts, Administration, and Project teams for required data.
• Maintain proper filing and version control of Excel reports.

Required Skills

• Advanced knowledge of Microsoft Excel.
• Strong knowledge of Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, IFERROR, TEXT and Date functions.
• Knowledge of Power Query and Excel Dashboards will be an advantage.
• Good knowledge of MS Word and PowerPoint.
• Strong analytical and data-management skills.
• High accuracy and attention to detail.
• Ability to work with large volumes of data.

Qualification

Graduate in any discipline, preferably with a strong background in Computer Applications, Commerce, HR, Accounts, or Management.

Preferred Experience

Experience in Construction / Infrastructure / Real Estate / Corporate Office will be preferred, particularly in HR, payroll, attendance, manpower, MIS, or administration.

Key Performance Areas

• Accuracy of reports
• Timely submission of MIS
• Data integrity and reconciliation
• Automation of repetitive Excel work
• Quality of management dashboards
• Confidentiality of employee and company data

Salary: As per experience and industry standards.

Pay: ₹15,000.00 - ₹21,000.00 per month

Work Location: In person