Agenda

June 3, 2026
11:00 am - 1:00 pm EST

When you attend this live presentation, you’ll learn from Excel expert David Ringstrom, CPA, how to implement multiple techniques to create spreadsheets that are interactive, accurate, and user friendly. He demonstrates how to use a variety of Excel’s form controls and features to control the data input of other users, simplify data entry, preserve key formulas, minimize spreadsheet maintenance, and more.

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.

Topics

What You'll Learn:

• In this session, you’ll gain practical Excel skills to improve data accuracy, efficiency, and usability.

  Topics include:

• Managing and removing Data Validation rules, including enhancing drop‑down lists with custom input and error messages
• Enabling advanced Excel tools by activating the Developer tab and using Form Controls such as combo boxes and checkboxes
• Filtering data efficiently using Table Slicers and PivotTable filters
• Converting data ranges into Tables and summarizing results using the Total Row
• Creating PivotTables quickly by assigning fields to Rows and Values
• Enhancing workbook usability with worksheet navigation tools and mailto hyperlinks

Speaker(s)

David H. Ringstrom

Author

David H. Ringstrom, Ed.D., has designed, delivered, and supervised communication training programs for more than 25,000 executive, managerial, supervisory, administrative, and technical professionals internationally over the past three decades. He is the author of the books How to Write Fast Under Pressure, The Art of E-mail Writing, and The Art of On-the-Job Writing. He has edited major reports for Fortune 500 companies, the US government, and the City of New York. He also writes the popular blog Words on the Line, which offers practical tips for developing writers. Dr. Vassallo has taught internationally, recently as a faculty member of the Beijing International MBA program.

Fees

Live Webinar - $299.00

• Live Access
• 30 Days OnDemand Playback
• Presenter Materials and Handouts

Available Upgrades

• Additional Live Access - $95.00 Per Person
• 12 Months OnDemand Playback - $120.00
• 12 Months OnDemand Playback + Digital Download - $150.00

**100% surcharge applied to non-members.

Association Contact