
Excel Level 4 Course - Macros & VBA
Course Description
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. s.
Live face-to-face instructor. No minimum class size - all classes guaranteed to run!
Students are expected to have completed Excel Advanced or have the equivalent experience prior to attending this class. Suitable for Excel 2010/2013/2016/365 users.
View our full range of Microsoft Excel training classes, or see below for the detailed outline for Excel VBA.
1 Day | $450.00
Detailed 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
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.
Timetable
Chicago
230 W Monroe St
#610
Chicago
IL 60606View Map
Guaranteed to Run
Limited Seats Left
Class times: 9.00am to 4.30pm
Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.
Other Cities
Los Angeles
915 Wilshire Blvd
#1800
Los Angeles
CA 90017View Map
Guaranteed to Run
Limited Seats Left
Class times: 9.00am to 4.30pm
Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.