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
-Dragging Boxes
-Address
-Picture Links
-Cut & Paste
-Manual Recalculate
-Advanced Filter
-CLEAN
-CTRL & ENTER
-Text to Column
-DatedIf
-Copy Sheets
-Date Problem
-Date Stamp
-Date Value
-Days 360
-Dollar
-Find Duplicates
-Cell navigation
-Import Web
-Import Data
-Net Working Days
-Record Macro
-Remove Duplicate
-Speak Cells
-Value
-Search
-Substitute
-Sum Sheets
-Weekday
-Workday
-Years fraction
-Function Wizard
-Dragging Boxes
-CTRL & ENTER
-Sum Sheets
-Audit Toolbar
-Good Design
-Copy Sheets
-Cell navigation
- Add In's
-Cut & Paste
-Manual Recalculate
-Identify missing categories
-Find Duplicates
-Date Problem
-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
-Weekday
-Workday
-Years fraction
-DatedIf
-Net Working Days
-Date Stamp
-Date Value
-Days 360
-EDATE
-Rank
-MAX/ MIN
-IF
-AND/ OR
-TEXT Function
-Value
-Search
-Substitute
-Dollar
-CLEAN
-Remove Spaces
-FIND
-Length
-Join characters
-Change Case
-Extract Text
-IS number EVEN/ODD
-Is cell a number
-ISERROR
-SUMIF/ COUNTIF -Data Validation
-Picture Links
-Record Macro
-Remove Duplicate
-Speak Cells
-Import Web
-Import Data
-Text to Column
-Advanced Filter
-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
 

 

Microsoft Excel ®  spreadsheet services

 

Welcome to the home page of Miricle Solutions, South Africa's premier provider of Microsoft Excel Consulting, Training and Excel add ins.

 

We offer a number of services and these can be summarized as:

 

Search the site

 

 

Advanced Excel Training Courses

Contact us for more information on info@AuditExcel.co.za

 

9th & 10th Feb 2010 - Two Day Advanced Excel Course

 

CLICK HERE to download the Registration Document for the above course which includes the pricing and map

 

Watch a video clip of what you will learn

 

Featured Product

Online Excel training based on the Excel for dummies series.

  • Train at your own pace

  • Learn from anywhere

  • Intuitive and easy to use

  • Review and practice what you learnt for a full year

For a sample register by clicking on this link for a trial

Contact Details

Mail: info@AuditExcel.co.za

Call Adrian + 27 83 272 2552

Miricle Solutions cc

PO Box 2683

Rivonia

2128

Excel Training Solutions

"I found your site by accident. I am so glad I did. Your videos are easy to understand and saved the day here at work today!"- Debra L. Barnes"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

 

Excel Consulting & Services

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                                   

Live Excel Training

We offer Excel Training Courses for all levels. We can provide customized in-house training courses where required. See what is on offer at the Advanced Excel training page

Next Course- Rivonia

9th & 10th February 2010- Two Day Advanced Excel

 

New Courses: Half day courses for VBA, Graphing and Pivot Tables! Contact us for more details at info@AuditExcel.co.za

Recent Testimonials:

“Data accuracy and consistency has improved dramatically across Absa Capital, so much so that it has become compulsory within certain areas for all staff to complete Adrian’s Data Analyses Spreadsheet Techniques course.”

Anton Faber, Head of Learning and Development, ABSA Capital

Excel Skills Audit

Do you know the Excel skill levels in your organization? Have you ever sent a employee to Excel training that was either too advanced or too simple? Have you ever hired someone whose Excel skills aren't what you expected? Find out about our Excel Aptitude Test. Perfect for Excel skills audits.

Online Excel Training

If you’re looking for online Excel training that’s dead easy, cost-effective and that you can do in your own time, try out our free Excel beginner course by clicking here. Other courses available from our e commerce site at www.AuditExcel.com include

More technical computer training?

