Module 3 — Lookup & Reference Functions

• •3.1　The concept of lookup — linking data across tables
• •3.2　VLOOKUP — all 4 arguments explained
• •3.3　Exact match (FALSE) vs approximate match (TRUE)
• •3.4　XLOOKUP — the modern Microsoft 365 powerhouse
• •3.5　VLOOKUP vs XLOOKUP — full comparison
• •3.6　INDEX + MATCH — the ultimate combo
• •3.7　Troubleshooting common errors (#N/A, #REF!, IFERROR)
• •3.8　Hands-on: Cross-sheet employee record lookup system
• •3.9　Recap + quiz

Module 4 — Data Validation & Conditional Formatting

• •Part A: Data validation
• •4.1　Data validation concept — the gatekeeper against bad input
• •4.2　Drop-down lists — the most-used validation feature
• •4.3　Custom validation — rules built with formulas
• •4.4　Input messages + error alerts
• •Part B: Conditional formatting
• •4.5　Built-in rules — data bars / colour scales / icon sets
• •4.6　Highlight entire rows — formula-based conditional formatting
• •4.7　Top 10 / duplicate values / unique values
• •4.8　Hands-on: Smart task tracker — putting it all together
• •4.9　Recap + quiz

Module 5 — Pivot Tables, Pivot Charts & Slicers

• •Part A: PivotTable basics
• •5.1　PivotTable concept — turn 100 rows into a multi-dimensional report
• •5.2　The 4 areas (Filters / Columns / Rows / Values)
• •5.3　Create a PivotTable — in 5 steps
• •5.4　Summary functions + grouping + Show Values As
• •Part B: PivotCharts
• •5.5　PivotCharts — the 4 go-to chart types
• •Part C: Interactive dashboards
• •5.6　Slicers — visual filtering
• •5.7　Timelines — the date-specific slicer
• •5.8　Hands-on: Interactive sales dashboard
• •5.9　Recap + quiz

Module 6 — What-If Analysis

• •Part A: Goal Seek
• •6.1　What-If Analysis concept — 3 decision-support tools
• •6.2　Goal Seek — reverse-solving made easy
• •6.3　Goal Seek in action — home loan calculator
• •Part B: Scenario Manager
• •6.4　Scenario Manager — comparing multiple scenarios
• •6.5　Scenario Manager in action — 3 sales-target scenarios
• •Part C: Data Tables
• •6.6　One-variable Data Table — interest-rate sensitivity
• •6.7　Two-variable Data Table — rate × tenure matrix
• •6.8　Hands-on: Integrated financial analysis — all 3 tools combined
• •6.9　Recap + quiz

Module 7 — AI for Excel Productivity

• •Part A: Bringing AI and Excel together
• •7.1　AI + Excel concept — the 3 AI assistants (Copilot / ChatGPT / Claude)
• •7.2　AI vs traditional Excel — when to use which
• •7.3　The 3-part prompt formula — the gold standard for AI prompts
• •Part B: AI in practice
• •7.4　AI writes formulas — plain English to Excel formula
• •7.5　AI explains formulas — taking over someone else's file
• •7.6　AI generates sample data + cleans messy data
• •7.7　AI writes management commentary + translation
• •7.8　Hands-on: Malaysian working-day formula (AI prompt walkthrough)
• •7.9　Recap + quiz