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
We are seeking an experienced, high-impact MS Excel Corporate Trainer for an intensive 1-week training engagement. The successful candidate will lead interactive, hands-on training sessions for our employees in Noida/ Bengaluru. This role focuses on elevating workforce proficiency from basic/intermediate handling to advanced data manipulation, automated workflows, reporting dashboards, and analytical efficiency.
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 modules.
● Corporate Communication: Exceptional verbal and written communication skills with experience engaging corporate audiences.
● Adaptability & Patience: Capability to manage classrooms with mixed skill levels, ensuring both novice and experienced users remain engaged.
● Problem Solving: A strong analytical mindset to troubleshoot formula errors live in class and provide practical solutions to real work problems.
5. Preferred Qualifications & Experience
● Experience: 3+ years of professional corporate training or facilitation experience in MS Excel, Data Analytics, or Business Intelligence.
● Certifications: Microsoft Office Specialist (MOS) Expert / Master in Excel certification is highly desirable.
● Education: Bachelor's degree in Computer Science, Statistics, Finance, Business Administration, or related fields.
● Location Availability: Ability to conduct on-site sessions in Noida or Bengaluru for the full 1-week program duration.
Pay: ₹2,000.00 - ₹30,000.00 per week
Work Location: In person
