->
Lynda - Excel 2013: Macros - 154420
Lynda - Excel 2013: Macros
Want to save time on routine tasks in Microsoft Excel? Macros are your answer. In this course, author Dennis Taylor explains how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros 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: converting mailing list data into a database-friendly format.


Table of Contents

  • Introduction
  • 1. Getting Started with Macros
  • 2. Running a Macro
  • 3. Using Visual Basic for Applications (VBA)
  • 4. Recording a Macro in Stages
  • 5. Creating Nonrecordable VBA Code
  • 6. Macro Project: Converting a Mailing List into a Database List
  • Conclusion
  • Lynda - Excel 2013: 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