Microsoft Excel Series - Part 1: Shake Hands with Macros

This first training program in the Microsoft Excel webinar series will discuss the automation possibilities that Excel macros offer and the nuances of Excel’s Personal Macro Workbook. It will also define how to use Excel’s Macro Recorder, and offer a quick guide on how to create a keyboard shortcut on the Quick Access Toolbar and on applying Relative References when recording macros.

Other Webinars in the Series:

• Microsoft Excel Series - Part 2: Learn More about Macros
• Microsoft Excel Series - Part 3: Beyond IF and Excel Macros
• Microsoft Excel Series - Part 4: Creating Custom Excel Interfaces with UserForms

Why Should You Attend:

This first webinar in the four-part series will help participants gain an in-depth understanding of Excel macros. Program participants will also learn how to automate repetitive tasks, learn more about Excel’s Macro Recorder, discover how to store macros in a Personal Macro Workbook for future use, and learn how to create a shortcut on the Quick Access Toolbar.

Learning Objectives:

• Recall the automation possibilities that Excel macros offer.
• Apply the Hide and Unhide commands in an Excel Personal Macro Workbook as needed.
• List actions you can take if you make a mistake while recording a macro.
• Define how to use Excel’s Macro Recorder.
• Identify how to create a keyboard shortcut on the Quick Access Toolbar.
• Apply Relative References when recording macros.

Areas Covered in the Webinar:

• An introduction to Excel macros.
• Using Excel’s Macro Recorder to create simple macros.
• Determining when to use Relative References with Excel’s Macro Recorder.
• Recovering from mistakes you’ve made while recording macros.
• Understanding the nuances of Excel’s Personal Macro Workbook and why you might want to use it.
• Creating an icon on your Quick Access Toolbar so you can launch frequently used macros with a mouse click or a keyboard shortcut.

Who Will Benefit:

• Banking
• Finance
• Insurance
• Education
• Telecom
• IT
• CPAs
• CFOs
• Controllers
• Marketing
• Sales
• Investments
• Pharmaceutical
• Medical Devices
• FDA
• Aviation
• Energy
• Retail
• Human Resource
• Logistics and Supply Chain
• Accountants
• Audit