Use Landscape to see Search/Filter
Item Types:
Field of Study:
CPE Hours:
Course Details

Fraud Audit Techniques Using Excel - v11 (Course Id 1869)

QAS / Registry
  Add to Cart 
Author : Joseph P Helstrom, CPA
Course Length : Pages: 25 ||| Review Questions: 11 ||| Final Exam Questions: 10
CPE Credits : 2.0
IRS Credits : 0
Price : $17.95
Passing Score : 70%
Course Type: NASBA QAS - Text - NASBA Registry
Primary Subject-Field Of Study:

Computer Software & Applications - Computer Software & Applications for Course Id 1869

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().
Another tool used in fraud audits that does not necessarily require Excel, but can be used in conjunction with Excel, is Benford’s Law.  Benford’s law is based on an observation that in certain large data sets, certain digits appear more frequently than others.  By comparing the distribution of first digits in some accounting data, this tool can assist you in determining where more investigation is necessary by helping to pinpoint where data may have been contrived through fraud.
There is an accompanying Excel file so that you can walk through all the exercises. Answer sheets immediately follow.

2 Hours. 1 Hr Audit/1 Hr Computer Science 

Usage Rank : 0
Release : 2021
Version : 1.0
Prerequisites : None.
Experience Level : Overview
Additional Contents : Complete, no additional material needed.
Additional Links :
Advance Preparation : None.
Delivery Method : QAS Self Study
Intended Participants : Anyone needing Continuing Professional Education (CPE).
Revision Date : 31-Jul-2021
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 - NASBA Registry - 1869

Keywords : Computer Software & Applications, Fraud, Audit, Techniques, Using, Excel, v11, cpe, cpa, online course
Learning Objectives :

Course Learning Objectives

Upon completion of this course, you should be able to:
  • Recognize and identify when Auto Filter and conditional formatting may be utilized to highlight exceptions
  • Recognize how to use VLOOKUP and IFERROR/IFNA functions when comparing lists
  • Recognize different array formulas, lookup functions as well as a few other functions that are useful for comparing lists and displaying data
  • Identify and eliminate duplicate items
  • Identify gaps in a sequence using Excel
  • Recognize Benfords Law and how it to use it
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



Using Arrays

Comparing Lists Using Arrays


Range Names

Identifying Duplicates in a List

Remove Duplicates

Duplicates and Conditional Formatting

Review Questions

Gaps in Sequence Using If Statements

Benfords Law

Review Questions

Link for Spreadsheet


CPE Computer Software & Applications Course: https://www.cpethink.com/excel-cpa-courses
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
Exam completed on .

Do you want to add the course again?