2 days

Course Description

This two-day class is intended for advanced Excel professional’s that need to automate their Excel spreadsheets using Visual Basic for Applications (VBA). You will learn to save time by automating the same reports you use regularly, you will learn to develop forms, screens and “machines” for data management and make Excel an even more powerful tool for your daily work.

Prerequisites

Excel Part 1

Excel Part 2

Excel Part 3

Excel Pivot Tables is useful but not required

Course Outline

Lesson 1 Getting Started

Lesson 2 Working with Procedures and Functions

Lesson 3 Understanding Objects

Lesson 4 Using Expressions, Variables, and Intrinsic Functions

Lesson 5 Controlling Program Execution

 

Lesson 6 Working with Forms and Controls

Lesson 7 Working with the PivotTable Object

Lesson 8 Debugging Code

Lesson 9 Handling Errors