This is a 2 week remote course. You will learn from home with guidance from a tutor via a Microsoft Teams meeting.
You must have access to a laptop or computer.
You will have a live session with a tutor (10am – 4pm) We do have some flexibility for school runs.
Units Covered:
Once you have completed the Digital Technologies 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.
You must complete the Level 2 Digital course first.
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.
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.
Registration has passed – if you cannot find a course currently, feel free to contact us
SCL Education Group was established in 1999 and with 20+ years’ experience in unlocking potential across the UK, our vision is to positively impact on the future prospects of one million children and young people; creating a legacy in the communities we serve.
SCL Education Group is built on four organisations, all driven and motivated by the same goal, to unlock potential across the UK.
Together we are leading providers in education, apprenticeships, traineeships, adult education, childcare, sports coaching and end point assessment.
Plymouth House
22 Plymouth Road
Blackpool
Lancashire
FY3 7JP
