Excel for Auditors

Audit Spreadsheets Using Excel 97 through Excel 2007

Bill Jelen, Dwayne K. Dowell

$64.95 $58.84

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Holy Macro! Books
08 January 2007

Management accounting & bookkeeping; Excel

Series: Excel for Professionals series

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.

By: Bill Jelen, Dwayne K. Dowell
Imprint: Holy Macro! Books
Country of Publication: United States
Dimensions: Height: 254mm, Width: 203mm, Spine: 11mm
Weight: 371g
ISBN: 9781932802160
ISBN 10: 1932802169
Series: Excel for Professionals series
Pages: 212
Publication Date: 08 January 2007
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

# Copying a Worksheet # Showing Numbers in Thousands # Quickly Seeing Sum or Average - Better in XL 2007! # Adding Subtotals # Quickly Filling a Series # Using a Fixed Value in Your Formula # Replacing a Thousand Formulas with One # Highlighting Outliers # Using Conditional Formatting in Excel 2007 - Better in XL 2007! # Finding Transactions from the Last Week # Using Icon Sets to Mark Values # Excel Secrets: Applying Icons to Only the Top 10% # Turning Your Data on Its Side with Transpose - Better in XL 2007! # Joining Text # Looking up Data # Dealing with #N/A for Missing Values # When You Know There Is a Match but Excel Cannot Find It # Retrieving Many Columns from the Lookup Range # Getting Good Records from Bad Data # Sorting Your Data - Better in XL 2007 - Sort by Color! # Dealing with Dates # Fiscal Responsibility (Fiscal Years NOT Ending on 12/31) # Analyzing Data with Pivot Tables # Analyzing Results by Date # Creating a Random Sample from a Dataset # Finding and Analyzing Records Using AutoFilter # Formula Auditing # Matching Two Lists # Finding Duplicates or Unique Values - Better in XL 2007! # Finding Missing Dates in Data # Automating Excel with VBA # Conclusion # Index

Dwayne K. Dowell has over 20 years of experience inaccounting for public and private industries, and is the founder of Dwayne K. Dowell, PSC, a CPA firm located in Louisville, Kentucky. He isa Certified Public Accountant, Certified Fraud Examiner, and Certified Internal Auditor, as well asa 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.