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

Excel for Corporate Professionals (Advanced)

Dynamic Reports, Dashboards and Macros

This two-day Advanced level covers dynamic arrays, data analysis, financial modelling and reporting techniques, then introduces macros and VBA to automate repetitive tasks and report generation. Everything is practised on realistic business cases with fictional company data, and the programme ends with a final project: a financial performance dashboard.

2 days
Excel for Corporate Professionals (Advanced) corporate training session

Learning outcomes

  • Build reports with dynamic array formulas that resize themselves.
  • Analyse data to find trends and outliers.
  • Build a simple financial model with clear inputs and outputs.
  • Design one-page reports and dashboards people can read at a glance.
  • Record macros and edit simple VBA to automate repetitive tasks.

Course outline

  1. 1

    DYNAMIC ARRAYS

    • • Formulas that return whole lists.
  2. 2

    DATA ANALYSIS

    • • Find what the numbers are saying.
  3. 3

    FINANCIAL MODELLING

    • • Models that are easy to follow and change.
  4. 4

    REPORTING TECHNIQUES

    • • Reports people can read at a glance.
  5. 5

    INTRODUCTION TO MACROS

    • • What macros can do, and when to use them.
  6. 6

    RECORDING MACROS

    • • Capture a routine once, then replay it.
  7. 7

    INTRODUCTION TO VBA

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

    AUTOMATING REPETITIVE TASKS

    • • Hand the routine work to Excel.
  9. 9

    AUTOMATED REPORT GENERATION

    • • Produce the monthly report with one click.

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