Microsoft Excel – Intermediate

Discover more about intermediate functions such as ABS, AVERAGEIF, AVERAGEIFS and AVERAGEA.
Get confident with data validation with date, list, time and numbers.
Move on to functions like RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN and EXACT.
Learn how to remove duplicates in Excel.
Find out about creating random numbers.
Explore how to change text case and use templates and insert charts.
Gain an insight into how to add custom backgrounds.
Discover how to use tables and how to auto fill data.
Get to grips with adding special characters.
Finally, learn how to change border colour and theme.

While Excel is undoubtedly a useful software program for the home, the content of this course is designed for those who want to use their Excel skills to improve their efficiency at work and advance their careers. It is particularly recommended for people working in the investment, banking or consulting industries. The course is also very useful for individuals who work in administration or anyone who needs to track and analyse data as part of their job. With many employers now demanding intermediate Excel skills from job candidates, investing the time in gaining this skill is a smart move for those who wish to climb the career ladder.

Internet Explorer 8 or above Google Chrome Safari 8 Mozilla Firefox

The easy to engage with video modules make it easy to study in your own time on all your internet-enabled devices.
Technical support is available, should you encounter problems.
The course content is yours for 12 months on signing up, meaning you can recap learning whenever you like.
Gaining sought-after intermediate skills with Microsoft Excel is a career-boosting skill that will get you noticed by employers or help you gain greater control of your own business.