Excel for Auditors
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.
Analyzing Data with Pivot Tables
Analyzing Results by Date
Creating a Random Sample from a Dataset
Finding and Analyzing Records Using AutoFilter
Matching Two Lists
Finding Duplicates or Unique Values
Automating Excel with VBA
Adding Subtotals Analyzing by Date Analyzing w argument arrow AutoFilter Automating Bill Jelen blank cell Cells(ThisRow choose Click OK column command contains custom list custom number format Customer field data bars Data field Data ribbon dataset display dollar signs drag dropdown Duplicate or Unique employees End key End Sub Evaluate fill handle FinalRow follow these steps Formula Auditing gaps green arrow Here’s the Situation Highlighting Outliers Home ribbon icon set IntelliSense ISBN Looking up Data lookup table loop MATCH function Matching Two Lists menu Microsoft Excel mouse N/A error Nortel Options dialog Paste Special pivot table PivotTable Field List PivotTables Figure Press Region result revenue right-click row green Select a cell Shell Canada shown in Figure single cell Sort dialog Sorting Your Data Special dialog spreadsheet Status Bar ThisRow toolbar tooltip Type Unique Values version of Excel Visual Basic Weekdays workbook worksheet zero