We are open! Classes are running in-person and live online. Secure your seat today

Compare Classes & Certificates

Which course is right for you? This tool allows you to compare any class or certificate program in our catalogue with the important information you need to make the right decision.

Remove
Key Information
Excel Programming with VBA
$549 12 Hours
Learn More
Overview
Learn Visual Basic for Applications to accelerate your workflow and reduce errors in Excel. This bootcamp course includes Excel VBA Macros Levels 1 and 2. By the end of this course, you'll be able to develop a macro, create automated event processes, and use automation to manage unforeseen errors. 
Prerequisite
Prior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.
Location
185 Madison Avenue, NYC or Live Online
Schedule
Next start date: Jan 8–9, Weekdays
Other scheduling options: Weekdays or sundays
View full schedule
Certification
Receive a Certificate of Completion
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Courses Included (Certificates & packages only)
Financing See our Leif FAQ for more details
Target Audience
Anyone
What You’ll Learn
  • Develop a macro
  • Format worksheets using macros
  • Create an interactive worksheet
  • Work with multiple worksheets
  • Perform calculations
  • Navigate a workbook using offsets, range names, and variables
  • Analyze data using looping structures, in combination with if and case statements
  • Create user interface structures to capture multiple variable inputs
  • Control the lifetime and scope of variables
  • Create automated event processes
  • Create automation to handle unforeseen errors and events

Add Class or Certificate to Compare

Yelp Facebook LinkedIn YouTube Twitter Instagram