# Excel Programming with VBA

Canonical URL: <https://www.careercenters.com/courses/vba>

## Overview

### Excel VBA Programming Classes in NYC

Master VBA (Visual Basic for Applications) and macros in this course for avid Excel users. Visual Basic for Applications or VBA is Microsoft's coding language to program Excel. You can use it to write macros and automate tasks. On Day 1, you'll learn everything covered in [Excel VBA Macros Level 1](/courses/excel-vba-and-macros-level-i). Day 2 covers advanced VBA techniques in [Excel VBA Macros Level 2](/courses/excel-vba-and-macros-level-ii). 

In this hands-on course, you'll learn how to accelerate your workflow in Excel with macros. In addition to working faster, you'll also work smarter by eliminating possible errors—both days of the course end with a lesson on error handling with VBA code.

## What you'll learn

- Develop a macro
- Format worksheets using macros
- Create an interactive worksheet
- Work with multiple worksheets
- Perform calculations
- 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

Prior VBA programming knowledge is not required, but knowledge equivalent to our [Intermediate Excel](/courses/intermediate-excel) course is recommended, including VLOOKUP, Pivot Tables, and IF statements.

## Schedule
- Jul 30, 2026 – Jul 31, 2026 — NYC
- Sep 16, 2026 – Sep 17, 2026 — NYC
- Nov 5, 2026 – Nov 6, 2026 — NYC

## Pricing

**Tuition:** $549