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-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Wed, September 23, 2015
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 Training ExpertDennis 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:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Macro Magic: Using Excel 2013 Macros to Save Time and Automate Your Work
    Presenter(s): Dennis Taylor

 
DMCA.com Protection Status