# Excel VBA and Macros Level II Course

Canonical URL: <https://www.graduateschool.edu/courses/excel-vba-and-macros-level-ii>

## Overview

Our Advanced Excel VBA Training shows you how to automate tasks and optimize workflows using macros. Excel VBA Macros Level 2 is our advanced course and assumes knowledge of the basic macro concepts covered in our Level 1 Excel VBA class. Mastering the skills from our VBA Excel classes enables users to apply all the tools from our Excel courses in the most effective and powerful way.

## What you'll learn

- Navigate a workbook using offsets, named ranges, and variables
- Analyze data using looping structures in combination with If and Case statements
- Control the lifespan and scope of variables
- Create user interface structures to capture multiple variable inputs
- Create automated event-driven processes
- Create automation to handle unexpected 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 — Live Online
- Jul 31, 2026 10:00am–5:00pm — Live Online
- Jul 31, 2026 10:00am–5:00pm — Live Online
- Sep 17, 2026 10:00am–5:00pm — Live Online
- Nov 6, 2026 10:00am–5:00pm — Live Online

## Pricing

**Tuition:** $345