Excel 2007 - VBA

Course details

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.

Objectives

Upon successful completion of this course, students will be able to:

• create, edit, and debug a macro.
• format worksheets using macros.
• create an interactive worksheet.
• work with multiple worksheets.
• perform calculations.

Prerequisites

Lessons

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