Maximize Excel: Mastering Large Spreadsheets
Presented by David H. Ringstrom, CPA
 
Event Date/Time: 7/21/25 12:00 PM Eastern
Duration: 100 minutes
 
Don’t let large Excel workbooks push you around anymore! In this informative webcast, Excel expert David Ringstrom, CPA, explains techniques you can use to gain control over unwieldy spreadsheets. His helpful tips enable you to save time, avoid repetitive tasks, and improve the integrity of your large workbooks. Step-by-step, David demonstrates how to hide and unhide multiple worksheets, expand or collapse rows and/or columns, monitor changes made to your workbooks, and more.
 
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
 
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.
 
Who should attend:
Practitioners seeking to work more efficiently in large Excel workbooks as well as to improve the integrity of their spreadsheets.
 
Topics covered:
 
• Choosing between custom views within a workbook to hide/display multiple worksheets at once.
 
• Comparing the risks and benefits of 64-bit versus 32-bit Microsoft Excel.
 
• Creating a macro you can use in any workbook in order to display all sheets at once.
 
• Creating custom views that will enable you to display all worksheets in a workbook at once as well as hide/display selected worksheets.
 
• Exploring how the INDIRECT worksheet function can automate pulling values from a group of individual worksheets.
 
• Hiding multiple worksheets within a workbook at once.
 
• Making the same edits on multiple worksheets at once by grouping worksheets.
 
• Minimizing the file size of large workbooks by way of the Excel Binary Workbook format.
 
• Navigating large workbooks with ease by way of a hidden menu as well as keyboard shortcuts.
 
• Navigating purposefully through worksheets by way of clickable hyperlinks.
 
• Navigating through workbooks and identifying non-blank worksheet cells with the Navigation task pane in Microsoft 365.
 
• Restoring Full Screen View in Excel 2013 and later as well as enabling a keyboard shortcut for this feature.
 
Learning objectives:
• Define how to use the Watch Window feature to monitor and navigate to key worksheet cells.
• Apply the Custom Views feature to manage the hidden/visible status of columns, rows, worksheets, print settings, and more.
• State how the INDIRECT worksheet function simplifies creating summary worksheets.
 
 
Level:
Intermediate

 
NASBA Field of Study:
Computer Software & Applications (2 hours)
 
Program Prerequisites:
Experience with Excel Spreadsheets
 
Advance Preparation:
None