Discover how to automate tasks in Excel. Learn how to record, share, and edit macros.
- View Offline
- [Voiceover] Hi, I'm Dennis Taylor and welcome to Microsoft Excel 2013: Macros in Depth. If you want to eliminate some of the drudgery associated with repetitious command sequences, or data manipulation tasks, then you need to know more about macros, Excels automation capability. I'll show you when it's appropriate to use macros, creating macros by recording keystrokes, expanding a macro for more than one task, launching macros with keystroke shortcuts and toolbar buttons, editing VBA code, and making sense of that VBA environment, debugging and testing macros via step-mode and split screens, and expanding the power of macros with do loops and if statements.
I'll show you this power as we get started with Excel 2013: Macros in Depth.
- Understanding what macros can do for you
- Running macros
- Creating a Personal Macro Workbook
- Recording macros
- Creating nonrecordable VBA code
- Expanding a macro with statements
- Using absolute and relative references
- Testing a macro in Step mode
- Joining two macros
- Using loop structures
- Streamlining macros