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 Advanced Course
From Goal Seek to Advanced Formulas to Pivot Tables and Recording a Macro, the objective of this course is to expose you to the many powerful Advanced Features that Excel has to offer, as well as cover some key principles that ensure good practice when working with data.
Course Length: 79 Lessons | 7.5 Hours of Videos.
Total course duration: 10 hours
Skills Level: To take this course, we recommend that you have completed our Excel Intermediate Course or you are familiar with the Intermediate course content
Course Content
Introduction
Section 1 - Key Essentials
Section 2 - Spreadsheet Integrity
Section 3 - Cell References
Section 4 - Goal Seek
Section 5 - CSV Import
Section 6 - Merging & Splitting Data
Section 7 - Text Formulas
Section 8 - Date Formulas
Section 9 - Logical Formulas
Section 10 - Lookup Formulas
Section 11 - Maths Formulas
Section 12 - Data Validation & Worksheet Protection
Section 13 - Pivot Tables & Pivot Charts
Section 14 - Recording a Macro for Repeatable Tasks
Section 15 - Course Evaluation
