17–18 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
Still stuck with basic spreadsheets?
If monthly reporting means hours of copy-paste, broken formulas, and messy data, this 2-day Excel training in Malaysia will change how you work. Move beyond the basics into lookup functions, PivotTables, and interactive dashboards — and turn raw workplace data into clear, useful reports.
Can’t make August? The next intake runs in November 2026 — WhatsApp us to reserve early.
Who should attend this Excel training in Malaysia
Executives, administrators, finance and accounts personnel, HR practitioners, sales and operations coordinators — any working professional who uses Excel regularly and wants to move up to intermediate-level analysis and reporting. You should already know the basics: cell referencing, simple formulas, and basic formatting. Class is capped at 10 participants, so everyone gets hands-on trainer support.
What you will be able to do after 2 days
- Create and apply Custom Lists to speed up data entry and sorting
- Use Subtotal, VLOOKUP, logical functions, and database statistical functions to analyse structured data
- Apply MAX, MIN, COUNT and AVERAGE — and their conditional variants — to summarise datasets
- Apply Conditional Formatting and Data Validation to improve accuracy and visual reporting
- Consolidate data from multiple sheets and workbooks into a single summary view
- Build PivotTables with Slicers to create interactive, filterable reports
- Define Range Names to simplify and audit your formulas
- Design charts and assemble them into an interactive dashboard with a clickable index sheet
- Understand what Power Query does, and perform a basic data import and cleanup
Programme agenda
Day 1 — Formulas, Functions & Data Analysis Foundations
- Excel Setup & Custom Lists: creating and editing custom lists for fast, consistent data entry and custom sort sequences (departments, branches, product categories)
- Core Statistical & Aggregation Formulas: MAX, MIN, COUNT, COUNTA, AVERAGE and their conditional variants (MAXIFS, MINIFS, COUNTIFS, AVERAGEIFS); building quick summary panels from raw data
- Logical Functions: IF, nested IF, AND, OR, NOT, IFS and IFERROR; combining logical tests with lookup and aggregation formulas
- VLOOKUP & Database Statistical Functions: exact vs approximate match with error troubleshooting; DSUM, DAVERAGE, DCOUNT, DMAX and DMIN for criteria-based analysis
Day 2 — Data Management, PivotTables & Interactive Dashboards
- Subtotal & Multi-Sheet Consolidation: automatic subtotals on grouped data; consolidating figures across worksheets and workbooks using 3-D references
- Define Range Names: Name Box, Name Manager and Create from Selection; using names in formulas for clarity and fewer errors
- Conditional Formatting & Data Validation: rule-based and formula-based highlighting; controlling data entry with drop-down lists, custom formulas, and input/error alerts
- PivotTables & Slicers: building PivotTables from structured data; grouping, filtering, calculated fields; adding Slicers and Timelines for interactive filtering
- Graphs & Interactive Dashboard Design: choosing the right chart type; linking charts, PivotTables and Slicers into a single dashboard sheet
- Hyperlinks, Dashboard Index & Power Query Introduction: building a clickable navigation sheet; what Power Query is, when to use it, and a live demo of importing and cleaning a dataset
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, using real-world datasets and a step-by-step lab workbook provided to each participant.
Your trainer
- Senior Corporate Trainer
- HRD Corp Accredited Trainer
- Microsoft Master Instructor · Microsoft Certified Trainer
- Microsoft Office Specialist Master (Excel, Word, Access, PowerPoint)
- Over 35 years of software training experience
- Trained professionals across 180+ organisations, including Bank Negara Malaysia, Maybank, Canon, Intel, and government agencies
HRDC claim details
This programme is 100% HRDC Claimable for HRD Corp registered employers.
- Registered programme title: Mastering Microsoft Excel – Intermediate & Advanced
- 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 actual reporting scenarios with direct trainer support, not a lecture. 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.
Is this suitable for complete beginners?
You should already use Excel for basic tasks — cell referencing, simple formulas, basic formatting. If your team needs to start from zero, contact us about a foundation-level in-house session instead.
Do I need to bring anything?
A laptop with Microsoft Excel installed. All exercises are hands-on with real workplace datasets, and each participant receives a step-by-step lab workbook.
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 Excel training is available as an in-house programme customised to your company anywhere in Malaysia, also HRDC claimable. Contact us for a proposal.
