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

Excel for Accounting & Finance Professionals (Intermediate)

Reconciliations, Ageing and Fixed Assets in Excel

This two-day Intermediate level brings in the tools that do that work: XLOOKUP, INDEX & MATCH, SUMIFS and PivotTables, applied to general ledger reconciliation, payables and receivables ageing, and the fixed asset register with its depreciation. Every exercise uses fictional company data, and the programme ends with a final project: a fixed asset register with a depreciation schedule.

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

Learning outcomes

  • Set up workbooks and number formats suited to accounting work.
  • Clean and structure ledger and bank data in Excel Tables.
  • Use core formulas and absolute references correctly.
  • Sort and filter transactions to find what matters.
  • Use data validation to keep account codes and entries consistent.
  • Prepare a simple bank reconciliation.

Course outline

  1. 1

    EXCEL FOR FINANCE WORK

    • • Set up a workbook the way finance teams need it.
  2. 2

    BASIC SKILLS

    • • The formulas every finance task relies on.
  3. 3

    ACCOUNTING DATA MANAGEMENT

    • • Turn ledger and system exports into clean data.
  4. 4

    SORTING AND DATA FILTERING

    • • Find the transactions you need, fast.
  5. 5

    DATA VALIDATION

    • • Stop errors at the point of entry.
  6. 6

    BANK RECONCILIATION

    • • Reconcile the bank statement to the cash book.

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