Author : | Patricia McCarthy, MBA |
Status : | Production |
CPE Credits : | 3.0 |
IRS Credits : | 0 |
Price : | $26.95 |
Passing Score : | 70% |
Course Type: | NASBA QAS - Text - Technical - NASBA Registry |
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 & forensic 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 techniques, 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-Dec-2019 |
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 - Text - Technical - 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 |