Excel: Macros and VBA for Beginners

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