Course Detail(IT077v : Building Interactive Budget Tracking and Variance Analysis Model using Excel (Live Webinar))
Not Available

UTAP Funding

IT077v : Building Interactive Budget Tracking and Variance Analysis Model using Excel (Live Webinar)

7.00 CPE Hours (Category 5)
Live Webinar

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
 
27 November 2020
 

Intended For

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

Competency Mapping

Category 5 = 7.00 Hours

Schedule & Fees
Date & Time

30 Aug 2024 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 318.28
For Non-Members: $ 382.59

Programme Facilitator(s)

Terry Wong

Venue

Online Classroom in or outside of
Singapore
Date & Time

02 Dec 2024 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 381.50
For Non-Members: $ 458.89

Programme Facilitator(s)

Terry Wong

Venue

Online Classroom in or outside of
Singapore

Testimonial


Great tips shared by the trainer. Very useful to apply in my work.

Past Participant


It helps me to gain more knowledge on many areas relating to my profession

Past Participant


Enable me to better make use of excel formulas to build, track and performance analysis on the budget

Past Participant


This programme really helped in preparing budget effectively

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)


Terry Wong
 
Mr. Terry Wong (ACCA) is an experienced trainer and heavy user of MS Excel. He started his career in IBM’s Shared Service Center as an Accounting Analyst where he is required to be involved in many process improvement projects and initiatives, including leveraging on creative Excel to build templates, streamline processes and automate reports and tools. Subsequently, he became an Accounting System Analyst in IBM where his role is involved in system technical support.  This gave him a platform to provide numerous in-house training, to more than 300 accountants across finance and accounting department. His training received great feedback and was invited to provide training to non-accounting department and also to offices outside the region such as emerging market in Far East countries.

Being the technical support that understand both the technical knowledge and with the proper finance professional qualification, Terry was able to quickly understand and help his audience to brainstorm, provide smart and practical insights in dealing and solving many real-life work challenges using MS Excel.  

His strong analytical skill, capability to quickly research coupled with detail process driven nature makes him a competent trainer in helping participants to come out with creative ideas in solving work problems. He is frequently engaged to conduct small group coaching in guiding internal advanced MS Excel users to further streamline and enhance the reports and work processes through MS Excel.  

 

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
 
27 November 2020
 

Intended For

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

Competency Mapping

Category 5 = 7.00 Hours

Programme Facilitator(s)

Terry Wong
 
Mr. Terry Wong (ACCA) is an experienced trainer and heavy user of MS Excel. He started his career in IBM’s Shared Service Center as an Accounting Analyst where he is required to be involved in many process improvement projects and initiatives, including leveraging on creative Excel to build templates, streamline processes and automate reports and tools. Subsequently, he became an Accounting System Analyst in IBM where his role is involved in system technical support.  This gave him a platform to provide numerous in-house training, to more than 300 accountants across finance and accounting department. His training received great feedback and was invited to provide training to non-accounting department and also to offices outside the region such as emerging market in Far East countries.

Being the technical support that understand both the technical knowledge and with the proper finance professional qualification, Terry was able to quickly understand and help his audience to brainstorm, provide smart and practical insights in dealing and solving many real-life work challenges using MS Excel.  

His strong analytical skill, capability to quickly research coupled with detail process driven nature makes him a competent trainer in helping participants to come out with creative ideas in solving work problems. He is frequently engaged to conduct small group coaching in guiding internal advanced MS Excel users to further streamline and enhance the reports and work processes through MS Excel.  

 

Upcoming Schedule

Date & Time

30 Aug 2024 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)

For Members: $ 318.28
For Non-Members: $ 382.59

Programme Facilitator(s)

Terry Wong

Venue

Online Classroom in or outside of
Singapore


Other courses you might like

View Courses 
14.00
CPE Hours
Classroom

Creating Professional PivotTable Driven Reports (Intermediate Level)

23 Apr 2024 - 24 Apr 2024

  • SkillsFuture Credit
  • UTAP
7.00
CPE Hours
Live Webinar

RPA Implementation Strategy for Accounting Firms (Live Webinar)

30 Apr 2024 - 30 Apr 2024

  • UTAP
7.00
CPE Hours
Classroom

Learning Microsoft Excel Power Query in Ease

02 May 2024 - 02 May 2024

  • UTAP