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, 2010 and 2011 (Apple Mac) Training Courses for all levels in Sandton and the whole of South Africa. We can provide customized in-house training courses where required. See what is on offer at the Excel 2003,  Excel 2007, Excel 2010 and Excel 2011 for Mac training page

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.

If you are not sure what you or your organisations skill level is, download this file , complete the Instructions and Questions sheets and email back to us for a free skill assessment (South Africa and African countries only)

Which Function should you use

We are working on a new tool to help you choose the correct Excel function or tool to use.

Find out more

Work in progress- Advanced Excel Training for Engineers- we are currently registering with CESA to be able to provide CPD points.

Excel Downloads

We are now selling downloads on various topics in Excel.

• 'Dates in Excel'
• 'Pivot Tables in Excel ' 

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

• Excel 2003 Training Series
  
• Excel 2007 Series
• Excel 2007 Advanced Series
• Converting to Office 2007 Series
• Access 2003 Training Series
• Access 2007 Series
• Access 2007 Advanced Series
• ICDL
• Outlook 2007 Series
• Office 2007 Series
• PowerPoint 2007 Series
  
• Sharepoint 2007 Series
• Word 2003
• Word 2007 Series

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. If you have a complex business or process to model, we have experts in all industries who can help. Feasibilities, valuations, reporting packages, cost cutting exercises and more. Clients include the likes of MTN and Anglogold Ashanti.

Some of the other areas we cover include:

Financial Modelling- You need to make a decision but you are not sure what impact various scenarios may have on your business. You need a flexible, clear financial model to assess the risks.

Financial Model Audits- You want to have a professional review of your Financial Model before you proceed with the project.

Spreadsheet Templates- You want to create a spreadsheet template that your staff can use to make the right decisions.

Data Analytics- You know the information you want is in your system but you can't seem to get it out? We can assist using a variety of tools. In fact there is a good chance we consult to your consultants on these matters.

Convert Spreadsheets to Databases- You have spreadsheets that run parts of your business and you know it is a risk! We can convert your spreadsheet into a formal, safe system

Consolidate inputs from hundreds of sources- You receive many excel files that you spend hours trying to consolidate into a single, usable database. We have a novel way to achieve this almost instantly!

Business Intelligence- All the data in the world but not a single report that is useful! Does this sound familiar? Whether you are running on SAP, Oracle, Pastel or any other package, we can assist you in getting some intelligence out of your business data

Convert spreadsheets into working web pages- Share your spreadsheets using the power of the internet. See some serious and fun examples on these pages

• IRR Calculator

• Retirement Calculator

• 2011 Rugby World Cup

• Gauteng Toll Calculator

• Education Savings Calculator

• Home Loan Calculator

Contact us at info@AuditExcel.co.za for more details

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.

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

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