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

Excel for Accounting & Finance Professionals (Basic)

Clean, reliable accounting data and a first reconciliation

This one-day Basic level gives accountants and finance staff a solid Excel footing: clean and structure accounting data, use the core formulas with confidence, and put simple controls in place. Every exercise uses fictional company data, and the day ends with a final project: a bank reconciliation.

1 day
Excel for Accounting & Finance Professionals (Basic) 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 FORMULAS

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

    ACCOUNTING DATA MANAGEMENT

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

    SORTING AND 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?
1 day. 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