The global body for professional accountants

Apply now
Request info
myACCA
14
UNITS

Webinar | ACCA

Financial Modelling For Forecasting, Budgeting & Financial Statements In Excel

Gain essential skills for creating robust financial models in this 2-day hands-on online workshop on forecasting and budgeting delivered in Microsoft Excel

Overview

financial modelling excel class webinar training

Gain essential skills for creating robust financial models in this 2-day hands-on online workshop on forecasting and budgeting delivered in Microsoft Excel. Participants will learn how to create forecasting and budgeting financial models using Excel.

This course will cover the fundamentals of financial forecasting, budgeting, and generating accurate financial statements, all designed to enhance decision-making. Ideal for finance professionals, the course provides hands-on training to develop models that support effective financial planning and analysis.

Being an Excel-intensive class, participants are expected to possess a mid-level working knowledge of MS-Excel. The session teaches participants the Excel and statistics know-how in building a robust budgeting and forecasting financial model.

Financial Models covered are the Budgeting Model, Forecasting Model and the 3-Statement Model. The use of MS-Excel is extensive, and laptops affixed with Excel 2019 (or higher) with Power Query are required. This programme is conducted with practical exercises and case studies.

  1. Financial Models
  2. Building the financial model
  3. Forecasting methods
  4. Price setting for products & services
  5. Cashflow
  6. Form Controls
  7. Extracting and consolidating historical accounting data
  8. NPV & IRR
  9. Important Excel knowledge
  10. Managing multiple budget versions
  11. Introduction to business intelligence tools in Excel

Please click here to see complete outline and course schedule

 

Vincent Chin FCCA

Vincent has held financial, continuous improvement and I.T. positions in the banking, shared services and hospitality industry. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Certified Trainer, Microsoft Office Specialist and a PSMB-accredited trainer. His previous roles include being an internal change consultant of a global team, a financial shared-services local head and a finance regional head.

He currently trains professionals in Excel, Power BI and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA and process improvement.

Qualifications

  • Microsoft Certified Trainer| MICROSOFT | 2020
  • Microsoft Office Specialist Expert| MICROSOFT | 2020
  • Microsoft BI Reporting in Excel | MICROSOFT | 2019
  • Microsoft Office Specialist | MICROSOFT | 2017
  • Certified Trainer | PSMB | 2013
  • Certified Six Sigma Black Belt | ASQ | 2011
  • FCCA | ACCA | 1998

CPD units

Attendance to this session will accord you with 14 CPD units. A CPD certificate will be sent to you by email within 2 business days after your completion of this online workshop.

Requirements

  • Required software: Excel 2019 or above. Microsoft for Excel 365 is preferred.
  • Participants with Excel versions earlier than Excel 2019 may not be able to participate fully in certain topics of the learning session.
  • Participants are encouraged to use two computers (if available) for online training.

 

Pricing and booking information

Price

Member 465 SGD

Affiliate 475 SGD

Approved employer 530 SGD

Student 475 SGD

Public 600 SGD

Location

Singapore

Date & time

18 March 2025 - 19 March 2025

Book on ACCA

Delivered by

ACCA logo