Office Assistant (Advanced proficiency in Microsoft Excel)

Job Summary

We are seeking a highly skilled Excel Expert to support data management, analysis, and reporting needs across the organization. The ideal candidate will possess advanced Excel skills, including data modeling, automation using formulas and macros, and the ability to create complex dashboards and analytical tools to support business decision-making.

Key Responsibilities

• Design, build, and maintain advanced Excel models, templates, and dashboards for business reporting and forecasting.
• Develop and optimize complex formulas, pivot tables, charts, and conditional formatting.
• Automate repetitive tasks using VBA (Visual Basic for Applications) or Power Query.
• Perform data cleaning, consolidation, and analysis to generate actionable insights.
• Collaborate with teams to understand reporting needs and translate them into Excel-based tools.
• Integrate Excel with other applications such as Power BI, SQL, or Google Sheets when necessary.
• Ensure data accuracy and integrity across all reports and analyses.
• Provide training and support to team members on Excel best practices and advanced functionalities.

Qualifications & Skills

• Proven experience as an Excel Expert, Data Analyst, or similar role.
• Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, INDEX-MATCH, array formulas, Power Query, Power Pivot, VBA macros).
• Strong analytical and problem-solving skills with a keen eye for detail.
• Familiarity with data visualization and business reporting techniques.
• Experience integrating Excel with databases or BI tools (e.g., SQL, Power BI) is a plus.
• Excellent communication and documentation skills.
• Intermediate and Bachelor’s degree.

Preferred Experience

• Certification in Microsoft Excel (MOS Expert) or equivalent preferred

Job Type: Full-time

Pay: Rs25,000.00 - Rs30,000.00 per month

Work Location: In person