Computer Help Training: Excel Courses - Toronto - North York - Mississauga

Excel
Macros &
VBA Level 1

3 Days (9am to 4pm)
$ 825. or 3 Tickets

Other Excel Course Levels

Introduction
Intermediate Level 1
Formulas
Intermediate Level 2
Functions
Advanced Level 1
Advanced Level 2
Macros & VBA Level 1
Macros & VBA Level 2
Macros & VBA Level 3
Version 2007/2010 Upgrade

Register Now

Contact Us

View PDF Course Outlines for All
Excel Courses

Locations

Toronto
20 Queen Street West, Suite 3306
(Toronto Eaton Centre)

North York
2 Lansing Square, Suite 505
(Hwy 401 & Hwy 404/DVP)

Mississauga
1087 Meyerside Drive, Unit 10
(Dixie Rd. & Hwy. 401)

Newmarket
16635 Yonge Street, Unit 19
(Yonge St. & Mulock Dr.)

While Excel is a very powerful and complete tool, you’ll sometimes encounter a situation where the program is missing some feature you really need. Whether it’s the ability to massage a list of data a particular way or make a sophisticated spreadsheet that is nevertheless safe to hand off to beginner users, a macro is the way to go.
In this course you will learn the basic concepts of macros, from simple recorded macros to sophisticated written VBA macros. It is intended for students who either have repetitive work to do in Excel and would like to teach the program how to do it, or who are in an informal support role and create spreadsheets for less-sophisticated Excel users. It also lays the foundation for students who need more formal and complete understanding of large-scale Excel customization and are moving on to the Level 2 and 3 courses.

Basic Macro Concepts

Macros And Sub Procedures

Limitations Of Recorded Macros

Recording Macros

Relative Referencing

Macro Options

Storing Macros

Editing A Macro

Debugging A Macro

Step Into, Step Over, Step Out

Run To Cursor

Seven Ways To Run A Macro; Adding To Toolbars, Creating Buttons, Etc.

Visual Basic

Defining Projects, Modules, Sub Procedures, Statements, And Events

The Visual Basic Editor

Views And Icons

Adding Comments

Checking Syntax Errors

Sub Procedures

Structures Of Sub Procedures

Objects

Working With

Object Names

Class

Properties

Common Properties

Using The With Command

Properties That Are Objects

Methods

Common Methods

Events

The Object Browser

Project/Library Box

Classes

Variables

Constants

Variable Types

String Variables

Date Variables

Declaring Several Variables

User Interaction

Input Boxes

Converting Input Box Answers

Message Boxes

Building Messages

Special Characters To Sue When Concatenating

Message Box For Input

Status Bar Messages

Flow Of Control

If … Then Statements

If … Then … Elseif

Running Other Procedures From Within Procedures

If Statements With Message Boxes

For … Next Loops

Do While … Loops

Event Trapping

Auto_Open And Auto_Close

On Error Go To

Resume

Application Event Properties

Other Objects’ Event Properties

Versions	Toronto	North York
2007/2010	Mar 19/20/21	Feb 15/16/17
Versions	Mississauga	Newmarket
2007/2010	May 14/15/16	Apr 10/11/12
Course Prerequisite: Required: Solid understanding of all Excel Introduction, and Intermediate Levels I & II topics. Recommended: Knowledge of Excel Advanced topics.