Maximize Excel: Mastering Large Spreadsheets

CPE Credit: 2 hours
 
Don’t let large Excel workbooks push you around anymore! In this informative presentation, 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 Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples used in the course. 

.
Topics Covered

• Comparing the risks and benefits of 64-bit versus 32-bit Microsoft Excel.
• Restoring Full Screen View in Excel 2013 and later as well as enabling a keyboard shortcut for this feature.
• Navigating large workbooks with ease by way of a hidden menu as well as keyboard shortcuts.
• Learning how to use a single line of programming code to unhide all worksheets within a workbook.
• Understanding Excel’s Freeze Panes feature.
• Using the Group command to interactively hide/unhide columns (and/or rows) within Excel worksheets.
• Utilizing the Split Worksheet feature properly to lock certain rows at the bottom of the Excel window.
• Discovering resources for making unwieldly spreadsheets calculate faster.
• Exploring how the INDIRECT worksheet function can automate pulling values from a group of individual worksheets.
• Hiding multiple worksheets within a workbook at once.
• Navigating purposefully through worksheets by way of clickable hyperlinks.

 
Learning Objectives:

• State how the INDIRECT worksheet function simplifies creating summary worksheets.
• Demonstrate your knowledge of Excel’s Freeze Panes feature.
• State how to hide multiple worksheets within a workbook simultaneously.

Course Number: 
DR1912
NASBA Field of Study: 
Computer Software and Applications
Level: 
Intermediate
Presenter:
David Ringstrom
Prerequisites: 
Experience with Excel Spreadsheets
Advanced Preparation: 
None