Excel VBA Macros Level 2 (Virtual)

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

Please click HERE for the Course Syllabus

This Course is Available Live Online

You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).

• Classes are activity-based and taught by a live instructor.
• You can hear the instruction, ask questions, and share your screen—all in real-time.
• Retake the course for free (in-person or live online) within one year.