- View Offline
- Understanding what a macro does
- Recording and adding functionality to a macro
- Running macros
- Creating non-recordable VBA code
- Testing a macro in Step mode
- Joining two macros
- Using loop structures
- Streamlining macros
- Creating a Personal Macro Workbook
Skill Level Intermediate
- Hi, I'm Dennis Taylor, welcome to Microsoft Excel 2010 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, Excel's automation capability. I'll show you when it's appropriate to use macros, and in the process familiarize you with the following features. Creating macros by recording keystrokes, expanding a macro for more than one task, making macros available to all Excel workbooks, launching macros with keystroke short cuts 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 commands.
For many Excel users, macros become a power tool with seemingly unlimited capabilities. I'll show you this power as we get started with Excel 2010 Macros in Depth.