Excel for Auditors

Overview

An auditor's guide to correcting errors and detecting fraud in Excel spreadsheets

Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed, as are the best practices for error and fraud prevention when developing spreadsheets. This reference is fully updated to reflect Excel 12.

Author Biography

Dwayne K. Dowell has over 20 years of experience in accounting for public and private industries, and is the founder of Dwayne K. Dowell, PSC, a CPA firm located in Louisville, Kentucky. He is a Certified Public Accountant, Certified Fraud Examiner, and Certified Internal Auditor, as well as a Certified QuickBooks Pro Advisor and Certified Intact Consultant. Bill Jelen is the principal of MrExcel.com and the author of Mr. Excel on Excel and Guerilla Data Analysis Using Microsoft Excel. He lives in Uniontown, Ohio.