In this course, students will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.
Who Should Attend
Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).
Prerequisite(s) or equivalent knowledge
Excel 2007 - Level 1
Excel 2007 - Level 2
Excel 2007 - Level 3
Outline
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
Note: There are PC computers at location for students to use.