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
What is Intermediate Microsoft Excel ?
The Intermediate Microsoft Excel course is for delegates who understand the basics of Excel, and are familiar with the Excel screen, formatting and basic formulas. For this course, the standard Excel screen should be a familiar one, one which no longer scares the learner. It involves basic Vlookups and PivotTables, to ensure that the learner understands the more advanced formulas and functions of Ms Excel.
Intermediate Microsoft Excel
Davisha Chetty
 The Intermediate Excel course broadened my knowledge regarding calculation. I now know that I must use advanced formulas to calculate data.
Kumaren Pillay
I have now completed both the basic and intermediate Excel courses. Both were really helpful.
- 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 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.
Job Market Prospects
Introduction to Computers is a prerequisite for most companies.Â
​
​
​
​
What other people are saying:
How long does it take to complete?
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 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 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 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.
 R 150 (incl VAT) for access to The Accelarator Programme for a year
Or
Microsoft Outlook
Microsoft Excel Basics
Microsoft Access
Microsoft Word Beginner
Microsoft Excel Advanced
Microsoft PowerPoint
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 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 9 - Formatting functions
9.1 Conditional formatting
9.2 Format painter
9.3 Paste special