Six practical modules built around real corporate workflows — plus a bonus AI + Excel session.
01
Data Preparation
Master TRIM, CLEAN, and smart extraction using Flash Fill to handle messy corporate data with ease.
02
Logical Intelligence
Utilize Nested IF, IFS, and Error Handling (IFERROR) to create bulletproof spreadsheets that never fail.
03
Advanced Lookup
Beyond VLOOKUP — master XLOOKUP and INDEX & MATCH for flexible, dynamic data matching across workbooks.
04
Visual Analytics
Create dynamic KPI indicators using Formula-based Conditional Formatting and Data Bars for instant insight.
05
Pivot Mastery
Build interactive executive dashboards with Slicers and advanced data grouping — no formulas required.
06
AI + Excel
Leverage ChatGPT for rapid formula generation and automated data insight suggestions to work 70% faster.
Bonus Module
Lead Instructor
Meet your trainer
Learn from a practising corporate digital workflow expert.
MF
Lead Instructor
Muhammad Faris
Expert in corporate digital workflow. Muhammad helps teams reduce manual Excel workloads by up to 70% through intelligent automation and practical AI integration. He brings real-world experience into every hands-on session.
Nested IF evaluates multiple conditions in sequence. IFERROR wraps it to catch any errors gracefully.
Score Range
Grade
Remark
80 – 100
A
Distinction
65 – 79
B
Credit
50 – 64
C
Pass
0 – 49
F
Fail
Non-numeric
Invalid
IFERROR handles it
Module 5 — Pivot Mastery
Rows: Department | Values: COUNT(Staff), AVERAGE(Salary) | Interactive: Slicer by Region
Built from 60 raw records in seconds. Slicers let executives filter by region with a single click — no formulas, no coding.
Department
Headcount
Avg Salary (RM)
Total Payroll (RM)
Finance
12
5,200
62,400
HR
8
4,800
38,400
IT
15
6,100
91,500
Marketing
10
5,500
55,000
Operations
15
4,950
74,250
Grand Total
60
5,310
321,550
Trainer's tip: Insert → Slicer → choose "Department" or "Region". One-click interactive filtering — the feature that impresses management most.
Bonus Module — AI + Excel
ChatGPT prompt → Excel formula | Automated insight generation
Use ChatGPT as your Excel co-pilot. Describe your task in plain English — get the exact formula back instantly.
Your prompt to ChatGPT
What you learn in class: How to craft precise prompts, verify AI output, fix AI mistakes, and build a personal formula library — so you work 70% faster every day.
Training Fee
Choose your plan
One-day intensive online class via Zoom — 16 April 2026. Certificate included in both options.
