Skip to content
  • 086 167 3923
  • hello@SummitSolutions.co.za
  • Login
  • Sign up for online courses
Menu
  • Login
  • Sign up for online courses
  • 086 167 3923
  • hello@SummitSolutions.co.za
  • Login
  • Sign up for online courses
Menu
  • Login
  • Sign up for online courses
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Menu
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Facebook
Linkedin
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Menu
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Facebook
Linkedin

MS Excel Intermediate Course

Current Status
Not Enrolled
Price
R799
Get Started
Pay & Enroll
 4.5/5

4.80

(1202 reviews)

Course Overview

This MS Excel course builds on the Basic Functions and Formulas covered in our Beginner Course and introduces new concepts that will take your skills to the next level.

Course Length: 55 Lessons | 5.5 Hours of Videos.

Total course duration: 8 to 10 hours

Skills Level: To take this course, we recommend that you have completed our Excel Beginner Course or you are familiar with the Beginner course content.

Download Course Outline

Course Content

Expand All
Introduction
01 – Welcome to our Excel Intermediate Course
02 – How did you find out about this course? 1 Survey
Expand
Lesson Content
How did you find out about this course?
03 – How to get started
04 – Download the Excel Intermediate workbook
Section 1 - A Quick Test
01 – A Quick Test to see if you’re ready for this course
Section 2 - Key Essentials
01 – Numbers
02 – Dates and Times
03 – Regional Settings
04 – Number Formats
05 – Key Essentials Recap
Section 3 - Non Standard Series Generation
01 – Basic Recap
02 – Using the Autofill Handle
03 – Using Formulas
04 – Using a Combination
Section 4 - Advanced Copy and Paste
01 – Copy and Paste All
02 – Copy and Paste Special – Formula
03 – Copy and Paste Special – Values
04 – Copy and Paste Special – Transpose
05 – Copy and Paste Special – Multiply
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
Section 6 - Cell Referencing
01 – Absolute Cell Reference
02 – Named Cells
03 – Split Screen Tip
04 – Referencing across sheets
Section 7 - Rounding
01 – Rounding – Difference between Formatting & using the ROUND Function
Section 8 - View Optimisation
01 – View Options – Show / Hide Excel Components, Column Widths, Freeze Panes etc.
02 – Data Grouping
Section 9 - Find and Replace
01 – Find and Replace
Section 10 - Sort and Filter
01 – The importance of storing Data and Tabular Ranges
02 – Sorting
03 – Filtering Basics
04 – Filtering using Data Type specific Filters, incl. Filter by Colour
Section 11 - Graphs
01 – Creating and Editing Charts
02 – Multiple Series Charts
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
Section 13 - Ranges vs. Tables
01 – Ranges vs. Tables
Section 14 - Pivot Tables
01 – Pivot Table and Chart Basics
02 – Creating a 2nd Pivot Table off the same Data
Section 15 - VLOOKUP
01 – The VLOOKUP Function
02 – VLOOKUP Example
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
Section 17 - Wrap up Exercises
01 – Covering VLOOKUP
02 – Covering Pivot Tables and Charts
03 – Covering Sort, CONCAT, Conditional Formatting and Filter
04 – Covering Paste Special and Pivots
Section 18 - Course Evaluation
01 – Download the completed Excel Intermediate workbook
02 – Short Feedback Questionnaire 1 Survey
Expand
Lesson Content
Excel Intermediate Course – Short Feedback Questionnaire

Course reviews

In one word, “INVALUABLE”.
Stephen – Good Earth Development (Pty)Ltd

LOVED it!!! Wish someone had sent me on this course years ago!
Kelly – Poetry Stores

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

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

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

I started  this course to make a career change and did not think it  would help in my current. I was wrong, even the basic functions helped me  to improve my Excel efficiency as well as look manipulate my data to make it clearer and easier to understand.
Dylan

I loved it. I have learnt many things that cost me hours of work in the past. It is great to know how simple it can be if you know what to do.
Pierre – Cape Union Mart

The facilitator is very easy to listen to. His pace is excellent, and he explains in such a way that he makes it understandable.
Megan – Budget Insurance

This course is extremely clear, concise and well explained.
Nicky

This was a really great course and really taught me some new and interesting shortcuts as well as more importantly the use of graphs and pivot tables.
Darryl

I have found these courses very much interesting and beneficial, motivating, more advance in terms of short cuts , I have really enjoyed it and have gained  more experience. I have found that excel is the best especially when doing reports it makes your life more easy and accurate.
Ncamisile – Safire Insurance

I truly appreciated the opportunity to have done this course. It assisted in providing information accurately and a LOT quicker to relevant parties in matters that I deal with on a daily basis.
Vanessa

I enjoyed the way this course has been presented as well as the presenter , who spoke clearly , explained everything in detail and even included some situations and stories. I have learned so much. Thank you for brushing up my Excel Skills
Leandrie – Hotel School

Easy and simple to follow. Great explanation as you learn. Really enjoyed it.
Katia – Colendbrander

Excellent course. The shortcuts was absolutely amazing. Thank you 🙂
Karusha – Colendbrander

I found the Intermediate course quite challenging, but it was really helpful.
Bhekithemba – Safire Insurance

An excellent course. I have learnt so much and look forward to putting it all into practice!
Jane

I loved this so much . Thank you !!
Tracey – Ecobalance Landscaping

Thanks a mil – awesome course.  Will be pushing my boss to do the Advanced as well.
Samantha – King Price

Absoulutely loved being remined of some of the stuff learnt but forgotten and the many many new “tricks”. Just hoping I get to try them out ASAP so I dont forget them.
Brett – King Price

Wow, excellent course, learnt so many time saver tips and more efficient ways to do things. Thank you!
Jolene – Collins Residential

Have a problem you’re struggling to resolve? Feel free to ask us a question!

FAQs
Contact us

Contact us

  • 086 167 3923
  • hello@summitsolutions.co.za
  • Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton

Sign up for our newsletter

Receive our monthly Excel tips and news to your inbox!

Quick links

  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Menu
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Facebook
Linkedin

© 2020 Summit Solutions | All Rights Reserved | Website by Yellow Door Collective

Scroll to top
Login
Accessing this course requires a login. Please enter your credentials below!

Lost Your Password?