Excel 2007 Automating Tasks with Macros

Objective

Learn to write macros to automate various Excel tasks.

Prerequisite Skills

• Comfortable with Excel and its formatting capabilities.
  (Suggested courses: Excel 2007 Getting Started and Excel 2007 Formatting Spreadsheets)

• Comfortable with basic functions & formulas.
  (Suggested course: Excel 2007 Functions & Formulas)

• Comfortable working with Excel worksheets and workbooks.
  (Suggested course: Excel 2007 Working with Workbooks)

Course Description

Do you frequently perform the same tasks in Excel? Learn various ways to save time and steps by recording macros.

Attend this course if you want to:

• Learn various ways that macros can be used.

• Enable macro security in Excel, and open workbooks containing macros.

• Record a macro using the macro recorder.

• Understand absolute vs. relative recording.

• Run a macro from the Macros dialog box or from a shortcut key.

• View a macro.

• Modify a macro.

• Assign existing macros to shortcut keys or to the Quick Access toolbar.

• Assign a macro to an object on the worksheet.

• Make macros available to all workbooks.

• Delete macros.

• Save workbooks that contain macros.

Class Length

90 minutes

Delivery Options

• Virtual classroom - public
  ($70 per student; check times and register here)

• Virtual classroom - dedicated (up to ten people from the same organization)
  ($480 per class; contact us for more details)

• Virtual classroom - one on one
  (Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)

• On-site instructor-led
  (Contact us for details)