26 Sep
|
BAYFORD HUMAN CAPITAL
|
Kozhikode
26 Sep
BAYFORD HUMAN CAPITAL
Kozhikode
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 specialists and learners.
Develop structured training materials, practical exercises, and real-world case studies.
Explain complex Excel concepts in a easy 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 Energetic 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
📌 Advanced Excel Trainer Kozhikode
🏢 BAYFORD HUMAN CAPITAL
📍 Kozhikode