/training/webcasts/Mastering-Excel-Macros.aspx
Request a Catalog.
Share

Mastering Excel® Macros

Price: $149

Overview

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 not have 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.


Schedule

We have 2 webinar(s) available starting between 3/21/2014 - 6/12/2014

Date Location Time Attendees  
Mar 21, 2014 Online Webinar On Demand
Jun 12, 2014 Online Webinar 1:00 PM - 2:30 PM
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 as seasoned Excel coach Dennis Taylor explains 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 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!

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

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!

Plus, you’ll have free access to an on-demand archive of the program for a minimum of one year so that you can refer to it again and again to refresh your memory.

Please note that AMA Webinars are designed to provide a learning experience for individual attendees with interactive features that might not be appropriate for group participation. In addition, if certification credits are offered, they can only be applied to the registered individual.

This particular webinar does not offer continuing education credits.

*Microsoft, and Excel are registered trademarks of Microsoft.

About the Presenters

Dennis Taylor is an author and highly respected computer trainer and facilitator, specializing in Excel. His focus is on those spreadsheet and database techniques that improve business efficiency and productivity. He has taught over 250 Excel seminars throughout the U.S. and Canada, thousands of classes, and over 100 webinars. He has  recorded over 50 different Excel training courses. Taylor is author of Teach Yourself Microsoft Excel 2000 and coauthor of six books on using spreadsheet software.

 

Technical Requirements

To 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

Microsoft® Windows® 98 SE, 2000, XP, Windows VistaTM Home Basic, Home Premium, Ultimate, Business, or Enterprise (32-bit or 64-bit editions)

  • Internet Explorer 5.0 or higher
  • Netscape Navigator 7.1
  • AOL 9
  • Mozilla Firefox 1.5 or higher

Macintosh (OS X 10.2, 10.3, 10.4)

  • Safari 1.1 or higher
  • Mozilla Firefox 1.5 or higher

Linux

  • Mozilla Firefox 1.5 or higher

Solaris

  • Mozilla 1.7 or higher

Additional Requirements:

  • Macromedia Flash Player 8 or higher
  • Macromedia Flash Player 9 or higher for Linux and Solaris
  • Minimum bandwidth requirement is 56 kb/sec

Important tip - Please allow 15 minutes prior to joining a session to conduct your set-up and testing! Dial-up connectors - please allow more time.