JN CPE Courses
Save Time  •   Save Money  •   Your Solution
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: Basic
CPE Credit: 2 Hrs-
Ÿ
1 Hr Specialized Knowledge & Application
Ÿ
1 Hr Auditing
Price without printed book: $34
Price with printed book: $49 plus s/h
Course expiration:  You have one year from date of purchase to complete the course.

Software Requirements: Text is based upon Excel 2007. There are no associated data files.

Course Description:Spreadsheets have become pervasive in most companies and have many uses. Those that are used in the financial reporting process are of most concern to the assessment of the effectiveness of internal controls over financial reporting mandated by Sarbanes-Oxley. This course discusses how to evaluate spreadsheets under the rules of Section 404 and Auditing Standard No. 5 as well as what specific compensating spreadsheet controls are supported by Excel 2007.

Learning Objectives
The objectives of this course are:
Ÿ
To be familiar with the purpose of the Sarbanes-Oxley Act and have an overall understanding of Section 404 of the Act as well as to  familiar with the Public Accounting Oversight Board and have an overall understanding of Auditing Standard No. 5
Ÿ
To understand how spreadsheets should be evaluated under the rules of Section 404 and Auditing Standard No. 5
Ÿ
To become familiar with the use of specific compensating spreadsheet controls supported by Microsoft Excel

Spreadsheet Controls Under SOX 404
2 Hrs. CPE Credit
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 #6002b Including Printed Book
                                         $49
                                   No extra charge for online exam
Course Registration:
Course #6002 ONLINE
 $34
Course #6002 Book ONLY
$15


Course #6002 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).
Quantity:
This course is included in our Mega CPE Special
Quantity:
Quantity:
Other Courses You Might Be Interested In

Quantity: