# Excel VBA and Macros Level II (Self-Paced)

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

## Overview

Our Advanced Excel VBA Training will teach you how to automate tasks and streamline your workflows using macros.

Excel VBA Macros Level 2 is our advanced class and assumes you're already familiar with the basic macro concepts introduced in our Level 1 Excel VBA class. Getting a handle on the skills taught in VBA Excel classes will empower you to use all the tools from our Excel courses in the most efficient and powerful way possible.

## 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 to capture multiple variable inputs
- Control the lifespan and scope of your variables
- Create automated, event driven processes
- Build automation that handles unexpected errors and events gracefully

## Prerequisites

Students should be comfortable with the concepts covered in [Excel VBA and Macros Level I](/classes/excel-vba-and-macros-level-i).

## Curriculum

#### Lesson 1: VBA Editor

- Project Explorer
- Properties Window
- Modules

#### Lesson 2: Creating / Editing Code

- Functions
- Events

#### Lesson 3: Invoking Macros

- Worksheet Buttons
- Customize Ribbon

#### Lesson 4: Compiling Code

- Stepping through code
- Setting Breakpoints

#### Lesson 5: Variables

- Declarations
- Option Compare Text
- Option Compare Binary
- Lifetime and Scope

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

- Application
- Workbook

#### Lesson 7: Creating & Naming Objects

- Naming conventions
- Housekeeping

#### Lesson 8: Navigation / Selection Techniques

- Absolute versus Relative Reference
- Offsets

#### Lesson 9: Logic Statements

- Nested IF Statements
- Case Statements

#### Lesson 10: Functions

- Intrinsic Functions
- User Defined Functions

#### Lesson 11: Looping Statements

- For Each Next Loops

#### Lesson 12: Interactive Code

- User Forms - dashboards
- Message Boxes

#### Lesson 13: Error Handlers

- Error numbers
- Error descriptions

## Pricing

**Tuition:** $345