|
Course: Excel in Finance (II) - Introduction to VBA Programming, Copenhagen |
|
|
11 nov -
12 nov
|
|
|
|
Kursusprogram
|
|
|
|
Kursusbeskrivelse
• 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
|
|
|
|
Formål
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. |
|
|
|
Forudsætninger
This course requires knowledge of Excel on an intermediate level, corresponding to the course "Excel in Finance (I)”. Furthermore, using financial examples, a basic understanding of mathematics and fixed income products will be useful. |
|
|
|
Niveau
Intermediate |
|
|
|
Kurset er relevant for:
• Analysts
• Portfolio managers
• Treasurers
• Traders |
|
|
|
Instruktører
Carsten Mygind Feldt
Jørgen Just Andresen
|
|
|
|
Sprog
English |
|
|
|
Sted
Financial Training Partner, København |
|
|
|
Pris
DKK 11,500 including course material, lunch and refreshments. The price is exclusive of VAT. |
|
|
|
Home » Kurser » Kursusudbud » Course: Excel in Finance (II) - Introduction to VBA Programming, Copenhagen 
