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.
Course Publication Date: June 15, 2016
This course is available with NO ADDITIONAL FEE
if you have an active self study membership
or can be purchased for $20.00
|Author:||Mill Creek Publishing
|Delivery Method:||Self Study
|Level of Knowledge:||Overview
|Prerequisites:||Basic knowledge of Excel
|Recommended Field of Study:||Auditing
- 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.