This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors
Live face-to-face instructor. No minimum class size - all classes guaranteed to run!
Prerequisite
Students are expected to have completed Excel Advanced or have the equivalent experience prior to attending this class. Suitable for Excel 2010/2013/2016 users.
What's Included
- Certificate of Course Completion
- Training Manual
- FREE Class Repeat
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
Using Variables to Store Data
- VBA Data Types and Naming Rules
- Declaring Variables
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
Performing Calculations with VBA
- Using VBA’s Built-in Functions
- Writing User-Defined Functions for Custom Calculations
- Code to Automate Inserting SUM Functions
Note:
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.