MOC 50432 Excel 2007 Programming Using Visual Basic for Applications

    

Summary:
This course provides students with the knowledge and skills to use Microsoft Visual Basic for Applications to control Microsoft Excel 2007 programmatically. The course serves as an introduction to programming using the Visual Basic programming language.

Duration:
3 Days/Lecture & Lab

Audience:
This course is intended for experienced Excel users who are interested in creating code to automate tasks in Excel.

Topics:

• Getting Started
• Working with Procedures and Functions
• Understanding Objects
• Using Expressions, Variables, and Intrinsic Functions
• Controlling Program Execution
• Working with Forms and Controls
• Working with the PivotTable Object
• Debugging Code

Prerequisites:
Before attending this course, students must have:-An intermediate level of experience using Microsoft Excel 2007. Familiarity with PivotTables is helpful, but not required. No prior programming experience is necessary.

Last Update: May 22, 2012