This instructor-led course helps advanced Excel users develop powerful new skills in writing and debugging VBA code to effectively automate complex Excel operations such as inserting and formatting text, sorting and transforming data, generating professional reports, and more. You will also learn to create interactive user forms, integrate calculations, and implement robust error handling strategies.
Course Delivery: Live face-to-face instruction with a qualified instructor. No minimum class size required. All classes are guaranteed to run.
Prerequisite:
Students should have completed Excel Advanced or equivalent hands-on experience prior to this class. Suitable for Excel 2010, 2013, and 2016 users.
What's Included:
- Certificate of Course Completion
- Comprehensive Training Manual
- Free Class Repeat (audit any session again at no charge)
Course Outline
VBA Concepts
- The Object Model Hierarchy
- Understanding Object Properties, Methods, and Events
- VBA Module and Procedure Types
Accessing VBA Functionality
- Macro Security Options
- Using the Macro Recorder
- Writing and Editing Macros
- Essential VB Editor Components
- Exploring the Object Browser
- Using VBA Comments and Formatting to Write Solid Code
Debugging and Error Handling
- Types of Programming Errors
- VBE Debugging Tools
- Error Handling Code Implementation
Using Variables to Store Data
- VBA Data Types and Naming Conventions
- Declaring Variables Properly
VBA Looping and Decision Structures
- For and Do Loops for Repetitive Actions
- If-Then Statements
- Select Case Statements
User-Interactive Worksheets
- Capturing User Input
- Dialog Box Types and Applications
Performing Calculations with VBA
- Using VBA's Built-in Functions
- Writing User-Defined Functions for Custom Calculations
- Code to Automate Inserting SUM Functions
Note: These outlines serve as a guide to content covered in a typical class. We may adjust or alter course topics to meet the learning objectives of a particular class section.
