# Excel VBA and Macros Level I

Canonical URL: <https://www.careercenters.com/courses/excel-vba-and-macros-level-i>

## Overview

### Learn Excel VBA Programming in Manhattan, NYC

Learn macros and automation in Excel VBA and Macros Level I. The class begins with an introduction to Visual Basic for Applications (VBA) and macros. Throughout the course, you'll learn hotkeys, how to compile code, loops, and logic statements. The session ends with a lesson on using interactive code to create input and message boxes, and error handling, so you can avoid mistakes that lead to software crashes.

### Excel VBA Programming Course Workbook

Our hands-on training approach helps to reinforce content, so you'll remember not just what you learned, but how to do it. By the end of Excel VBA and Macros Level I, you'll have experience writing code and creating macros. You'll also receive a personal copy of the course workbook, where you can take detailed notes to help you replicate the practice activities at home. The course workbook is a valuable training and reference tool that you can take on the job or anywhere you go for work.

### Enroll in Excel VBA Bootcamp & Save 20%

The [Excel VBA Bootcamp](/courses/vba) includes Excel VBA and Macros Levels I and II. The two-day course provides all the information you need to know to master VBA programming in Excel quickly. By enrolling the bootcamp, you get 20% off the regular price than if you enrolled in the classes individually.

### Free Retake

Your class fee includes a free retake. Take the VBA programming course again within six months free of charge.

## What you'll learn

- Develop a macro
- Format worksheets using macros
- Create an interactive worksheet
- Work with multiple worksheets
- Perform calculations

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

## Curriculum

#### Lesson 1: Macros / VBA

- What are Macros?
- What is VBA?
- How to record macros
- How to run macros

#### Lesson 2: VBA Editor

- Modules
- Procedures
- Project Explorer
- Toolbars / Options

#### Lesson 3: Creating / Editing Code

- Create Procedures
- Subs
- Comments

#### Lesson 4: Invoking Macros

- Hot Keys
- Quick Access Toolbar
- Call Command

#### Lesson 5: Compiling Code

- Stepping through code
- Reset
- Run

#### Lesson 6: Variables

- Declarations
- Option Explicit
- Data Types

#### Lesson 7: Working with The Object Model

- Worksheets
- Ranges: Rows, Columns, Cells

#### Lesson 8: Creating & Naming Objects

- Naming conventions
- Housekeeping

#### Lesson 9: Navigation / Selection Techniques

- Formula R1C1 Reference Style
- Offsets
- Range Names

#### Lesson 10: Logic Statements

- IF Statements

#### Lesson 11: Looping Statements

- Do Loops

#### Lesson 12: Interactive Code

- Input boxes
- Message boxes

#### Lesson 13: Error Handlers

- Preventing fatal errors and crashes

## Schedule
- Jun 23, 2026 10:00am–5:00pm — NYC
- Jul 30, 2026 10:00am–5:00pm — NYC
- Sep 16, 2026 10:00am–5:00pm — NYC
- Nov 5, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $345