Advanced Excel training courses are facilitated by Certified Microsoft trainers.

Excel training courses for intermediate-level students is held at our training centre in Durban. Excel training facilitated by a Microsoft Certified Trainer. Let our team create a custom Excel learning journey for you and your team. We are able to assess your training needs so that employees learn practical skills which can be applied in the workplace. 

The advanced course helps you to automate spreadsheets, and work with advanced functions and reports using pivot tables and pivot charts. This course is suitable for people working in Finance, HR, and senior management positions who have a lot of reporting to do. 


Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data

Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks

Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros

Topic A: Use Lookup Functions
Topic B: Use Dynamic Arrays and Dynamic Array Functions
Topic C: Trace Cells
Topic D: Watch and Evaluate Formulas

Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends

Topic A: Create Sparklines

Other Excel Training Courses

We offer the full spectrum of Microsoft Excel training at our head office in Westville, Durban. Our trainers are Microsoft Certified and constantly stay updated on software enhancements and changes so you get the highest and most current Microsoft Office training.

Microsoft Excel Basic (Level 1)

Our entry level Excel course where students learn to create, edit, format and print a spreadsheet.

Microsoft Excel Intermediate (Level 2)

This course focuses on the tools needed to work with large spreadsheets, clean up data, sort and filter, pivot tables and charts.

Meet Keshnie, our certified Microsoft Trainer with over 10 years of qualified experience.

Customised and personal training of over 1000 people. Training is held at our offices in Westville, client offices or online.

What you can expect from our Advanced Microsoft course

Learning needs to be fun so we always ensure we create an environment that is relaxed and friendly so that learners don’t feel intimidated or nervous.

We cater for lunch, teas & coffees so learners stay hydrated and are able to focus throughout the training!

Our training is offered in groups or if preferred on a one-on-one basis.

You are able to choose to receive either an Attendance Certificate or a Certificate of Competency. Choosing the latter will require you to be tested on what we cover in the Excel Advanced Course.

Our  courseware is aligned to SAQA Unit Standards. 

Our training centre is designed to let in lots of natural light which helps make the learning experience more comfortable. 

Ready to maximise your software investment?

Featured Insights

Unlocking the potential in people so that businesses can thrive.

Our Services