Excel Macros and VBA
June 15, 2027 @ 9:00 am - 4:00 pm
$459 non-member · $339 memberRegister for this session
$459 non-member · $339 member
Technology & Digital Skills
Tuesday, June 15, 2027 ยท Virtual Live
Course Details
9:00 AM โ 4:00 PM ET
28 available
Excel macros and VBA are utilized to automate repetitive tasks, customize Excel's functions, and streamline data processing. With VBA, custom functions and procedures can be created, making complex calculations and data manipulation possible, extending Excel's capabilities, and making it a more powerful and efficient tool for data analysis and reporting.
Program Level: Intermediate
Prerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience.
Contents:
- Understanding Macrosย
- What is a Macro?ย ย
- What isย VBAย ย
- Displaying the Developer Ribbon Tabย ย
- Macro Securityย
- Recording a Macroย ย
- Storing Macrosย ย
- The Personal Macro Workbookย ย
- Using Macro-Enabled Workbooksย ย
- Running Macrosย ย
- What isย VBAย ย
- Creating a Macro Icon for the Toolbarย ย ย
- What is a Macro?ย ย
- Creating Macros 3 waysย
- Absolute Macrosย
- Create a macro for a report or repetitive dataย setย
- Relative reference macrosย
- Create a macro that will work on anyย columnย
- Relative reference macro starting from aย selectionย ย
- Create a macro that will format anyย selectionย
- Absolute Macrosย
- Create Functional toolsย
- Create a macro to clean and trim aย columnย
- Create a macro to add leading zeros to aย columnย
- Introduction to the VBA interfaceย
- Visual Basic button / Developer Ribbonย
- Setting up and understanding the VBA Editorย
- Using the Project Window / Hiding the Properties Windowย
- Opening / closing and saving your workย
- Using pre-built code to do what excel doesย notย
- Saving a workbook before closingย
- Create a backup copy with todayโs date in theย titleย
- Create a new workbook for eachย worksheetย
- Create a Table of Contents forย youย worksheets in a workbookย
- Moving data from multiple sheets to a single sheetย
- Text to columns on all columns to apply numberย formatย
- Create a new sheet for each item in anย Autofilterย
- Copy all Charts toย PowerPointย
- Visual Basic Formsย ย
- What is a VB Form?ย ย
- Building a Basic Formย
- Working with Modulesย
- Renaming Modulesย ย
- Changing Form Propertiesย ย
- Form Controlsย ย
- Text Boxesย ย
- Labelsย ย
- Combo Boxesย ย
- Check Boxesย ย
- Displaying the formsย
- Make your formย appearย
- Closing the formย
- Adding VB Code to your Formย ย
Note: This course will be taught using the windows operating system environment
Ready to Advance Your Career?
Join professionals across the Carolinas who trust Catapult for professional development.

