Introduction to VBA
0/30
Course starts: 24.04.2017. | Duration: 5 days (40 h)
NEW!
This course is aimed at delivering an introduction to VBA programming!
Description:
This course will cover, the following topics
• Variables, Data Types, Constants
• Functions
• Subroutines
• Objects
• Applications
• Connection with Other Excel Platforms
• Dialogue Boxes
• Pivot Tables
• Charts
• Regression Analysis in VBA
Expectations and Goals:
The goal is to introduce the VBA basic programming blocks. This will be done step-by-step with numerous examples from numerical analysis, econometrics and financial and portfolio theory. Key concepts will be taught in depth in order to prepare the delegates for more in-depth analysis in computational finance and econometrics.
Course Materials:
Every student should bring their own laptop for this course, the classes will be held in English. You can pay for the course 50% before it starts, and 50% when it is about to finish.
There is no requirement for prior knowledge in VBA programming, although some exposure would be helpful.
The classes are held every day, for five consecutive days, Monday to Friday, from 9 am to 5 pm.
Advanced levels coming soon:
- Risk Management with VBA
- Volatility Modelling and Trading
- Numerical Methods in Finance