Introduction to Excel Macros

Member price:


Your price:

$ 199.00

1:00 PM - 3:00 PM CT

Presenter: David H. Ringstrom, CPA

You’ll learn the basics of how to use macros—one of Excel’s most powerful features—in this live webcast presented by Excel expert David Ringstrom, CPA. David introduces the overall concept of Excel macros as well as Visual Basic for Applications (VBA) macros, which allow you to automate procedures commonly performed in Excel. In addition, he shows you step-by-step how to use the Record Macro feature, Excel’s Personal Macro Workbook, and more. After participating in David’s presentation, you’ll be equipped to use macros immediately to speed up your work in Excel.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Topics Covered:

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

Learning Objectives:

  • Apply Visual Basic for Applications (VBA) macros in Excel.
  • Define how to use the Record Macro feature.
  • Apply the Hide and Unhide commands in an Excel Personal Macro Workbook as needed.

David Ringstrom David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.