Excel Macros & Intro to VBA: Building Tools & Eliminating Repetition
- Live virtual or in person
- 7 hours
- Instructor-led
Live virtual or in person · 7 hours · Instructor-led
Automate repetitive tasks and extend Excel’s capabilities with macros and VBA.
Upcoming sessions
Pick a date and register
Course outline
Topics covered
- Understanding macros and the VBA environment
- Recording, storing, and running macros
- Creating macros three ways: absolute, relative, and relative from a selection
- Building functional tools, like cleaning a column or adding leading zeros
- Introduction to the VBA editor and Project window
- Using pre-built code for common tasks: backups, tables of contents, moving data between sheets
- Visual Basic forms: building forms, controls, and displaying them
About this course
What this course covers
Excel macros and VBA are used to automate repetitive tasks, customize Excel’s functions, and streamline data processing. With VBA, you can create custom functions and procedures, making complex calculations and data manipulation possible and extending Excel into a more powerful, more efficient tool for data analysis and reporting.
Before you attend. This is an intermediate-level course. You should be a current Excel user and have taken at least Excel Level 1 and 2, or have equivalent experience. Taught in the Windows operating system environment.
Your facilitators
Who teaches this course
Ken Worthy
Facilitator
Monica Lewis
Learning On Demand Consultant
Monica B. Lewis has been a contract trainer at Catapult for over a year. As a Microsoft Certified Trainer, she has delivered training in 34 countries and 45 U.S. states, reaching professionals and trainers across many industries. Her Catapult courses include Computer Basics, Outlook, PowerPoint, Word, Excel (including PivotTables and dashboards), and Teams.
See the full team of Catapult HR Advisors.
Good to know
Course questions
It is delivered live online, and in person at the Charlotte Learning Center. Each session runs 7 hours.
Current Excel users who have completed Excel Level 1 and 2, or have equivalent experience, and want to automate repetitive spreadsheet work.
A single seat is $459 for non-members and $339 for members. It is also included with a Class Pass.
Next: Dec 9 · 3 upcoming dates. Pick a date from the list above to register.
Yes. Private delivery is available for your organization, scheduled around your calendar, live online or on site.
Learners also liked
Courses learners usually take next
Number Crunching with Excel Pivot Tables
Next: Dec 10 · 3 upcoming datesView dates & register →Pulling Data using Excel VLOOKUPs and More
Next: Nov 10 · 3 upcoming datesView dates & register →MS Excel Level 3
Next: Oct 27 · 9 upcoming datesView dates & register →MS Excel Tips & Tricks
Next: Nov 19 · 1 upcoming dateView dates & register →Related training
More Technology & Digital Skills training
MS PowerPoint Level 2
Dec 1 · 2 dates
Live virtual or In person, Charlotte
$459 non-member · $339 member
Delivered live online nationwide, with select courses also meeting in person in Charlotte and Raleigh. Explore training by state: North Carolina · Wisconsin · Florida · Maine · New Jersey · Tennessee
MS Project Levels 1 and 2
Oct 27 · 2 dates
Live virtual
Only 3 seats left on Oct 27
$799 non-member · $699 member
MS Teams
See upcoming dates
View dates & register →All Courses & Dates
Browse the full catalog of 101 live, instructor-led courses.
Browse the catalog →Technology & Digital Skills
All technology & digital skills courses with upcoming dates.
Explore →All HR Training
Every Catapult training topic and format.
Browse →Private Group Training
Bring this course to your team on your schedule.
Learn more →Register for Excel Macros & Intro to VBA today
Live online, open to your whole team. Or bring it in-house with private delivery.