JOB DESCRIPTION

Corporate Trainer - Advanced MS Excel

Position Title: Corporate MS Excel Trainer

Contract Duration: 1 Week (Full time Corporate Workshop)

Locations: Noida & Bengaluru (On-site)

Employment Type: Short-Term Contract

1. Role Overview

2. 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 dynamic 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.

3. 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.

4. 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)
🏢 Integraminds
📍 Bengaluru