In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros
can be used to automate tasks in Excel and walks through the process of
creating and running simple macros. This course also covers advanced topics
such as making macros widely available through the Personal Macro Workbook,
recording a macro in stages, absolute and relative recording, and using
Visual Basic for Applications (VBA) for actions that can't be recorded.
The course wraps up with a macro project that brings together each of the
elements in a real-world scenario. Exercise files are included with the course.
Topics include:
* Understanding what a macro does
* Recording and adding functionality to a macro
* Running macros
* Creating non-recordable VBA code
* Testing a macro in Step mode
* Joining two macros
* Using loop structures
* Streamlining macros
* Creating a Personal Macro Workbook
Download File Size:391.8 MB