Topics covered include: Switching between Custom Views by way of a hidden drop-down list you can enable on Excel's Quick Access Toolbar; Learning the power—and the risks—of grouping worksheets; Understanding the difference between manual and automatic calculation modes in Excel; Simplifying repetitive tasks by creating your own keyboard shortcuts; Using the Watch Window to easily monitor the ramifications of even minor changes to your workbooks; Seeing how to view two worksheets from within the same workbook at the same time; Saving time when aggregating data from multiple worksheets with Excel's INDIRECT function; Using the Group and Ungroup feature to expand or collapse rows and/or columns; Using Excel's OFFSET function to dynamically reference data from one or more accounting periods; Avoiding repetitive work by creating a keyboard shortcut for Excel's Freeze Panes feature; Using Excel's Custom Views feature to hide and unhide multiple worksheets with ease; Using Excel's Custom Views feature to apply different print settings, including orientation and margins, to a single worksheet. Upon completing this course, you should be able to: Recognize and apply the Watch Window feature to monitor and navigate key worksheet cells; Identify how to use Custom Views to manage the hidden or visible status of columns, rows, worksheets, print settings, and more; Implement the INDIRECT worksheet function to create simpler summary spreadsheets.