1 Day Spreadsheet Auditing Training Course  

1 Day Spreadsheet Auditing Training Course 1 day Windows

    Platform: Windows
(No download - this is a Buy-Only product)   Buy Now   
  $ 930.00  
For course dates and an enquiry form, see the Course description page

? Are spreadsheets in the scope of your Sarbanes-Oxley project?
? Is your job to assess or prevent spreadsheet inaccuracy, error or even fraud?
? Discover the really essential indicators to look for
? Learn good practice to prevent errors and improve quality

Most spreadsheets contain errors, as is clear from the research reported at the European Spreadsheet Risk Interest Group conferences every year. See  their list of 72 reported incidents of expensive and embarrassing mistakes.

In the current climate of Sarbanes-Oxley compliance, where auditors must report on the integrity of controls over financial reporting, an organization's reliance on spreadsheets needs to be supported by good internal controls.

The intended audience is anyone who builds or reviews spreadsheet models, such as managers, accountants, actuaries, financial modelers, or IT analysts  in enterprise SOX IT audits. You need to have an intermediate or advanced knowledge of Excel. You should leave the seminar with the confidence to use the tools and methods shown to risk-assess and test spreadsheets in your organisation.

? Where to start and what are the most efficient techniques to use
? How you can cut down a huge system of spreadsheets to a manageable audit task
? The symptoms that indicate potential or actual problems
? How a company can create an inventory of its critical spreadsheets, assess them for risk, and prioritize scarce resources
? How the top spreadsheet auditing software tools compare, including little-used secrets of Excel's auditing features
? Includes a copy of "Spreadsheet Check and Control", Patrick O'Beirne's new book of 47 professional checking techniques
? Reinforce your learning with an optional two hours of hands-on practice using your preferred auditing tool on your laptop
? Demonstration versions of auditing software made available on request

In order to provide optimum benefit to attendees, there is a limited number of places.
Each participant will receive free helpdesk support for 30 days after the class.

Course Content

08:30 Registration

09:00 Controls over spreadsheets;
 - regulatory overview & background to spreadsheet risks;
 - review of spreadsheet usage, criticality, controls gap;
 - management of the spreadsheet lifecycle;
 - audit methodology, inventory, complexity & risk assessment

10:00 Spreadsheet inspection;
 - prioritisation of effort;
 - getting to grips with an unfamiliar model, mapping techniques, finding links, asking questions
 - types of error and concealment

10:45 Break

11:00 Know what you're looking for;
 - specific error-prone functions and operations;
 - structural testing, common defects, bad smells, pattern inconsistencies

11:45 Exercise in execution testing, test cases

12:30 Lunch

