EXCELLEARN: Advanced course

This course is suitable for individuals who seek advanced Excel knowledge. If you use Excel in your daily personal or work life, and want to improve your skills to be more efficient, this course is perfectly curated to achieve advanced status.

It focuses on building basic Excel skills, allowing the learner to improve on an already solid Excel foundation. This includes finding, replacing, navigating and filtering data. It simplifies complex functions so the individual can use a step-by-step method to apply these functions in their own capacity.

This includes detailing and applying lookup functions, index & match functions, common if statements and advanced if statements. The course also looks at inserting and editing pivot tables, slicers and pivot charts.

In the later videos, the course shifts to some useful data tools that can be used in small or large profit models as well as conditional formatting to aid data analysis.

At the end of the course, there is a thorough step-through of building a very basic mini model which allows the learner to apply the skills they’ve developed during the course as well as gain an idea of how to start the process of building your own model.

This is a short course that can be completed in 3 hours. The videos were recorded with the idea of being practical and as short as possible to ensure the course can be completed even if you have a busy schedule. Thus, can be taken on by students, employees, small business owners or just any regular person trying to learn the ropes of Excel in absolutely no time.