Explore advanced VBA programming techniques and powerful Excel functions through the Excel VBA and Macros Level II course. This course expands upon the foundational concepts you learned in Excel VBA and Macros Level I, diving deeper into object creation, loop structures, conditional logic statements, and sophisticated automation methods and strategies.
Master Advanced Excel Functions with VBA:
In Excel VBA and Macros Level II, you will design and implement a user interface to capture and process data input efficiently. Additionally, you will learn how to evaluate complex data sets using looping structures combined with conditional logic statements. Similar to Level I, this course concludes with a comprehensive lesson on Error Handling, where you will study error numbers, descriptions, and best practices for creating resilient and reliable code.
Enroll in VBA Bootcamp and Save:
Are you an experienced Excel user who is new to VBA programming? Take advantage of a 20 percent discount when you enroll in our Excel VBA and Macros Bootcamp. The bootcamp package includes both Excel VBA and Macros Levels I and II combined into a focused, two-day intensive program totaling 14 hours of comprehensive instruction. The bootcamp covers Level I content on the first day and Level II content on the second day.
Course Prerequisites:
Excel VBA and Macros Level I completion or equivalent knowledge and experience.
Course Overview
- Navigate workbooks effectively using offsets, range names, and variables
- Analyze and process data using looping structures combined with if and case statements
- Design user interface structures to capture multiple variable inputs from users
- Control variable lifetime and scope within your programs
- Create automated processes that respond to specific events and triggers
- Build automation solutions that handle unexpected errors and edge cases
Learn more about Excel VBA and Macros Level II at NYC Career Centers.
