Request a Catalog.

Mastering Excel® Macros

(Read reviews)

Price: $199


Save Time by Automating Repetitive Tasks with Simple-to-Use Macros

Do you find yourself repeating the same click-click-click sequence of keystrokes over and over again when you’re working on spreadsheets?

If you do, you’ve probably also found that using multiple keystrokes opens yourself up to slip-and-click errors that consume even more of your time … or cause embarrassing gotchas!

This interactive 90-minute webinar explores the rationale and techniques for using macros in Excel to eliminate repetitive command sequences, automate your work, and use Excel more efficiently.

A macro is Excel’s automation tool. As you work with this powerful software, you often find yourself performing the same tasks repeatedly. If you regularly update sales figures, plot data on a chart, or apply special formats, you may find yourself repeating the same sequence of commands and actions.

With a macro, you can store these sets of procedures and avoid having to repeat the entire sequence of actions each time you need to perform them. You can also easily activate them with a keystroke combination, a toolbar button, or an on-screen pointer.

The result is that you’ll save a good deal of time and effort and improve accuracy by creating macros.


We have 1 webinar(s) available starting between 1/9/2018 - 1/9/2018

Date Location Time Attendees  
On Demand Online Webinar On Demand
For assistance registering more than 4  people, please call 1-877-566-9441.

What You Will Learn

Macros can eliminate some of the drudgery associated with repetitive tasks, as well as open the door to powerful capabilities that you cannot perform with standard Excel techniques.

Join us to discover exactly what macros are and how to put them to work for you right now! You’ll learn the best and fastest ways to create and modify time-saving macros with a minimum of effort, including: 

  • Recognizing situations ideal for creating macros
  • How to create a macro by recording, and why this is usually the best way to create a macro 
  • Four ways to run a macro: keystroke shortcut, toolbar button, command, or graphic 
  • Ways to work with macro code (in the language called Visual Basic), created when you record command sequences
  • How to use the step method to test a macro slowly
  • Understanding when you need to add code to a macro and efficient ways to do it
  • Ways to extend the power of macros to perform tasks you cannot achieve with standard Excel features

By seeing examples of how you can automate repetitive tasks—whether short or long—you'll be able to create tools that you can use to work more efficiently with Excel. Plus, a quick introduction to the world of Visual Basic will give you insight into how this programming feature broadens the scope of Excel usage.

Get the expertise others envy—and bosses clamor for!

How You Will Benefit

After completing this course, you will be able to demonstrate a working knowledge of creating Excel macros to reduce keystrokes when analyzing and manipulating complex data in spreadsheets.

How Do AMA Webinars Work?

AMA Webinars provide you with a cost-effective and convenient way to boost your know-how. You can participate in the comfort of your office without the need for travel costs and time.

Because the webinar is live, you can ask our expert questions via online chat during the program. In addition, we will be sending you pre-work approximately one day before the program date via email. Please register early to get these materials that will help guide your learning process!

In addition, paid registrants will have a single-user license to access a recorded archive of the program for a full year.

Please note that AMA Webinars are designed to provide a one-to-one learning experience for an individual and are not designed to be viewed in a group setting. Program access is available only via the MYAMA account of the registered attendee.

This particular webinar does not offer continuing education credits.

Please note: The instructor will be demonstrating these methods and techniques using Excel 2016.

*Microsoft and Excel are registered trademarks of Microsoft.

About the Presenters

BJ Wilson  is a Microsoft Certified Trainer and Excel expert with Osprey Productions. He has been helping people learn Microsoft Office for the past 10 years.

best live chat
AMA is one of the most widely recognized leaders in business training, having provided corporate training solutions for over 95 years. From leadership, communication and managerial training to sales, customer service and analytical skills, AMA has developed a vast array of content and training solutions to help individuals and organizations achieve business results . Each year, AMA delivers thousands of seminars and courses across the United States. With courses offered in a  classroom near you or live online, AMA is a flexible, convenient resource for all of your organization's talent development needs. AMA also offers customized solutions based on your specific talent development requirements.

Technical Requirements

https://event.on24.com/view/help/ehelp.htmlTo fully participate in this electronic, interactive and live session, please check your system (or ask your IT department) to ensure it meets the following requirements:

Supported OS, Browser and Additional Requirements

  • Windows 7+ (Microsoft Edge, Latest Internet Explorer, Firefox, or Chrome)
  • Apple Mac OS 10.9+ (*Latest Firefox, Safari, or Chrome)
  • Ubuntu Linux (Firefox only)
  • Android 4.x (Chrome Browser Only)
  • Apple iOs (*Latest version, Safari Browser Only)

* Official support for the "latest" version of a newly released browser, among those noted above, will be added within 8 weeks of public release. Until then, the previous version will continue to be supported instead.

If you are using an unsupported version of a Windows, Mac, or Linux operating system, you may experience difficulty in viewing and/or listening to the event.

Test Your Computer

The audio portion of this AMA web event will be delivered directly through your computer’s speakers or attached headphones. To fully participate in this electronic, interactive, live session, please test your system and review the requirements (or ask your IT department) before the program begins:


Additional Requirements:

  • Minimum bandwidth requirement is 512 kbps for meeting attendees
  • In order to access the event, your computer must have cookies and JavaScript enabled. If your operating system currently does not have cookies or JavaScript enabled, contact your network administrator.
  • POP-UP Blockers must be turned off to access the program.

Still need Help? Additional technical information can be found here. You can also view these tips in Spanish and French.

Important tip - Please allow 15 minutes prior to joining a session to conduct your set-up and testing!