reader
Using Excel as an Audit Tool
The purpose of EZ-R Excel is to simplify and facilitate the analysis and audit of data contained in Excel spreadsheets (or loaded into Excel spreadsheets) by providing an intuitive, easy to use menu system of all the commonly needed analytical and au...
Feed & Web Facts
10
Feed Item Count
22 May 12 01:54
Last Reading
2.0
RSS/XML Version
Windows-1252
Feed Encoding
Related Feeds
You could also like to visit these feeds:
—
Page-Views
—
Weekly People
Week Using Excel as an Audit Tool
Newest Posts in Feed
Tutorial example - web analytics software
A brief tutorial on the use of web analytics software to classify data and to identify dates falling on federal holidays. Because the software is run from the web, there is no need to install or maintain the software. Also, this software is available for free use. The general approach is to analyze data contained in Excel sheets by selecting and copying the data, and then "pasting" it into the web...
Simple, efficient method to classify data in Excel and identify duplicates
Two common audit procedures are to classify data by their frequency of occurrence and to determine if there are any duplicate items. Often, this data may reside within an Excel spreadsheet. Both procedures can be done manually within Excel - for example by first sorting the data, doing subtotals, etc. However, this procedure can be both time consuming as well as error prone.
Here I discuss how th...
A simple, yet effective, test using Benford's Law
This example explains how to perform a simple, yet effective, test to determine if a data range in Excel conforms with that expected under Benford's law. The example data used is that provided in the 26th annual report to Congress (link provided). This is an audit test that should take no more than a few minutes, yet provides a good test of fit for the numbers in the range, and potentially an easy...
