0
| Author : | Patricia McCarthy, MBA |
| Status : | Production |
| CPE Credits : | 3.0 |
| IRS Credits : | 0 |
| Price : | $26.95 |
| Passing Score : | 70% |
| NASBA Technical: | Yes |
| Primary Subject-Field Of Study: | Auditing - Auditing for Course Id 1024 |
| Description : | Microsoft Excel provides some easy to use tools that can greatly enhance and expedite the fraud audit process. With all detective work, you want to be able to sift through a large volume of data and utilize a tool that is adequately flexible for you to perform immediate investigations of anything questionable. Excel provides a number of different tools however we are going to focus on a couple of extremely useful ones: Auto filter, Arrays as well as a couple of extremely useful functions that include TEXT,WEEKDAY, IFERROR, IFNA MATCH and MOD. |
| Usage Rank : | 0 |
| Release : | 2017 |
| Version : | 1.0 |
| Prerequisites : | None. |
| Experience Level : | Overview |
| Additional Contents : | Complete, no additional material needed. |
| Additional Links : |
Using Excel to Detect Fraud J Carlton Collins
|
| Advance Preparation : | Should have familiarity with formulas and functions. |
| Delivery Method : | Self-Study |
| Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
| Revision Date : | 15-Jun-2017 |
| NASBA Course Declaration : | Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam. |
| Approved Audience : | NASBA QAS - NASBA Registry - 1024 |
| Keywords : | Auditing, Fraud, Audit, Techniques, Using, Excel, cpe, cpa, online course |
| Learning Objectives : |
Course Learning Objectives Upon completion of this course, you should be able to:
|
| Course Contents : | Chapter 1 - Fraud Audit Techniques Using Excel Getting Started With AutoFilter Searching for P.O. Boxes Text Filters Checking EIN Numbers Missing EIN or Telephone Number Review Questions Reviewing Items Below a Review Threshold Dates Rounding Using Arrays Comparing Lists Using Arrays TEXT FUNCTIONS Range Names Identifying Duplicates in a List Remove Duplicates Duplicates and Conditional Formatting Review Questions Gaps in Sequence Using If Statements Benford’s Law Review Questions Glossary |
Login/Register