Attend upcoming webinar and earn continuing education credits. Excel Macro Basics (2-part series) | | | | | | | April | | 27-28 | 1 pm - 2:40 pm ET each day | | | | | | | | | Excel Macro Basics: Part 1 April 27th, 2017, 1:00 PM to 2:40 PM, ET
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.
Excel Macro Basics: Part 2 April 28th, 2017, 2017, 1:00 PM to 2:40 PM, ET
In Part 2 of Excel Macro Basics, Excel expert David H. Ringstrom, CPA, guides you beyond the basics of Excel's Record Macro feature. He demonstrates how to enhance the code you've created by adding error-handling features, interactive features, and decision-making capabilities.
In addition, David explains how to: - Filter based on cell contents.
- Simplify what-if analysis with Excel's Goal Seek feature.
- Play back recorded macros to eliminate repetitive tasks.
- Create simple macros with the Record Macro feature... and more.
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. Course Reviews from Past Attendees
100% of attendees said they would recommend this course to others. "Very informative." "Instructor is awesome." | | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 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. | | | | | | | | | ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,000 on-demand courses | | | | | |
No comments:
Post a Comment