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.
Who should attend
All Ms Excel users in every level
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