Login View Cart
Items In Cart: 0 Total: $0.00

Fraud Audit Techniques Using Excel  #293518



Course Details, Learning Objectives, Table of Contents

Credits
CPA 1.5

Scroll Down to Register
Course Description

This course was updated on 5/24/2018.

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

To overcome an inability to segregate duties as well as other issues, small businesses must look for mitigating controls. The most pervasive mitigating control is the direct oversight of management. This oversight may take the form of financial statement review, approving disbursements, signing checks as well as other review processes. While there are other considerations as to whether the oversight of management may mitigate a lack of segregation of duties and other internal control challenges, if done correctly, this is one of the best ways to overcome these inherent issues.

There are internal control fundamentals that are appropriate for small businesses. This course discusses fundamental operational and accounting controls and also reviews the optimal company culture for an effective internal control environment.

Course, Credit, Sponsor Information  
Open link (above): Course Details, Table of Contents, and Learning Objectives.
Subject Codes/Fields of Study: Auditing

Course Format Options
If you purchase the "Online Book and Online Exam" option of a course, you get anytime access to the course (in PDF) and the online exam. Both can be printed.
If you purchase the "Hardcopy Book and Online Exam" option, you get online access to the course-PDF and exam, PLUS printed copies of both, sent via USPS or UPS.

Taking the Exam Online
Online exam is included in price and is accessed through your account.
The exam may be started, stopped, then resumed at a later date.
The exam is "open book," it is not timed, and it may be retaken if not passed (no charge).
Results (correct, incorrect answers), and certificate appear once you pass the exam.

How To Register Online
1. Enter Quantity 
2. Select Purchase Option
3. Click Add to Cart
4. Click Begin Secure Checkout or Continue Shopping
5. If prompted, login (or Create an Account).
6. Return to "My Account" to view your course and online exam.

Discounts and shipping/handling, if applicable, are added during checkout
Hardcopy courses may also be purchased by phone: 800-588-7039 (Bus./EST)

Online Book, Online Exam Price   $29.00
Hardcopy Book (mailed), Online Exam Price   $39.00

Quantity 
Purchase Option: 
 
Add to Cart
  Go Back

Have a Question?
Call 800-588-7039
 


We accept all major credit cards


CFP , CFP®, CERTIFIED FINANCIAL PLANNER® are certification marks owned by the Certified Financial Planner Board of Standards, Inc. These marks are awarded to individuals who successfully complete CFP® Board's initial and ongoing certification requirements.
CPE Beacon Hill Financial Educators, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org
IRS Approved Education Provider Copyright © 2001 - 2015 Beacon Hill Financial Educators Inc. All Rights Reserved.
51A Middle Street, Newburyport, MA 01950
Phone - (toll free): 800.588.7039 - Fax: 877.902.4284
contact@bhfe.com