Excel 2003 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 2003 Getting Started and Excel 2003 Formatting Spreadsheets)

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

• Comfortable working with Excel worksheets and workbooks.
  (Suggested course: Excel 2003 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.

• Record a macro using the macro recorder.

• Run a macro from the menu or a shortcut key.

• View a macro.

• Modify a macro.

• Understand absolute vs. relative recording.

• Assign existing macros to shortcut keys.

• Make macros available to all workbooks.

• Create a macro button.

• Delete 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)