25 August 2026 · 9:00 AM – 5:00 PM · WORQ KL Gateway Mall, Bangsar South, Kuala Lumpur
2-Day Physical Public Training · 100% HRDC Claimable · Limited to 10 participants
Doing everything in Excel by hand?
If you already work confidently in Excel but still build every formula and report from scratch, this 2-day programme shows you how to combine advanced spreadsheet techniques with AI assistants — turning hours of manual work into minutes of guided, AI-assisted output.
Who should attend this advanced Excel training in Malaysia
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 trainer support.
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, 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 instant 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 accurate 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 is trainer-led demonstration followed by hands-on practice on real business datasets. Each participant receives a step-by-step lab workbook and a prompt library to take away.
HRDC claim details
This programme is 100% HRDC Claimable for HRD Corp registered employers.
- 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 · MyCoID 20220326 2664
Our team will guide you through the HRDC grant application before the training date, so your claim is ready in time.
Limited to 10 participants
Small class, real practice — you work on live datasets with AI tools open on your own laptop, with direct trainer support throughout. Seats are confirmed on a first-come, first-served basis.
Register now
WhatsApp us at +6010 926 5226 or email amy@goflexevents.com to reserve your seat.
Frequently asked questions
Can my company claim this under HRD Corp?
Yes — registered employers can claim under the HRD Corp Claimable Courses scheme (Skim Bantuan Latihan Khas). WhatsApp us and we’ll walk you through the grant 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 to bring anything?
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 available as an in-house training customised to your company anywhere in Malaysia, also HRDC claimable. Contact us for a proposal.
