Course Outline

Excel 2007 Recording Macros - NEW
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/5/2010
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600