Advanced Excel Executive

TalentMark Academy Placement Department; Indore District; On-site; INR 300,000 - 420,000; Full time

Job summary

TalentMark Academy is seeking an Advanced Excel Executive to manage large Excel databases, build reports, dashboards, and data visualizations to support data-driven decisions.

You will use Pivot Tables and Pivot Charts, advanced formulas, data cleaning, and basic financial modeling, collaborating with finance, sales, and HR while ensuring data security and clear communication. TalentMark Academy Certification is compulsory to apply for this job.

Qualifications

• Strong knowledge of Pivot Tables and Pivot Charts.
• Proficiency with Advanced Excel Formulas (VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, IFERROR).
• Experience with Data Visualization and Conditional Formatting.
• Ability to perform Data Cleaning and Validation.
• Understanding of Financial Modeling & Statistical Analysis.
• Familiarity with What-If Analysis tools (Goal Seek, Scenario Manager).
• Solid communication and problem-solving skills.
• Attention to detail and ability to manage multiple tasks.

Responsibilities

• Maintain and update large Excel databases and generate advanced reports.
• Create and manage dashboards and pivot-based visualizations.
• Present data insights to non-technical stakeholders.
• Assist in financial modeling and scenario analysis to support decisions.
• Document data processes and ensure data security across teams (finance, sales, HR).

Skills

Pivot Tables & Pivot Charts

Advanced Excel Formulas

Data Visualization

Conditional Formatting

Data Cleaning & Validation

Financial Modeling

What-If Analysis

Communication

Problem-Solving

Attention to Detail

Education

Bachelor’s degree in Commerce, Management, Finance, Statistics

Tools

Excel

Job description

TalentMark Academy Placement Department | Full time

Weare seeking a detail-oriented and analytical individual with strongExcel skills to join our team as an Advanced Excel Executive. You’llbe responsible for managing data, creating insightful reports, andsupporting our team through data-driven decisions.

TALENTMARK ACADEMY CERTIFICATION IS COMPULSORY TO APPLY FORTHIS JOB.

• Maintain and update large Excel databases.
  
• Ensure data accuracy through effectivedata cleaning and validation techniques.
  

Reporting andAnalysis:

• Create and manage advanced Excelreports using pivot tables, pivot charts, and dashboards.
  
• Present complex data visually usingadvanced Excel charts and graphs.
  
• Implement conditional formattingtechniques to highlight key data insights.
  

Financial andStatistical Analysis:

• Assist in financial modeling and scenarioanalysis using Excel.
  
• Conduct variance and sensitivity analysesto support decision-making.
  

Documentation& Data Security:

• Protect and maintain dataconfidentiality through appropriate Excelsecurity practices.
  
• Regularly document and update dataprocessing procedures and methodologies.
  
• Work closely with internal teams(finance, sales, HR) to understand reporting needs.
  
• Clearly communicate findings and insightsto non-technical stakeholders.
  

Requirements

Job Requirements (Skills & Qualifications):

TALENTMARK ACADEMY CERTIFICATION IS COMPULSORY TO APPLY FORTHIS JOB.

• Strong knowledge of Pivot Tables& Pivot Charts
  
• Proficiency with Advanced ExcelFormulas (VLOOKUP,INDEX/MATCH, SUMIFS, COUNTIFS, IFERROR, nested functions)
  
• Experience with DataVisualization and ConditionalFormatting
  
• Ability to perform Data Cleaning& Validation
  
• Understanding of basic FinancialModeling & Statistical Analysis
  
• Familiarity with What-IfAnalysis tools (Goal Seek,Scenario Manager)
  
• Solidcommunication andproblem-solving skills
  
• Attention to detail, accuracy, and ability to managemultiple tasks
  

Educational Qualification:

• Bachelor’s degree in Commerce, Management, Finance, Statistics,or related fields.
  
• Competitivesalary package based on skills and experience
  
• Professionaltraining and skill enhancement opportunities
  
• Collaborativeand supportive working environment
  
• Opportunitiesfor career advancement within the organization
  
• Recognitionfor performance and contribution