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:
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.
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