Loading Events

« All Events

Excel Macros and VBA

June 15, 2027 @ 9:00 am - 4:00 pm

$459 non-member · $339 member
TS Thumbnail new 7nv3l8

Register for this session

$459 non-member · $339 member

Add to cart

Technology & Digital Skills

Tuesday, June 15, 2027 ยท Virtual Live

Register Now →

Course Details

FormatVirtual Live
LocationVirtual Live (Online)
Date & TimeTuesday, June 15, 2027
9:00 AM โ€“ 4:00 PM ET
Price$339Member ยท Non-member: $459
FacilitatorMonica Lewis
Seats28 seats
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ย ย 
    • Creating a Macro Icon for the Toolbarย ย ย 
  • 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ย 
  • 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.

Register Now →

​

Details

Venue

  • Virtual Live (Online)

Organizer

  • Monica Lewis

Get sharper HR insights, every month.

Practitioner-written guidance on compliance, leadership, and workplace strategy, sent straight to your inbox.

Prefer something specific? Choose exactly what you get