Automating Excel 2010 Tasks Using Macros

Overview/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.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
1.0

Lesson Objectives

Automating Excel 2010 Tasks Using Macros

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