Microsoft Excel 2007 Introduction to VBA Training

How To Take This Class:

• Live Instructor-Led Online Class   > View Schedule or Register
• Onsite Group Training   > Request Pricing

Instructor-Led Online Course Tuition:

$245.00

Course Duration:

1 Day

What Students Receive:

Each student will receive:

• A printed courseware manual for use during and after class.
• Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
• A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2007 Training Class
• A course completion certificate upon successful completion of your Microsoft Excel 2007 Training course
• Six months of post-class email support from a Microsoft Excel Instructor

Course Description:

In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this Microsoft Excel 2007 Introduction to VBA Training course, you 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.

Course 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.

Course Audience:

This course is designed for advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Course Prerequisites:

Students should have completed, or have experience with, topics covered in the Microsoft Excel 2007 Introduction. Intermediate and Advanced Training courses.

Course Syllabus:

1. 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 the Quick Access Toolbar and Hotkeys
• Topic 1E: Work with Macro Security
2. Lesson 2: Formatting Worksheets Using Macros
• Topic 2A: Insert Text
• Topic 2B: Format Text
• Topic 2C: Sort Data
• Topic 2D: Duplicate Data
• Topic 2E: Generate a Report
3. Lesson 3: Creating an Interactive Worksheet
• Topic 3A: Determine the Dialog Box Type
• Topic 3B: Capture User Input
4. 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
5. Lesson 5: Performing Calculations
• Topic 5A: Create User-Defined Functions
• Topic 5B: Automate SUM Functions