The course is structured around a series of topics. To support effective learning, each topic includes:
The course is delivered as e-learning through our digital learning platform. It combines narrated presentations, videos with whiteboard explanations, Excel exercises, quizzes and reading materials, allowing you to learn at your own pace – whenever and wherever it suits you.
You should allow approximately two working days to complete the course. The course includes two months’ access.
• Date and Time Functions
• Financial Functions
• The Logical Library
• Lookup and Reference Library
• Build your own Bond Calculator (Duration, Price, Cash Flows)
• The Goal Seek (Yield-to-Maturity and Implied Volatility)
• Solver (Set up the Efficient Frontier, Optimize the Porfolio)
• Scenario Manager (Stresstesting a Portfolio)
• The Database Library
• Pivot Tables (Reporting and Administrating a Portfolio)
• The Function Library
• Value at Risk, Expected Shortfall (Simulation-based, Delta Normal)
• Formatting and Combo Boxes
• Risk Managers
• Risk Controllers
• Treasurers
• Investors
• Analysts
• Backoffice
• Fund Managers
• Account Managers
• IT-employees
• Financial Authorities
• Internal Auditors
• Compliance
A basic knowledge of financial instruments is an advantage. Whenever there is a new topic, you can choose to watch an introduction video to get familiar with the theory behind. As an example, you can watch a video explaining the various bond key figures before learning how to implement it in Excel.
Jørgen Just Andresen is Managing Director of Financial Training Partner A/S, which he co-founded in 2002.
He has many years of teaching experience as a chief consultant at SimCorp’s training department, which he joined in 1996. Prior to SimCorp he worked at Danske Bank with fixed income research and fixed income sales.
Jørgen also works as an external lecturer at CBS (Copenhagen Business School) and was awarded teacher of the year at CBS’ education Graduate Diploma in Business Administration (Financial planning).
He is author of the books Finansiel Risikostyring (Financial Risk Management) and Finansielle Derivater (Financial Derivatives) published by Djøf Publishing.
He holds an M.Sc. (international finance) and an HD (accounting).
Jørgen teaches Derivatives, Risk Management, Portfolio Management and Fixed Income
Dette kursus giver dig værktøjer til effektivt at kunne måle og styre den operationelle risiko i en finansiel virksomhed. Du lærer om kapitalkrav ...
In this course, you will learn how to measure and manage market risk. The course is designed for professionals working in risk management and control....
På dette kursus lærer du at måle og styre markedsrisiko. Kurset henvender sig til medarbejdere, der beskæftiger sig med risk management og kontrol...
Kurset giver dig en detaljeret viden om, hvilke værktøjer der findes til at måle og styre likviditetsrisiko. Du lærer også, hvordan man kan stres...