Producing Error-Free Excel Spreadsheets

Duration: 90 Minutes
In this beneficial webinar, Excel expert David H. Ringstrom, CPA, presents numerous techniques he relies on to improve the integrity of the Excel spreadsheets he builds for himself and others. David outlines simple ways to avoid introducing errors into your workbooks, thereby saving you valuable time while working in Excel. David teaches from Excel 2010, but provides guidance specific to Excel 2007, 2013, and 2016 as well. Coverage of Excel 2003 is available upon request.
Instructor: David H. Ringstrom
Product ID: 501130
Objectives of the Presentation
  • Understand how range names can minimize errors, save time in Excel, serve as navigation aids, and store information in hidden locations
  • Implement design techniques that minimize errors
  • Reduce errors by arranging worksheets or workbooks side by side while building formulas
  • Master lookup functions, which can lower the risk of referring to an incorrect cell
  • Learn ways to restrict others from working in a spreadsheet, including using the Very Hidden property to protect sensitive worksheets
  • Toggle a single worksheet between a detailed view and a summary view using the Custom Views feature (versus creating separate summary and detail worksheets)
  • Discover techniques that automatically provide fallback positions in order to view previous versions of a spreadsheet
Why Should you Attend
Learn to reduce errors in your Excel spreadsheets.

Areas Covered
  • Benefits of creating range names
  • Design techniques that reduce errors
  • Worksheet and workbook arrangements that minimize errors
  • Lookup functions that lower the risk of referring to an incorrect cell
  • Worksheet protection
  • Custom Views feature
  • Techniques that automatically provide fallback positions
Who can Benefit
  • Accountants and CPAs
  • CFOs
  • Financial consultants
$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
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 and presents dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. He has served as the technical editor for other 30 books on accounting software, and is the Tech Editor-at-Large for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
View More