# Excel VBA and Macros Level II Course (Self-Paced)

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

## Overview

This advanced VBA course builds on the foundation from Level 1 and brings your macro skills to the next level. You'll discover how to automate more complex tasks, streamline workflows, and apply everything you've learned across Excel in a faster, more powerful way.

To get the most from this course, you'll want to come in with a solid grasp of the core macro concepts covered in our Level 1 VBA class. With that foundation in place, you'll be well positioned to unlock the full potential of everything taught across our Excel courses.

## What you'll learn

- Navigate workbooks using offsets, named ranges, and variables
- Analyze data by combining looping structures with If and Case statements
- Build user interface structures to capture multiple variable inputs
- Control the lifespan and scope of your variables
- Create automated, event-driven processes
- Handle unexpected errors and events with reliable automation

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

## Pricing

**Tuition:** $345