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 Advanced Course

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

4.77

(506 reviews)

Course Overview

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.

Download Course Outline

Course Content

Expand All
Introduction
01 – Welcome to our Excel Advanced 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 Advanced Work Book
Section 1 - Key Essentials
01 – Key Data Types
02 – The Influence of Regional Settings
03 – Auto Formats and Number Facades
Section 2 - Spreadsheet Integrity
01 – Quick Check of Numerical Content
02.1 – Show Formula
02.2 – Trace Precedents and Dependents
02.3 – Formula Error Checking
03 – Blanks vs. Zeros
04 – Excel’s Golden Rule
05 – Excel’s 2nd Golden Rule
06 – Running Totals
07 – Audit Trails
08 – Data Ranges
Section 3 - Cell References
01 – Linking Data Across Sheets
02 – Relative, Absolute and Mixed Cell References
Section 4 - Goal Seek
01 – Goal Seek Intro
02 – Goal Seek Examples
Section 5 - CSV Import
Download Two CSV Files for this Lesson
01 – The Issues with Double Clicking
02 – Enabling the Legacy Wizard
03 – Legacy Wizard Import
04 – The Resultant Connection
Section 6 - Merging & Splitting Data
01 – Text to Columns – Delimiter
02 – Text to Columns – Fixed Width
03 – Merging using Formula
04 – Merging using FLASHFILL
Section 7 - Text Formulas
01 – Text Formula Overview – UPPER, LOWER, PROPER, LEFT, RIGHT, MID & CONCAT
02 – Nested Formula using Helper Columns
03 – Nested Formula Challenge – Client Description
04 – Nested Formula in one go – DOB from SA ID Number
05 – Data Cleanup using the Trim Function
06 – Moving Formula Columns & Loading new Data
07 – Fixing ID Number Formats using Text-to-Columns
Section 8 - Date Formulas
01 – Date Formula Introduction
02 – Date Component Functions – YEAR, MONTH, DAY, WEEKDAY, WEEKNUM
03 – Date Projections – EDATE, EOMONTH, TODAY
04 – Days between 2 Dates – YEARFRAC, NETWORKDAYS
05 – Date Formula Example – Age Calculation from D.O.B.
06 – Date Formula Example Extension
Section 9 - Logical Formulas
01 – Logical Formula – IF, AND, OR
02 – Logical Formula E.g 1 – Sales Rep Commission Calc.
03 – Logical Formula E.g. 2 – IFERROR
Section 10 - Lookup Formulas
01 – VLOOKUP – Using Ranges
02 – VLOOKUP – Using Columns
03 – VLOOKUP – Using Named Ranges
04 – VLOOKUP – Using Tables
05 – INDEX – MATCH – the alternative to VLOOKUP
06 – XLOOKUP
Section 11 - Maths Formulas
01 – Maths Formula Overview – SUM, COUNT, COUNTA, SUMIF(S), COUNTIF(S)
02 – SUMIF v SUMIFS
03 – SUMIF & COUNTIF example
04 – SUMIFS example
05 – COUNTIFS example
06 – Using Pivot Tables instead
07 – Maths FUNCTIONS v Pivot Tables
08 – One last example
Section 12 - Data Validation & Worksheet Protection
01 – Data Validation Basics
02 – Lookup Lists and In Cell Drop downs
03 – Worksheet Protection
04 – The Copy Paste Issue
Section 13 - Pivot Tables & Pivot Charts
01 – Pivot Table Data Structure
02 – Creating a Pivot Table & Chart
03 – Pivot Table Layout Options
04 – Filters
05 – Grouping
06 – Calculated Fields
07 – Multi Pivot Dashboard with Slicers
08 – Adding Pivot Table Data
Section 14 - Recording a Macro for Repeatable Tasks
01 – Macros Introduction
02 – Recording a Macro
03 – Macro E.g. 1 – Bank Statement Cleanup
04 – Running a Macro
05 – Saving a Macro Enabled Workbook
06 – Macro E.g. 2 – Bank Statement Cleanup 2
Section 15 - Course Evaluation
01 – Download the completed Excel Advanced workbook
01 – Short Feedback Questionnaire 1 Survey
Expand
Lesson Content
Excel Advanced Course – Short Feedback Questionnaire

Course reviews

One word Invaluable . . . I will go and leave proper comments on LinkedIn, and promote heavily on all social pages accessed to me . . . Well Done with all three of these courses. A definite 5 Star rating. Thank you Mark!
Eugene

This course is fantastic. I did the first 2 and learned a few pointers but the Advanced one was wow. Thank you so much for the way you explain and show all the points.
Lezelle – Global Learning Services

Very well structured , course material is excellent
Vishal – Maritzburg College

Professional!
George – Castle Lead Works Zambia Limited

Thanks for such an in-depth training.
Tracy – Safire Insurance Company Limited

This was amazing! Wow! I would recommend anyone who uses Excel to do all 3 course I have learnt so much it is scary! Thank You!
Debra-Ann

I have learned so much in this course and I believe I will be more productive at work Thanks again for this great opportunity
Sthembiso – Barloworld

Brilliant, Informative & Friendly
Callum – Student

I really enjoyed the way it was presented and feel that I have learned a lot of helpful tricks in Excel which will certainly help me in my job. Thank you very much
Gerry

Well presented, easy to follow. Nice to stop and pause, go back to grasp a concept there and then. Has enabled me to expand my skills in excel so I can work quicker and smarter.
Carl

Practical. Loaded with tips.
Louise – Humkoop

This course was really excellent and very detailed. I personally have learnt a lot from this course.
Thank you.
Louise – HR Torque

I found the course very informative and helpful, the explanations really help and the Excel Spreadsheet notes really help to navigate through figuring out formulas etc on your own.
Alisha – Tag Travel

Loved it!!
Jacqui – King Price

Well presented and extremely informative, definitely have given me more skills and insight into Excel.
Joel

Super helpful and easy to follow- thanks a mil
Samantha – King Price

I found the course very informative and it highlighted better, more efficient ways that I could be doing things.  The challenge is to remember to use them.
Mandy – Crickmay

Well designed and was thoroughly enjoyed. Learnt some cool shortcuts and work around.
Jenny – Safire Insurance

What a privillege to have been able to do this course. The course is awesome. I have learned so much and by doing the Advanced has made everything make more sense.  How amazing is Excel. Thank you.
Shelley – Safire Insurance

Fantastic course! I have learnt so much more than I expected. The downloadable shortcuts and the workbook tips and tricks will be great for refreshing when needed.
Magda – KZN Wildlife

Wow that was amazing, like I said before. I am so shocked by what I have learnt. Believe you me, I will be using every thing from this COURSE. Thanks a Million.
Mallisa – Aeroklas Duys

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?