Live Educational Webinar
Excel Efficiency - Minimizing Worksheet Errors
Price: FREE
Jan. 9, 2018 Tuesday
11:00 AM - 12:00 PM (Pacific)
1 Hour
Registration for this event is currently closed
shutterstock_532873330.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
In this session Excel expert David H. Ringstrom, CPA will present numerous techniques that he relies on to improve the integrity of spreadsheets that he builds for himself and others. The webinar covers design techniques, formulas that add resilience, using Conditional Formatting to identify unprotected worksheet cells, 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.

You learn how to:
  • Building resilience into spreadsheets by avoiding daisy-chained formulas.
  • Discovering techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheet.
  • Employing the SUMIF function to add up values related to multiple instances of criteria that you specify.
  • Learning a simple design technique that greatly improves the integrity of Excel’s SUM function.
  • Preserving key formulas using hide and protect features.
  • Protecting workbooks to prevent users from renaming, hiding, unhiding, or otherwise affecting worksheets.
  • Removing Conditional Formatting when it's no longer needed within a spreadsheet.
  • Summing disparate sections of a spreadsheet quickly with the SUBTOTAL function.
  • Toggling the Locked status of a worksheet cell on or off by way of a custom shortcut.
  • Using Conditional Formatting to identify unlocked cells into which data can be entered.
  • Using range names to streamline formulas and bookmark key inputs within a workbook.


You can preview this course on our site.

Learning Objectives

After attending this event you will be able to:
Recall how to access the Wrap Text command.
Identify the impact of deleting a column on other formulas that reference that column.
Demonstrate knowledge of how and when to use the Name Manager command.

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.