My Shopping Cart
There are no items in your shopping cart.

Macro Magic: Macros Aren't Just for Programmers (IMEB203)

Presented by: Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Audio Conference
75 minutes
  •  Wed, October 30, 2013
Event Description

Whenever you find yourself repeating actions in Excel – whether it's a five-step sequence you use when formatting a certain cell type or the 30 steps you use when you sort, filter, and print multiple worksheets once a week, the possibility exists that you can automate these actions in the form of a macro. Thereafter, you can perform these sets of actions with a simple keystroke combination or by using a new button in your Quick Access Toolbar.

In this riveting session, our Excel coach Dennis Taylor will show you how to create these macro shortcuts, alerts you to situations ideal for creating macros, and explores the actual code (in the language called Visual Basic) created when you record command sequences.

Have a look at what you will learn through this exciting 75 minutes conference:

  • Learn how to create a macro by recording and why this is usually the best way to create a macro
  • Learn four ways to run a macro – keystroke shortcut, toolbar button, command, or graphic
  • Learn how to use the step method to test a macro slowly
  • Learn when you need to add code to a macro and efficient ways to do it
  • Learn how 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 will see the tools that you could use to work more efficiently with Excel. An introduction to the world of Visual Basic will give you insight into the potential power of this feature and some sense of how this programming feature broadens the scope of Excel usage.

About Our Speaker(s)

Dennis Taylor | Microsoft Excel SpeakerDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

We Also Recommend
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Macro Magic: Macros Aren't Just for Programmers
    Presenter(s): Dennis Taylor

Our Accreditation Partners Protection Status