a Sift Media publication
Sift Media logo

Creating Error Proof Spreadsheets

Thursday, October 1, 1:00 Eastern

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. 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.

See Full List of Webinar Offerings
Click Here to Purchase

Program Content

Level: basic
Delivery Method: Group Internet-Based
Field of Study: Specialized Knowledge and Applications
  • 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
In addition, the session includes a live question and answer period during which you can ask the instructor any questions you above Microsoft Excel, even if it's not related to this session.


Program Prerequisites

  • none

Advance Preparation

  • None, but we'll provide a copy of the handout for you to review prior to the session.

Recommended CPE Credits

  • one hour

Registration Instructions

Refund/Cancellation Policy

Please direct questions, complaints, cancellations, or refund requests to Rob Nance, Publisher, at AccountingWEB at publisher@accountingweb.com or 1.866.688.1678 ext. 16. We will do our best to ensure that every attendee is completely satisfied.

Complaint Resolution Policy

AccountingWEB, Inc. will address any and all complaints, after each event, with dissatisfied customers.


Accountingweb, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Web site: www.nasbatools.com.