Financial Modelling in Excel – Course in Copenhagen
Copenhagen, Denmark
An intensive 3-day computer-based practical financial course with case studies and worked examples. With a step–by–step approach, this course will guide you through various techniques, providing you with a comprehensive understanding of advanced modelling, as well as how each technique can practically be applied through the use of Excel.
An intensive 3-day computer-based practical training course with case studies and worked examples, featuring how to:
- Design & structure different models
- Key auditing techniques
- Forecasting methods
- Use Monte-Carlo simulations
- Develop models incorporating risk, sensitivity, optimisation and forecasting using solver
- Design & structure different models
- Key auditing techniques
- Forecasting methods
- Use Monte-Carlo simulations
- Develop models incorporating risk, sensitivity, optimisation and forecasting using solver
Who Should Attend
The course will be of value to professionals in the following areas:
- CFOs
- Financial controllers and managers
- Financial & business analysts
- Risk managers
- Accountants
- Corporate treasury managers
- Middle office staff
- General managers
The course will be of value to professionals in the following areas:
- CFOs
- Financial controllers and managers
- Financial & business analysts
- Risk managers
- Accountants
- Corporate treasury managers
- Middle office staff
- General managers
Teaching Method
This programme will be delivered through practical and interactive case studies and worked examples, demonstrating how and why each technique is used. Emphasis is placed on you gaining practical, hands-on experience of the design and construction of financial models in Excel. You will also benefit from formal lectures and group discussions. Comprehensive product notes and modelling software will be provided for future reference.
This programme will be delivered through practical and interactive case studies and worked examples, demonstrating how and why each technique is used. Emphasis is placed on you gaining practical, hands-on experience of the design and construction of financial models in Excel. You will also benefit from formal lectures and group discussions. Comprehensive product notes and modelling software will be provided for future reference.
Course Background
Financial modelling techniques allow users to improve the reliability, quality and timeliness of their decision making. Modelling techniques are now used in many different areas, such as investment appraisal, capital planning, budgeting, valuation, and financial analysis and forecasting.
With a step-by-step approach, this course will guide you through the various techniques, providing you with a comprehensive understanding of advanced modelling, as well as how each technique can practically be applied through the use of Excel.
Financial modelling techniques allow users to improve the reliability, quality and timeliness of their decision making. Modelling techniques are now used in many different areas, such as investment appraisal, capital planning, budgeting, valuation, and financial analysis and forecasting.
With a step-by-step approach, this course will guide you through the various techniques, providing you with a comprehensive understanding of advanced modelling, as well as how each technique can practically be applied through the use of Excel.
Course Structure
The course starts by focusing on the advanced use of Excel in modelling. These newly gained skills will be applied in the construction of basic company valuation models, before the incorporation of risk assessment, scenarios, optimisation and forecasting into the models. With the help of the course director and through a proven step-bystep approach, you will then construct models of different types.
You will leave this intensive three-day course with the ability to effectively apply modelling techniques in Excel in a wide range of practical scenarios.
The course starts by focusing on the advanced use of Excel in modelling. These newly gained skills will be applied in the construction of basic company valuation models, before the incorporation of risk assessment, scenarios, optimisation and forecasting into the models. With the help of the course director and through a proven step-bystep approach, you will then construct models of different types.
You will leave this intensive three-day course with the ability to effectively apply modelling techniques in Excel in a wide range of practical scenarios.