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

📌 MS Excel Expert (India)
🏢 GAMUT BUILDCON
📍 India