Microsoft Excel Macros Specialist Course

Is it right for me?

Our Excel Macros Specialist course aims to show how macros can be used to automate commonly used commands and processes.

This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course.

What will I get out of it?

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

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

Versions available

2003, 2007, 2010

Related courses in our range

• Excel Module 4 -– Advanced Formulas and Functions
• Excel Pivot Table Specialist
• Excel Business Intelligence and Dashboards
• VBA in Excel Part 1
• VBA in Excel Part 2
• VBA in Excel Part 3

What does it cover?

Recording macros

• Accessing the Developer Tab (2007 and 2010)
• Naming conventions and storage locations
• Absolute and relative cell addressing
• Saving workbooks containing macros (2007 and 2010)

Running macros

• Assigning macros to toolbars (2003)
• Creating menus (2003)
• Assigning macros to the Quick Access Toolbar (2007 and 2010)
• Assigning macros to objects

Creating macro toolbars (2003)

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

Storing macros in workbooks (2007 and 2010)

• 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
• Using debug

Function procedures

• Creating function macros