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 prerequisite
Prior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.
Course Overview
- Develop a macro
- Format worksheets using macros
- Create an interactive worksheet
- Work with multiple worksheets
- Perform calculations
- 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
Learn more about Excel Programming with VBA at NYC Career Centers