JN CPE Courses
JN Productions CPE Courses - PO Box 293024 - Lewisville, TX 75029
Phone (800)479-5636 Fax (443)222-0698
JN Productions 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.learningmarket.org.
Delivery Method: Self-Study. Make your purchase through our secure shopping cart. Once your purchase is completed, you will receive download instructions by email.
Format: Online pdf text (Printed book available for addl. $15 plus s/h.)
Prerequisites: Familiarity with Excel
Level: Intermediate
Advance Prep: Should have familiarity with Excel formulas and functions
CPE Credit: 3 Hrs-
Prerequisites: Familiarity with Excel
Level: Intermediate
Advance Prep: Should have familiarity with Excel formulas and functions
CPE Credit: 3 Hrs-
|
|
1 Hr Specialized Knowledge & Application
|
|
|
2 Hrs Auditing
|
Price without printed book: $48
Price with printed book: $63 plus s/h
Course expiration: You have one year from date of purchase to complete the course.
Software Requirements: Excel 2007. This course provides step by step instruction and Excel practice exercises as well as answer files.
Price with printed book: $63 plus s/h
Course expiration: You have one year from date of purchase to complete the course.
Software Requirements: Excel 2007. This course provides step by step instruction and Excel practice exercises as well as answer files.
Course Description:Microsoft Excel provides some easy to use tools that can greatly enhance and expedite the fraud audit process. With all that 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.
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.
Learning Objectives
To improve your ability to sift through large volumes of data to determine the possibility of fraud.
To improve your ability to sift through large volumes of data to determine the possibility of fraud.
Other Excel courses by this author:
Excel Tools & Tips for CPAs
Spreadsheet Controls Under SOX 404
***Buy all three and get a 15% discount***
Excel Tools & Tips for CPAs
Spreadsheet Controls Under SOX 404
***Buy all three and get a 15% discount***
About the Authors
Patricia McCarthy has an extensive background in teaching and business. She has doing customized software training for more than 16 years and has had a variety of clients including the Indiana CPA Society. She has also been a contributor to the Journal of Accountancy. Patricia was a full-time Lecturer in Management Information Systems at Butler University’s School of Business for six years and she has also taught at other universities in Indiana. Prior to embarking on a career in software training, Patricia was in the financial analysis and treasury functions for several large corporations. Patricia holds a B.A. degree from the College of the Holy Cross and holds an M.B.A in finance from Babson College. She is also certified as a MOS expert in Excel.
Joseph P. Helstrom, CPA is the Chief Financial Officer for Carmel Financial Corporation, a sales finance company and is also a partner at CFO Resources, LLC a technology training company focusing on training and courseware for accountants. Joe has over 25 years of experience as a CPA in both public accounting and industry. After auditing SEC clients for a large, global public accounting firm, he has managed the internal audit function as well as the financial reporting and analysis function for a global consumer electronics manufacturer and has directed corporate tax and corporate treasury functions for an international manufacturer of automotive parts. He has extensive experience in using and integrating computer applications to enhance the speed and decision usefulness of accounting and financial analysis processes.
Course #6003b Including Printed Book
$63
$63
No extra charge for online exam
Course #6003 Book ONLY
$15
Course #6003 E-Book ONLY - PDF Download
$10
Order the book only:
-If you do not need CPE credit but are looking for excellent reference material.
-If you have already ordered the online course or the Mega CPE Special and now want to order the printed book. (No CPE credit is available if you have not ordered the complete course).
Order the book only:
-
This course is included in our Mega CPE Special