Intermediate Excel

Creating and applying templates

Creating and modifying charts

Calculating using advanced formulas

Sorting and filtering of data

Importing and exporting Excel data

Working with graphic objects

Working with comments and web features

What does the Microsoft Excel bouquet consist of?

The Microsoft Excel bouquet of courses is for delegates who are interested in mastering the whole array of Excel functions. The package consists of Basic, Intermediate and Advanced Excel. It also covers financial modeling as well as Visual Basic for Applications.

Microsoft Excel Bouquet

Davisha Chetty

 The Intermediate Excel course broadened my knowledge regarding calculation. I now know that I must use advanced formulas to calculate data.

Kumaren Pillay

I have now completed both the basic and intermediate Excel courses. Both were really helpful.

What are the prerequisites?

  • Computer/Laptop
  • Email for notifications and communication
  • Internet connection
  • PDF viewer (e.g ADOBE Acrobat)
  • Microsoft Excel
  • A web browser

What other bouquet courses are offered?

We provide a variety of courses, from computer studies to leadership and softskills courses.

The following are our other bouquet courses:

This course helped me to understand features such as enhancing, checking on cells and table data sorting which is essential to create a spreadsheet that  is presentable.

Course Content

Job Market Prospects

Introduction to Computers is a prerequisite for most companies. 

What other people are saying:

How long does it take to complete?

How much does it cost?

Advanced Excel

Formula basics

Logical formulas

Lookup formulas

Text formulas

Reporting formulas

Formatting functions

Other formulas and dates

Visual Basic for Applications

Financial Modeling

It takes between 4 days and 2 weeks, depending on your speed.

only R 800 (incl VAT)

Microsoft Office Beginner

Leadership

David Ngobeni

Basic Excel

Getting started with Excel

Performing calculations

Modifying data in an Excel worksheet

Modifying the appearance of a worksheet

Managing an Excel worksheet

Printing Excel workbooks