About the course

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