MS Excel Advanced Course
Self-paced Online
R 1,550 pp
7.5 hrs of videos
Live Online
R 3,050 pp*
2-days / 3 mornings
Live Onsite
R 4,850 pp*
2-days
* Live Training is for groups of 6 or more - Prices Ex. Vat
Course Overview
Picking up from where the Intermediate Course left off, the objective of this course is to expose you to the many powerful advanced functions that Excel has to offer.
Topics covered include: Data Modelling, Advanced Formula, Pivot Table Dashboards, Data Validation and Automating processes… not forgetting all those useful tips and tricks to help maximize efficiencies and impress your colleagues!
Course Content
Looking at all the key aspects to ensure Data Integrity. Using some neat Excel tools to check, troubleshoot, verify and validate data within your spreadsheet.
Points covered include: Verifying numerical content, Formula auditing, Empty cells vs Zero values, Excels Golden Rule, Running Totals, Audit Trails and Data Ranges.
Highlighting the importance of one’s current List Separator, Decimal symbol, Thousand Separator and Date formats when working with CSV files.
Explaining the difference between the New and Legacy Import Wizards within Excel and then using the Legacy Wizard to import a CSV file; highlighting the importance of the resultant Data Connection and how to use it to one’s advantage.
Taking formulas to the next level…
- Text Formulas
Using Text Formulas to dynamically manipulate and extract data while introducing the concept of nested formulas. CONCAT, PROPER, UPPER, LEFT, RIGHT, MID & TRIM.
- Date Formulas
Understanding that Dates are – or should be – stored as a numerical value. This opens up a whole new world when working with Dates. Date Functions such as WEEKNUM, EOMONTH, TODAY and NETWORKDAYS help us to take this to the next level.
- Logical Formulas
Introduction to the AND & OR functions in conjunction with IF to cater for multiple conditions, as well as the use of IFERROR to hide known errors.
- Lookup Formulas
Explore the many different variations of the VLOOKUP function and their advantages and disadvantages. Plus, the introduction to INDEX-MATCH and the all new XLOOKUP as better alternatives to VLOOKUP.
- Maths Formulas
Taking your basic SUM and COUNT functions to the next level with SUMIF(S) and COUNTIF(S). Building 2-dimentional formula arrays with these functions to create Data Summary Tables. Comparing these to Pivot Tables and exploring the advantages and disadvantages of both.
Best methods to prevent incorrect data entry, including lookup lists and in cell dropdowns.
Includes a brief recap on Pivot Table basics and the Key Features and Layouts to be aware of.
Best Practices of creating multiple Pivot Tables and Charts off the same data and how to combine these into a multi-pivot Dashboard by linking Slicers and Timelines; plus a really neat trick on how best to add additional records to your source data.
Introduction to the timesaving world of Recording a Macro for repeatable tasks. A clear explanation of the different options available to save your Macro and some really clever Tips and Tricks to ensure that your Macro works on different datasets.
Over 50 Keyboard Shortcuts covered throughout the course to increase those efficiencies.
A printable 1-pager, of all these shortcuts and more, is provided with the follow-along Workbook.
What's Included?
- A detailed follow-along Excel Workbook with Summary Notes
- Self-marking quick questions to test your progress as you learn
- Practical Tasks that will enable you to put your newly acquired Excel Skills into practice
- Course completion Certificates
- Lifetime access to course material and updates
Next Step ...
For further specific information for our various training options use the links below; or alternatively contact us on hello@summitsolutionstraining.co.za or 086 167 3923.
Course Reviews
Great content, easy to understand
Louise Riddell – AAM
Very easy to follow, great examples to work with
The course was informative
Vele Khangale – Macmillan Education
Excellent course!
Kuhle Molobye – King Price
I feel like I'll soon be an excel guru
Great course
Athi Ngayi-Mtshali – Nyeleti Consulting
Great course, wouldn't change anything. I've done this course previously with another service provider and it was nothing like this one. I would highly recommend this course.
Will make my day-to-day work easier
Nomkhosi Mlaba – Scottfin
I enjoyed the course and I already have ideas on where to apply my new skills to make my day-to-day work easier and professional. Thank you!
Very helpful and informative.
Nonhlanhla Nxumalo – Scottfin
Although it was super long but very helpful and informative.
Was very informative and helpful.
Denelle Gopal – HRTorQue
Was very informative and helpful.
Was very informative and helpful.
Denelle Gopal – HRTorQue
