Excel Explained: Creating Interactive Spreadsheets

This session covers practical tools for controlling user input and improving worksheet functionality, including Data Validation management, combo boxes, checkboxes, and enhancing drop-down lists with clear prompts and error messages.

You’ll also explore filtering with Slicers and PivotTable filters, converting ranges to Tables, summarizing data with PivotTables, enabling the Developer tab for advanced tools, and creating helpful navigation links and mailto hyperlinks within Excel.

Date
Jun 3, 2026
Location
Virtual
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.

Association Contact
Susan Clark Silvia Regalado
Professional Development Coordinator Professional Development Coordinator
o: 317-387-9380 o: 317-387-9380
d: 317-333-7169 d: 317-333-7170
sclark@indiana.bank sregalado@indiana.bank
Additional Information

WHO SHOULD ATTEND?

Banking professionals who use Excel for reporting, analysis, reconciliations, loan tracking, or operational decision-making and want to work more efficiently, accurately, and confidently with their data.