To automate repetitive tasks, Excel 2010 provides a time saving feature known as a macro. These small programs, created using either a simple macro recorder or by using the more complex VBA language, allow you to record the numerous steps involved in accomplishing a task so that they can be played back automatically when the macro is run. This results in time savings and increased efficiency in day-to-day tasks. This course will introduce you to macros in Excel and show you how to leverage their power to make you work with Excel easier.
Learning objectives
- Identify the features of Excel 2010 macros
- Use the Macro Recorder to record and run a macro
- Identify the steps in recording a macro using the macro recorder
- Edit and delete macros
- Run a macro in different ways
- Prepare for recording a macro
- Record and run a macro
- Assign a macro to the developer tab on the Ribbon
- Add a macro the Quick Access Toolbar
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
