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

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

## Overview

This advanced course assumes you are comfortable with the macro concepts from Level I and moves into writing VBA that holds up in real use. You will navigate workbooks using offsets, named ranges, and variables rather than hard-coded cell references, which is what makes automation survive a changing spreadsheet.

You will analyze data with looping structures paired with If and Case statements, build user interface elements that capture several inputs at once, and control the lifespan and scope of variables. The course closes with event-driven processes that run automatically and with error handling, so your automation copes with the unexpected instead of stopping dead.

## What you'll learn

- Navigate a workbook using offsets, named ranges, and variables
- Analyze data with looping structures paired with If and Case statements
- Build user interface structures that capture multiple inputs
- Control the lifespan and scope of your variables
- Create automated, event-driven processes
- Build automation that handles unexpected errors and events gracefully

## Pricing

**Tuition:** $345