Course Description
You’ll learn the basics of how to use macros—one of Excel’s most powerful features—in this course 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 course.
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 include:
- 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.
After attending this course, participants will be able to:
- 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.
Review our course policies and procedures page for further information