# Excel VBA and Macros Level I

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

## Overview

Our VBA Excel Macro Classes will instruct you how to use basic Macros to automate Excel. You will be able to use your Excel knowledge more productively by incorporating Macros in your spreadsheets. This Excel Macro Course assumes no previous knowledge of Macros. Excel VBA Macros Level 1 course is a basic VBA (Visual Basic for Applications) class, that will help you apply spreadsheet skills, in a faster, more efficient and exciting 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](/classes/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 16, 2026 10:00am–5:00pm — NYC
- Jun 23, 2026 10:00am–5:00pm — NYC
- Jul 30, 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

## Instructors

### Brian McClain — Program Director & Senior Instructor

Brian McClain is an experienced instructor, curriculum developer, and web developer. Brian served as Director for a coding bootcamp before joining Noble Desktop in 2022, where he is now a lead instructor and course developer for both JavaScript and Python. He teaches Web Development, JavaScript, Python for Data Science, Machine Learning, and AI. Prior to Noble, he taught Python Data Science and Machine Learning as an Adjunct Professor of Computer Science at Westchester County College.

Brian is also an active industry professional in the field of generative AI app development. His website and iOS app, Artmink, provides appraisals of art and antiques from user-uploaded images.

### Mourad Kattan — Program Director & Instructor

Mourad Kattan is an instructor and Program Director of Business, Finance, & Excel at Noble Desktop, teaching classes and designing courses in Excel, finance, accounting, and financial modeling.

Before Noble Desktop, Mourad worked as a financial analyst at Credit Suisse and H/2 Capital Partners. In those positions, he used advanced analytical and financial skills to evaluate a variety of investments.

Mourad graduated from the University of Pennsylvania summa cum laude and is part of the Beta Gamma Sigma honor society.

Learn more about [Mourad Kattan's](/mourad-kattan) background and expertise.

### Adebayo Norman — Instructor

Adebayo "Ade" Norman is a Senior Software Trainer with over 14 years of experience in the classroom. He is a training professional with vast troubleshooting/help desk experience and thousands of hours of software training & delivery experience. His specialty is in the In-person/Online Hybrid training environment needed in these new & changing times.

### Garfield Stinvil — Senior Instructor

Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.

Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. 

Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.

## Pricing

**Tuition:** $345