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
-=#n/a Error
-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
-=#n/a Error
-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 ®  training and consulting services

BEE certification number- BEE6853244.

 

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:

 

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 2003, 2007 and 2010 Training Courses for all levels in Sandton and countrywide. We can provide customized in-house training courses where required. See what is on offer at the Excel 2003,  Excel 2007 and Excel 2010 training page

Next Courses- Visit www.AuditExcel.co.za/livetraining.html for details

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 homepage where you can learn about MCSE, CISCO and many more.

Excel Spreadsheet Consulting

Our Excel consultants will help you with any of your advanced Excel development requirements.

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

PSL and English Premier League Spreadsheets

For fun we have created a PSL and English Premier League spreadsheet. Download it for free from the Soccer Spreadsheet Page .

Not what you were looking for?

Perhaps these companies can help you

 

Excel Software & Add Ins

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.

 

Search the site

 

 

Advanced Excel Training Courses

Contact us for more information on 011 563 3805 or info@AuditExcel.co.za

 

Excel Course in Rivonia and Sandton, Johannesburg

Financial Modelling

16 & 17 Sept 2010

Advanced Excel

20,21,22 Sept 2010

Pivot Tables

Part of Advanced Excel course

Graphing

Part of 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

     
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