# Excel VBA and Macros Level I Course

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

## Overview

Our VBA Excel Macro Classes teach you how to use basic Macros to automate Excel tasks. By incorporating Macros into your spreadsheets, you can work more efficiently and make better use of your Excel skills. This Excel Macro course requires no prior knowledge of Macros. The Excel VBA Macros Level 1 class is an introductory VBA (Visual Basic for Applications) course designed to help you apply your spreadsheet skills in a faster, more efficient, and engaging way.

## What you'll learn

- Write and run basic macros to automate tasks
- Use macros to format worksheets efficiently
- Build interactive worksheets using VBA elements
- Automate tasks across multiple worksheets
- Perform calculations using VBA to enhance spreadsheet functionality

## Prerequisites

Prior VBA programming knowledge is not required, but knowledge equivalent to our [Intermediate Excel](/courses/intermediate-excel-classes) 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 — Live Online
- Jul 30, 2026 10:00am–5:00pm — Live Online
- Sep 16, 2026 10:00am–5:00pm — Live Online
- Nov 5, 2026 10:00am–5:00pm — Live Online

## Pricing

**Tuition:** $345