Overview
-
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).
Syllabus
-
Introduction
- Macros and VBA for beginners
- Making the case: Why a macro and not regular Excel?
- Add the Developer tab to your ribbon
- Record the macro and review the code
- Stepping through the code
- 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
- You can do anything with VBA
