Excel: Introduction to VBA
37mIntermediate2019-01-18
Authors
Chris B. Smith
Former Microsoft Excel MVP and Content Developer at Microsoft
Course details
Excel macros allow you to automate routine tasks. Although working with macros involves the Visual Basic for Applications (VBA) programming language, you don’t need to be a programmer to use it. In this course, Excel guru and Microsoft content developer Chris "Smitty" Smith provides a quick introduction to macros and VBA. He walks through the steps of recording a basic macro, then demonstrates how to edit macros, including testing and adjusting, and making recorded macros dynamic. Learn how to do more with Excel using macros.
Skills covered
SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Save time with Excel macros and VBA
1. Understand Macros and VBA
- 02 - What is an Excel macro
2. Record a Macro
- 03 - Enabling the Developer tab to expose VBA tools
- 04 - Recording your first macro
- 05 - Assign a macro to a button
3. Edit the Macro
- 06 - Introduction to Visual Basic (VBA)
- 07 - Reading your recorded code
- 08 - Testing recorded macros
- 09 - Adjusting recorded macros
- 10 - Making recorded macros dynamic
- 11 - Rules of thumb for testing
- 12 - How to step through code when testing
Conclusion
- 13 - Next steps