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

60 Minutes

365 Days

loading...