Excel Level 4 Course - Macros & VBA
Course Description
This instructor-led course covers automation and customation of Excel using macros and screen items (such as buttons and menus). Trainees learn how to write macros using VB code and assign macros to screen items.
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 users.
View our full range of Microsoft Excel training classes, or see below for the detailed outline for Excel VBA.
1 Day | $450.00
What's Included
Certificate of Course Completion
Training Manual
FREE Class Repeat
Detailed course outline
- Introduction and the Macro Recorder
- Introduction
- Demonstration
- Recording a macro
- Recording a macro with absolute references
- The personal macro workbook
- Assigning shortcut keys
- Deleting macros
- Recording a macro with relative references
- Creating and Editing Macros With VBA
- Macro storage concepts
- The VBA program (the VB editor)
- The program components
- Storing and handling macros (modules)
- Introduction to editing code
- Copying and pasting procedures
- Linking procedures together
- Create and use a user-defined function
- Auto-executable macros
- Objects and Dialog Boxes
- Introduction to objects
- The VBA Object Browser
- Using the object browser and searching it
- Built-in Dialog Boxes
- User defined dialog boxes (message boxes and input boxes)
- Introduction to Controls
- Worksheet controls
- User forms
- Selected VBA Procedures
- IF...THEN...ELSE (Conditional Control Structure)
- SELECT CASE (Branching)
- The DO...LOOP control structure
- The FOR...NEXT control structure
- Additional exercises
- Exercise 1: Case Changer Macros
- Exercise 2: Change Object Properties
- Exercise 3: Copy Macros
- Exercise 4: Custom Menus
- Exercise 5: Input Boxes
- Exercise 6: Linking Macros
- Exercise 7: Message Boxes (MsgBox)
- Exercise 8: User Defined 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.
