Excel Explained: Introduction to Spreadsheets Workshop part 2

Part 2 builds on foundational skills with practical techniques that improve accuracy, efficiency, and workbook control. This interactive session focuses on working smarter with formulas, managing worksheets, and producing clean, professional output.

Date
Sep 3, 2026
Location
Virtual
Agenda

Thursday September 3, 2026

11:00 am – 1:00 pm EST

In this continuation workshop, you’ll strengthen your Excel fundamentals while adding time-saving tools to your workflow. Topics include using AutoSum with keyboard shortcuts, understanding Excel’s order of operations, freezing rows for easier navigation, and managing print settings to avoid scaling and formatting surprises. You’ll also learn how to work confidently with templates, duplicate and manage worksheets, and navigate large workbooks efficiently.

The session also emphasizes data control and error management. You’ll explore filtering techniques, eliminating duplicates, and managing Excel’s green error prompts so you stay in control of your spreadsheets. As with Part 1, this workshop includes breakout sessions for hands-on practice and guided support throughout.

Topics

What You’ll Learn

  • Using AutoSum to total columns quickly with mouse or keyboard shortcuts
  • Understanding Excel’s order of operations in formulas
  • Starting with templates and managing worksheets (cut, duplicate, delete)
  • Navigating large workbooks efficiently with menus and shortcuts
  • Managing green error prompts and error-checking rules
  • Removing duplicate records from lists
Speaker(s)

David H. Ringstrom
CPA

David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant, educator, and speaker. He has presented more than 2,500 live webinars to professionals nationwide.

David is the author or co-author of ten books, including Microsoft 365 Excel For Dummies, Exploring Microsoft Excel’s Hidden Treasures, QuickBooks Online For Dummies, and Idiot’s Guide to Introductory Accounting.

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?

This session is ideal for Excel users who want to strengthen core spreadsheet skills and gain confidence managing data, worksheets, and printed reports.