What is Advanced Microsoft Excel about?
SpecCon’s 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 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.
- 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.
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.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.
only $1 + 36c
(the 36c is the administration fee)
Microsoft Excel Basic
Microsoft Visual Basics
Microsoft Excel Intermediate
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
Unit 9 - Google sheets
9.1 Google sheets
9.2 More google sheets
9.3 Import ranges
9.4 Google forms