This course is for the intermediate to advanced Excel user. In this course you learn to create and modify macros using both the macro recorder and the Visual Basic Editor. You learn how to create controls including combo boxes, check boxes and text boxes on a worksheet and how to create and modify toolbars and menus.

Prerequisites

Microsoft Excel 2003 - Part 3 or equivalent knowledge. 

---

Objectives

After completing this course, students will be able to:

• Record and run a personal macro
• Record and run a workbook macro
• Edit a macro
• Add a macro button to a worksheet
• Open a new module in the Visual Basic Editor
• Display a data prompt during macro execution
• Use a conditional statement in a macro
• Use a control loop in a macro
• Place a combo box on a worksheet
• Place a check box on a worksheet
• Link a control to worksheet data
• Create a new toolbar
• Add a button to a toolbar
• Assign a macro to a toolbar button
• Create a new menu
• Add an item to a menu
• Assign a macro to a menu item
• Display Visual Basic Help information

---

Course Materials

The courseware (book) and student data files are included with the class. The courseware is Microsoft Approved Courseware. The courseware has been reviewed and approved to satisfy Microsoft Office Specialist certification exam standards.

[Part 1]  [Part 2]  [Part 3]  [Part 4]

Top of Page