Live Educational Webinar
Excel Efficiency: Taming Large Spreadsheets
Price: FREE
Feb. 6, 2018 Tuesday
12:00 PM - 01:00 PM (Pacific)
1 Hour
Registration for this event is currently closed
illumeo image.jpg

Free Live Webinar

  • Free CPE
  • Non-sponsored webinars mean you never listen to a 3rd party sales pitch – it’s all just great education
  • Expert-instructor-led learning with live Q&A
  • Based on a great course on Illumeo
David Ringstrom President and CPA, Accounting Advisors Inc
Excel expert David Ringstrom, CPA, coined the phrase, “Either you work Excel or it works you!” Large spreadsheets tend to subject spreadsheet users to extra work. In this practical presentation, David demonstrates several ways you can gracefully manage large spreadsheets. His goal is to help you save time, improve the integrity of your spreadsheets, and minimize repetitive tasks.

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.

You'll learn how to:
  • Choose between custom views within a workbook to hide or unhide multiple worksheets at once.
  • Create a custom view that will enable you to unhide all worksheets in a workbook at once.
  • Enable a hidden keyboard shortcut for toggling the Freeze Panes feature on or off.
  • Explore how the INDIRECT worksheet function can automate pulling values from a group of individual worksheets.
  • Hide multiple worksheets at once within a workbook.
  • Learn how to use a single line of programming code to unhide all worksheets within a workbook.
  • Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts.
  • Restore “classic” Print Preview functionality in Excel 2010 and later.
  • Restore Full Screen View in Excel 2013 and later, as well as enabling a keyboard shortcut for this feature.
  • Understand Excel's Freeze Panes feature
  • Use the SUM Function to drill through two or more worksheets.
  • Use the Watch Window to easily monitor the ramifications of even minor changes to your workbooks.


You can preview this course on our site.

Learning Objectives

After attending this event you will be able to:
Apply the Watch Window feature to monitor and navigate to key worksheet cells.
Identify how to use Custom Views can be used to hide and unhide multiple worksheets at once.
Implement the INDIRECT worksheet function to create simpler summary spreadsheets.

Speakers

David RingstromPresident and CPA, Accounting Advisors Inc
David Ringstrom
President and CPA, Accounting Advisors Inc
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.
Moderated by Jennifer RobbinsIllumeo Webinar Manager
Moderated by Jennifer Robbins
Illumeo Webinar Manager
Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 200 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.