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.
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.
• 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.
• 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.
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.
• Excel User
• Income Tax Preparers
• Enrolled Agents
• Financial Consultants
• IT Professionals
• Human Resource Personnel
• Government Personnel