Excel 2010: Macros

Any Excel user, regardless of expertise level, can learn how to save time by automating tasks using Excel macros and Visual Basic for Applications (VBA).

Introduction

• Macros and VBA for beginners

1. The World of Macros and VBA

• Making the case: Why a macro and not regular Excel?

2. Record a Basic Macro

• Add the Developer tab to your ribbon
• Record the macro and review the code
• Stepping through the code

3. Other Things to Know before Creating Macros

• Warnings about VBA and macros: There is no undo
• Warnings about VBA and macros: Recorded macros are literal
• Warnings about VBA and macros: Errors
• The VBA environment
• Four ways to launch macros

Conclusion

• You can do anything with VBA