Financial Modelling, Budgeting, Forecasting With Excel Training Course

This practical 2 or 3 day Financial modelling, Budgeting and forecasting with Excel training course leads delegates through the advanced MS Excel functions required when modelling, explaining the functions and techniques to use to build reliable, robust financial models. It is run on a monthly basis in Midrand to facilitate delegates from Pretoria and Johannesburg.

Key Outcomes:

• Understanding HOW a spreadsheet should be built to make it robust and safe
• Best ways to set up templates to easily obtain the information required for the financial model
• How to run comprehensive ‘What If’s through the spreadsheet
• Understanding time value of money where relevant.

• Spreadsheet Best Practice
  • Why should you follow best practice guidelines for financial models
  • Consistency
  • Separating the inputs, calculations and outputs
  • Spreadsheet Integrity
• Other Spreadsheet Best Practice Suggestions
  • Determine the business drivers or triggers of the model
  • Single input vs a row of inputs
  • Contentious Issues in Spreadsheet Best Practice Theory
  • Other best practice suggestions
• Excel related tips and tricks for Financial Modelling
  • Viewing many parts of the spreadsheet (at the same time)
  • Doing Quick Calculations in a Financial Model
  • Where should you start building your formula?
  • Which cell should you check if there is an error?
  • How to build nested formula in Excel
  • Determining which Excel function to use
  • The flow of a financial model (but this does not mean it is only for accountants- we use financial terminology to explain how all models should have checks and balances in them)
  • Data Validation
• Financial Modelling Essential Knowledge
  • Building buckets for financial models
  • Function Wizard
  • Auditing a formula in financial models
  • Using $ signs (absolute and relative referencing)
  • IF function in Financial Models
• Headers for Financial Models
  • Building the Headers
  • Making use of the headers
• Aggregation
  • Trick for aggregating in Financial Models
  • Useful for the aggregation trick
  • Practical examples to be completed