Advanced Microsoft Excel

Advanced Microsoft Excel

Richard Moodley

Richard Moodley

Advanced Microsoft Excel covers all principles on how to control finances using functions such as logical test, lookup and advanced reporting functions. Great course.

Advanced Microsoft Excel covers all principles on how to control finances using functions such as logical test, lookup and advanced reporting functions. Great course.

Laura van Niekerk

Laura van Niekerk

I learned so much in this advanced course and found it to be on a very high level.

I learned so much in this advanced course and found it to be on a very high level.

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 has been difficult but the video simulations helped a lot. I am so much more knowledgeable now.

This course has been difficult but the video simulations helped a lot. I am so much more knowledgeable now.

Course Content

Course Content

Job Market Prospects

Having an Advanced Excel qualification is highly regarded at a lot of companies. 

Job Market Prospects

Having an Advanced Excel qualification is highly regarded at a lot of 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 -Formula basics

1.1 Formula basics

1.2 Types of errors

1.3 Fixed referencing

Unit 1 -Formula basics

1.1 Formula basics

1.2 Types of errors

1.3 Fixed referencing

Unit 2 - Logical Functions

2.1 Logical test

2.2 IF function

2.3 OR function

2.4 AND function

2.5 IFERROR function

Unit 2 - Logical Functions

2.1 Logical test

2.2 IF function

2.3 OR function

2.4 AND function

2.5 IFERROR function

Unit 3 - Lookup function

3.1 VLOOKUP function

3.2 MATCH formula

3.3 Using the MATCH formula to populate the column index number

3.4 INDEX

3.5 OFFSET

3.6 Using VLOOKUP to fix data with mapping tables 

3.7 Using a True or 1 in a Vlookup

Unit 3 - Lookup function

3.1 VLOOKUP function

3.2 MATCH formula

3.3 Using the MATCH formula to populate the column index number

3.4 INDEX

3.5 OFFSET

3.6 Using VLOOKUP to fix data with mapping tables 

3.7 Using a True or 1 in a Vlookup

Unit 5 - Text formulas

5.1  FIND formula

5.2 CONCATENATE formula

5.3  LEFT, RIGHT and MID functions

5.4 TRIM functions

5.5 PROPER/LOWER and UPPER formulas

5.6 SUBSTITUTE formula

5.7 VALUE formula

5.8 LEN formula

Unit 5 - Text formulas

5.1  FIND formula

5.2 CONCATENATE formula

5.3  LEFT, RIGHT and MID functions

5.4 TRIM functions

5.5 PROPER/LOWER and UPPER formulas

5.6 SUBSTITUTE formula

5.7 VALUE formula

5.8 LEN formula

Unit 6 - Dates

6.1 Understanding dates and dynamic dates

6.2 Converting text to dates with formulas

6.3 The NETWORKINGDAYS formula

6.4 The END OF MONTH formula

6.5 Working with time

6.6 The TEXT formula and dates

Unit 6 - Dates

6.1 Understanding dates and dynamic dates

6.2 Converting text to dates with formulas

6.3 The NETWORKINGDAYS formula

6.4 The END OF MONTH formula

6.5 Working with time

6.6 The TEXT formula and dates

Unit 4 - Reporting functions

4.1 The ADDRESS formula

4.2 Pivot tables

4.3 Count using pivot tables to generate lists

4.4 Updating values in a pivot table and adding multiple values

4.5 Using calculated fields in pivot tables

4.6 Changing the look and feel of pivot tables

4.7 Splitting pivot tables into multiple sheets and grouping data

4.8 Retrieving the field list when lost

4.9 Creating dashboards from pivot tables

4.10 The SUMIFS formula

4.11 Recording macros and using macros to improve reporting

4.12 The INDIRECT formula

Unit 4 - Reporting functions

4.1 The ADDRESS formula

4.2 Pivot tables

4.3 Count using pivot tables to generate lists

4.4 Updating values in a pivot table and adding multiple values

4.5 Using calculated fields in pivot tables

4.6 Changing the look and feel of pivot tables

4.7 Splitting pivot tables into multiple sheets and grouping data

4.8 Retrieving the field list when lost

4.9 Creating dashboards from pivot tables

4.10 The SUMIFS formula

4.11 Recording macros and using macros to improve reporting

4.12 The INDIRECT formula

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 Excel Basic

Microsoft Excel Basic

Microsoft Visual  Basics

Microsoft Visual  Basics

Microsoft Access

Microsoft Access

Financial Modeling

Financial Modeling

Microsoft Excel Intermediate

Microsoft Excel Intermediate

Microsoft PowerPoint

Microsoft PowerPoint

Charlene Naicker

Charlene Naicker

Unit 7 - Financial functions

7.1  PMT function

7.2  IPMT function

7.3  FV function

7.4 NPV function

7.5 IRR function

Unit 7 - Financial functions

7.1  PMT function

7.2  IPMT function

7.3  FV function

7.4 NPV function

7.5 IRR function

Unit 8- Other

8.1 Using the find and replace option to edit formulas

8.2 Use conditional formatting to do reconciliations and finding duplicates

8.3 Countif formula and using countif to number data

8.4 Goalseek

Unit 8- Other

8.1 Using the find and replace option to edit formulas

8.2 Use conditional formatting to do reconciliations and finding duplicates

8.3 Countif formula and using countif to number data

8.4 Goalseek

Unit 9 - Google sheets

9.1 Google sheets

9.2 More google sheets

9.3 Importranges

9.4 Google forms

Unit 9 - Google sheets

9.1 Google sheets

9.2 More google sheets

9.3 Importranges

9.4 Google forms