Excel in Finance – Introduction to VBA Programming

Kursusbeskrivelse

Using the built-in functionality in Excel can bring you a long way. But if you want to design tailor-made spreadsheets with full flexibility, you have to use Visual Basic for Applications (VBA). This course will give you a thorough introduction to VBA programming, going through all relevant topics and relate them to financial cases. The course will to a large extent be based on computer workshops, whereby you will get hands-on experience with building your own advanced financial spreadsheets.

Kursusindhold

The VBA environment
– Variables and Naming
– Objects and Ranges
– Conditional Actions
– Loops and Debugging

Build your own
– Macros, Procedures and Functions

VBA in Financial Cases
– Generate Cash Flows
– Calibration of Zero Coupon Models

Hvem henvender kurset sig til?

– Analysts
– Portfolio Managers
– Treasurers
– Traders
– Backoffice/Operations
– Middle Office
– Front Office
– Anyone working with excel

Forudsætninger

This course requires knowledge of Excel on an intermediate level. Furthermore, using financial examples, a basic understanding of mathematics and fixed income products will be useful.

Anmeldelser af dette kursus

Datoer

15 nov 2022 - 16 nov 2022

Vi planlægger løbende nye datoer.

Kontakt os for mere information.

Instruktør på dette kursus

Ulrik Strandgaard

Ulrik Strandgaard

Ulrik Strandgaard is senior product owner at SimCorp A/S. Until 2016, Ulrik was a partner in Financial Training Partner A/S. From 1995 – 2002 he worked for SimCorp A/S and was Head of the training department. Prior to SimCorp he worked at Bikuben Børs with derivatives and fixed income research.

Ulrik is also an external lecturer at Copenhagen Business School and was awarded teacher of the year at CBS’ education Graduate Diploma in Business Administration (Financial planning) in 2017.

He holds an M.Sc. (Economics) and a BA (Business).

Ulrik teaches Excel in Finance

Tilmeld dig her





    Faktura skal sendes til (hvis anden person end dig)