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.
Robust 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 robust 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 Saket
🏢 Gamut Buildcon
📍 Saket