Automating Excel 2010 Tasks Using Macros


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



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
  • Course Number:
    mo_aexl_a05_dt_enus