Remote Level 1 or 2 Customer Service with Microsoft Excel Level 1 or 2 – Non Dev

This is a remote course. You must have access to a laptop or computer.

You can work on this course at your own pace, as long as the course is completed within the 1 month time frame given.

What does this qualification cover? 

Level 1:

• Know how to deliver good customer service
• Know different communication methods
• Know how to provide good customer service in line with organisational procedures
• Know how to effectively deal with customer queries, problems and complaints.

Level 2:

• The principles of customer service
• How customer needs and expectations are formed
• The principles of responding to customers’ problems or complaints
• Interpersonal and team working skills
• How to meet customer needs and expectations
• Communicating effectively with customers
• Legislation which supports the customer service process

Who is it suitable for? 

This qualification is aimed at learners who are new to the customer service sector and wish to improve their knowledge of this area resulting in the achievement of a nationally recognised qualification.  The qualification provides learners with the knowledge and understanding in customer service for learners who deal, or intend to deal, with customers on a daily basis as part of their job role and is applicable to a variety of work environments.

Microsoft Excel Options

Once you have completed your Customer Service element of the course, Jobskilla will issue your Microsoft Excel course, you can pick either level 1 or level 2!

Microsoft Excel Breakdown

This course will be issued to you via email, you can simply login and out of this course whenever you like and complete at your own pace!

Microsoft Excel Level 1 Units:

This Level 1 starter course is recommended for anyone in the business that may use Excel for uncomplicated data capture and analysis, such as tracking simple expenditure or for calculating sums or totals. The course is ideal for anyone who:

• 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.

It 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.

The second half of the Level 1 course covers ‘sheets’ – the Excel equivalent of a page. The team member will learn how to rename, delete, hide and unhide a sheet and how to move and copy a sheet. They will also learn how to change the colour of the tabs.

Microsoft Excel Level 2 Units:

The material in the Level 2 course is designed for those who work with Excel in the workplace and wish to improve their skills. Whether the employee is involved in investments, banking or consulting, the content will be useful for anyone who tracks and analyses a lot of data.

Employees who are new to the workforce will need to ensure that they are equipped with at least intermediate (Level 2) Excel skills.

Before starting this Level 2 course, the employee should have a good grasp of the Level 1 Excel functions. Those with experience in Excel may feel that they can skip the Level 1 course, but it is advisable to at least review the course material, before starting the Level 2 material.

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.