Course Description

This course aims to increase your productivity by providing the skills and knowledge to use programming VBA code in Excel 2003 effectively.

Pre-Requisites

This course is designed for participants who have a sound working knowledge of Excel 2003. Participants should have extensive experience in formulas, ranges, functions and multiple workbooks.

Outcome

At the completion of this course, participants will be able to:

• Create recorded macros in Excel
• Use the macro recorder to create a variety of macros
• Create and work with userdefined functions
• Work with the main components of the VBA Editor window
• Create command procedures
• Create and use variables
• Write code to manipulate Excel objects
• Use a range of common programming techniques
• Create a custom form complete with controls and event procedures.