Creating Error-Proof Spreadsheets (Currently Unavailable)

Author: David H. Ringstrom

David H. Ringstrom, CPA presents numerous techniques that he relies on to improve the integrity of spreadsheets that he builds for himself and others.

This session will empower you to track down errors in spreadsheets that you encounter, as well as learn simple ways to avoid introducing errors into your own workbooks.

Publication Date: June 2014

Designed For
Practitioners who may benefit from working more efficiently in Excel.

Topics Covered

• Learn design techniques that minimize errors.
• Build formulas faster and more accurately by using range names, which also makes auditing easier
• Avoid unintended consequences by using Excel's Formula Auditing tools
• Learn the keystroke that can reveal inconsistent formulas or hard-coded amounts
• Make your charts and pivot tables expand or contract automatically by using dynamic range names
• Minimize errors by arranging worksheets or workbooks side by side while you build formulas.
• Learn how to incorporate check figures and alarms into your work.
• Master look-up functions, which can lower the risk of referring to an incorrect cell
• Learn how to restrict how others use your spreadsheet
• Discover Excel features that eliminate tedious tasks

Learning Objectives

• Recognize and improve the integrity of your spreadsheets.

Level
Basic

Instructional Method
Self-Study

NASBA Field of Study
Specialized Knowledge and Applications (2 hours)

Program Prerequisites
None

Advance Preparation
None