Excel 2013: Macros

Discover how to automate tasks in Excel. Learn how to record, share, and edit macros.

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