29-30 October 2026 · 9:00 AM – 5:00 PM · WORQ, KL Gateway Mall, Bangsar South, Kuala Lumpur
2-Day Physical Public Training · HRD Corp Claimable · Limited to 10 participants
HRD Corp Rate: RM1,699 per participant · Self-Pay Special Rate: RM1,299 per participant
Download Programme Outline (PDF)
Doing everything in Excel by hand?
If you already work confidently in Excel but still spend too much time building formulas, analysing data and preparing reports, this 2-day programme shows you how to combine advanced Excel techniques with AI assistants to work more efficiently and make better-informed decisions.
Who should attend this Advanced Excel with AI training?
Executives, analysts, finance and accounts professionals, and experienced Excel users who are already comfortable with intermediate formulas, PivotTables and formatting – and who want to advance both their technical Excel skills and their fluency with AI tools like Microsoft Copilot and Claude.ai for daily reporting and decision-making.
Class is capped at 10 participants so everyone gets hands-on support throughout the programme.
What you will be able to do after 2 days
- Apply advanced lookup functions (INDEX-MATCH, XLOOKUP, XMATCH) and dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE)
- Use Goal Seek, Data Tables and Scenario Manager to model business decisions
- Build a Power Pivot data model with relationships across multiple tables
- Use Microsoft Copilot in Excel to generate formulas, summarise data and suggest charts in plain language
- Use Claude.ai to explain, debug and generate formulas and VBA macros, and to analyse uploaded datasets
- Write effective prompts using the Role-Task-Content framework
- Critically review and validate AI-generated formulas before applying them to real reports
- Produce an AI-assisted management report combining advanced Excel with Copilot and Claude.ai
Programme agenda
Day 1 – Advanced Excel Core Skills
- Advanced Lookup & Reference Functions: INDEX-MATCH, XLOOKUP and XMATCH for flexible multi-directional lookups; multi-condition lookups and troubleshooting reference errors
- Dynamic Arrays & Modern Functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and spill ranges; building self-updating summary lists without helper columns
- What-If Analysis & Decision Tools: Goal Seek, Data Tables and Scenario Manager for modelling business decisions; sensitivity analysis for budgeting and forecasting
- Power Pivot & Data Model Basics: importing tables into the Data Model, creating relationships, basic DAX measures, and cross-table PivotTables beyond a single sheet
Day 2 – AI-Powered Excel with Copilot & Claude.ai
- AI in Spreadsheets – The New Landscape: how AI is changing spreadsheet work, and where Microsoft Copilot and Claude.ai each fit into a typical workflow
- Microsoft Copilot in Excel: natural-language formula generation, data summarisation, trend highlights and chart or PivotTable suggestions inside the worksheet
- Smarter Formulas with Claude.ai: explaining, debugging and rewriting complex formulas; generating XLOOKUP, array and nested-IF formulas from plain English; drafting VBA macros for repetitive tasks
- AI-Assisted Data Analysis: uploading and analysing datasets for pattern spotting and anomaly detection; comparing AI-generated insights against manual PivotTable analysis
- Prompt Writing for Spreadsheet Tasks: the Role-Task-Content framework for formulas, summaries and dashboard narratives; reviewing and validating AI output before use
- Capstone – AI-Assisted Report & Dashboard: hands-on lab combining advanced formulas, Power Pivot and AI prompts to produce a polished management report, with group walkthrough and Q&A
Each day runs 9:00 AM – 5:00 PM. Lunch and refreshments provided.
Bring your laptop with Microsoft Excel installed – every session combines trainer-led demonstration with hands-on practice using real business datasets.
Each participant receives a step-by-step lab workbook and a prompt library to take away.
Training fees & registration
- HRD Corp Rate: RM1,699 per participant
- Self-Pay Special Rate: RM1,299 per participant
The self-pay special rate is available for participants paying for the programme personally.
Choose the registration option that applies to you:
HRD Corp Registration – RM1,699
HRD Corp claim details
This programme is HRD Corp Claimable for registered employers, subject to employer eligibility and HRD Corp approval.
- Registered programme title: Advanced Excel & AI-Powered Excel Tools
- Scheme: HRD Corp Claimable Courses (Skim Bantuan Latihan Khas)
- Course type: Scientific, Technical or Statistics · Hard Skill
- Training provider: GOFLEX EVENTS (M) SDN. BHD. (SA0588592-U) – HRD Corp Registered Training Provider
Our team will guide you through the HRD Corp grant application process before the training date.
Download Programme Outline (PDF)
Limited to 10 participants
Small class, real practice – work on real business datasets with Excel and AI tools on your own laptop, with direct support throughout the programme.
Seats are confirmed on a first-come, first-served basis.
Frequently asked questions
How much is the Advanced Excel with AI training?
The HRD Corp rate is RM1,699 per participant. Participants paying personally can register at the self-pay special rate of RM1,299 per participant.
Can my company claim this under HRD Corp?
Yes – registered employers can claim under the HRD Corp Claimable Courses scheme (Skim Bantuan Latihan Khas), subject to employer eligibility and grant approval. WhatsApp us and we’ll walk you through the application steps.
Do I need to know Excel well before attending?
Yes. This is an advanced programme – you should already be comfortable with intermediate formulas, PivotTables and formatting.
If your team is still building those foundations, start with our Mastering Microsoft Excel: Intermediate & Advanced programme first.
Do I need AI experience before attending?
No prior AI experience is required. The programme introduces how Microsoft Copilot and Claude.ai fit into spreadsheet workflows, including practical prompting and how to review and validate AI-assisted output.
Do I need to bring anything?
Bring a laptop with Microsoft Excel installed and internet access. Each participant receives a lab workbook and a prompt library to keep.
Where exactly is the venue?
WORQ, KL Gateway Mall, Bangsar South, Kuala Lumpur – directly connected to Universiti LRT station, with parking available in the mall.
Can we run this in-house for our team instead?
Yes. This programme is also available as an in-house corporate training programme customised for your team anywhere in Malaysia.