13:45 Appropriate techniques to detect and control different types of errors;
 - comparing native Excel features with third-party utilities and auditing software;
 - detecting concealment as well as mistakes and omissions;
 - detecting suspicious or fraudulent activity (eg Benford's Law)
 - spreadsheet comparisons

14:45 Break

15:00 Good design principles to prevent errors;
 - specification, documentation, styles, building, options, validation, data integrity;
 - developer and user training for best practice standards

16:00 Start of hands-on practice with participants' own laptops
 
? we provide example spreadsheets seeded with errors and concealed data

17:00 Close of day

Conditions

Bookings are not confirmed until full payment has been received. You may pay by credit card or bank transfer.
We show you how to audit your spreadsheets in accordance with good practice. While every effort is made to help you we cannot guarantee the completeness or accuracy of your work ? that is entirely your responsibility.
Delegates agree to accept any license conditions imposed by the suppliers of the audit software used.

Refund Policy: We refund your fee in full if you cancel at least six weeks before the course. After that, a 50% handling charge will be made. You may of course substitute another delegate at any time. If we cancel the workshop, all fees received will be immediately refunded in full. We are not liable for any other costs you may incur in relation to this course.

More information and enquiry form: Course description page
Publisher: Systems Modelling Ltd | More by Systems Modelling Ltd | Visit Home Page
Downloads: so far this month, 0 last month, 197 total
License: Shareware $ 930.00
Last updated: More than a year ago ( 2 Oct 09)
Install support: No Install Support
Watch for updates:
Want to be notified when 1 Day Spreadsheet Auditing Training Course is updated?
(no spam, just a single confirmation email)
Subscribe

Tell a friend... | What's on My CD
User Rating: NOT RATED
Rated by: 0 user(s)
3 out of 5 stars
User 0/5 stars User 0/5 stars User 0/5 stars User 0/5 stars User 0/5 stars  
Ask a question about 1 Day Spreadsheet Auditing Training Course

Add this link to your website:

Or to a forum:


ExcelPipe Lite (+1 Yr Maintenance) - Automatically Find and Replace across Thousands of Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate... ...

New

MITCalc Straight beams calculation

The application is designed for calculations of straight, maximum three times static indefinite beams with constant axis-symmetrical profiles. Application is developed in MS Excel, is...
Shareware | $ 14.87

MITCalc Force shaft connection

The calculation is intended for geometrical design and strength check of force couplings of shafts with hubs with a cylindrical contact area (Interference fit, clamping connection). The...
Shareware | $ 20.18

HXTT Excel

Pure Java Type 4 MS Excel JDBC(1.2, 2.0, 3.0, 4.0, 4.1,4.2) driver packages for Microsoft Excel XLS (XLSX) version from 95, 97, 98, 2000, 2001, XP, 2002, 2003, 2004, 2007, 2010, to 2013,...
Shareware | Buy Now

Investment and Business Valuation

The Excel Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business plan scenarios. Business valuation is based on the...
Shareware | US$ 26.00 US$ 20.80 with 20% discount coupon

XLTools Popup Calendar Add-in for Excel

It is a must-have date and time picker for Excel. Insert date only, time only, or date with time into cells and ranges in one click! The calendar drops down next to a cell, displays week...
Shareware | $ 14.95

Editor's Picks

MITCalc Straight beams calculation

The application is designed for calculations of straight, maximum three times static indefinite beams with constant axis-symmetrical profiles. Application is developed in MS Excel, is...
Shareware | $ 14.87

ExcelPipe Lite (+1 Yr Maintenance)

Search and Replace multiple Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate...
Shareware | US$ 99.00 US$ 94.05 with 5% discount coupon

Similar Data Finder for Excel (Single user license)

Similar Data Finder for Excel will help you to find cells with similar values in Microsoft Excel worksheets. The program enables you to: Quickly find mistakes made while entering cell...
Shareware | $ 39.00

Compare Spreadsheets for Excel (Single user license)

Compare Spreadsheets for Excel is a powerful and convenient tool for comparison of files in Microsoft Excel. Program features: Work with files, tables or the selected range of cells....
Shareware | $ 59.00

Excel Password Recovery (for personal use)

Excel Password Recovery is a program to recover lost or forgotten passwords to the Microsoft Excel documents protected with password for open. The program supports the "brute-force"...
Shareware | $ 29.95

Popular

TA-Lib Pro Excel

Multi-Platform Tools for Market Analysis TA-Lib is widely used by trading software developers requiring to perform technical analysis of financial market data. Includes 200...
Shareware | $ 149.00

XLTools PRO Add-In for Excel

XLTools is a toolkit of useful Excel add-ins that makes execution of complex operations easier and increases performance!
Shareware | $ 57.44

Oxygen Phone Manager II for Symbian OS phones

Oxygen Phone Manager II for Symbian OS smartphones lets your PC and mobile Symbian OS phone communicate with each other. The program allows you to work with Phonebook, Calendar, To-Do List,...
Demo | $ 46.00

AbleBits.com Add-ins Collection for Microsoft Excel

The Add-ins Collection for Microsoft Excel includes 12 add-ins that were specially designed to deal with the most tedious, painstaking and error-prone tasks in Excel that consume a lion's...
Shareware | $ 119.80

Reviews

Coupons and Discounts

Merge Excel Files Pro

Merge Excel Files Pro can help you merge multiple excel files. with this powerful software, you can merge many worksheets to just one new worksheet. You can merge multiple worksheets to one...
Shareware | US$ 49.95 US$ 39.96 with 20% discount coupon

Investment and Business Valuation

The Excel Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business plan scenarios. Business valuation is based on the...
Shareware | US$ 26.00 US$ 20.80 with 20% discount coupon

Portfolio Tracking & Monitoring

The Excel Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investment assets. Investment asset categories can be...
Shareware | US$ 22.00 US$ 17.60 with 20% discount coupon

ExcelPipe Lite (+1 Yr Maintenance)

Search and Replace multiple Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate...
Shareware | US$ 99.00 US$ 94.05 with 5% discount coupon

Free

No Results

Cheap - Less than $10

Dropbox Connector Excel

With the Dropbox Connector for Excel has the following options in Excel: Open Dropbox file Save workbook directly in Dropbox Browse Dropbox to Excel files Access the Dropbox website The...
Shareware | $ 1.50

Heat Transfer Calculator

Using heat and mass transfer equations taught at the university level, this excel macro calculates temperatures across a plane. It can be used as a stand-alone calculator or a module for...
Shareware | $ 1.00

Duplicate Preventer

Duplicate Preventer is a Microsoft Excel add-in that helps to prevent entering duplicate data while working in Excel. Duplicate Preventer integrates into MS Excel by placing its toolbar into...
Shareware | $ 9.95

Calendario

This little excel sheet helps you generating calendar sheets for your Fileofax, Brepols or Succes agenda with just a few clicks. You can add national holidays as well as personal reminders...
Shareware | $ 9.95

Price $10-$25

MITCalc Straight beams calculation

The application is designed for calculations of straight, maximum three times static indefinite beams with constant axis-symmetrical profiles. Application is developed in MS Excel, is...
Shareware | $ 14.87

MITCalc Force shaft connection

The calculation is intended for geometrical design and strength check of force couplings of shafts with hubs with a cylindrical contact area (Interference fit, clamping connection). The...
Shareware | $ 20.18

XLTools Popup Calendar Add-in for Excel

It is a must-have date and time picker for Excel. Insert date only, time only, or date with time into cells and ranges in one click! The calendar drops down next to a cell, displays week...
Shareware | $ 14.95

Ablebits.com Workbook Manager for Microsoft Excel

The Workook Manager for Microsoft Excel can become your irreplaceable assistant in managing Microsoft Excel worksheets. See all opened workbooks & worksheet
Shareware | $ 19.95

Ablebits.com Split Table Wizard for Microsoft Excel

Split Table Wizard instantly splits an Excel worksheet across multiple tables based on key values in selected columns. Use this add-in if you have a large table with complete
Shareware | $ 19.95


Top