Office Executive – Advanced Excel
Location: Chandigarh University, Mohali, Punjab
Employment Type: Full-Time
Key Responsibilities
- Manage, maintain, and update departmental data, records, and databases using MS Excel.
- Prepare daily, weekly, and monthly MIS reports, dashboards, summaries, and presentations.
- Use advanced Excel functions such as VLOOKUP/XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, Pivot Tables, Pivot Charts, Conditional Formatting, Data Validation, and Excel Tables.
- Consolidate data from multiple sources and perform data cleaning, validation, sorting, filtering, and reconciliation.
- Prepare management reports and provide accurate data insights for decision-making.
- Maintain attendance, employee/student records, departmental trackers, and other operational databases.
- Create automated and user-friendly Excel reports and dashboards wherever required.
- Coordinate with different departments for timely collection and verification of data.
- Handle official correspondence, documentation, filing, and record maintenance.
- Draft letters, notices, reports, and other official documents as required.
- Track pending tasks, follow-ups, approvals, and departmental activities.
- Ensure accuracy, confidentiality, and timely updating of institutional data.
- Support meetings by preparing agendas, reports, data sheets, minutes, and presentations.
- Perform other administrative and coordination duties assigned by the reporting manager.
Required Skills
- Advanced proficiency in MS Excel is mandatory.
- Strong knowledge of Pivot Tables, Pivot Charts, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF functions, dashboards, and data analysis.
- Knowledge of Power Query / Excel automation will be an added advantage.
- Good knowledge of MS Word and PowerPoint.
- Strong data management and analytical skills.
- Excellent documentation and reporting skills.
- Good written and verbal communication.
- Strong organizational and time-management abilities.
- High attention to detail and accuracy.
- Ability to manage multiple tasks and work within deadlines.
Educational Qualification
Graduate degree in any discipline from a recognized university/institution.
Preferred: MBA, M.Com, B.Com, BBA, or a relevant administrative/business discipline.
Experience
- 2–5 years of experience in office administration, MIS, data management, academic administration, or a similar role.
- Candidates with strong Advanced Excel/MIS experience in educational institutions, corporate offices, or large organizations will be preferred.
Pay: ₹15,715.08 - ₹31,469.54 per month
Work Location: In person
