What is Advanced Microsoft Excel ?

SpecCon Holdings Advanced Ms Excel course is called ‘advanced’ for a reason; it’s not for amateurs! It is jam-packed with over 60 different functions and formulas. It teaches delegates to combine formulas and ensures that the learner can take these formulas to a new level. The most important element of this course is that the learner learns how to teach himself. There are so many different functions, the learner must be confident to grow and improve himself in the Excel environment.

Advanced Microsoft Excel

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.

Laura van Niekerk

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

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 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:

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

Course Content

Job Market Prospects

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

​

​

​

​

What other people are saying:

How long does it take to complete?

How much does it cost?

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

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

 R 150 (incl VAT) for access to The Accelerator Programme for a year 

Or

Microsoft Excel Basic

Microsoft Visual  Basics

Microsoft Access

Financial Modeling

Microsoft Excel Intermediate

Microsoft PowerPoint

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

What will my certificate look like?