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


















Microsoft Excel Courses

Microsoft Excel Courses For Beginners, Intermediate And Advanced Users

Many of the Microsoft Excel courses offered online or live are either too basic or too advanced for the learner. Miricle Solutions ensure skills training at the appropriate level. An easy to follow skills assessment can be done to ensure relevant training. Interested parties can simply download the form and email it back to Miricle Solutions for a free skills assessment in South Africa.

Skills Audit and Live Training

Once the skills level is known a person can follow any of the Microsoft Excel courses offered by Miricle Solutions with confidence. Apart from Excel 2003, courses in 2007 and 2010 are also offered. In addition, Apple Mac Excel 2011 courses are presented live at predetermined venues and dates. Companies requiring customised courses will appreciate the range of in-house training options available. The live Excel courses are presented by experienced lecturers who are also advanced users of the program in their day to day lives and range from accountants and CA’s to financial managers. It is their knowledge of application which set them apart and ensures focussed training.

Online Training

Apart from the live Microsoft Excel courses, Miricle Solutions provide a range of online training options. Whether you are a beginner, intermediate or advanced user of the program you will appreciate the extensive range of online courses including Excel 2003 and 2007 training. Miricle Solutions even provides a free Excel training course online for beginners.

Benefits of Online Microsoft Excel Training Courses at Miricle Solutions

  • Low pricing in relation to the average online and live courses offered by other companies.
  • Learn from anywhere in South Africa and even when travelling abroad.
  • Controlled learning pace ensures that you don’t fall behind on the curriculum.
  • Learn at a pace that suits your lifestyle, learning requirements, and time.
  • No need to install software - as the courses include enough exercises, data files, challenges, and simulations.
  • No need to wait for the arrival of courses since you can immediately download the courses.
  • Learn any time that suits you for as you long or a short a period as you have available.
  • Certification is obtained once the course is completed and you score 80% plus.
  • No need to write exams at an institution since you receive the test questions online and can complete them at your own time.
  • Certification is excellent for career development.
  • Interactive training ensuring that both individuals and corporations can use the courses.
  • Demo courses are available to try for free.
  • Three hour beginner Excel training free.
  • Video based step by step instructions with printable versions.

The online training courses can be purchased at our commerce site Audit Excel at affordable prices ensuring that you can stay within your training budget. Some of the courses which are available are that of:

Microsoft Excel 2003 Online Training Courses

The 2003 series consists of 26 hours training which can be done in your own time. Select the module that you want to complete and master such through step by step video tutorials. You can repeat a module whenever you need. It is suitable for beginners and intermediate users.

Advanced Microsoft Excel 2007 Online Training Courses

The course runs over 12 hours and is aimed at the intermediate to advanced user. Upon completion the user will be able to apply the knowledge in business applications such as for the creation of financial models and forecasting.

Downloadable Excel Training Books

Miricle Solutions offers Microsoft Excel courses in various forms. Whether you prefer to download a course in book form, attend online training or learn the required skills at a one or two day Excel workshop or seminar, we ensure that you have access to the preferred method of instruction. An example of a downloadable book is the “Excel Dates” which will help you to work with dates more effectively and thus reduce the time it takes to create complex spreadsheets. We have numerous books for download at our sister site.

Contact Miricle Solutions for more information about any of the Microsoft Excel courses discussed and start your training without any further delay.




  • Microsoft Excel Courses
  • Advanced Excel Training
  • Excel Training and Consulting Services
  • Excel Training in South Africa

  • 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