Master Visual Basic for Applications (VBA) and macros in this comprehensive course designed for experienced Excel users. VBA is Microsoft's official coding language for programming Excel, allowing you to write powerful macros and automate routine tasks effectively. Day 1 covers all content from Excel VBA Macros Level 1; Day 2 builds upon this foundation with advanced VBA techniques from Excel VBA Macros Level 2.
In this practical, hands-on course, you'll learn to accelerate your workflow in Excel through intelligent macro usage. Beyond working faster, you'll work smarter by systematically eliminating potential errors; both days conclude with detailed lessons on error handling using VBA code to ensure robust solutions.
This course has a prerequisite:
Prior VBA programming knowledge is not required; however, 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 combined 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
