Microsoft Excel Training Courses

We offer a variety of MS Excel training courses covering all aspects of spreadsheet use including using MS Excel in Financial and Decision modelling.

MS Excel training coursesWhy us for MS Excel Training Courses?

  • Skilled presenters (all presenters are Chartered Accountants at a minimum and have presented hundreds of MS Excel training courses)
  • Practical training (based on the real life problems we encounter in consulting on  MS Excel)
  • Guaranteed course dates (if you have paid  to attend the public MS Excel Intermediate to Advanced course, the course will run- no cancellations!)
  • Free MS Excel Skills assessment (use our free tool to make sure you attend the correct course)
  • On site or off site (we can train at your place, an external venue or you can attend our monthly open MS Excel training courses)

Find the best MS Excel training courses for you

Our suggested way forward would be:

  • Assess your skill level to ensure that you attend the correct level of course by completing our free Skills Assessment (these are the numbers from 1 to 10 that appear on all the training material)
  • Determine which of the courses are correct for your needs? Use this quick ‘Which Excel Course should I do‘ questionnaire to establish which course is correct for you with the current work you do.
  • or give us a call ( see number above)

Cape Town Advanced Excel Training Course 3 Days in Cape Town

This practical 3 - day Cape Town Intermediate to Advanced Excel training course leads delegates through advanced Excel functions and specialised MS Excel techniques, explaining the functions and their uses including Pivot Tables and Charting. Next course dates: 4-6 Mar 2019

Corporate Financial Modeling Training Course 5 Days

This practical 5 - day Corporate Financial Modeling Training Course covers all of the key MS Excel Advanced and financial modelling, budgeting and forecasting techniques and will enable participants to handle all their MS Excel needs. Next Course: 11-15 Feb, 11-15 Mar 2019

In House Excel Training Courses Normally 1 to 3 days

We provide in house Excel training courses covering any of the material listed on this site. So if you prefer that your staff stay onsite while receiving their Excel Training we can accommodate you any where in the world!

PowerQuery for Excel 1 Day

How to use Excel's new PowerQuery add in to import data (including from multiple files), clean data (including unpivoting the data or appending tables onto each other), and export the data into pivot tables and dashboards.

Pivot Table Training Course ½ or 1 Day Course

This practical ½ or 1 day pivot table course leads delegates through Excel’s Pivot Table feature, explaining its uses with practical examples.

The course covers how to create your first pivot table and builds up to linking your pivot table to external databases and extracting meaningful reports from your databases

Excel Charts and Graphs ½ Day Course

This practical ½ - day charting course leads delegates through Excel’s charting and graphing tools.

The course covers the various chart types and how to combine and customise them to provide a visual interpretation of your data. Tricks taught include how to conditionally format your charts.

Excel for Beginners 1 Day Course

This practical 1 - day beginner course leads delegates through the fundamentals of excel spreadsheets.

The course starts with understanding a spreadsheet and moves onto how to create simple formula like the IF function and how to use some of the inbuilt tools including filtering, sorting and conditional formatting.

Excel Dashboard Training for management reporting 1 or 2 days

Excel dashboard training to create meaningful management reports and dashboard templates that easily explains what is happening in your business. The focus is on providing knowledge on how to automate your reports and dashboards so that you spend more time understanding the information and less time creating it.

Advanced Excel Functions 2 Day Course

This practical 2 - day programme leads delegates through advanced Excel functions and specialised spreadsheet techniques, explaining the functions and their uses.

The course covers all the advanced functions that may be required in the business world including VLOOKUP, SUMIF, conditional formatting and dealing with dates in Excel.

Excel for Sales and Marketing 1 or 2 days

Make sure you have the most efficient and effective way to analyse your sales and marketing efforts so that you can spend more time on understanding and improving the numbers and less time on creating them!

Excel for HR 2/3 days

Excel for HR will teach you how to calculate and track leave, determine tax deductions, clean up personal databases, join data bases together, identify strong and weak employees and track training.

PowerPivot Training Courses 1 day

This practical 1 day PowerPivot training course leads delegates through Excel’s new PowerPivot features (Excel 2010 and Excel 2013), explaining where you would use PowerPivot, how it differs from Pivot Tables and what the benefits are with practical examples.

MS Excel VBA training course 2 Day Course

This practical 2 - day VBA for Excel course leads delegates through advanced Excel VBA and macro use.

Using practical examples the course shows how to construct a simple macro and then to customise it to create forms and to loop through various procedures.

Excel for equity analysis and research 2 or 3 days

Learn how to maximise the use of Excel when involved in any sort of equity analysis and end up with a working equity analyst model.

Concepts taught would be beneficial to equity researchers, project finance, corporate finance and private equity players.

Access with Excel 2 or 3 days

A comprehensive Microsoft Access course covering the basics to advanced features of Access and then how to interact with the best features within Excel. The course focuses on using the best features of Access with Excel products to provide a structured, safe solution to your business dilemmas.

Excel Skills Transfer Programme Various

A comprehensive Excel skills transfer programme to ensure that the skills and knowledge we posses are transferred to your staff.

Given our vast experience we can assist staff responsible for data analysis, reconciliation's, reporting and financial modelling. Any user of Excel will benefit from this comprehensive programme to ensure skills transfer.

Budgeting and Forecasting with Excel 1 or 2 days

Budgeting and Forecasting with excel will teach you how use Excel to make projections such as budgets (generally 1 year forward), forecasts (2 to 3 years) and financial modelling/ feasibilities (3 to 30 years).

Financial Modelling Training Course 2 Days

This practical 2 - day Financial Modelling Training Course covers a variety of techniques and best practices to build robust, flexible financial models in MS Excel. This course is presented in Midrand to facilitate delegates from Johannesburg and Pretoria.

Advanced Excel Training Course 3 Day Course

This practical 3 - day Intermediate to Advanced Excel training course leads delegates through advanced Excel functions and specialised spreadsheet techniques, explaining the functions and their uses including Pivot Tables and charting. The course covers all the key features in Excel including pivot tables, charting, tools like conditional formatting and detailed and practical knowledge of Excel functions like VLOOKUP, SUMIF etc

Consulting

We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.

Find Out More

Live Training

"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."

Find Out More