Skip to content
2026/2027 in-house training dates are now open.Request a proposal →
Digital & AI training

Excel, VBA & Macro Automation for Corporate Professionals (Intermediate)

Write and Edit VBA for Everyday Business Tasks

This two-day Intermediate level teaches the VBA behind the macros: reading and editing code, variables and ranges, decisions and loops, working across sheets and workbooks, data consolidation and simple error handling. Everything is practised on realistic business cases with fictional company data, and the programme ends with a final project: a tool that combines files from several departments into one summary.

2 days
Excel, VBA & Macro Automation for Corporate Professionals (Intermediate) corporate training session

Learning outcomes

  • Read and edit recorded VBA code in the VBA editor.
  • Work with cells, ranges, sheets and variables in VBA.
  • Use decisions and loops to process lists row by row.
  • Move and combine data between sheets and workbooks.
  • Add basic error handling and test macros before use.

Course outline

  1. 1

    INTRODUCTION TO VBA

    • • Read and adjust the code behind a macro.
  2. 2

    VARIABLES & RANGES

    • • Work with the data directly.
  3. 3

    DECISIONS & LOOPS

    • • Let the code decide and repeat.
  4. 4

    AUTOMATING REPETITIVE TASKS

    • • Process lists row by row.
  5. 5

    WORKING WITH SHEETS & WORKBOOKS

    • • Move data between files.
  6. 6

    DATA CONSOLIDATION

    • • Combine files from several departments.
  7. 7

    ERROR HANDLING & TESTING

    • • Macros that fail safely.

Quick facts

How long is the programme?
2 days. The schedule can be adjusted, for example split into half-day sessions, to suit your operations.
Who should attend?
Executives, Finance Staff, Analysts, Managers.
Where is it held?
In-house at your premises, at an external venue or hotel of your choice, or virtually, anywhere in Malaysia including Kuala Lumpur, Selangor, Penang and Johor.
Can the content be customised?
Yes. We tailor examples, case studies and activities to your industry, KPIs and company values while keeping the programme's learning outcomes.

Related programmes