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

Fraud Audit Techniques Using Excel (Course Id 1024)

QAS / Registry   Add to Cart 
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 :
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:
  • Identify the uses of auto filter in fraud auditing
  • Recognize when auto filter and conditional formatting may be utilized to highlight exceptions
  • Associate VLOOKUP and IFERROR functions with a need to compare lists
  • Associate array formulas and certain text functions with a need to compare lists
  • Identify and eliminate duplicate items
  • Identify gaps in a sequence using Excel
  • Recognize the uses of Benford’s Law
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

Benford’s Law

Review Questions



Auditing Course 1024 Home: https://www.cpethink.com/fraud-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?