Advanced Excel Training

Advanced Excel Training Courses

Miricle Solutions is a leading provider of end-user computing related training courses online, downloadable and at specific locations around the country on set dates. We from time to time offer advanced Excel training courses such as the one at Rivonia.

It is a three day application driven advanced Excel training course taking the attendees through the various components of Excel 2003, 2007 and 2010 in a hands-on course with several exercises to reinforce skills learned. The course is presented in a relaxed and well paced way ensuring that every delegate that attends will be able to master the data analysis functions of Excel.

The advanced Excel training course is well suited for anyone working with Excel spreadsheets on a regular basis, who is involved in the creation of datasets and who needs to convert the datasets into usable report format for business decision making purposes. Since it is an advanced course, some previous experience with Excel functions and working with spreadsheets are pre-requisites. A person who attends will thus already be familiar with printing, navigating around spreadsheets, inserting and deleting rows, columns and ranges, creating formulas and copying the basic formulas.

Attendees will learn how to reconcile accounts, compare lists of data, locate and correct errors, and identify data duplication or missing data. The presentation is easy to understand and includes vital areas of data analysis such as using the auditing toolbar and working with the function wizard, applying text to column tools, avoiding common pitfalls, correcting date formats, applying the GOTO function, working with dates, importing data and working with the data.

Many more areas of data analysis are addressed in this advanced Excel training course. Contact us for more information on the contents, to get a quote, find out when the next course will be and to make your booking.