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

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

Microsoft Excel Bouquet

Microsoft Excel Bouquet

Davisha Chetty

Davisha Chetty

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

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

Kumaren Pillay

Kumaren Pillay

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

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

What are the prerequisites?

What are the prerequisites?

  • Computer/Laptop
  • Email for notifications and communication
  • Internet connection
  • PDF viewer (e.g ADOBE Acrobat)
  • Microsoft Excel
  • A web browser
  • 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?

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:

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.

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

Course Content

What other people are saying:

What other people are saying:

How long does it take to complete?

How long does it take to complete?

How much does it cost?

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

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.

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

only $4 + 25c 

(the 25c is the administration fee)

only $4 + 25c 

(the 25c is the administration fee)

Microsoft Office Beginner

Microsoft Office Beginner

Leadership

Leadership

David Ngobeni

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

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

Please click on the course name to view its content. 

Please click on the course name to view its content.