Description:
This course introduces participants to the world of Excel automation through macros and Visual Basic for Applications (VBA). Starting with the Macro Recorder, users learn to capture routine actions and convert them into reusable, stored macros. From there, participants explore the Visual Basic Editor (VBE) and develop foundational programming skills including variables, loops, and error handling.
By the end of this course, participants will understand the relationship between macros and VBA, know how to blueprint and write basic procedures, and have the skills to begin customizing Excel beyond its standard functionality.
This one-day Excel VBA course runs from 8:30 a.m. to 4:30 p.m. with a live instructor and works through eight modules. You start by enabling the Developer tab and macro security, recording your first macros, and using absolute and relative references. You then learn to plan a macro before you record it, edit and save recorded macros, assign macros to buttons and shortcuts, and manage macro-enabled workbooks. The class moves into the Visual Basic Editor, where you read and edit recorded code and write your own procedures with variables, constants, If…Then…Else logic and For…Next and Do While loops.
Later modules cover stored macros in the Personal Macro Workbook so you can run them across workbooks, and error trapping with breakpoints, stepping through code and On Error handling. The final exercise combines several macros into one multi-step workflow. This Excel macros course suits people who use Excel confidently and want to automate repetitive tasks, and it prepares you for Excel Macros and VBA Level 2.
The course fee is $345 for 8 hours of instructor-led training, delivered live virtually or on-site for groups. Use the form on this page to ask about upcoming dates or to plan private VBA training for your team.
Module 1: Introduction to Macros
-
What is a macro and why use them?
-
Macro security and enabling the Developer tab
-
Recording your first macro
-
Understanding absolute vs. relative references
Exercise: Record and execute a macro to automate worksheet formatting
Module 2: Planning and Blueprinting Macros
-
Understanding the “macro blueprint” process
-
Identifying repeatable tasks suitable for automation
-
Documenting actions and expected outcomes before recording
-
Naming conventions and structure for efficient macro management
Exercise: Plan and document a macro workflow
Module 3: Working with the Macro Recorder
-
Recording sequential actions and commands
-
Modifying and saving recorded macros
-
Assigning macros to buttons or shortcuts
-
Managing macro-enabled workbooks (.xlsm)
Exercise: Record, edit, and assign macros to quick access buttons
Module 4: Introduction to the Visual Basic Editor (VBE)
-
Opening and navigating the VBE window
-
Understanding modules, procedures, and properties
-
The difference between recorded and written code
-
Editing recorded macros directly in VBA
Exercise: Open recorded macros and edit simple lines of code
Module 5: Fundamentals of VBA Programming
-
The structure of a VBA procedure
-
Understanding variables and constants
-
Branching and conditional commands (If…Then…Else)
-
Introduction to looping (For…Next, Do While)
Exercise: Write a basic VBA procedure that automates repetitive cell entries
Module 6: Building Stored Macros and Running Them Across Workbooks
-
Creating and organizing stored macros
-
Understanding Personal Macro Workbook (PERSONAL.XLSB)
-
Accessing and running macros from other files
-
Best practices for managing shared macros
Exercise: Create a stored macro and execute it across multiple workbooks
Module 7: Error Trapping and Debugging
-
Common VBA errors and how to interpret them
-
Using breakpoints and stepping through code
-
Simple error handling (On Error Resume Next, On Error GoTo)
-
Maintaining macro stability and reliability
Exercise: Debug and correct a faulty macro
Module 8: Bringing It All Together
-
Combining multiple macros into a workflow
-
Refining procedures for clarity and performance
-
Macro maintenance and documentation best practices
-
Preview of Level II: Building custom functions and user forms
Wrap-Up Exercise: Design and implement a multi-step macro solution
Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.
For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22