Excel VBA and Macros Level II (Live Online)

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 VBAIn 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 SaveAre 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 prerequisiteExcel VBA and Macros Level I or knowledge equivalent.Course OverviewNavigate a workbook using offsets, range names, and variablesAnalyze data using looping structures, in combination with if and case statementsCreate user interface structures to capture multiple variable inputsControl the lifetime and scope of variablesCreate automated event processesCreate automation to handle unforeseen errors and eventsLearn more about Excel VBA and Macros Level II at NYC Career Centers.