Overview
Large spreadsheets can quickly become difficult to navigate, slow to calculate, and challenging to manage—especially in 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.
Areas Covered
· Navigate large workbooks using keyboard shortcuts, advanced search tools, and productivity features.
· Freeze panes, split worksheets, and maximize screen space for easier data review.
· Manage multiple worksheets with Custom Views, sheet grouping, and bulk hide/unhide techniques.
· View and compare multiple worksheets simultaneously using New Window and Arrange Windows.
· Group rows, columns, and worksheets to simplify navigation and improve organization.
· Improve workbook performance by reducing file size and understanding the impact of volatile functions.
· Link and manage data across worksheets using functions such as INDIRECT and other cross-sheet referencing techniques.
· Apply best practices to keep large workbooks organized, accurate, and easy to maintain.
