# Excel VBA and Macros Level II

Canonical URL: <https://training-nyc.com/courses/excel-vba-and-macros-level-ii>

## Overview

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.

## What you'll learn

- 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

## Prerequisites

Students should be comfortable with the concepts covered in [Excel VBA and Macros Level I](/courses/excel-vba-and-macros-level-i).

## Curriculum

#### 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

## Schedule
- Jun 24, 2026 10:00am–5:00pm — NYC
- Jul 31, 2026 10:00am–5:00pm — NYC
- Sep 17, 2026 10:00am–5:00pm — NYC
- Nov 6, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $345