Excel in Finance – Online Course

Kursusbeskrivelse

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 available as a classroom-based course.

Hvordan foregår online kurset?

The course is structured around a series of topics. To support effective learning, each topic includes:

  • A video explaining the practical application of the topic – for example, how to use the Scenario Manager for stress testing
  • A video demonstrating how to apply the topic in practice
  • An Excel exercise where you solve a similar task yourself
  • A video showing how to solve the exercise

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.

Kursusindhold

• 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

Hvem henvender kurset sig til?

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

Forudsætninger

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.

Anmeldelser af dette kursus

Instruktør på dette kursus

Jørgen Just Andresen

Jørgen Just Andresen

Jørgen er adm. direktør og stiftede Financial Training Partner A/S i 2002.

Han har mange års undervisningserfaring fra Financial Training Partner og som chefkonsulent i SimCorps kursusafdeling, hvor han startede i 1996. Før SimCorp arbejdede han i Danske Bank med salg og analyse af obligationer.

Jørgen arbejder desuden som ekstern lektor på CBS (Copenhagen Business School), hvor han blev kåret som årets underviser på HD, Finansiel Rådgivning.

Han er forfatter til bøgerne Finansiel Risikostyring og Finansielle Derivater udgivet på Djøf Forlag.

Han er uddannet cand.merc.int og HD(R)

Jørgen underviser i Derivater, Risikostyring, Porteføljestyring og Fixed Income

Tilmeld dig her

    Faktura skal sendes til (hvis anden person end dig)