Loading...

Excel Explained: Managing Large Workbooks

This webinar will help you take control of complex, oversized Excel workbooks with practical navigation, organization, and performance techniques. Learn how to work faster, see more on screen, and reduce frustration when managing large volumes of data.
OnDemand

Beginner Friendly

DATE

Recorded Monday,
July 27, 2026

INSTRUCTOR

David Ringstrom

DURATION

2 Hours

FORMAT

Webinar

$299.00 or 1 Token

Includes: 30 Days OnDemand Playback, Presenter Materials and Handouts

  • Accounting/Reporting
  • Computer Skills
  • Management/Employee Development
  • Reporting
  • Technology/Security
  • Trainer

Save on annual training costs with our Webinar Subscription Service and share webinars across your entire organization.

Become a subscriber

Learn about upcoming events, webinars and discounts.

Sign Up For Email Notifications

Large spreadsheets can quickly become difficult to navigate, slow to calculate, and challenging to manage—especially in banking environments where workbooks often span multiple sheets and thousands of rows. This session focuses on tools and techniques that make large files easier to control, review, and maintain without sacrificing accuracy.

You’ll explore efficient navigation shortcuts, pane management tools, worksheet grouping, Custom Views, and strategies for managing multiple sheets at once. We’ll also cover file size reduction, calculation performance considerations, and functions like INDIRECT that connect data across worksheets—so you can confidently manage even the most demanding Excel workbooks.

What You'll Learn

  • Navigating large workbooks with keyboard shortcuts, search tools, and hidden menus
  • Viewing multiple worksheets simultaneously with New Window and Arrange Windows
  • Freezing panes, splitting worksheets, and maximizing screen space
  • Grouping rows, columns, and worksheets for simplified views
  • Managing multiple sheets with Custom Views and bulk hide/unhide options
  • Improving performance with file size reduction techniques and awareness of volatile functions

Who Should Attend

Banking professionals who manage large Excel workbooks for reporting, reconciliations, analysis, or operational tracking and want to improve efficiency and performance.
David Ringstrom

Instructor Bio

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.


 


 

Print this page