Development of Financial Applications in VBA for EXCEL™ – Level 1

This training combines an insight into the fundamentals of VBA programming with the use of concrete examples linked to finance

• Creating a simple pricer and simulation matrices
• Calculating position
• Calculating indicators on the basis of past prices
• Automating graphs
• Importing and handling external data (file, web)
• Automating reconciliations
• Interacting with external applications (Word™, Outlook™)

The solutions to the examples interactively created as well as VBA applications are given to participants at the end of the course

Review of EXCEL™

• Functions, libraries, tables/matrices, algorithms, etc.
• Naming cells
• Assigning a name to a constant or a formula
• Absolute and relative references

Customise EXCEL™

• Customised icons
• Customised formulas

Visual Basic for EXCEL™

• Introduction to Visual Basic Editor (VBE)
• VBE windows
• Working with the code window
• Customising the Visual Basic Editor workspace
• Macros: definition, saving and personal folder

EXCEL™ object model

• Introduction to the object model: properties, methods, events
• Application object
• Workbooks collection - Workbook object
• Worksheets collection - Worksheet object
• Range object
• Chart object

VBA programming

• Variables, types of data and constants
• Tables
• Controlling the task flow
• Sub and function procedures
• Managing errors
• Handling objects and collections
• Using predefined functions

UserForms

• Introduction to UserForms
• Dialogue boxes: InputBox, MsgBox
• Predefined dialogue boxes in EXCEL™
• Toolbox controls
• UserForms events
• Customising the toolbox

Debugging tests and tools

• Debugging window
• Step-by-step execution
• Viewing variables
• Spies