View Cart

             Course   Search

Login

Email Address

Password

Forgot Password? Click Here
 
Courses by Number of Hours   
Courses by Field of Study
Courses by Authors
QAS Courses - Only
EA Courses - Only
RTRP Courses - Only
Pilot Courses - FREE
FREE CPE Courses
Webinars
Subscriptions
Course and Site Instruction
 
 
 
Authors
Business Services
Boards and Associations
Not For Profit Organizations
 
 
 
CPA Continuing Education
CPE for CPAs
CPE Courses
CPE Ethics
CPE Online
CPE Requirements
Tax CPE
CPE Accounting
 
 
  Home > Course Details
 

Course Details - Go to Course Contents

   QAS   Registry
    
Title :

Spreadsheet Controls Under Sarbanes-Oxley Section 404

Author :

Joseph P Helstrom, CPA

Status :

Production

CPE Credits :

2.0

IRS Credits :

0

Price :

$19.95

Passing Score :

70%

Primary Subject-Field Of Study :

Auditing - Accounting and Auditing

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 and Excel 2010. This course has been written for 2007. Steps that differ in Excel 2010 have been noted in gray shadow boxes.

Usage Rank :

0

Release :

2013

Version :

1.0

Prerequisites :

Excel 2007/ Excel 2010 is needed.

Experience Level :

Overview

Additional Contents :

Complete, no additional material needed

Advance Preparation :

Should have familiarity with formulas and functions

Delivery Method :

Self-Study

Intended Participants :

Anyone needing Continuing Professional Education (CPE)

Approved Audience :

NASBA QAS - NASBA Registry -  - 

Revision Date :

04/09/2013

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.

Comments :

CPE, online, self-study, self study, CPA, CPAs, continuing professional education, continuing education, accounting, spreadsheets, sox, sarbanes oxley, internal controls

Learning Objectives :

Course Learning Objectives


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

Course Contents - Go to Details

Chapter 1 - Spreadsheet Controls under Sarbanes-Oxley Section 404

Sarbanes-Oxley

Public Company Accounting Oversight Board

Section 404

Auditing Standard No. 5

Specific Procedures Related to Spreadsheets   

            Passwords

            Data Validation

            Cell Protection

            Workbook Protection

            Documentation

            Formula Audit Features

            Inspect Document

Summary

 

Glossary

 

Back To Top

Cart is empty
Subtotal: $0.00

Cpethink.com will donate 1% of ALL purchases. See our donations.


Coupons and Specials

Payments secure through

Merchant Services by
iTransact Merchant Services


Save 10-25% or more on fees

Or we will assure you that you already have an exceptional rate

 

Hostgator 1 Cent Offer

 

Showcase Courses

IFRS in the U.S.A.: An Implementation Guide
California’s Regulatory Review for CPAs
Payment Processing Considerations to Comply with IRS and PCI-DSS Regulations & Policies (Video)
Texas Ethics: An Overview for CPAs (TSBoA Approved)
Spreadsheet Controls Under Sarbanes-Oxley Section 404
Fraud Audit Techniques Using Excel
The Ultimate Guide to Retirement Planning from a Tax Perspective
All Courses

 

 

 

Click to verify BBB accreditation and to see a BBB report. Trusted Commerce

CPE for Thursday, October 30th, 2014
Copyright© 2002-2014 Cpethink.com
Home | Privacy | Refunds | Login | System Requirements | FAQs | Contact Us | Facebook | Facebook | Blog

Cpethink.com
27854 Yule Circle Evergreen, Colorado 80439
Phone: ☎ (888) 273-0273

McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams