Dive into advanced VBA and Excel functions in Excel VBA and Macros Level II. This course builds upon lessons learned in Excel VBA and Macros Level I, including creating objects, loops, and logic statements. Learn how to control variables and create automated processes.
Master Advanced Excel Functions with VBA
In Excel VBA and Macros Level II, you will create a user interface to input data. In addition, learn how to evaluate data with looping structures and logic statements. As with Level I, Excel VBA and Macros Level II ends with a lesson on Error Handling, in which you'll review error numbers and descriptions.
Enroll in VBA Bootcamp and Save
Are you an experienced Excel user that is new to VBA? Save 20% off when you enroll in the Excel VBA and Macros Bootcamp. The bootcamp includes Excel VBA and Macros Levels I and II. This two-day, 14-hour course covers Level I on the first day of bootcamp, and Level II on the second day.
This course has a prerequisite
Excel VBA and Macros Level I or knowledge equivalent.
Course Overview
- 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
Learn more about Excel VBA and Macros Level II at NYC Career Centers.
