Introduction to Excel VBA 4-Hour Virtual Power Session

Introduction to VBA

• Overview of Visual Basic Editor
• Recording Macros
• Recording with Relative References
• Writing and Editing simple code
• Assigning your code to buttons
• Creating Keyboard Shortcuts
• Using the VBA Object Browser
• Financial Application: Calculate asset returns quickly by recording and running a macro.

Procedures and Functions

• Create a User-Defined Function (UDF)
• Working with Modules
• Writing and Editing Functions and Subroutines
• Declaring Variables
• Variable Types
• Utilizing Excel functions inside VBA code
• Debugging VBA
• Financial Application: Create a simple function related to CAPM and more complex functions like those related to M&A deals.

Looping

• Repeat a series of actions by using loops such as For…Each…Next
• Recursive syntax within code
• Looping through Collections of Objects
• Financial Application: Build a Payback Period Calculator using loops.

Please note that this power session is an abbreviated version of our 2-day seminar, which covers additional topics such as working with Large Datasets, Input Boxes and Messages Boxes, Userforms and Controls and Querying data and using SQL in VBA and associated exercises.