2014
Lynda
Dennis Taylor
2:43
English

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.

Introduction
Welcome
Using the exercise files
1. Getting Started with Macros
Identifying applicable situations for using macros
Recognizing the need for single-action macros
Understanding security
Short examples of the recording method
Overview of other techniques
2. Running a Macro
Running a macro from the Developer tab or the View tab
Running a macro from the Quick Access Toolbar button
Running a macro from a keystroke shortcut
Running a macro from an object or clip art
3. Using Visual Basic for Applications (VBA)
The VBA environment and VBA components
Creating the Personal Macro Workbook
Closing and updating the Personal Macro Workbook
4. Recording a Macro in Stages
Recording a simple macro
Expanding a macro with the if statement
5. Creating Nonrecordable VBA Code
Understanding when to use absolute or relative references
Using For and For Next statements
Using Do While and Do Until statements
Creating interactive macros
6. Macro Project: Converting a Mailing List into a Database List
Planning a macro
Recording partial code
Using loop structures in context
Testing a macro in Step mode
Pulling the data together
Joining two macros
Streamlining macros
Conclusion
Next steps

Download File Size:419.69 MB

---