View Cart

             Course   Search


Email Address


Forgot Password? Click Here
Courses by Number of Hours   
Courses by Field of Study
QAS Courses
Ethics Courses
Tax Courses
Accounting/Audit Courses
Auditing Courses
Yellow Book Courses
EA Courses
Return Preparer
Video Courses
Pilot Courses - FREE
FREE CPE Courses
Course and Site Instruction
Business Services
Boards and Associations
Not For Profit Organizations
CPA Continuing Education
CPE for CPAs
CPE Courses
CPE Ethics
CPE Online
CPE Requirements
CPE Accounting
  Home > Course Details

Course Details - Go to Course Contents

   Updated ! ! !   QAS   Registry
Title :

Fraud Audit Techniques Using Excel.

Author :

Patricia McCarthy, MBA

Status :


CPE Credits :


IRS Credits :


Price :


Passing Score :


Primary Subject-Field Of Study :

Auditing - Accounting and Auditing

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 WEEKDAY and MOD.

Usage Rank :


Release :


Version :


Prerequisites :


Experience Level :


Additional Contents :

Complete, no additional material needed

Advance Preparation :

Should have familiarity with formulas and functions

Delivery Method :


Intended Participants :

Anyone needing Continuing Professional Education (CPE)

Approved Audience :

NASBA QAS - NASBA Registry -  - 

Revision Date :


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.

Comments :

CPE, online, self-study, self study, CPA, CPAs, continuing professional education, continuing education, accounting, accountants, business, commerce, fraud audit, investigations, auto filter, arrays, WEEKDAY, MOD, Benford Law

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 array formulas 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 - Go to Details

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


Chapter 2 - Links for Spreadsheets



Back To Top

Customer Reviews

Cart is empty
Subtotal: $0.00

Sponsor Ids

NASBA QAS Self-Study Sponsor Id 108299 NASBA Sponsor Ids
QAS - 053
Registry - 108299
QAS Self-Study -
IRS Approved Continuing Education Provider
IRS Provider Id: 1SXC8

Payments secure through


Merchant Services by
iTransact Merchant Services






Click to verify BBB accreditation and to see a BBB report. Trusted Commerce

CPE for Tuesday, January 17th, 2017
Copyright© 2002-2017
Home | Privacy | Refunds | Login | System Requirements | FAQs | Contact Us | Facebook | Facebook
27854 Yule Circle Evergreen, Colorado 80439
Phone: ☎ (888) 273-0273

McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams