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
Google
Web AuditExcel.co.za


















AssumeIT Training Courses

Knowing the basics of excel in itself is considered vital if you were to run an efficient and effective business, but allowing your company the leg up on competitors requires more in depth training. Such is the AssumeIT training courses available from Miricle Solutions. By implementing this training course your employees will learn how to use the AssumeIT Sensitivity Tool in Microsoft Excel which provides you with a quick and easy to use  sensitivity tool for all your Excel models to perform those ‘What Ifs’ to the benefit of your company.

Through experience the team of Miricle Solutions realised that the use of the AssumeIT Sensitivity Tool is imperative when it came to creating spreadsheets. With this simple tool companies are able to use it for IFRS 7 Sensitivity Analysis which allows your company to choose what type of sensitivity they want to run, what their inputs and outputs are, as well as being able to run all of these at once. One of the main benefits of training your employees to use the AssumeIT Sensitivity Tool is that doesn’t leave the option open of co-variances, correlations and any other such scenarios, which will ultimately make your company’s decision making process much simpler.

Some of the key elements of the AssumeIT Sensitivity Tool is that it allows your company to discover the most sensitive inputs. It can run multiple inputs as opposed to multiple outputs, and save your sensitivities in order for it to be used at a later stage or in another spreadsheet. By training your employees with AssumeIT they will be able to create fully functional spreadsheets with  concurrently calculated scenarios.

Apart from being simple to use, the AssumeIT Sensitivity Tool is also functional in operating systems such as Excel 2003, 2007, XP and/or Vista. With this in mind and the fact that it has all the previously mentioned features and more available, training your employees to be able to use the AssumeIT Sensitivity Tool would seem rather imperative. With the help of this tool you will be able to prevent any potential pitfalls and the task of making decisions to benefit your company would be much simpler.

Should you require further information on the AssumeIT Sensitivity Tool or you want to acquire training to be able to use this tool, contact Miricle Solutions today for the most up to date in excel training solutions!

 


  • Excel Spreadsheets
  • Excel Organizations
  • Advanced Excel Training Courses
  • Assume IT
  • DataSafeXL

  • Excel Audit & Financial Modeling Review

    Miricle Solutions provides review and auditing services on excel spreadsheets that are important to the organisation. Using the benefits of the internet these services can be provided to companies worldwide.

    More on excel audit and reviews

    Excel design and development

    Miricle Solutions designs and develops professional excel spreadsheets. Benefit from the combination of our business knowledge and modeling experience.


    More on design and development in excel

    Spreadsheet & Excel Risk Management in the Sarbanes Oxley world

    Excel has become a core tool in the business world. However few companies have managed to address the risks associated with these spreadsheets. Now Sarbanes Oxley is making it compulsory to address the issue in the States and it will reach the rest of the world soon. Visit our new SOX site , which covers spreadsheet controls relating to documenting ,access, input, testing, version control, audit trails, change control and backup/ archiving,

    More on reducing SOX risks due to excel use

    Decision Modeling

    The business world is all about making decisions. Miricle Solutions can provide the services to understand your problems, develop a Excel spreadsheet model to assess the decision, and ensure that the necessary level of quality is generated.




    More on decision modelling using excel and spreadsheets

    EXCEL TOOLS
    arrow Spreadsheet Professional Video Clip
    arrow
    Download Trial Copy
    arrow
    Quick start guide
    arrow
    Spreadsheet Professional
       Read our privacy policy if you are concerned about your information
     

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