Home > Courses Certifications > Programming > Excel 2007 VBA - 1 Day Synopsis

Excel 2007 VBA

Duration: 1 Day

Lesson 1: Developing Macros

• Create a Macro with the Macro Recorder
• Edit a Macro
• Debug a Macro
• Customize the Quick Access Toolbar and Hotkeys
• Work with Macro Security
  

Lesson 2: Formatting Worksheets Using Macros

• Insert Text
• Format Text
• Sort Data
• Duplicate Data
• Generate a Report

Lesson 3: Creating an Interactive Worksheet

• Determine the Dialog Box Type
• Capture User Input

Lesson 4: Working with Multiple Worksheets

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

Lesson 5: Performing Calculations

• Create User-Defined Functions
• Automate SUM Functions