Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Fraud Audit Techniques Using Excel (FAMC)

Choose CPE Format:

Live WebinarSELECT

There are currently no upcoming dates scheduled for this webinar. Please fill out this short form to be notified when this webinar is next available. 

FIRST NAME
LAST NAME
EMAIL ADDRESS
COMMENTS (OPTIONAL)
Self-Study (On Demand) SELECT

This course is not currently available. Please fill out this short form to be notified when self-study options are available.

FIRST NAME
LAST NAME
EMAIL ADDRESS
COMMENTS (OPTIONAL)
This new course has not yet been reviewed. Check back soon!

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

Fraud Audit Techniques Using Excel (FAMC)

  • Customer Rating
    Not Yet Rated
  • Field of Study
    Computer Software & Applications
  • Level
    Intermediate
  • Credits
    2
  • Qualifies for

    CPE

Overview

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. This course provides step by step instruction and Excel practice exercises as well as answer files.

Major Topics:

  • Getting Started with Auto
  • Filter
  • Searching for P.O. Boxes
  • Text Filters
  • Checking EIN Numbers
  • Missing EIN or Telephone Number
  • Reviewing Items Below a Review Threshold
  • Comparing Lists Using Arrays
  • Text functions 
  • Benford's Law

Learning Objectives

  • 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

Designed for:

All CPAs

Prerequisite:

Knowledge of how to use basic formulas and functions

Advanced Preparation:

None

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.
loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

Thank You!

Thank You! Your request has been submitted.



Get More with a Surgent CPE package

Unlimited Self-Study Package

  • Unlimited 24/7 access to 200+ downloadable self-study courses

  • Courses range from 2-20 credits

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses

$499

Buy Now

Unlimited Webinar Package

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1-, 2-, 3-, 4-, and 8-hour webinars, including Saturday and evening options

  • Access through December 31st of the year in which you purchase

  • Does NOT include Premium courses

$699

Buy Now

 

Unlimited Plus Package

  • Unlimited access to ALL live CPE webinars

  • Includes all premium courses and virtual conferences

  • Unlimited 24/7 access to all self-study courses

  • Includes all on-demand webcasts

  • Access for a year from purchase date

$799

Buy Now

Explore Additional Courses by Topic

  • CPE Continuing Professional Education for CPAs

  • IRS Continuing Education for EAs and the AFSP program

  • CFP Accepted by the CFP® Board

  • YB YellowBook Continuing Education

  • CTEC Approved for CE by CTEC

QAS Approval Surgent IRS Approval Surgent CFP Approval Surgent CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.