Taming Large Excel Spreadsheets (Completed)

Date: Friday, May 18, 2018
Instructor: David H. Ringstrom
Begin Time:  12:00pm Pacific Time
1:00pm Mountain Time
2:00pm Central Time
3:00pm Eastern Time
CPE Credit:  2 hours for CPAs

Excel expert David Ringstrom, CPA, coined the phrase, “Either you work Excel or it works you!” When it comes to large spreadsheets, users often feel stressed in myriad ways. In this beneficial presentation, David demonstrates a number of ways you can manage large spreadsheets with aplomb. His helpful tips enable you to save time, improve the integrity of large workbooks, avoid repetitive tasks, and much 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 he uses during the webcast.

Who Should Attend
Practitioners seeking to improve the efficiency and integrity of their large Excel spreadsheets.

Topics Covered

  • 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

Learning Objectives

  • 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

Level
Intermediate

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
Basic experience with large Excel spreadsheets.

Advance Preparation
None

 Chat — Books Support