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. |
Conteúdo
5 | |
9 | |
15 | |
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 |
209 | |
Back Cover | 215 |
Outras edições - Ver todos
Termos e frases comuns
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
Passagens mais conhecidas
Página 6 - Number Alignment || Font | Border || Patterns || Protection Category: General Number Currency Accounting Date Time Percentage Fraction Scientific Text...