Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series) |  | Authors: Bill Jelen, Dwayne K. Dowell
Publisher: Holy Macro! Books
Category: Book
List Price: $24.95
Buy New: $15.10
as of 7/29/2010 14:57 CDT details
You Save: $9.85 (39%)
New (19) Used (13) from $13.86
Seller: fantastic_shopping
Rating:  5 reviews
Sales Rank: 659467
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
| |
| Also Available In:
|
| Similar Items:
| |
| 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:
 Especially for Auditors Who Already Use Excel December 10, 2006
John Matlock (Winnemucca, NV)
4 out of 4 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.
useful and helpful book February 17, 2010
Silvia (Columbia, SC USA)
a useful reference tool for fast efficient use of excel. I had to get this book for a masters level accounting information technology class and I will definitely not be selling this textbook back after the semester is over.
Good Value - Great Tips March 29, 2010
Sanjay Agarwal (India)
Book has a simple, lucid style. Tips are good and useful. I knew some of them - there are many I did not know of. Almost all are useful - especially for auditors. That is the key to this book's value. While there may be thouands of Excel tricks - they are useless unless they are relevant and you understand them well enought to use them. The one about selecting a random sample was particularly useful.
 Don't waste your money May 8, 2007
Whirly Girly
6 out of 7 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.
Don't bother May 23, 2009
Paul K. Cooke (Detroit, MI)
2 out of 3 found this review helpful
This book offers nothing for the Auditor, this is a basic Excel highlight book, this book covers nothing new that isn't already in the self proclaimed "Mr Excel's" other books. I do not recommend this book to anyone above beginning Excel users.
|
|
|
