1 - 5 years

1 - 5 Lacs

Posted:2 days ago| Platform: GlassDoor logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Job Description: Advance Excel Executive / AnalystJob Title: Advance Excel Executive / MIS Executive / Data AnalystDepartment: Operations / Finance / HR / MISLocation: As per company requirementExperience: 1–5 YearsEmployment Type: Full-time / ContractKey Responsibilities:

  • Prepare, analyze, and maintain complex Excel spreadsheets for MIS and reporting.
  • Develop dynamic dashboards using Pivot Tables, Pivot Charts, and slicers.
  • Perform data cleaning, validation, and consolidation from multiple sources.
  • Use advanced formulas such as VLOOKUP, HLOOKUP, XLOOKUP, INDEX–MATCH, SUMIFS, COUNTIFS, IF, nested IF, TEXT, DATE functions.
  • Automate repetitive tasks using Macros and VBA (if applicable).
  • Generate daily, weekly, and monthly performance reports.
  • Support management with data-driven insights and trend analysis.
  • Ensure data accuracy and maintain proper documentation.
  • Coordinate with internal teams for data requirements and reporting needs.

Required Skills & Competencies:

  • Strong proficiency in MS Excel (Advanced Level).
  • Hands-on experience with:
  • Pivot Tables & Charts
  • Power Query / Power Pivot (preferred)
  • Macros & VBA (added advantage)
  • Conditional Formatting & Data Validation
  • Knowledge of MIS reporting & dashboard creation.
  • Basic understanding of data analysis & visualization.
  • Good analytical, problem-solving, and communication skills.
  • Ability to work under deadlines and manage large datasets.

Educational Qualification:

  • Graduate in Commerce / Science / Management / IT or equivalent.
  • Certification in Advance Excel / Data Analysis is a plus.

Preferred Candidate Profile:

  • Experience in HR MIS, Finance MIS, Sales MIS, or Operations MIS.
  • Familiarity with Power BI / Google S

Job Types: Full-time, Fresher

Pay: ₹9,563.41 - ₹44,851.41 per month

Work Location: In person

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

sonipat, kundli