Excel Training In South Africa

Options For Excel Training In South Africa To Address Specific Skills

Miricle Solutions provides a wide range of courses regarding Excel training in South Africa to address the skills development requirements of beginners, intermediates, and advanced Excel users. With free skills assessments available, we ensure training at the proper level. Learners and employers thus save money and time while also benefitting from more targeted training.

The Excel training in South Africa takes several forms to also address the preferred method of learning and instruction:

• Online, interactive training courses.
• Multimedia CD based courses.
• Downloadable books.
• Free beginner tutorials and training.
• Free tips on specific functions.
• Live training at predetermined venues in Sandton.
• Live customizable in-house training at corporate client premises.

Some of the courses forming part of our product stable of Excel training in South Africa are briefly introduced below to give you an indication of what we offer.

Live Financial Modelling Excel Training

It is a live two day course presented in an engaging manner with enough hands-on exercises to build confidence in using the newly developed skills. The course is well suited for intermediate and advanced users and focuses on issues surrounding financial modelling. Delegates master the building of financial models; learn how to create sensitivities in models, income statements, balance sheets and cash flow charts. In addition, they learn how to create detail input sheets with revenue forecasts while also working with exchange rates. Delegates furthermore gain skills in the development of debt schedules allowing for interest and capital holidays.

Live Pivot Table Training

Another one of the Excel live training options in South Africa focuses on pivot tables in Excel 2007. It is a half day course suited for intermediate and advanced spreadsheet users. Aspects of pivot tables such as the creation thereof, running total calculation, working with group dates and numbers, and usage of complex functions are addressed.

Online Excel 2007 Training in South Africa

It is an 11 hour training series focussing on an introduction to Excel 2007 and is suitable for the beginner user of spreadsheet programs. The course is also an excellent refresher of skills and suitable for 2003 users who have converted to Excel 2007. The course covers areas such as working with the Ribbon, adding, renaming and moving worksheets, navigating in Excel and entering data. It moves on to teach essentials such as entering cell values, finding and correcting errors, making use of the AutoFill and AutoComplete as well as AutoSum and SUM functions. The course furthermore addresses the formatting of cells and their sizes as well as lay-out and data within the cells.

The editing and printing of worksheets module focuses on working with various views while the managing of worksheets is addressed in a separate module. The course concludes with a two hour focus on charts and objects in Excel including Smart Art and pictures.

Downloadable Excel Training Books in South Africa

If you simply need to obtain a reference book on specific modules of Excel or prefer learning from printed matter you will appreciate our range of downloadable books. A brief overview of the content from one of the books is provided below:

Excel 2007 – How to Pivot Tables

The book deals with aspects surrounding the creation of pivot tables, manipulating and summarizing data, formatting such and representing. Row manipulation, values and subtotal settings are also addressed. Creation of fields, calculations, and adding of items are other topics addressed. Many more aspects of pivots are addressed in depth.

Whether you prefer working with printed matter, learn at your own pace through online Excel training in South Africa or want to master specifics in Excel through attendance of live training, Miricle Solutions is the answer. Contact us for more information about the various training options.