Excel for Auditors

 

By Bill Jelen and Dwayne K. Dowell

 

 
Web AuditNet

One of the first business applications developed for the personal computer was the spreadsheet. These applications were commonly used by auditors in the mid-1980's replacing columnar pads. They have been standard tools for auditors since the early days of personal computers. Microsoft Excel has become the standard spreadsheet application used by most audit professionals. While the software has many advanced features, few auditors take the time to learn its capabilities. The authors are Excel experts and share with you tips and techniques that make this popular software a powerhouse tools for analyzing data. The book covers such topics as finding duplicates, stratification, random sampling, finding fraud, auditing formulas and more. If you are like most auditors I know that use Excel regularly, you will find more than one tip to enhance your spreadsheet skills in this book.