Course Detail()

Programme Objective

Build effective Budget Model quickly and systematically to meet business needs efficiently
Prepare What-if analysis to support better Management Decision Making
Understand the Do’s and Don’t’s in Building Financial Model using Excel
Leverage on Excel Functions to enhance the models
Use Macro recording to automate certain repetitive tasks efficiently

Programme Outline

Financial Model 1: Building Financial Budgeting Tracking Model

Understand the importance of layout planning for a successful budget proposal.
Understand common basis for deriving budget number
Learn to calculate and organise the worksheet systematically to derive the number
Restrict input to a defined set of options
Expand the Budgeting model to include updated actual data
Prepare 12-month rolling budget

Financial Model 2: Building Variance Analysis Model

Prepare interactive variance analysis report for easy comparison and analysis
Prepare Dashboard for Reporting
Prepare useful reports for comparisons
Learn to use simple macro to automate and simplify reports

Putting it Together

Create one click button to move between worksheet

Training Methodology

Webinar Style with Lecture, Demo and Hands On Exercise

Closing Date for Registration

One week prior to course commencement

Intended For

Accountants, Finance Managers, Accounts Supervisor (Intermediate to Advance Level)

Schedule & Fees

Testimonial

Past Participant

Funding

1] NTUC Union Training Assistance Programme (UTAP)

NTUC members enjoy 50% *unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2025.

*Unfunded course fee refers to the balance course fee payable after applicable government subsidies. This excludes material fees, registration fees, misc. fees etc.

This course is approved for UTAP support for intakes conducted between 08 February 2024 – 31 March 2025.

As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.

Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
Course by training provider must be supported under UTAP and training must commence within the supported period and;
Unfunded course fee must not be fully sponsored by company or other types of funding
Unfunded course fee must be S$20.00 and above, and;
Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
UTAP application must be made within 6 months after course ends.

For more information on UTAP Funding and to submit for UTAP claims, please visit https://www.ntuc.org.sg/uportal/programmes/union-training-assistance-programme. Terms and conditions apply.

Programme Facilitator(s)