Excel VBA and Macros Level II

Hands-on Training from Experts NYC or Live Online

Master advanced VBA and Excel functions by analyzing data using looping structures and navigating a workbook using offsets, range names, and variables. Become a pro at user interface structures, automated event processes, and automations.

This course includes

  • 6 hours of live, project-based training from experts
  • Software Access
  • Learn from a Microsoft Certified Trainer
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion

Advanced VBA Programming Classes in New York City

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 VBA

In 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 Save

Are you an experienced Excel user who 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.

Free Retake

Retake the Excel VBA and Macros Level II course within 12 months for free.

Read more

This course has a prerequisite

Students should be comfortable with the concepts covered in Excel VBA and Macros Level I.

Schedule & Enrollment: Excel VBA and Macros Level II

  • 6 Hours
  • Full tuition: $345
  • NYC or Live Online
  • Free retake
  • Expert instructors
  • Software Access
  • Small classes

  • June 26
    Thursday 10–5pm
    Live Online Only
    Enroll

  • August 22
    Friday 10–5pm
    Enroll

  • November 20
    Thursday 10–5pm
    Enroll

Show more
Teacher leading class
Sunlit data science classroom
One-on-one training instructor with student in a classroom
Instructor teaching PowerPoint
Excel class in session

Related Courses: Compare to Excel VBA and Macros Level II

These related courses share skills and topics with Excel VBA and Macros Level II. Select up to two and tap Compare selected courses to view a side-by-side comparison.

  • Excel Programming with VBA
    12 hours $549

    Learn Visual Basic for Applications to accelerate your workflow and reduce errors in Excel. This bootcamp course includes Excel VBA Macros Levels 1 and 2. By the end of this course, you'll be able to develop a macro, create automated event processes, and use automation to manage unforeseen errors. 

  • Excel VBA and Macros Level I
    6 hours $345

    Take the first steps to learn Visual Basic for Applications (VBA), Microsoft's programming language. You'll work more quickly and efficiently by using VBA to automate tasks and eliminate errors. By the end of the course, you'll be able to write code, record macros, and troubleshoot common errors with your code. 

  • Microsoft Excel Bootcamp
    18 hours $549

    Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts,  Pivot Tables and scripts, and macros for automating tasks with ease. 

Yelp Facebook LinkedIn YouTube Twitter Instagram