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 skilled 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.
Solid 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 Saket
🏢 Gamut Buildcon
📍 Saket