Save time and increase efficiency in day-to-day tasks by Automating Excel 2010 Tasks Using Macros.
Description
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