Learning outcomes

Recall guidance for testing data for authenticity and reasonableness
Identify a guideline for using Excel to test data for the potential of Fraud using Benford's Law
Identify guidance for preparing a general ledger report for pivoting in Excel
Recall guidance in producing random numbers to be used in selecting data for statistical analysis and other data procedures

£35.00 (CIMA members only)

£45.00

VAT calculated on checkout

Product information

Overview

In this video, you will learn several ways to use Excel to help detect and prevent fraud, including working with random numbers, applying Benford’s Law, and cleaning general ledger data so it can be pivoted and analyzed in detail. The goal is to provide accounting and finance professionals with guidance for testing data for authenticity and reasonableness. Don’t miss this unique opportunity to learn more about Excel from this unique and interesting perspective.

Professional development

This Video offers 1 hours of CPE credit.
Note on CPE Requirements and Credits
All learning resources available in the CGMA Store qualify for CPD for CIMA members.

Programme level:	Intermediate
Duration:	1h 15m
Format:	Video
Access:	This is a digital product. You will have access to the content for a year after purchase date.

Return and refund policy

£35.00 (CIMA members only)

£45.00

VAT calculated on checkout

Speaker

J. Carlton Collins, CPA, ASA Research, Editor, Jekyll Island, GA
J. Carlton Collins, CPA is a Certified Public Accountant with experience in technology, tax, auditing, accounting systems, financial reporting, and bond financing. He is an author, lecturer, and technology & accounting systems consultant. He has published books, articles, and web pages and is the author of the monthly technology Q&A column for the Journal of Accountancy. As a public speaker, Mr. Collins has delivered more than 2,800 CPE lectures in 44 states and 5 countries addressing to CPAs and business professionals. As a consultant, Mr. Collins has assisted 275+ large and small companies with the selection and implementation of accounting systems.

As an auditor, Mr. Collins has audited businesses in the areas of health care, construction, distribution, automobile dealerships, insurance, manufacturing, and general business. Mr. Collins' tax experience includes preparation of more than 1,000 corporate, individual, partnership, fiduciary, and estate tax returns.

Mr. Collins is a member of the American Institute of CPAs since 1985, Chairperson of the AICPA’s national Technology Conference, and a member of the Georgia Society of CPAs since 1982."