WhatsApp us Skip to content
Corporate Training Malaysia Request a quote
Excel training · In-house & public

Microsoft Excel training for Malaysian companies

Stop rebuilding the same report by copy-paste every month. Your team learns the formulas, pivot tables and dashboards they need for their own work — classic Excel, with AI only if you ask for it. 100% HRD Corp claimable programmes.

Pick the level

Eight Excel programmes, from first formulas to data models and automation

Every programme runs in-house or as a public class. Not sure which fits? Tell us what your team does in Excel today and we’ll recommend one, and send the full outline.

1 day · Beginner

Excel Basic: foundations & everyday productivity

For new or occasional users who need to set up and use a clean worksheet with confidence.

  • Getting started and working with data
  • Formatting for clarity
  • Getting confident with formulas
  • Logical, text and lookup functions
  • Data validation and control
2 days · Intermediate

Excel Intermediate: smart work & business efficiency

For staff who use Excel daily but still fix things by hand.

  • Power formulas and functions
  • Structuring and cleaning worksheets
  • Working across multiple worksheets
  • Business charts, tables and structured data
  • Data validation, protection and collaboration
  • PivotTables
2 days (or 1-day version) · Intermediate to advanced

Excel Intermediate to Advanced: analysis, reporting & automation

Our broadest programme: analysis, reporting and automation in one course.

  • Excel functions for analysis
  • PivotTable mastery, calculations and insights
  • Pivot charts and dashboards
  • Power Query: cleaning and preparing data
  • Automation with macros and VBA essentials
  • AI-enhanced automation
1 day · Intermediate

Excel Dashboard & Reporting

Build a one-page dashboard your managers will actually use.

  • Dashboard design principles
  • Preparing data for PivotTables
  • Building and analysing PivotTables
  • Creating, formatting and customising PivotCharts
2 days · Intermediate to advanced

Power Query, Data Modelling & Power Pivot

For teams who combine exports from several systems and want the monthly report to update with one Refresh. No coding.

  • Power Query: connect to Excel, CSV, database and web sources
  • Clean, transform and reshape data
  • Combine tables with merge and append; refresh a folder of files
  • Power Pivot data model, relationships and hierarchies
  • DAX measures, PivotTables and PivotCharts on the model
1 day · Intermediate

Mastering Excel VBA Macros with ChatGPT

For teams who repeat the same steps every week and want Excel to do them.

  • Where AI fits in Excel work
  • Building formulas with AI, including harder dynamic ones
  • Automating with macros and VBA
  • Real use cases and working practice
2 days · Advanced

Excel Advanced with AI tools

Analyse, report and automate with Microsoft Copilot and other AI tools.

  • AI-guided formulas and PivotTable insights
  • AI-powered charts and dashboard automation
  • Advanced pivot analysis
  • AI-enhanced data cleaning with Power Query
  • Writing VBA faster with AI assistance
2 days · Advanced

Excel Advanced with Statistical Analysis for Engineers

Analyse test results, monitor process performance and forecast, all in Excel.

  • Data analysis and automated reporting
  • Quality control and process improvement
  • Correlation and regression
  • Experiment and R&D analysis
  • Forecasting and planning

Want AI in the mix? Our AI + Excel automation programme adds ChatGPT and Copilot on top of the same skills.

At your office, or in a public class

In-house

We come to your team

  • Exercises built on your own reports and data, if you share samples
  • We check your Excel version first and teach functions that work on it
  • Anywhere in Malaysia, at your office or live online
Public class

Send one or two staff

Common questions

Is the training HRD Corp claimable?

Yes — 100% HRD Corp claimable programmes. We send the outline and quotation your HR team needs to apply.

Do participants need their own laptop?

Yes, with Microsoft Excel installed. Tell us the Excel version your company uses and we’ll match the exercises to it.

Can you use our own files?

For in-house training, yes. Send us a sample report (with confidential figures removed) and we’ll build exercises around it.

Does this include AI?

Only if you want it. These are standard Excel programmes. If your team wants ChatGPT or Copilot as well, see AI + Excel automation.

Tell us what your team does in Excel

We’ll suggest the right level and send an outline and quotation.