Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series) | 
 enlarge | Authors: Bill Jelen, Dwayne K. Dowell
Publisher: Holy Macro! Books
Category: Book
List Price: $24.95
Buy New: $14.88
You Save: $10.07 (40%)
New (22) Used (9) from $10.60
Rating:  2 reviews
Sales Rank: 644759
Media: Paperback
Pages: 212
Number Of Items: 1
Shipping Weight (lbs): 0.8
Dimensions (in): 9.1 x 7.4 x 0.6
ISBN: 1932802169
Dewey Decimal Number: 005.54
EAN: 9781932802160
ASIN: 1932802169
Publication Date: October 1, 2006
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Condition: New; Brand new.
| |
| Editorial Reviews:
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.
|
| Customer Reviews:
 Don't waste your money May 9, 2007
Whirly Girly
3 out of 3 found this review helpful
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 December 10, 2006
John Matlock (Winnemucca, NV)
5 out of 5 found this review helpful
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.
|
|
|
