UMSL logo

Computer Education & Training Center

Excel VBA

Excel VBA (Visual Basic for Applications) Classes

Take your skills to the next level with comprehensive Excel VBA training. Understand how to write a macro and learn to create and edit VBA code to automate tasks and become more productive by attending a class at the Computer Education & Training Center.

Virtual Classes: Our Excel VBA classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training.

In-person classes are also available at our West County facility with limited enrollments to promote social distancing. When you register, choose your class section based on how you want to attend the class: virtual or in-person.

  • Select Live Online" if you want to attend virtually from your workplace or home.
  • Choose "West County In-Person" if you want to attend a class at our West County location.

Excel Macros Using VBA

(Prerequisites: Significant Excel experience and Intermediate Applications of Excel or equivalent experience. Students should have a solid knowledge of Excel, a strong background using conditional statements, and substantial experience working with spreadsheets before taking this class.) In this two-day class, discover the power of macros by using Visual Basic for Applications to automate your Excel applications. Visual Basic terminology, such as procedures, methods, properties, and objects, will be introduced and used to create and edit Excel macros. Understand how to modify recorded macros and write original macros using Visual Basic in order to customize your interface and create dialog boxes for input and messages. Additional topics include using control structures, such as conditionals and loops. [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E2193 Wed., Oct. 6 & Thurs., Oct. 7Virtual/WCBill Barry
E2399 Tues., Jan. 25 & Wed., Jan. 26Virtual/WCBill Barry

Intermediate Excel VBA

(Prerequisite: Excel Macros Using VBA or equivalent experience.) Explore Excel VBA in more depth with this second level class and build on your skills by learning how macros can interact with a wide variety of Excel objects. Understand how your macros can be used and learn different trouble-shooting strategies to avoid problems. Master using arrays to manage multiple elements, learn to automate and manage PivotTables, and understand how to interact with Excel charts. Learn to incorporate other Office software such as Word and PowerPoint into your Excel VBA workflow. Discover how to make external connections to data and pull information into an Excel spreadsheet using VBA. Topics include creating a custom user form, handling controls, working with arrays, interacting with pivottables and charts, using SQL commands in macros, using VBA with other office software, and cleaning up data with VBA.  [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E2194 Tues., Oct. 19 & Wed., Oct. 20Virtual/WCBill Barry
E2400 Tues., Feb. 8 & Wed., Feb. 9Virtual/WCBill Barry

If you would like to register for a course, call (314) 984-9000 or register online.

Beginning through advanced level Excel classes are available as well as classes in Excel Charts, PivotTables, Formulas and Functions, and Excel Data Manipulation.

For more information, please email