Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007

Front Cover
Tickling Keys, Inc., Oct 1, 2006 - Computers - 212 pages
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.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Showing Numbers in Thousands
5
Quickly Seeing Sum or Average
9
Adding Subtotals
15
Quickly Filling a Series
23
Using a Fixed Value in Your Formula
29
Replacing a Thousand Formulas with One
33
Highlighting Outliers
35
Turning Your Data on Its Side with Transpose
49
Analyzing Data with Pivot Tables
85
Analyzing Results by Date
121
Creating a Random Sample from a Dataset
129
Finding and Analyzing Records Using AutoFilter
131
Formula Auditing
135
Matching Two Lists
155
Finding Duplicates or Unique Values
165
Automating Excel with VBA
189

Joining Text
53
Looking up Data
57
Sorting Your Data
69
Dealing with Dates
81
Conclusion
207
Index
209
Back Cover
215
Copyright

Other editions - View all

Common terms and phrases

Popular passages

Page 6 - Number Alignment || Font | Border || Patterns || Protection Category: General Number Currency Accounting Date Time Percentage Fraction Scientific Text...

About the author (2006)

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

Bibliographic information