audit excel spreadsheet auditing
audit excel spreadsheet auditing
Audit Excel 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

Other 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
 

AssumeIT Excel Sensitivity Software

AssumeIT Sensitivity Tool for Microsoft Excel provides quick, easy to use sensitivity tools for all your Excel models.

Ideal for performing 'What Ifs' on your spreadsheets and for IFRS 7 Sensitivity Analysis purposes you can choose the type of sensitivity to run, what your inputs are, what your outputs are and run them all at once. The tool was built with the express purpose of keeping it simple. So there are NO questions about co variances, correlations and the like. It is simply there to make your life easier.

Read more on these and other features below

.

 

Search the site

 

 

Contact Details

Mail: info@AuditExcel.co.za

 

Miricle Solutions cc

PO Box 2683

Rivonia

2128

AssumeIT Excel Sensitivity Tool

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

 

Downloads, video tutprials and other information

 

KEY Features

  • Discover your most sensitive inputs

  • Run multiple inputs vs multiple outputs

  • Save your sensitivities for later use or use on another spreadsheet

  • Create fully functional, and simultaneously calculated scenarios within your own spreadsheets

  • 'Input' cells can actually be formula's

  • Automatic reminder to Save spreadsheets before processing sensitivities

  • Protect and Unprotect multiple sheets at the same time

  • Hide and Unhide multiple sheets at the same time

  • Automatically create a hyperlink navigation sheet

  • One Click Adjustment for #Div/0! errors

  • Works with Excel 2003 and Excel 2007 on either the XP or Vista operating systems

PURCHASE- Introductory Price

If you wish to purchase the software a single copy costs

  • US$400 once off fee, or

  • ZAR 4 560 once off fee (incl VAT).

To activate the purchase, on the copy of AssumeIT on your computer, click on the HELP button and then the ABOUT button.

Click on GENERATE REQUEST KEY and send it to us via the email option shown.

Once we have received this all that is required is that payment is made via the secure site and we will email you back the required key to license your product.

Please contact us to arrange for payment at adrian@AuditExcel.co.za

Money Back Guarantee:

If you are not happy with the product after 30 days we will refund you your money in full.

 

You can download the   AssumeIT Sensitivity Tool Features pdf or download the   FREE TRIAL- Download AssumeIT Sensitivity Tool (see Install Instructions below)

To Install- if this is your first use of the tool (NB- If you have a previous version you MUST UNINSTALL it first)

  • Save the zip folder to your desktop

  • Extract the folder from the zip

  • Double Click the  AssumeITSetup file

  • Accept the various terms (Please note the initial install may take time. It looks like it has stalled but it hasn't)

  • Open up Excel and the tool will be loaded. Watch the video clips above to see how it works.

If you have a previous version loaded, first uninstall the previous version before performing the above steps.

VIDEO CLIPS

Watch video clips of AssumeIT at work (contains audio). These all are based on Excel 2003, but the same methods are used for Excel 2007.

Prefer text to video? Download the AssumeIT Sensitivity Tool Features pdf

 

     
     Read our privacy policy if you are concerned about your information
 

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