Excel 2003 Level 4:Introduction to VBA

 

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
 

Appendix A: Microsoft Office Specialist Program