We are looking for a detail-oriented and technically proficient Excel Admin / MIS Executive with strong hands-on knowledge of Microsoft Excel. The candidate will be responsible for maintaining and managing data, preparing reports, updating trackers, performing data analysis, and supporting day-to-day administrative and reporting requirements.
The ideal candidate should have strong technical knowledge of Excel, excellent attention to detail, and the ability to work efficiently with large volumes of data.
Key Responsibilities
- Manage, maintain, and regularly update company data and records in Excel.
- Prepare daily, weekly, and monthly MIS reports as required.
- Create and maintain various Excel-based trackers and databases.
- Consolidate data from multiple sources and prepare structured reports.
- Check data accuracy and identify discrepancies, errors, or missing information.
- Perform data cleaning, sorting, filtering, formatting, and validation.
- Prepare summaries, reports, and analysis for management review.
- Maintain employee, attendance, sales, expense, payment, task, and other operational trackers.
- Coordinate with different team members to collect and verify required data.
- Ensure all reports and trackers are updated within the required timelines.
- Maintain proper documentation and systematic records of all data.
- Generate performance reports and dashboards using Excel wherever required.
- Support management with ad-hoc Excel reports, data analysis, and presentations.
- Ensure confidentiality and accuracy of company-related data.
- Handle other administrative and reporting responsibilities as assigned by management.
Technical Excel Skills – Mandatory
The candidate should have strong technical and practical knowledge of MS Excel, including:
- Advanced Excel formulas and functions
- VLOOKUP / XLOOKUP
- INDEX & MATCH
- IF / IFS / AND / OR
- SUMIF / SUMIFS
- COUNTIF / COUNTIFS
- Pivot Tables & Pivot Charts
- Conditional Formatting
- Data Validation
- Sorting & Advanced Filtering
- Data Cleaning and Data Formatting
- Removing duplicates and handling large datasets
- Excel Charts and Graphs
- Basic Dashboard Creation
- Report Consolidation
- Linking and managing multiple Excel sheets
- Basic understanding of Excel-based data analysis and MIS reporting
Advanced Excel knowledge will be highly preferred.
Required Skills
- Strong technical knowledge and hands-on experience in MS Excel.
- Excellent numerical and analytical skills.
- High level of accuracy and attention to detail.
- Ability to work with large volumes of data.
- Good typing and data-entry skills.
- Strong organizational and time-management skills.
- Ability to prepare reports independently.
- Good communication and coordination skills.
- Ability to meet deadlines and manage multiple tasks simultaneously.
- Responsible, disciplined, and systematic approach to work.
Qualification & Experience
- Graduate in any discipline.
- 1–3 years of relevant experience in Excel, MIS, administration, data management, or a similar role.
- Candidates with strong practical Excel skills will be given preference.
- Strong technical Excel knowledge is mandatory for this position.
Preferred Candidate
The ideal candidate should be someone who is technically strong in Excel, quick with data, highly accurate, organized, and capable of independently handling Excel-based reporting and administrative work.
Pay: ₹35,000.00 - ₹40,000.00 per month
Work Location: In person