Excel VBA and Macros Level I

$345
7 Hours
PC provided
Small in-person class
Free retake
185 Madison Avenue, NYC

All Microsoft Excel Courses Excel VBA and Macros Level I

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.

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

nyc@careercenters.com 212 • 684 • 5151 Download Syllabus

Course Overview

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

Full Course Syllabus

Download PDF Outline

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