Training: Excel – VBA Fundamentals

Module 1: First steps with Excel VBA programming

• Introduction to VBA
• When to use VBA
• Recording a macro
• Saving a macro
• Analyzing a macro

Module 2: Working in the Visual Basic Editor

• Presentation of the Visual Basic Editor
• Essential elements of the VBA language
• Creating and using functions and sub-processes

Module 3: Working with variables

• Declaration and scope of variables
• Types of variables
• Working with constants
• Assigning values to variables
• Retrieving values from variables

Module 4: Using VBA functions and Excel

• Using VBA functions
• Using Excel functions (WorksheetFunction)
• Creating custom functions