Excel VBA and Macros Level II

  • 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
All Microsoft Excel Courses Excel VBA and Macros Level II

Our Advanced Excel VBA Training will teach you to automate tasks, and streamline workflow, using Macros. Excel VBA Macros Level 2 is our advanced class, which assumes a familiarity with the basic Macro concepts, introduced in our Level 1 Excel VBA Class. An understanding of the skills taught in VBA Excel Classes will empower the user to utilize all of the tools taught, in our Excel courses, in the most efficient and powerful manner.

Upcoming Class Dates

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

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