January 24, 2008
Using Excel’s Internal Audit Features to Prevent Spreadsheet Errors..
Joel Vander Weele wrote this in the early evening:
http://www.aicpa.org/pubs/jofa/feb2004/simkin.htm
An interesting article from Professor Simkin on using various Excel functions to prevent errors…Much of the top half of the article is pretty standard stuff (use of hash/control totals, limit tests, check calculations of key totals) but there is some neat stuff about using charts to find outlying data values, the use of signature forms (this should be standard procedure!) and especially the “Data Validation”, “Audit Formulas” and “Trace Precedents” features of Excel.
Filed under: Uncategorized
Leave a Reply
You must be logged in to post a comment.
