Financial Modelling in Excel – Course in Copenhagen
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.
- Design & structure different models
- Key auditing techniques
- Forecasting methods
- Use Monte-Carlo simulations
- Develop models incorporating risk, sensitivity, optimisation and forecasting using solver
The course will be of value to professionals in the following areas:
- Financial controllers and managers
- Financial & business analysts
- Risk managers
- Corporate treasury managers
- Middle office staff
- General managers
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.
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.
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.