Transcription of Excel 2013 for Intermediate Users - ASA Research
{{id}} {{{paragraph}}}
Excel 2013 for Intermediate Users A S A R e s e a r c h J. Carlton Collins, CPA ASA Research - Atlanta, Georgia Excel 2013 for Intermediate Users Page 2 Copyright May 2013 Table of Contents 1. Random Numbers Attendees will learn how to generate random numbers to be used for statistical sampling purposes.. 5 2. Consolidating Data Attendees will learn how to consolidate data (such as budgets, financial reports, departmental reports, inventory lists, salesperson reports, location reports, etc.) using four different techniques as follows: Formulas, spearing formulas, consolidation tools, pivot tools.. 9 3. Benford s Law Benford s Law predicts the occurrence of digits in large sets of data and these predictions might help red-flag potential irregularities.. 23 4. Using Regression to Create & Using Budgets to Detect and Prevent Fraud An accurate budget should be the CPAs first line of defense for detecting and preventing fraud.
Excel 2013 for Intermediate Users ASA Research J. Carlton Collins, CPA ASA Research - Atlanta, Georgia 770.842.5902 Carlton@ASAResearch.com
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}