Skip to content

Microsoft Excel Intermediate Certificate

FREE PDF Certificate|CPD Certified Training |Assessment Included|Interest Free Payment Plans|14 day money back guarantee


Online Courses For Job

Summary

Price
£99 inc VAT
Or £33.00/mo. for 3 months...
Study method
Online
Duration
10 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
CPD
10 CPD hours / points
Additional info
  • Tutor is available to students
  • TOTUM card included in price What's this?

Add to basket or enquire

Overview

Become a Pro with these valuable skills. Start Your Course Today. Save up to 90%!

CPD

10 CPD hours / points
Accredited by The CPD Certification Service

Description

Microsoft Excel Certification Level 2

This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions.

The Microsoft (MS) Excel Certification Level 2 course will take what the team member learnt in the Level 1 course and expand on it, teaching them more advanced concepts than those that were presented in the earlier course.


What’s Covered in the Course?


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.
What are the Benefits of the Course?

Excel data analysis tools have applications throughout the organisation;
As with the Level 1 course, the Level 2 course comprises short modules, accessible on any device that can connect to the internet;
Lifetime access to the course materials allows learners to revise any of the material at any time in the future;
Online learning support is provided for your employees

Who is this course for?

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Requirements

The course does not require any pre-knowledge to pursue the course. And it is compatible with any kind of device. You will get the same experience in learning whether you are using Windows, Mac, a smartphone or tablet. You can access the course materials with any kind of connection, from anywhere, without any limitation!

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.