Microsoft Excel Training Courses

This practical, 4 day MS Excel Advanced training course focuses on the Excel skills that the typical business user would require. This course is presented in Midrand to facilitate delegates from Johannesburg and Pretoria. Next course dates: 10-13 Feb 2025

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. Next course: 13-14 Mar 2025

This practical 4 - 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: 10-13 Feb 2025

This practical, 4 day MS Excel Advanced training course focuses on the Excel skills that the typical business user would require. This course is presented virtually to facilitate delegates worldwide. Next course dates: 10-13 Feb 2025

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!

This practical, 2 day MS Excel Intermediate training course focuses on the Excel skills that the typical Intermediate user would require.

This practical, 2 day MS Excel Advanced training course focuses on the Excel skills that the typical Advanced user would require.

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: 10-13 Feb 2025 & 13-14 Mar 2025

Virtual MS Excel Training Course- Option A- Full Time Presenters- A full MS Excel course with live presenter via an online streaming platform.

Virtual MS Excel Training Course- Option B- MS Excel experts for questions- A online MS Excel course with MS Excel experts to answer questions during the course.

MS Excel training adapted for lockdown conditions, combining the best of online and classroom training to keep social distancing but provide the feel and benefit of a live course, with the help of MS Excel experts.

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.

Advanced Excel Courses in Botswana.

BQA accredited.

Next course dates 10-13 Feb 2025.

Blended MS Excel training combining the best of online and classroom training where the delegates learn at their own pace but then get to practically apply the teachings with the help of an MS Excel expert.

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

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.

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 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.

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.

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 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.

Turning your school staff into Excel Professionals. Use Excel to get to grips with the performance of the learners, educators and the school!

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.

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.

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.

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.

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.

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in London, England

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Accra in Ghana

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) for Mahe and Praslin in Seychelles

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Luanda, Angola

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) for Blantyre and Lilongwe in Malawi

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Zimbabwe (Harare, Bulawayo and Victoria Falls)

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Lusaka, Ndola and Livingstone in Zambia

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Dar Es Salaam and Kilomunjaro, Tanzania

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Windhoek, Walvis Bay and Ondangwa in Namibia

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Nairobi and Mombasa, Kenya

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Mauritius

Advanced Excel and Financial modelling courses (including Budgeting and Forecasting) in Maputo and Beira, Mozambique

We are now running Advanced MS Excel and Financial Modelling training courses for Africa. We have recently expanded our reach to include the rest of Africa.

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).

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.

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