1 Week Level 1 Award in Customer Service with Microsoft Excel Level 1 or 2 Certificate – Manchester

1 Week Customer Service with Microsoft Excel for residents of Greater Manchester.

This is a remote course. You will learn from home with guidance from a tutor via Teams meeting.

Customer Service Units Covered:

This is a spiral curriculum, commencing with development of knowledge and moving onto application of learning. Learners will explore what is meant by customer service, aspects of product and service knowledge, understanding customer needs, wants and responses when these are not met and the vital skills to be successful in customer service. They will then move onto look at how this knowledge is applied via scenarios, role plays and discussions. Learners will also explore the key skill of self assessment, applying the improvement techniques to self and service.

The programme aims to support and develop long term learning by delivering learning within the 10 sessions, however learners will complete the assessment activities after completing all learning sessions, enabling them to build on knowledge throughout that is reflected in the final assessment activities including role play scenario.

The programme aims to move attendees closer to the job market and to support a change in career.

Once you have completed the Customer Service side of the course, we will issue a voucher code via email which allows you to log in anytime to complete the Excel section of the course at your own pace. 

Microsoft Excel Units:

Microsoft Excel Level 1 Units:

Has never used Excel before;
Has only a basic understanding of the software;
Wishes to update their skills to the latest version of the software.

This is also the ideal starting point for those who wish to go on to use Excel for more advanced applications, such as functions and formulae. The course covers all the basics, such as calculations of sums, averages and totals. The team member will learn some of the basic functions, such as IF, COUNTIF, SUMIF and AVERAGEIF, as well as the use of pivot tables, creating graphs and charts and using hyperlinks.

Microsoft Excel Level 2 Units:

Learners who would like to take this course, will need to ensure that they are equipped with at least intermediate (Level 2) Excel skills. Before starting the Level 2 MS Excel course, the learners should have a good grasp of the Level 1 Excel functions.

The course teaches team members how to use functions, including AVERAGEA, AVERAGEIF, AVERAGEIFS and ABS. They will also learn data validation information, focusing on the type of data validation, such as date, list and time, as well as more information on specific functions, including CHAR, CODE, MEDIAN, MODE and ROUND and how to utilise these functions, in order to meet the organisation’s needs. Other information in the Level 2 course includes how to change text in Excel, e.g., changing text to all upper case or lower case. Team members will also learn how to change the background and add a custom image, how to use AutoFill and how to insert special characters. Upon completing the course, employees will know about most of the functions that Excel has and how to use the software at an intermediate level, which is sufficient to be able to use Excel in most business environments.