Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007Tickling Keys, Inc., 1 de out. de 2006 - 212 páginas 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. |
Outras edições - Ver todos
Termos e frases comuns
Adding Subtotals Analyzing w arrow AutoFilter Automating Bill Jelen blank cell button Cells(ThisRow choose Click OK column command contains custom number format Customer field Data field dataset Delete display drag dropdown Duplicate or Unique employees End Sub Evaluate fill handle follow these steps Formula Auditing gaps Go To Special green arrow Here’s the Situation Highlighting Outliers Home ribbon Icon Set IntelliSense ISBN Layout Looking up Data lookup table loop Matching Two Lists menu Microsoft Excel Microsoft Office Excel Milling Corporation Missing Dates mouse N/A error OK Cancel Page Fields Paste Special pivot table PivotTable Field List PivotTables Figure Press Product Quantity Revenue Region result right-click Row area row green Sears Canada Select a cell Shell Canada shown in Figure single cell Sorting Your Data Status Bar Sum of Revenue ThisRow toolbar tooltip Unique Values version of Excel Weekdays workbook worksheet zero
Passagens mais conhecidas
Página 6 - Number Alignment || Font | Border || Patterns || Protection Category: General Number Currency Accounting Date Time Percentage Fraction Scientific Text...