Excel 2003: VBA Programming (2 day)

Course Overview

In this course you apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks in Excel.

Audience

Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Prerequisites

Excel to a Power User level.

Course Outline

Developing Macros

• Create a Macro with the Macro Recorder
• Edit a Macro
• Debug a Macro
• Customize Toolbars, Menus, and Hotkeys

Formatting Worksheets

• Sort Data
• Insert Rows and Columns
• Insert Text
• Format Text
• Duplicate Data
• Generate a Report

Creating an Interactive Worksheet

• Determine Dialog Box Type
• Capture User Input

Working with Multiple Worksheets

• Insert, Copy, and Delete Worksheets
• Rename Worksheets
• Modify the Order of Worksheets
• Print Worksheets

Performing Calculations

• Create User-defined Functions
• Automate SUM Functions