Contact us
- 086 167 3923
- hello@summitsolutions.co.za
- Suite 6, 24 Hilton Ave, Leonard, Hilton, KwaZulu-Natal, 3245, South Africa
Sign up for our newsletter
Receive our monthly Excel tips and news to your inbox!
Quick links
Menu
MS Excel Intermediate Course
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.
Course Content
Introduction
Section 1 - A Quick Test
Section 2 - Key Essentials
Section 3 - Non Standard Series Generation
Section 4 - Advanced Copy and Paste
Section 5 - Formulas
Section 6 - Cell Referencing
Section 7 - Rounding
Section 8 - View Optimisation
Section 9 - Find and Replace
Section 10 - Sort and Filter
Section 11 - Graphs
Section 12 - Conditional Formatting
Section 13 - Ranges vs. Tables
Section 14 - Pivot Tables
Section 15 - VLOOKUP
Section 16 - Data Manipulation
Section 17 - Wrap up Exercises
Section 18 - Course Evaluation
