5 Day Level 2 Award in Customer Service & Employability with Microsoft Excel Level 1 or 2

5 Day Customer Service & Employability with Microsoft Excel Level 1 or 2.

This is a remote course. You will learn from home with guidance from a tutor via a Zoom meeting. You will complete the 5 Days Customer Service course first.

The course will run from 9:30am to 3:30pm Monday to Friday.

Customer Service/Employability Units Covered:

Employability – Job searching
Applying for a job
Building working relationships with customers
Group discussion on where jobs can be located and advertised

Discuss how you would search for jobs relevant to customer services.
Identify your own skills and knowledge required to selected job roles.
Learning Outcome 1 – Know how to deliver good customer service
Learning outcome 2 – Know different communication methods
Learning outcome 3 – Know how to provide good customer service in line with organisational procedures
Learning outcome 4 – Know how to effectively deal with customer queries, problems and complaints

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

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.

You must complete an enrolment before you can start the course. This will be booked with you upon a successful booking of the course.