Excel VBA and Macros Level II in NYC or Live Online

  • tag-solid $345
  • clock-solid 7 Hours
  • display-solid PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
  • cloud-line Also available live online
All Microsoft Excel Courses Excel VBA and Macros Level II

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 that 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 6 months for free.

warning-standard-solid

This course has a prerequisite

Excel VBA and Macros Level I or knowledge equivalent.

Upcoming Class Dates

Corporate training classroom
Career Centers teacher helping a student

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com
phone-handset-solid 212 • 684 • 5151
file-group-solid Download Syllabus

Course Overview

  • 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
block-quote-line

This class was very helpful & the instructor was very knowledgeable on the subject. The class was very interactive and I would 10/10 suggest it to others.

Marquise Satterwhite, Moody's Analytics

Highly recommend to anyone looking to build technical skills in Excel.

Michael Chen, NYU

circle-arrow-solid circle-arrow-solid

Full Course Syllabus

file-group-solid Download PDF Outline

Lesson 1: VBA Editor

  • Project Explorer
  • Properties Window
  • Modules

Lesson 2: Creating / Editing Code

  • Functions
  • Events

Lesson 3: Invoking Macros

  • Worksheet Buttons
  • Customize Ribbon

Lesson 4: Compiling Code

  • Stepping through code
  • Setting Breakpoints

Lesson 5: Variables

  • Declarations
  • Option Compare Text
  • Option Compare Binary
  • Lifetime and Scope

Lesson 6: Working with The Object Model

  • Application
  • Workbook

Lesson 7: Creating & Naming Objects

  • Naming conventions
  • Housekeeping

Lesson 8: Navigation / Selection Techniques

  • Absolute versus Relative Reference
  • Offsets

Lesson 9: Logic Statements

  • Nested IF Statements
  • Case Statements

Lesson 10: Functions

  • Intrinsic Functions
  • User Defined Functions

Lesson 11: Looping Statements

  • For Each Next Loops

Lesson 12: Interactive Code

  • User Forms - dashboards
  • Message Boxes

Lesson 13: Error Handlers

  • Error numbers
  • Error descriptions