Pre-requisites:

Must have a working knowledge of Excel. Power users of Excel and end-user specialist who need to develop macros for their departments.

Chapter 1: Make a Macro Do Simple Tasks

How Visual Basic for Applications Talks to Excel

Creating a Simple Macro

Changing Multiple Properties at Once

Editing a Recorded Macro

Recording Actions in a Macro

Chapter 2: Make a Macro Do Complex Tasks

Divide and Conquer

Task One: Opening the Report File

Task Two: Filling in Missing Labels

Task Three: Adding a Column of Dates

Task Four: Appending to the Database

Task Five: Deleting the Worksheet

Assembling the Pieces

Part 1 Review and Practice

Shifting a Column

Adding a Row with Formulas

Chapter 3: Explore Microsoft Excel’s Object Library

Using the Locals Window to Learn About Objects

Using the Immediate Window to Learn About Objects

Using Help to Learn About Objects

Using Auto Lists to Learn About Objects

Using the Object Browser to Learn About Objects

:: Course VBA03 ::

Chapter 4: Explore Range Objects

Enhancing Recorded Selections

Exploring Ranges

Exploring Formulas

Chapter 5: Explore Graphical Objects

Exploring Graphical Objects

Exploring Chart Objects

Chapter 6: Explore PivotTable Objects

Building PivotTables

Refining PivotTables

Part 2 Review and Practice

Add Totals to a Table

Synchronize Two PivotTables

Chart a Row from a PivotTable

Chapter 7: Controlling Visual Basic

Using Conditionals

Creating Loops

Managing Large Loops

Chapter 8: Extending Excel and Visual Basic

Creating Custom Functions

Handling Errors

Part 3 Review and Practice

Display the Full File Name

Create Selective Totals from a List

Chapter 9: Launching Macros with Events

Creating Custom Toolbars and Menus

Creating Custom Command Buttons

Handling Worksheet and Workbook Events

:: Course VBA03 ::

Chapter 10: Using Dialog Box Controls on a Worksheet

Using a Loan Payment Calculator

Creating an Error-Resistant Loan Payment Calculator

Retrieving a Value from a List

Proctecting the Worksheet

Chapter 11: Creating a Custom Form

Creating a Form’s User Interface

Preparing a Form’s Functionality

Implementing a Form