Advanced MS Excel Specialist

Advanced Excel Specialist

Job Description:

We are seeking an Advanced Excel Specialist with strong expertise in Excel formulas and data handling. The ideal candidate will manage complex data tasks, create automated spreadsheets using advanced formulas, and support the team with accurate and efficient data-driven solutions.

Key Responsibilities:

• Develop and maintain spreadsheets using advanced Excel formulas (LOOKUPs, INDEX-MATCH, SUMIFS, COUNTIFS, IFERROR, TEXT functions, etc.).
• Create and optimize pivot tables, dashboards, and data summaries.
• Clean, sort, and analyze large datasets for reporting and decision-making.
• Ensure accuracy and consistency of data across all reports.
• Troubleshoot formula errors, improve existing sheets, and enhance data workflows.
• Collaborate with internal departments to understand reporting requirements.

Required Skills & Qualifications:

• Strong command of advanced Excel formulas and logical functions.
• Hands-on experience with pivot tables, data validation, conditional formatting, and charts.
• Ability to manage and interpret large datasets with accuracy.
• Excellent analytical and problem-solving skills.
• Strong attention to detail and ability to work within deadlines.

Job Type: Full-time

Pay: ₹15,000.00 - ₹35,000.00 per month

Benefits:

• Provident Fund

Application Question(s):

• How do you combine first name and last name into one cell?
• How do you group dates (months/years) in a Pivot Table?
• How do you remove duplicate values from a list?

Experience:

• Microsoft Excel: 1 year (Required)

Work Location: In person