Excel Programming with VBA (Live Online)

Master VBA (Visual Basic for Applications) and macros in this course for avid Excel users. Visual Basic for Applications or VBA is Microsoft's coding language to program Excel. You can use it to write macros and automate tasks. On Day 1, you'll learn everything covered in Excel VBA Macros Level 1. Day 2 covers advanced VBA techniques in Excel VBA Macros Level 2. In this hands-on course, you'll learn how to accelerate your workflow in Excel with macros. In addition to working faster, you'll also work smarter by eliminating possible errors — both days of the course end with a lesson on error handling with VBA code.This course has a prerequisitePrior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.Course OverviewDevelop a macroFormat worksheets using macrosCreate an interactive worksheetWork with multiple worksheetsPerform calculationsNavigate 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 eventsPlease click HERE for the Course SyllabusLearn more about Excel Programming with VBA at NYC Career Centers