Macros in MS Excel

To reduce carbon footprint, and reduce cost to you, we are a “paperless” course. Your course materials are available in digital format, and may be printed on-demand if a paper copy is required. This portal will serve as your one stop shop for all the information you need for your course. In this class, we will be using MS Excel. Depending on the version licensed to your computer, it may be a standalone application; or, it may be bundled under Microsoft Office, or Office 365.

Learning Objectives:

This course is a basic introduction to the Macros feature in Microsoft Excel, intended for people who have never formally used that feature. After completing this training, participants should have achieved the following deliverables.

Deliverables:

Upon completion of this 7.5-hour course, students will be able to:

• Use the macro recorder to create a simple Excel macro

• Implement the 5-step process for building simple macros

• Open the Visual Basic editor to read, and modify recorded code

• Troubleshoot macros by using the built-in debugging tools