Excel gives you the edge whenever you want to do something new with financial models, something never seen before in instrument pricing, and something that none of your competitors has ever done.
Delivered via Virtual Classroom you will be able to engage with the instructor and other participants, share screens, ask questions without leaving your office or your home, city or country.
VBA is based upon object hierarchies, with each object possessing various properties and methods. This module explores this basic structure of VBA and how it is exploited to create new tools for Excel users.
• VBA object hierarchy
• Application, ActiveWorkbook, and ActiveSheet
• Defining variables
• Populating variables