Excel 2013: Macros

Discover how to automate tasks in Excel. Learn how to record, share, and edit 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.

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

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