->
Lynda - Excel 2010: Macros - 74463
Lynda - Excel 2010: Macros
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.


Table of Contents

  • Introduction
  • 1. Getting Started
  • 2. Running a Macro (Execute, Play Back, Etc.)
  • 3. Using Visual Basic for Applications (VBA)
  • 4. Recording a Macro in Stages
  • 5. Creating Non-Recordable VBA Code
  • 6. Macro Project: Converting a Mailing List into a Database List
  • 7. The Personal Macro Workbook
  • Conclusion
  • Lynda - Excel 2010: Macros


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss