Advanced Excel Trainer

We are looking for a highly skilled Advanced Excel Trainer to conduct practical and industry-oriented training sessions. The ideal candidate should have strong expertise in advanced Excel functions, data analysis, reporting, dashboards, automation, and business intelligence tools.

Key Responsibilities

• Conduct advanced Excel training sessions for professionals and learners.
• Develop structured training materials, practical exercises, and real-world case studies.
• Explain complex Excel concepts in a simple and practical manner.
• Provide hands-on training and live demonstrations.
• Evaluate participants through assignments, projects, and assessments.
• Provide individual guidance and feedback to learners.
• Customize training content according to organizational or learner requirements.
• Stay updated with the latest Excel features and industry practices.

Advanced Excel Topics

• Advanced Excel Formulas & Functions
• XLOOKUP, VLOOKUP, HLOOKUP, INDEX & MATCH
• IF, IFS, SUMIFS, COUNTIFS and Nested Functions
• Array Formulas and Dynamic Arrays
• Pivot Tables & Pivot Charts
• Advanced Data Analysis
• Data Cleaning and Transformation
• Conditional Formatting & Data Validation
• Advanced Charts and Interactive Reports
• Dashboard Creation
• What-If Analysis, Goal Seek & Scenario Manager
• Power Query
• Power Pivot & Data Models
• DAX – Added Advantage
• Macros and VBA Automation
• Excel Automation and Reporting
• Real-world Business Case Studies

Requirements

• Excellent knowledge of Microsoft Excel and Advanced Excel.
• Strong practical experience in data analysis, reporting, and dashboard creation.
• Hands-on knowledge of Power Query, Power Pivot, and VBA is preferred.
• Previous experience as an Excel/Corporate Trainer is preferred.
• Excellent communication and presentation skills.
• Ability to deliver engaging, practical, and interactive training sessions.
• Strong analytical and problem-solving skills.

Qualifications

• Bachelor's or Master's degree in any relevant discipline.
• Microsoft Office/Excel certification is an added advantage.
• Relevant industry experience in MIS, Business Analytics, Finance, HR, Operations, or Data Analysis is preferred.

Experience

2+ years of experience in Advanced Excel / Data Analysis / Excel Training preferred.

Work Mode

Online / Offline, based on training requirements.

Work Location: In person