Versions Available:

2000, XP, 2003 and 2007

* Dates marked with an asterisk denote that the course is also available in Microsoft Office 2007 in addition to our standard Microsoft Office 2000, XP and 2003 offering

This course is designed for existing experienced users of Excel. The course aims to show how macros can be used to automate commonly used commands and processes.

Users must be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course.

By the end of the course participants will be able to:

• Record and run macros
• Navigate within the Visual Basic environment
• Edit pre-recorded macros
• Create their own functions

Related courses in our range include:

• VBA in Excel Part 1
• VBA in Excel Part 2
• Excel Module 1 - Essentials
• Excel Module 2 - Gathering & Presenting Data
• Excel Module 3 - Data Analysis
• Excel Module 4 - Advanced Formulas & Functions
• Excel Module 5 - Advanced Data Management
• Excel - Pivot Table Expert

Versions available:

Course Outline:

Recording Macros 

• Accessing the Developer Tag  (2007 only)
• Naming conventions·and storage locations· 
• Absolute and relative cell addressing

Running Macros· 

• Assigning macros to toolbar buttons· (2000, XP and 2003 only) 
• Creating menus· (2000, XP and 2003 only) 
• Assigning macros to the quick access toolbar (2007 only)
• Assigning macros to objects/buttons on the worksheet

Creating Macro Toolbars· (2000, XP and 2003 only)

• Creating a custom toolbar· 
• Adding macro buttons to the toolbar· 
• Attaching the toolbar to a workbook· 

Storing Macros in Workbooks (2007 only)

• Recording macros in a specific workbook
• Saving the workbook as an Excel Macro-enabled Workbook
• Creating quick access items specific to workbooks

Macro Management· 

• Deleting macros· 
• Setting macro options
• Macro security

The Visual Basic Environment· 

• Project explorer· 
• Code window· 
• Properties window

Working With Code· 

• Code structure· 
• Adding comments· 
• Navigating within your code· 
• Editing macro code· 
• Getting help with syntax

Commonly Used Commands· 

• Workbook and worksheet commands· 
• Excel selection methods

Debugging· 

• Errors· 
• Compiling· 
• Using Debug

Function Procedures· 

• Function macros· 
• Creating function macros as add-ins