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

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

Write and Edit VBA for Finance 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, and simple error handling, all applied to finance tasks. Every exercise uses fictional company data, and the programme ends with a final project: a payroll reconciliation that runs with VBA.

2 days
Excel, VBA & Macro Automation for Finance 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 ledger listings row by row.
  • Move data between sheets and workbooks with VBA.
  • Build reconciliation checks that flag exceptions.
  • 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 ledger listings row by row.
  5. 5

    WORKING WITH SHEETS & WORKBOOKS

    • • Move data between files.
  6. 6

    AUTOMATED RECONCILIATION CHECKS

    • • Match two listings and flag the differences.
  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?
Accountants, Finance Executives, Finance Managers, Account Assistants, Accounting Firms.
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