audit excel spreadsheet auditing
audit excel spreadsheet auditing
Audit Excel links
 
- Home Page
- Company Profile
- Free Tutorial Page
- Our BLOG
- Sensitivity Software
- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS
- Function Wizard
- Audit Toolbar
- Good Design
- Add In's
- Identify missing categories
- Check that data within range
- Count error checks
- Check import headers
- CAGR
- Show all formula
- Fill in blanks
- Data Cleanup
- Multi sheet changes
- Automatic Sort
- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
-
Automatic Sorting
- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table
- Database - Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF
- DATE
- EOMONTH
- EDATE
- Rank
- MAX/ MIN
- IF
- AND/ OR
- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text
- IS number EVEN/ODD
- Is cell a number
- ISERROR
- SUMIF/ COUNTIF - Data Validation
- Group/Ungroup
- Autofilter
- Workbook protect
- External Links
- Goto Special
- Find/ Replace
- Conditional Format
- Pivot Tables
- Data Sort
- Data tables
- Multiple Windows
- Hyperlinks
- Protect cells
- Paste Special
- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing
- Goalseek
- Data Tables
- Scenarios
- Watch Window
- Download All

Downloads / Products

Spreadsheet Prof.

The world's No.1 spreadsheet testing tool. Try it out below

excel spreadsheets Watch Video Clip
Download Trial Copy
Spreadsheet Professional Quickstart Guide
Buy It
 

Spreadsheet Professional Software for Auditing and Controling Excel Spreadsheets

This page shows you how Spreadsheet Professional can help you review and audit your spreadsheets and, where used within an organization, can address your excel spreadsheet control risks. If you want your excel models to be correct, and to eliminate those annoying errors that creep into spreadsheets, try Spreadsheet Professional out.

 

Addressing excel spreadsheet risks is a matter of providing your staff with the tools and processes to improve controls over their spreadsheets, and reduce the risks associated with excel use. No matter where you are or the legislation you are trying to comply with, you will need to address the following aspects of spreadsheet use:

  • spreadsheet documentation,

  • input controls,

  • comprehensive testing methodology,

  • version control,

  • audit trails, and

  • change controls.

If you are subject to any of these regulations ( SOX-404, 21-CFR-11, HIPAA, TREAD, SAS-70, IFRS, Basel-II, PIPEDA, Bill-198, USPA, GLBA ) then you need to know more about Spreadsheet Professional.

 

Search the site

 

 

Contact Details

Mail: info@AuditExcel.co.za

 

Miricle Solutions cc

PO Box 2683

Rivonia

2128

Spreadsheet Professional

Used by:  Shell, SASOL, Naspers, Engen, Siemens, GAPAC, PWC, Ernst & Young, AngloGold Ashanti, Rand Merchant Bank, Nedbank, BOC, HBOS, Eskom, Quest Co

 

Downloads and other information

 

Excel spreadsheets are notoriously difficult to control. The very features that make them so useful, also make them risky i.e. flexibility, ease of use and transferability.

Watch this brief summary of Spreadsheet Professionals tools

Below we show how Spreadsheet Professional can address the control issues required with some nifty tools just to make your life easier.

Testing and Auditing Excel Spreadsheets

Spreadsheet Professional is a world leader in testing excel spreadsheets. By incorporating its tools into a formal testing process you can reduce your testing time by up to 80% and achieve more thorough testing.

Use can be made of the following features (click to watch video clip with audio)

Documenting Excel Spreadsheets

You will need to ensure that the appropriate level of spreadsheet documentation is maintained and kept up-to-date to understand the business objective and specific functions of the spreadsheet. Spreadsheet Professional provides the following reports that can be run with a few simple clicks:

  • Summary report
  • Range Names and Links to other workbooks
  • Spreadsheet maps
  • Translation of all calculations into meaningful words
  • Report of all cells that require inputs
  • Report of all inputs in the spreadsheet
  • Results of general test performed
  • Results of detailed tests performed.
  • Visual representation of the formula in any cell and all the cells that are used to get the result
  • Differences between two versions of a spreadsheet.
  • Watch Spreadsheet Professional document Excel spreadsheets

Version Control, Audit Trails, and Change Control for Excel Spreadsheets

Depending on the longevity of your spreadsheet it may be useful to determine what has changed from version to version. Spreadsheet Professional provides you with a comparison tool that means it will take minutes instead of days.

Input Control for Excel Spreadsheets

A spreadsheet can only be as good as the inputs it receives. As per the old adage, garbage in means garbage out. See how Spreadsheet Professional can identify all inputs in a spreadsheet and compare them to previous versions of the spreadsheet.

Access Control for Excel Spreadsheets

Access to critical spreadsheet should be controlled. Excel provides some useful protection devices and control should be maintained over where the spreadsheet is stored. Spreadsheet Professional can assist you to quickly determine if any changes have been made to a spreadsheet using its comparison tool.

  Trial Copy of the Software- Click to download a 30 day trial

Spreadsheet Professional Documentation- a pdf with an explanation of the tools within Spreadsheet Professional

Spreadsheet Professional Training Sample- a sample of the training CD which is available to get you from beginner to expert in 6 hours.

Spreadsheet Professional Video Tutorials

Pricing

A single license for the software costs R4 500 excl VAT (£295/ $425)

The training material can be purchased for R450 excl VAT (£30/ $43)

We provide a 30 day money back guarantee.

Contact us at adrian@AuditExcel.co.za to arrange the purchase or go to the purchase page on the Purchase page

Our 5 part series on addressing Spreadsheet Risks

Addressing spreadsheet risk in the Sarbanes- Oxley era  Part 1, Part 2, Part 3, Part 4, Part 5.
5 part series on methods to address excel Spreadsheet risks

     
     Read our privacy policy if you are concerned about your information
 

Home | Contact Us | Site Map | Training | Sarbanes Oxley | Articles | Links | Blog