Author : | Joseph P Helstrom, CPA |
Course Length : | Pages: 25 ||| Review Questions: 11 ||| Final Exam Questions: 10 |
CPE Credits : | 2.0 |
IRS Credits : | 0 |
Price : | $17.95 |
Passing Score : | 70% |
Course Type: | NASBA QAS - Text - NASBA Registry |
Technical Designation: | NonTechnical |
Primary Subject-Field Of Study: | Computer Software & Applications - Computer Software & Applications for Course Id 1869 |
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 TEXT(),WEEKDAY(), IFERROR(), IFNA(), MATCH() and MOD(). 2 Hours. 1 Hr Audit/1 Hr Computer Science |
Usage Rank : | 29286 |
Release : | 2021 |
Version : | 1.0 |
Prerequisites : | None. |
Experience Level : | Overview |
Additional Contents : | Complete, no additional material needed. |
Additional Links : |
Detecting Financial Statement Fraud
|
Advance Preparation : | None. |
Delivery Method : | QAS Self Study |
Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
Revision Date : | 01-Mar-2024 |
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. |
Approved Audience : | NASBA QAS - Text - NASBA Registry - 1869 |
Keywords : | Computer Software & Applications, Fraud, Audit, Techniques, Using, Excel, v11, cpe, cpa, online course |
Learning Objectives : |
Course Learning Objectives Upon completion of this course, you should be able to:
|
Course Contents : | 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 Dates Rounding Using Arrays Comparing Lists Using Arrays TEXT FUNCTIONS 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 Link for Spreadsheet Glossary |