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

Macro Magic: Using Excel 2013 Macros to Save Time and Automate Your Work (IME950U)

Presented by: Dennis Taylor
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
60 minutes
Event Description
See the sneak peek before you buy!
1.0 CPE

Leverage the Power of Macros to Automate Repetitive Tasks and Boost Productivity!

Excel is a tremendously flexible application and offers numerous ways to increase productivity and efficiency. However, even people who use Excel everyday often inevitably end up repeating certain actions when they work, from formatting cell types to sorting, filtering and printing multiple worksheets once a week. You'd be surprised to know that it's possible to automate most of these actions in the form of a macro. The mighty macro will help you perform these sets of actions with just a simple keystroke combination or by using the Quick Access Toolbar!

This session with expert speaker Dennis Taylor will show you which situations are ideal for creating macros, how to actually create these macro shortcuts, and will explore the actual code (in the language called Visual Basic for Applications (VBA)) created when you record command sequences.

You will get examples of how to automate short or long repetitive tasks and will see the tools that you could use to work more efficiently in Excel. An introduction to the world of VBA (Visual Basic for Applications) 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.

Any Excel user wanting to automate repetitious Excel actions, such as short five-step sequences used frequently, longer multi-step procedures used less often, or even lengthy data cleanup efforts, needs to know how to automate these procedures in a macro to save time, improve accuracy, and become a more proficient Excel user. Anyone who needs tips on the best ways to build macros and wants to gain a sense of the power of macros will benefit from this presentation.

Session Highlights

  • Recognizing ideal situations for creating macros.
  • Creating a macro from recording and the merits of this method for creating a macro.
  • Running a macro in four ways using the toolbar button, keystroke shortcut, command, or graphic.
  • Working with macro code in VBA (the programming language of macros), which is created when you record command sequences.
  • Testing a macro slowly by using the step method.
  • When to add code to a macro and efficient ways to do it.
  • Performing tasks using the power of macros which is not achievable using Excel commands.

Who should attend

All Ms Excel users in every level

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

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Macro Magic: Using Excel 2013 Macros to Save Time and Automate Your Work
    Presenter(s): Dennis Taylor

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team