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.