JOB DESCRIPTION

Corporate Trainer - Advanced MS Excel

Position Title: Corporate MS Excel Trainer

Contract Duration: 1 Week (Full time Corporate Workshop)

Locations: Noida & Bengaluru (In office)

Employment Type: Short-Term Contract
Role Overview
Key Responsibilities & Role Scope
Curriculum Customization:Adapt standard training modules to align with company datasets, industry use cases, and participant skill levels.
Training Delivery:Facilitate a structured 5-day workshop covering core-to-advanced Excel functions, financial/data modeling techniques, and automation.
Hands-On Exercises:Guide participants through live practice exercises, real-world case studies, data cleaning challenges, and agile dashboard construction.
Assessment & Support:Evaluate participant progress through daily mini-assignments, address individual queries, and provide constructive feedback.
Post-Training Assets:Provide reference documentation, reusable templates, shortcut cheat-sheets, and solutions to practice workbooks.
Required Technical Skills & Expertise




Advanced Formulas & Functions:Mastery in XLOOKUP, VLOOKUP, INDEX/MATCH, INDIRECT, dynamic arrays (FILTER, UNIQUE, SORT), and complex nested logical functions (IF, AND, OR).
Data Analysis & Visualization:Expert level in Pivot Tables, Pivot Charts, Slicers, Calculated Fields, Conditional Formatting, and interactive executive dashboard design.
Power Query & Data Transformation:Proficiency in importing, cleaning, merging, unpivoting, and shaping data from disparate sources using Power Query.
VBA & Automation (preferred):Knowledge of Excel Macros and basic VBA script writing to automate repetitive reporting processes.
Data Validation & Quality Control:Expertise in input controls, error handling, audit formulas, and data structure standardization.
Key Core Competencies
Instructional Design & Facilitation:Ability to break down complex analytical concepts into easy-to-understand, step-by-step learning modul

📌 Corporate Trainer Bengaluru (India)
🏢 Integraminds
📍 India