Course Details

Microsoft® Excel Macros and VBA Level 1

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.

  • Record, run, and edit macros using Excel’s Macro Recorder.
  • Understand the concept of macro blueprinting and development planning.
  • Navigate the Visual Basic Editor and understand the structure of VBA code.
  • Create, store, and run macros across multiple Excel files.
  • Distinguish between recorded macros and written VBA procedures.
  • Write basic VBA code using variables, constants, loops, and conditional logic.
  • Debug and handle simple errors using VBA’s built-in tools.

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

Course Information

Course Level: 
Credit: 8 hours
Fee: $345
Length: 1 day
Hours: 8:30 a.m. - 4:30 p.m.
Delivery: Virtual Instructor-Led/Group On-site
Please choose which Microsoft® Office Hands-On Courses class(es) you are interested in.
Please choose which best describes your interest for this training:

Related Courses