Expediting Excel: Discovering Macros
28 May 2018
- 01:00 PM to 02:30 PM EST
90 Minutes

Overall concept of Excel macros as well as the Visual Basic for Applications (VBA)

Expediting Excel: Discovering Macros

Acclaimed Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, but in 2009, he began teaching for continuing education providers as well.

There is no webinar video currently available. Please check back soon.

Overview
In this valuable presentation, Excel expert David Ringstrom, CPA, introduces you to macros, one of Excel’s most powerful features. He explains the overall concept of Excel macros as well as the Visual Basic for Applications (VBA) macro. In addition, David shows you how to use Excel’s Macro Recorder to automate repetitive tasks, such as cleaning up reports exported from an accounting package, scrubbing data, and creating your own keyboard shortcuts for Excel features. After participating is this webcast, you’ll be prepared to begin using macros immediately.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation and in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Topics Covered
• Learning how to use Excel’s Record Macro feature to create simple macros, without having any knowledge of programming.
• Understanding how macros are used in Excel, along with the risks and benefits associated with them.
• Converting .XLS workbooks to the up-to-date .XLSX format with just two keystrokes.
• Learning the risks and frustrations of using merged cells in Excel worksheets.
• Deciphering and managing Excel’s macro security prompts.
• Discovering how to use Excel’s Personal Macro Workbook.

Learning Objectives
• Identify how to prevent macros from being discarded from workbooks when saving.
• Apply the Unhide command to locate and manage Excel’s Personal Macro Workbook.
• Define how to create general-use macros with the Relative Reference setting for Excel’s Macro Recorder.

Learning Benefits
Macros are one of Excel’s most powerful features that can help users automate repetitive tasks and work more efficiently in Excel.

Who should purchase
Practitioners seeking to understand the concept of macros, as well as anyone looking for experience using Excel’s VBA macro and the Macro Recorder.
• Accountants
• CPAs
• CFOs
• Controllers
• Excel User
• Income Tax Preparers
• Enrolled Agents
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Government Personnel

Level Basic

You may also like

HR Certification Institute Approved Provider

Proskilleducator.com is an HRCI Approved Provider and can assign recertification credit hours (based on HR Certification Institute standards) to HR-related continuing education events, including qualification for PHR, SPHR or GPHR recertification credits. The use of this seal is not an endorsement by HR Certification Institute of the quality of the program. It means that this program has met HR Certification Institute’s criteria to be pre-approved for recertification credit.

SHRM Approved Recertification Provider

"proskilleducator.com" is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM.  Our program is valid for PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org