Excel for Auditors

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)

Bill Jelenis the host of MrExcel.com and the author of 18 books on Microsoft Excel, including "Special Edition Using Excel 2007," "Pivot Table Data Crunching," "VBA & Macros for Microsoft Excel," "Excel for Marketing Managers," and "Guerilla Data Analysis Using Microsoft Excel," He has made more than 60 guest appearances on "TechTV"with Leo Laporte and was voted guest of the year on the "Computer America"radio show. He has produced more than 600 episodes of his daily video podcast "Learn Excel from MrExcel." Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent 12 years in the trenches as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company has automated Excel reports for hundreds of clients around the world. The website answers more than 30,000 questions a year--for free--for readers all over the world. Jelen joins us from Akron, Ohio.

Bibliographic information