Item description for Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series) by Bill Jelen, Dwayne K. Dowell, David Copperfield, Darrell Roberts, Kathryn O'dell, Hendrik Hinrichsen & Sylvia Yount...
Overview Provides information for auditors on using Microsoft Excel.
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.
Promise Angels is dedicated to bringing you great books at great prices. Whether you read for entertainment, to learn, or for literacy - you will find what you want at promiseangels.com!
Est. Packaging Dimensions: Length: 0.5" Width: 7.5" Height: 9.25" Weight: 0.84 lbs.
Release Date Oct 1, 2006
Publisher Holy Macro! Books
ISBN 1932802169 ISBN13 9781932802160
Availability 0 units.
More About Bill Jelen, Dwayne K. Dowell, David Copperfield, Darrell Roberts, Kathryn O'dell, Hendrik Hinrichsen & Sylvia Yount
Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,900 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 44 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel. com, Bill Jelen spent 12 years in the trenches--working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen. Tracy Syrstad is a Microsoft Excel developer and author of eight Excel books. She has been helping people with Microsoft Office issues since 1997, when she discovered free online forums where anyone could ask and answer questions. Tracy found out she enjoyed teaching others new skills, and when she began working as a developer, she was able to integrate the fun of teaching with one-on-one online desktop sharing sessions. Tracy lives on acreage in eastern South Dakota with her husband, one dog, two cats, one horse (two, hopefully soon), and a variety of wild foxes, squirrels, and rabbits.
Bill Jelen has published or released items in the following series...
Reviews - What do customers think about Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series)?
Don't waste your money May 9, 2007
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 Dec 10, 2006
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.