In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide you through the essential features of Microsoft Excel, focusing on the powerful capabilities of Excel macros. Attendees will learn how to turn on the Developer Tab in Excel's Ribbon, open Project Explorer, and utilize the Properties Windows. The session will cover how macros can streamline repetitive tasks, including recording and saving a Goal Seek macro, as well as editing recorded macros and deconstructing them for better understanding. David will also demonstrate how to create a macro button, enhance user interaction with InputBox, and address common debugging techniques for handling errors and invalid inputs. Join us to discover practical tips and tricks that will empower you to automate your Excel tasks effectively—plus, you’ll have the opportunity to ask questions and get support as you begin your macro journey!
David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant and speaker. He has presented over 2,500 live webinars and is the author or co-author of ten books, including “Microsoft 365 Excel All-in-One for Dummies”, “Microsoft 365 Excel for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and “QuickBooks Online for Dummies”.
In his webinars, David demonstrates every technique twice: first on a PowerPoint slide with numbered steps and then live in Excel for Microsoft 365 for Windows. He highlights any differences in Excel 2024, 2021, or 2019 during the presentation and in his detailed handouts. Attendees also receive an Excel workbook containing most of the examples he uses, making it easy to follow along and apply the techniques later. David additionally supports Excel for Mac users by answering their follow-up questions via email.