audit excel spreadsheet auditing
audit excel spreadsheet auditing
Online Excel Training Links
 
-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us
- Our BLOG
-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security
- 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
 

Products and Services

A listing of some of our products and services

 

Search the site

 

 

Advanced Excel Training Courses

Contact us for your Excel course requirements.

 

Featured Product

Financial Modeling Mentorship (1 year program)

For more information or other training requirement mail us for a quote

Contact Details

Mail: info@AuditExcel.co.za

Call Adrian + 27 83 272 2552

Miricle Solutions cc

PO Box 2683

Rivonia

2128

Free

"Excellent"- ICTGROUP Ireland, "Very nice tutorial, a person can understand the commands in a single view"- GE USA, "Fantastic to understand and for learning "- Visual Group New Zealand, "It was a very informative video which shows a step by step process.  This is really good."- Anon

 

For a Fee

Clients include:                                       MTN  ,  Anglogold Ashanti  ,  Old Mutual  ,  Sun International  ,  Sasol  ,  Telkom  ,  International Housing Solutions  ,  TUHF  ,  AFHCO  ,  Naspers  ,  Supersport  ,  Tiso Capital  ,  Standard Bank  ,  ABSA Capital  ,  Nedbank  ,  Gauteng Treasury  ,  South Africa Custodial Services,                                           AND YOU                                   

Trial copies of AssumeIT Excel Sensitivity Tool

Visit the AssumeIT Sensitivity page to get a free trial copy of our latest offering. The software allows you to run sensitivities on any of your spreadsheet models and includes some other useful features.

Trial copies of Spreadsheet Professional


Download or view a video clip of spreadsheet professional using your windows media player here:

The first version is a 30 day trial version. It allows you to use all features on any size spreadsheet for the 30 day period. Download the 30 day copy

The second version allows free limitless use for spreadsheets of 100 rows or less.  Download the 100 row copy

Download a Word file

 Spreadsheet Professional Quickstart Guide (To download, right click and select "Save Target As...")

The quick guide gives you a good starting point into using Spreadsheet Professional.

Download a PDF file Download a PDF file

 Spreadsheet Modelling Best Practice (1.4Mb).

Please feel free to download the above PDF file donated by Louise Bartlett of IBM Business Consulting Services to the European Spreadsheet Risks Interest Group.

 

Spreadsheet Professional/ Excel Training Courses

Microsoft Excel training available. View the free video clips on the TRAINING pages (click here).

We also offer a Financial Modeling mentorship program. Contact us to find out more

Spreadsheet design and development

Spreadsheet design and development for your critical decisions.

Comfort Reviews

Varying levels of review of a spreadsheet model depending on time and money constraints. This can range from a one day high level overview to a more detailed review into all aspects of the model or an audit of the model.

Spreadsheet Professional

We distribute Spreadsheet Professional, the ideal tool to audit spreadsheets. See what it can do by visiting the Spreadsheet Professional pages

AssumeIT Excel Sensitivity Tool

We distribute AssumeIT Excel Sensitivity Tool which allows users to run multiple sensitivities on any excel spreadsheet. Visit the AssumeIT page to see what it can do.

DataSafeXL

Protect, encrypt, restrict access  and impose time limits to your sensitive excel spreadsheets. Find out more on the XLSafe page.

 

 

     
     Read our privacy policy if you are concerned about your information
 

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