Macros in Excel

Advanced

Long thought to be the province of supergeeks, macros will come alive in this exciting class. You will learn how to record macros, be introduced to the Visual Basic programming language, and write simple code statements

  • The Developer tab on the Ribbon
  • Recording Macros
  • Playing back Macros with Keystrokes
  • Adding Macros to the Quick Access Toolbar
  • Attaching Macros to Buttons
  • How Cell References operate in Macros
  • Where does the Macro Live?
  • Macro-enabled File Formats
  • Exploring the VBA Editor
  • VBA Modules
  • Methods to build Complex Macros
  • Variables and Remarks
  • If… Then… Loops
  • Do While… Loops
  • Controlling the Computer with Macros

Class Length: 4 hours. Can include up to 15 attendees in one session.