Course Outline

Excel 2010 Recording Macros
This course covers all aspects of Excel’s macro recorder feature, including macro concepts, terminology, conventions and shortcuts. Participants will record, test, modify and run several useful macros to automate everyday tasks in Excel. Participants will learn several different approaches to running macros including creating custom macro commands for toolbars and menus and assigning them to macros. The course also covers assigning custom keyboard shortcuts to macros and designing custom command buttons to which macros can be assigned. The course provides a brief introduction to the Visual Basic Editor as a tool for modifying, copying and testing macros. 6 hours

Understanding the macro recorder

  • What’s VBA?
  • Macros and VBA
  • Concepts and Terminology
  • Using the Personal Macro Workbook

Record and run simple macros

  • Using the Macros dialog box
  • Using the Visual Basic and Stop-recording toolbars
  • Understanding the relative reference command

Record and run complex macros

  • Making macros modular
  • Running macros that run other macros
  • Macro efficiency concepts

Using the Visual Basic Editor

  • Understanding the Editor environment
  • Stepping through and debugging recorded macros
  • Copying macro code

Running macros

  • The macro dialog box
  • Custom menu commands for macros
  • Custom toolbar commands for macros
  • Custom buttons for macros
  • Knowing when to use which options
Prerequisites:  Excel levels 2 and 3 or equivalent experience. This course is for advanced Excel users.

Revised 8/14/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600