->
Lynda - Excel 2016: Macros in Depth - 431190
Lynda - Excel 2016: Macros in Depth
Macros can help you save enormous amounts of time, but they are uncharted territory for many Excel users. Learn how to create your own simple macros to automate repetitive tasks in Excel 2016, in this course with Excel expert Dennis Taylor. Find out 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 easily recorded. Discover how to expand macros with Do loops and If statements, and test macros step-by-step. 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
  • 2. Running a Macro
  • 3. Using 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 2016: Macros in Depth


     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