Visit our technical training hompage where you can learn about MCSE, CISCO and many more.

 

Excel Spreadsheet Consulting

Our Excel consultants will help you build your excel spreadsheet models. Feasibilities, valuations, reporting packages, cost cutting exercises etc. Clients include the likes of MTN and Anglogold Ashanti in South Africa. Contact us at info@AuditExcel.co.za for more details

Excel Audit and Review services

We provide auditing of excel spreadsheets for all types of financial models. Our particular focus is Private Public Partnerships and Project Finance spreadsheets. Contact us at info@AuditExcel.co.za for more details

Controlling the risks of excel spreadsheets in organizations

We can assist clients to improve controls over the organizations spreadsheets.  If Sarbanes Oxley interests you visit our  Sarbanes Oxley and Spreadsheets site!

Ad Hoc Excel Questions and Answers

If you have some questions or want to read more about particular issues with Excel, please read and interact with our Blog

New Capabilities

  • Capacity Planning, Control waste and machine efficiencies

  • Complex derivative valuation

  • MS Access System Design
  • Cell phone tariff analysis

Contact us at info@AuditExcel.co.za to find out more

Sample of Current assignments

  • Digital Dashboard for a listed company
  • Cost Control system using MS Access
  • Customised Excel training course
  • Excel Skills audit and benchmarking exercise
  • Consolidation of debtors aging reports
  • Creation of a reporting tool in the micro finance industry

World Cup Spreadsheet

For fun we have created a world cup spreadsheet. Download it for free from http://www.auditexcel.co.za/world_cup_spreadsheet.html .

 

 

Excel Software Solutions

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.

 

     
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, change control and backup/ archiving,
 

More on reducing SOX risks due to excel use

 
 Excel Training

Miricle Solutions provides Spreadsheet Professional and Excel training on CD Rom, Intranet or Internet.
Let Miricle Solutions provide your organisation with the excel spreadsheet help you require. Contact us at info@AuditExcel.co.za and tell us what you require.

Languages available via automatic translation:


  Spanish , German , French , Italian , Portuguese,  Chinese

Spreadsheet and Excel Errors

Research shows that the majority of spreadsheets or excel models have errors in them. Understanding how easy it is to make these errors and how they happen is critical to reducing the risks.

To get a good understanding of the issue please view the following pages on this website

Use of Excel in businesses- why is this a problem

Research findings- how many errors are there in excel spreadsheets?

Real Life Errors- Has any one lost money due to excel spreadsheet errors?

How errors occur in spreadsheets- Video tutorials on typical excel errors that humans make

Spreadsheet Professional- A means to reduce the errors

Spreadsheet Articles

Have you ever wondered about a specific function in Excel and never quite been able to figure it out? Perhaps one of our articles can help?

Financial Software
Spreadsheet Budgeting
Spreadsheet Software
Financial Solutions
Financial Reporting
Excel,

Advanced Excel Training
Spreadsheet Reports
Excel Help
Spreadsheet Reporting
Financial Services
Financial Spreadsheets
Financial Accounting
Financial Audits

      Financial Planning
Statistical Formulas
Mathematical Formulas
EOMonth Formula
EDate Formula
Combin Formula
Spreadsheet Linking
Comparison Charts
Data Graphs
Pie Charts
Financial Solutions
Future Budgeting
Auditing Software
     

Financial Auditing
Financial Planning
Financial Spreadsheets
Financial Analyst
Financial Help
Spreadsheet Models
Spreadsheet Reviews
Spreadsheet Testing
Spreadsheet Training
Financial Management
Financial Modeling
Spreadsheet Controls
Spreadsheet Development

More Articles

Some other useful articles

More about Spreadsheet Professional

Online Excel Training

Financial model review and auditing

Spreadsheet design and development

Decision models and decision modeling

Spreadsheet risk management

Spreadsheet errors

     Read our privacy policy if you are concerned about your information
 

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