Excel Advanced with AI Tools
DATE
04–05 January 2027
TIME
9:00am – 5:00pm, 2 days
VENUE
Kuching · venue confirmed on registration
COURSE CONTENT
2 days · 9:00am–5:00pm · Advanced · Bring your own data
Let Copilot or another AI tool draft the formula, PivotTable or VBA, then check it before it reaches a report. You work on your own export and leave with something you can use on Monday.
What you cover
• Smart formulas: IFS, SUMIFS, XLOOKUP, TEXTJOIN, MAXIFS
• PivotTables, slicers and calculated metrics
• Charts and a one-page dashboard
• Advanced pivots and the Data Model
• Data cleaning with Power Query
• Macros and VBA, drafted and debugged with AI
You leave with
• A one-page dashboard on your own numbers
• A step-by-step reference sheet
• Clear PDPA rules on what never goes into AI