Financial Modeling in Excel & VBA

 

An intensive three-day, computer-based practical training workshop with case studies and worked examples. This course provides a solid foundation to a wide range of Excel techniques applicable to all model building and data analysis.

Training courses

Banking & Finance

Course Background

Excel is the tool of choice in many different areas, such as investment appraisal, capital planning, budgeting, valuation, data analysis and forecasting. Banks and businesses worldwide rely on the information produced by financial models and therefore accurate modelling is an essential skill.

The first part of the course begins by outlining methods for building reliable models and showing how to make them results-orientated, flexible and scalable. Emphasis is placed on incorporating risk and building output scenarios.

The second section of the course concentrates on data imports, analysis and reporting and demonstrates the power of Excel for data manipulation.

Course Background

An intensive three-day, computer-based practical training workshop with case studies and worked examples. This course provides a solid foundation to a wide range of Excel techniques applicable to all model building and data analysis.

Excel is the tool of choice in many different areas, such as investment appraisal, capital planning, budgeting, valuation, data analysis and forecasting. Banks and businesses worldwide rely on the information produced by financial models and therefore accurate modelling is an essential skill

The first part of the course begins by outlining methods for building reliable models and showing how to make them results-orientated, flexible and scalable. Emphasis is placed on incorporating risk and building output scenarios.

The second section of the course concentrates on data imports, analysis and reporting and demonstrates the power of Excel for data manipulation.

Key Points

Featuring:

  • Model design and structure
  • Spreadsheet best practice methodology
  • Testing and auditing a model
  • Forecasting techniques
  • Sensitivity and scenario building
  • Optimisation and targeting
  • Data analysis and dashboards

On completion of this workshop, delegates will be able to:

  • Build models used a tried and tested methodology
  • Use a wide range of Excel techniques
  • Understand how to incorporate risk, sensitivity, optimisation and forecasting
  • Produce management reports, summaries and meaningful charts

Teaching Methodology

The programme is taught using demonstrations combined with practical and interactive case studies. The exercises in each session reinforce the concepts covered in each of the units. Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel.

Materials

Participants will receive printouts of all slides and the Excel spreadsheets used during the workshop plus a selection of templates and add-ins.

 

This course is also available bespoke for larger groups and organizations.

Who is this course for?

CFOs

Financial Controllers and Managers

Financial and Business Analysts

Risk Managers

Accountants

Corporate Treasury Managers

Middle Office Staff

General Managers


Public course dates for - Financial Modeling in Excel & VBA