Excel 2010: Macros

Introduction

• Welcome
• Using the exercise files

1. Getting Started

• Understanding what a macro does
• Reviewing macro examples
• Understanding security
• Reviewing the recording method
• Understanding other techniques for macros

2. Running a Macro (Execute, Play Back, Etc.)

• Running macros from the View tab
• Running macros from a keyboard shortcut
• Running macros from the Quick Access toolbar button
• Running macros from an object or clip art

3. Using Visual Basic for Applications (VBA)

• Introducing the VBA environment
• Viewing the VBA components

4. Recording a Macro in Stages

• Recording a simple macro
• Adding functionality to a macro

5. Creating Non-Recordable VBA Code

• Understanding absolute and 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

7. The Personal Macro Workbook

• Creating a personal macro workbook for macros with wide applicability
• Closing and updating the personal macro workbook

Conclusion

• Final thoughts