Course Descriptions

Microsoft Excel Macros Class

All April classes will be two half-day sessions delivered as live, on-line video conferences.

What You Will Learn

This course is for Microsoft Excel users who want a foundation knowledge of VBA and recording and writing Excel macros. Class discussion and exercises cover —

  • What Excel macros are and what they can do,
  • How to plan a macro before creating it,
  • Creating a macro by having Excel record your actions,
  • Editing a recorded macro,
  • VBA syntax, reading, understanding and writing VBA statements,
  • Excel objects and their methods and properties,
  • Using variables and constants to store values in the macro,
  • “Looping” a macro with Do While, Do Until and For statements to make it repeat certain actions until instructed to stop,
  • Using IF, ELSE and IFELSE statements to insert conditional actions into a macro,
  • Having a macro read data from worksheet cells and pop-up alert boxes, having it write to a worksheet,
  • Assigning the macro to toolbar buttons and worksheet objects, and
  • Choosing the appropriate macro security setting.

6 hours, $260 (available for Windows and Macintosh, not Mac Excel 2008)

Training Format

  • Live trainer in room — not on-line or remote learning,
  • Exercise-based, hands-on classroom instruction,
  • Emphasis on questions and student participation,
  • Small size (limited to 8), personal attention.

Class Location

Dates and Registration


A working knowledge of Excel, including how to create formulas and format a worksheet.

Related Classes and Services

Classes: Excel, Advanced Excel, Excel Dashboards, Pivot Tables and Excel Power Pivot.

We also offer consulting, private classes and one-on-one training. See Excel Services page for more information.

Mailing List and Further Information

Monthly newsletter and schedule: join our Mailing List.
For more information, please contact us.

Class Schedule · ComputerImages Excel Resources · Excel Support Links · Excel Tips

© Copyright 2020, 2010, ComputerImages. All rights reserved.
URL: / course_descriptions / excel-vba-macros-training-class.html
Microsoft Excel Macros Course Outline, Updated January 14, 2020.