Learn macros and automation techniques in Excel VBA and Macros Level I. The course begins with a foundational introduction to Visual Basic for Applications (VBA) and the concept of macros. Throughout this training, you'll learn essential skills including hotkey assignment, code compilation, loops, and logic statements. The course concludes with lessons on using interactive code to create input boxes and message boxes, plus comprehensive error handling techniques that help prevent mistakes leading to software crashes.
Excel VBA Programming Course Workbook:
Our hands-on training methodology reinforces learning objectives, helping you retain not just theoretical knowledge but also practical skills for implementation. Upon completion of Excel VBA and Macros Level I, you'll have developed real experience writing functional code and creating useful macros. You'll receive a personal copy of the comprehensive course workbook where you can record detailed notes and reference the practice activities for home study and workplace application. The course workbook serves as a valuable training and reference resource that you can carry with you throughout your career.
This course has a prerequisite:
Fundamental Excel knowledge equivalent to our Beginner Microsoft Excel course.
Course Overview:
- Develop a macro
- Format worksheets using macros
- Create an interactive worksheet
- Work with multiple worksheets
- Perform calculations
Learn more about Excel VBA and Macros Level I at NYC Career Centers.
