Computing Services
Automation Through Macros
Course Outline:
Many tasks that you perform in Microsoft Excel are often repetitive. These can include formatting cells, entering worksheet labels, printing commands, or deleting data. Individual tasks can be completed quickly. When there are several repetitive tasks that need to be executed at the same time, a macro can accomplish those tasks very efficiently.
Macros are Microsoft Office objects that record these tasks as you do them once. Then they can be executed within an Excel worksheet to play back those recorded tasks at any time in the future.
This course will cover:
- How to plan and record a macro
- Making Macros Flexible
Handouts:
UC_Excel_2007_Module_7_-_Macros.pdf (27 pages)Practice Files:
UC_Excel_2007_-_Macros_Workbook.xlsxlast update October 27, 2008 -ei for kv
