Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series)

by Bill Jelen

Product Description:

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.

Subjects: Audit, Computer Software Packages, Spreadsheet software, Auditing, Microcomputer Spreadsheet Software, Computers, Computers - Other Applications, Computer Books: General, Miscellaneous Software, Computers / Spreadsheets / IBM-Compatible, Business Software - General, Business, Computer programs, Data processing, Electronic spreadsheets,

Reviews:

Don't waste your money
Auditors: Unless you're a total beginner at Excel, don't waste your money or time on this book. Pick a better comprehensive book about Excel, such as Wiley's MS Office Excel 2003 or ANYTHING else - they will cover all those concepts and dozens more, without insulting your intelligence. The idea that this book is for auditors is laughable. More like for 5th graders. I'm almost returned it, but didn't want to waste the time packing it up.

Especially for Auditors Who Already Use Excel
The use of Excel for performing accounting tupe applications is well known and straight forward. In auditing, however, the straight addition type functions that work well in accounting are not adequate. In auditing you need to look at data in many different ways to try to find anomolies (or since Sarbanes-Oxley, fraud) in the financial statements.

This book is intended for Auditors (but I bet you knew that from the title) who have at least a working knowledge of Excel. It then builds on that knowledge to discuss more advanced topics such as Transpose, VLOOKUP, sorting by color, and there's a great deal of information on all the things you can do with Pivot Tables.

This is not a large book, only a bit over a hundred pages, but it's pages are filled with information that will be particularly useful. It has several points where it shows the advantages of using the newest Excel 2007.

Buy Now | Back to Top