Advanced Excel Training

Live And Online Advanced Excel Training To Master Important Skills

Miricle Solutions provides a range of advanced Excel training courses. Whether you prefer to attend one of our live courses presented in Sandton, learn at your own pace through downloadable courseware including books and multimedia or use the online training series of 12 hours, you will appreciate the presentation style and completeness of the courses.

The main difference between intermediate and advanced users of Excel is the way in which they apply the tools in their day to day activities. We recommend taking the free skills assessment to determine your skills level. In addition to advanced individual Excel training, we also offer companies customized training solutions for their employees.

An overview of one of the advanced Excel training courses which can be taken online is given below to give you an indication of course content.

SKU Excel 2007 Advanced Training

You will need to be an intermediate user to fully appreciate this course and be able to apply the skills taught. The course is focussed on Excel skills that will help you develop advanced business applications by for instance, learning how to apply filters and do data analysis. The course is divided into modules lasting two to three hours each. This ensures that you can complete a section per day and thus complete the training series in 5 to 6 days at a steady pace. It is possible to complete the course in two days, but to ensure that you completely understand and are able to apply the skills; it is recommended that you work with one module at a time.

Learn How to File and Sort Data

This part of the Excel 2007 course takes around two hours to complete and covers areas such as filters, sorting, and removal of duplicate records, setting the required filters, and doing custom sorting.

Pivot Tables – Usage in Excel 2007

It is also a two hour module that teaches Pivot Table creation skills, how to view, explore, and format the tables and how to group as well as filter data in the tables.

Macros in Excel 2007

The macros module runs over two hours and helps Excel users to gain skills for setting VBA security, how to record and run macros, write and combine macros as well as filter by means of macros. Upon completion of the module you will also have gained an understanding of VBA code and how to maximize the usage of the End key.

Functions in Excel 2007

It forms one of the most comprehensive modules in advanced Excel training and takes around three hours to master. The module focuses on the usage of functions including date, math, financial and statistical functions. Skills such as testing through the usage of information functions, location of data by means of lookup functions, and text adjustment form part of the module.

Connecting and Importing Data in Excel

The advanced training module for Excel 2007 takes around two hours to complete and focuses on the connection of worksheets, workbooks, and data for web pages, text files, and databases.

Analysing Data with Excel Tools

The shortest module in the series covers the usage of Goal Seek and What-If. It also covers the Exploring Solver and how to create scenarios by means of the Excel Scenario Manager.

The above is but one of the advanced Excel training courses available. Learn at a pace that suits you by downloading courses and books or attending one of our live courses for compact advanced training. Contact Miricle Solutions for a free skills assessment and assistance in selecting a relevant course and instruction method.