# 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

## FAQ

### Is this course open to beginners?

Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required.

### Do you offer payment plans or student financing for this course?

This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify.

### What is the cancellation and refund policy for this single course?

For this course, you are entitled to a 90% refund (your payment less the nonrefundable 10% registration fee) within 30 days of purchase if you have not accessed the course materials.

### What’s included with my tuition?

A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed Expert support with answers to your questions from real instructors throughout your learning journey Top-notch curricula that have been tried and tested over many years and are consistently improved for an optimal learning experience 30-day access to class recordings to review material at your own pace A certificate of completion to verify your accomplishment

### Are there any additional fees or expenses?

There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us. However, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.

### Do you offer any discounts for this course?

We don’t currently offer discounts as we do our best to affordably price our courses.

## Pricing

**Tuition:** $345