Unit 10 - Reporting formula

10.1 Pivot table

10.2  Count using pivot tables and drilling down into detail

10.3  Updating a pivot table with new data and adding multiple values

10.4  Using calculated fields in pivot tables

10.5  Removing or hiding subtotals, grand totals and filling blanks

Unit 10 - Reporting formula

10.1 Pivot table

10.2  Count using pivot tables and drilling down into detail

10.3  Updating a pivot table with new data and adding multiple values

10.4  Using calculated fields in pivot tables

10.5  Removing or hiding subtotals, grand totals and filling blanks

Intermediate Microsoft Excel

Intermediate Microsoft Excel

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 related courses are offered?

What other related courses are offered?

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

The following are our most popular courses:

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

The following are our most popular 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

Job Market Prospects

Introduction to Computers is a prerequisite for most companies. 

Job Market Prospects

Introduction to Computers is a prerequisite for most companies. 

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?

Unit 1 - Calculating data with advanced formulas

1.1 Applying cell and range names

1.2 Naming ranges automatically

1.3 Using specialised functions

1.4 Fixed referencing

Unit 1 - Calculating data with advanced formulas

1.1 Applying cell and range names

1.2 Naming ranges automatically

1.3 Using specialised functions

1.4 Fixed referencing

Unit 2 - Organising worksheet and table data

2.1  Sort and filter data

2.2  Create and modify tables

Unit 2 - Organising worksheet and table data

2.1  Sort and filter data

2.2  Create and modify tables

Unit 3 - Presenting data using charts

3.1 Creating a chart

3.2 Modifying charts

3.3  Adding data to charts

Unit 3 - Presenting data using charts

3.1 Creating a chart

3.2 Modifying charts

3.3  Adding data to charts

Unit 5 - Inserting graphic objects

5.1  Insert graphic objects

5.2  Draw and modify shapes

5.3  Illustrate workflow using SmartArt graphics

5.4 Add a background

Unit 5 - Inserting graphic objects

5.1  Insert graphic objects

5.2  Draw and modify shapes

5.3  Illustrate workflow using SmartArt graphics

5.4 Add a background

Unit 6 - Custom formatting

6.1  Custom format numbers, dates etc.

Unit 6 - Custom formatting

6.1  Custom format numbers, dates etc.

Unit 4 - Simplistic formulas

4.1  MIN, MAX and Average

4.2  COUNT, COUNTA and COUNTABLANK

4.3  Rounding

Unit 4 - Simplistic formulas

4.1  MIN, MAX and Average

4.2  COUNT, COUNTA and COUNTABLANK

4.3  Rounding

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 R 250 (incl VAT)

only R 250 (incl VAT)

Or

Or

Microsoft Outlook

Microsoft Outlook

Microsoft Excel Basics

Microsoft Excel Basics

Microsoft Access

Microsoft Access

Microsoft Word Beginner

Microsoft Word Beginner

Microsoft Excel Advanced

Microsoft Excel Advanced

Microsoft PowerPoint

Microsoft PowerPoint

David Ngobeni

David Ngobeni

Unit 7 - Other functions

7.1 Watch window option

7.2 Text to columns

7.3 Subtotal function

7.4 Protection

7.5 Set up calculations

7.6 Types of errors

7.7  Breaking links

7.8 Data validation

7.9 Hyperlinks

Unit 7 - Other functions

7.1 Watch window option

7.2 Text to columns

7.3 Subtotal function

7.4 Protection

7.5 Set up calculations

7.6 Types of errors

7.7  Breaking links

7.8 Data validation

7.9 Hyperlinks

Unit 8- Dates

8.1 Working with dates and time

8.2 Dynamic dates and the TODAY and NOW functions

Unit 8- Dates

8.1 Working with dates and time

8.2 Dynamic dates and the TODAY and NOW functions

Unit 11 - Google sheets

11.1  Google sheets

Unit 11 - Google sheets

11.1  Google sheets

Unit 9 - Formatting functions

9.1 Conditional formatting

9.2 Format painter

9.3 Paste special

Unit 9 - Formatting functions

9.1 Conditional formatting

9.2 Format painter

9.3 Paste special