CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APEX034 - Microsoft Office Excel 2003 Level 4: Introduction to VBA

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This course is designed for 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.

Click here for a printer-friendly version of this page

Prerequisites

Excel 2003 Level 2 or equivalent knowledge

Detailed Class Syllabus

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