Microsoft® Office Excel 2003: Introduction To VBA Macros

Training Course Content

Lesson 1: Developing Macros

Topic 1A: Create a Macro with the Macro Recorder
Topic 1B: Edit a Macro
Topic 1C: Debug a Macro
Topic 1D: Customize Toolbars, Menus, and Hotkeys

Lesson 2: Formatting Worksheets

Topic 2A: Sort Data
Topic 2B: Insert Rows and Columns
Topic 2C: Insert Text
Topic 2D: Format Text
Topic 2E: Duplicate Data
Topic 2F: Generate a Report

Lesson 3: Creating an Interactive Worksheet

Topic 3A: Determine Dialog Box Type
Topic 3B: Capture User Input

Lesson 4: Working with Multiple Worksheets

Topic 4A: Insert, Copy, and Delete Worksheets
Topic 4B: Rename Worksheets
Topic 4C: Modify the Order of Worksheets
Topic 4D: Print Worksheets

Lesson 5: Performing Calculations

Topic 5A: Create User-defined Functions
Topic 5B: Automate SUM Functions

Introduction To VBA Macros (Excel Level 4) Prerequisites: To ensure your success, we recommend that you have experience with intermediate level formulas, charting, data management tools and basic macros. Students can obtain this level of skill through our Level 1, 2 and 3 courses. Contact us to discuss if this level is right for you.

Delivery Method: Instructor led, group-paced, hands-on classroom training with activities. Additionally, manuals are provided for each student for after class reference.

Excel 2003 Course Outlines:
Level 1 - Fundamentals
Level 2 - Intermediate
Level 3 - Advanced
Level 4 - Exploring Macros
Level 5 - Advanced Macros & VBA