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


















Corporate Financial Modelling

Corporate Financial Modelling Is Great For Those “What If” Scenarios

South African companies and banks rely on the information produced by financial models to successfully make decisions in an ever-changing business environment. In order to cater for all the “what if” scenarios, a well structured spreadsheet is necessary. This will help determine the effects investments and business decisions have on profit and other financial indicators. MTN, Anglo gold, Old Mutual, Sasol, Telkom, Naspers, Standard Bank, Absa Capital and Nedbank are just a couple of clients who depend on Miricle Solutions for corporate financial modelling.

One service that Miricle Solutions over in terms of corporate financial modelling, is Excel spreadsheet consulting. A consultant will spend time at a company and recommend the most appropriate solution for a specific scenario. Miricle Solutions consultancy service can be done in a one day overview or an in-depth review. The latter will look at all aspects of a spreadsheet model. The time spend all depends on the urgency of fixing existing errors or implementing a new model

Financial and budget officers often need an objective opinion to help them reach an accurate and realistic analysis; that’s where Miricle Solutions can help. Microsoft Excel 2003 and 2007 have got such an array of functions that it is imperative you get the experts to help you. It will not only reduce the risks that can creep in due to human error but also save you a lot of time by automating certain features.

Financial analysts who want to improve their Excel skills can contact Miricle Solutions  who have years of experience in corporate financial modelling. With adequate spreadsheet knowledge you’ll see how a financial decision can affect your future finances. For all your development requirements - whether it is valuations, reporting packages, feasibilities or exercises in cost cutting; a consultant is always standing by to help you.  

 


  • Financial Modelling
  • Financial Reporting
  • MCSE Courses
  • Corporate Financial Modelling
  • Advanced Excel Training
  • Professional Spreadsheet Training
  • Spreadsheet Professional Software
  • Excel Spreadsheet
  • Video Tutorials Excel
  • Excel Basics

  • 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