In this comprehensive webcast, Excel expert David Ringstrom, CPA, introduces you to Visual Basic for Applications (VBA) macros—one of Excel’s most powerful features.
You’ll learn how to use Excel’s Record Macro feature to automate repetitive tasks and create your own keyboard shortcuts for Excel features. In addition, David demonstrates how to manage macro security prompts, how to use Excel’s Personal Macro Workbook, and how to convert .XLS workbooks to the up-to-date .XLSX format.
After participating in Part 1 of Excel Macro Basics, you’ll be equipped to begin using 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 Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation, as well as in his detailed handouts.
Who Should Attend:
Practitioners seeking to understand the concept of macros and gaining experience with VBA macros and the Record Macro feature.
Topics Typically Covered:
- Convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes.
- Decipher and manage Excel’s macro security prompts.
- Discover how to use Excel’s Personal Macro Workbook.
- Learn how to use Excel’s Record Macro feature to create simple macros, without having any knowledge of programming.
- Learn the risks and frustrations of using merged cells in Excel worksheets.
- Understand how macros are used in Excel, along with the risks and benefits associated with them.
- 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.
This is part one of a two-part webinar series. To register for both parts together at a discounted price, please click here.