Intermediate Excel VBA Class

Developed by Jon Peltier of Peltier Technical Services, the Intermediate Excel VBA class is a hands-on experience, scheduled to take three to four hours. The class assumes an intermediate level of competency in Excel, and builds on this base to develop strong skills. Students work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.

Intermediate Automation of Excel with VBA

Record Macros to Repeat Tasks Automatically
Understanding the VB Editor

Visual Basic Elements
Project Explorer, Properties Window
Object Browser, Immediate Window, Locals
VBE Options

Tweaking Recorded Macros
Debugging and Error Proofing

Errors in Recorded Macros
Error Trapping

Using a Dialog to Interact with Users

Let Users Select Simple Options
Let Users define Complex Options Using a Custom Dialog

Improve your Programming Technique

Variables
VB Structural Elements
Excel's Object Model
VBA Programming Tools

Modular (Reusable) Procedures
VBA for Working Across Applications

Contact Peltier Tech

to get information on upcoming training programs,
to schedule a training program at your facility,
to customize a training program to meet the needs of your organization.

Peltier Tech Advanced Excel Classes

Contact Peltier Tech

Excel Chart Add-Ins | Advanced Excel Training | Peltier Tech Blog