Excel Intermediate Course
R399 Incl. VAT (3 Months Access)
Select the "Pay & Enrol" Button below for Online or Direct Deposit Payment Options
or Contact us for Group Enrolments


4.8 (707 Reviews)


Course Outline

Build on the Features & Formulas covered in our Excel Beginner Course and learn new concepts that will take your Excel skills to the next level!

  • 1

    Introduction

    • 01 - Welcome to our Excel Intermediate Course!

    • 02 - How did you find out about this course?

    • 03 - How to get started

    • 04 - Download the Excel Intermediate Work Book

  • 2

    Section 1 - Quick Test.

    • 01 - A Quick Test to see-if you're ready for this course

  • 3

    Section 2 - Key Essentials

    • 01 - Numbers

    • 02 - Dates and Times

    • 03 - Regional Settings

    • 04 - Number Formats

    • 05 - Key Essentials Recap

  • 4

    Section 3 - Non Standard Series Generation

    • 01 - Basics Recap

    • 02 - Using the Autofill Handle

    • 03 - Using Formulas

    • 04 - Using a Combination

  • 5

    Section 4 - Advanced Copy and Paste

    • 01 - Copy and Paste All

    • 02 - Copy & Paste Special - Formulas

    • 03 - Copy & Paste Special - Values

    • 04 - Copy & Paste Special - Transpose

    • 05 - Copy & Paste Special - Multiply

  • 6

    Section 5 - Formulas

    • 01 - Basic Formula Recap - SUM, AVERAGE, COUNT, MAX & MIN

    • 02 - Logical Formula - IF Function

    • 03 - Show Formula - see all Formula at once

  • 7

    Section 6 - Cell Referencing

    • 01 - Absolute Cell References

    • 02 - Named Cells

    • 03 - Split Screen Tip

    • 04 - Referencing across sheets

  • 8

    Section 7 - Rounding

    • 01 - Rounding - Difference between Formatting & using the ROUND Function

  • 9

    Section 8 - View Optimisation

    • 01 - View Options - Show / Hide Excel Components, Column Widths, Freeze Panes etc.

    • 02 - Data Grouping

  • 10

    Section 9 - Find and Replace

    • 01 - Find and Replace

  • 11

    Section 10 - Sort and Filter

    • 01 - The importance of storing Data in Tabular Ranges

    • 02 - Sorting

    • 03 - Filtering Basics

    • 04 - Filtering using Data Type specific Filters, incl. Filter by Colour

  • 12

    Section 11 - Graphs

    • 01 - Creating and Editing Charts

    • 02 - Multiple Series Charts

  • 13

    Section 12 - Conditional Formatting

    • 01 - Conditional Formatting as an Alternative to Charts

    • 02 - E.g. 1 - Highlighting Duplicates

    • 03 - E.g. 2 - Stock Control

    • 04 - E.g. 3 - Sales Target

  • 14

    Section 13 - Ranges vs. Tables

    • 01 - Ranges vs. Tables

  • 15

    Section 14 - Pivot Tables

    • 01 - Pivot Table and Chart Basics

    • 02 - Creating a 2nd Pivot Table off the same Data

  • 16

    Section 15 - VLOOKUP

    • 01 - The VLOOKUP Function

    • 02 - VLOOKUP Example

  • 17

    Section 16 - Data Manipulation

    • 01 - Splitting Data with Text-to-Columns

    • 02 - Merging Data using the CONCAT function

    • 03 - Merging Data using FLASH FILL

    • 04 - Fixing Data using FLASH FILL

    • 05 - Fixing Data using FUNCTIONS

  • 18

    Section 17 - Wrap up Exercises

    • 01 - Covering VLOOKUP

    • 02 - Covering Pivot Tables and Charts

    • 03 - Covering Sort, CONCAT, Conditional Formatting and Fliter

    • 04 - Covering Paste Special and Pivots

  • 19

    Section 18 - Course Evaluation

    • Short Feedback Questionnaire

Course Reviews

''Love this, so easy to follow along, and when I did get stuck I could ask questions in the discussions tab at the top. 10 outa 10 guys''
Ashleigh - Safire Insurance


''Terrifically informative and the way that the videos are explained was easy to follow and understand all the aspects that were involved in this course.''
Bavershan - Huge Telecom


''Awesome! Thought it good to fiddle around on a free online Excel course during lockdown, merely to do something. What a great course, I worked through the course step by step. Completely grabbed my attention. Well worth it!''
Willem


''Brilliant Course, I definitely learnt alot''
Tracy - Safire Insurance Company


''Brilliant - thank you for this - really enjoyed it and wish I had known some of the things he told me years ago. ''
Betty - Safire Insurance Company


"
Great course facilitator, kept me on my toes throughout the course, job well done thank you''
Natasha


''Fantastic course! Would recommend it to anyone with an interest in accounting or working with data in general.''
Casper


''Thank you Mark for building up my confidence in using my laptop and Excel - made it a lot clearer for me.''
Carl - Good Earth Developments PTY LTD


''The pace of the instructor is excellent. ''
Maritzburg College - Vishal Rajpaul


''In the Beginners course I learned a few pointer but this one was wow! I learned a lot and can really apply this to my daily work. Thank you so much''
Lezelle - Global Learning Services


''Thank you so much, it was amazing! I've told so many people and will continue to do so! ''
Hannelie


''Was very informative and I learnt a lot. Great course. Thank you.''
Graesen


''Very well presented in an easy to follow format that kept me interested throughout. Learned a lot! ''
Ian


'' I thoroughly enjoyed the content of this course and enjoyed the humour''
Shannon


''Wow that was truly amazing. Thanks a Million for such an in depth and informative session''
MALLISA - Aeroklas Duys (Pty) Ltd


''I would recommend this to everyone that uses Excel regularly. Time is money and this course is money when it comes to saving you time. A must for all office staff members regardless of your proficiency in excel''
Paul


''Awesome ... very enlightening''
Karthigasan - Good Earth Developments


''This is awesome! Thank you very much.''
Sthembiso - Barloworld Transport


''In one word"INVALUABLE"."
Stephen - Good Earth Development(Pty)Ltd