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

Excel for Accounting & Finance Professionals (Advanced)

Automating Reconciliation, Reporting and Month-End

This two-day Advanced level shows how to automate that work in Excel: reports that update themselves, a month-end closing tracker, automated schedules, exception checks and simple macros for repeated steps. Every exercise uses fictional company data, and the programme ends with a final project: an automated GL reconciliation.

2 days
Excel for Accounting & Finance Professionals (Advanced) corporate training session

Learning outcomes

  • Build financial reports that update when new data is added.
  • Run month-end with a closing tracker.
  • Produce supporting schedules automatically from the source data.
  • Build exception checks that catch errors before reporting.
  • Present financial analysis in a dashboard.
  • Automate repeated month-end steps with macros.

Course outline

  1. 1

    FINANCIAL REPORTING

    • • Build reports straight from the data.
  2. 2

    MONTHLY FINANCIAL REPORTING

    • • Reports that refresh each month.
  3. 3

    MONTH-END CLOSING TRACKER

    • • See where every closing task stands.
  4. 4

    AUTOMATED FINANCIAL SCHEDULES

    • • Produce the supporting schedules automatically.
  5. 5

    EXCEPTION CHECKS AND CONTROLS

    • • Let the workbook point out the errors.
  6. 6

    AUTOMATED GL RECONCILIATION

    • • Match, flag and explain differences automatically.
  7. 7

    FINANCIAL ANALYSIS DASHBOARDS

    • • One page that shows the month.
  8. 8

    MACROS FOR MONTH-END

    • • Record repeated steps once, then run them.

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