24 Sep
|
BAYFORD HUMAN CAPITAL
|
Kozhikode
24 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 professionals 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 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
📌 Advanced Excel Trainer (Kozhikode)
🏢 BAYFORD HUMAN CAPITAL
📍 Kozhikode