Excel in Finance

Course description

This Excel course will give you a detailed knowledge of how to use Excel for financial analysis. The course is strictly linked to the World of Investing/Finance: Optimizing portfolios, setting up cash flows, calculating key figures, administrating and reporting of portfolios, performing stresstests etc.

This course is also offered as an online course. Read more.

Course content

• 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

The course is relevant to

• Risk Managers
• Risk Controllers
• Treasurers
• Investors
• Analysts
• Backoffice
• Fund Managers
• Account Managers
• IT-employees
• Financial Authorities
• Internal Auditors
• Compliance

Prerequisites

The course requires knowledge of excel on a user level.

Reviews of this course

Dates

23 Oct 2025 - 24 Oct 2025

We are currently planning future dates.

Please contact us for more information.

Instructor on this course

Jørgen Just Andresen

Jørgen Just Andresen

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 has worked for a number of years as external lecturer at 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

Sign up here

    Invoice is to be sent to (if another person than you)

    We are currently experiencing issues with the signups, if you are experiencing problems please contact us at info@FTPcourses.com and we will help you with your signup.