Post Description

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