Automating Excel 2010 Tasks Using Macros





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.


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


1.0

Using Macros to Automate Repetitive Tasks

  • 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


    • mo_aexl_a05_dt_enus