Please wait a moment loading...
01920 897663
  • Login
  • Contact
SST SST
  • Home
  • Courses
  • Delivery Method
    • Online Training
    • In-house Training
    • Blended Learning
  • SPEAK TO AN ADVISOR
  • Login
  • Contact Us
SPEAK TO AN ADVISOR

Microsoft Excel Certification Level 2

THIS COURSE IS INCLUDED AS PART OF THE STAFF TRAINING PACKAGE
Microsoft Excel Intermediate
Approved Course

A005786

  • Course Code: UKFEC16MXI
  • Duration: 10 hours
  • Qualification: Microsoft Excel Certification Level 2
  • Exams Included: Yes
  • Compatibility: All major devices and browsers
  • Delivery method: Online (In-house also available )
ENQUIRE
NOW
15710

Microsoft Excel Certification Level 2

Please Note: 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.


Course Modules/Lessons

Module 1: SumProduct Formula

Module 2 : Data Validation With Date

Module 3 : Data Validation with Whole Numbers

Module 4 : Data Validation with List Feature

Module 5 : ABS Function

Module 6 : CHAR Function

Module 7 : CLEAN Function

Module 8 : CODE Function

Module 9 : EXACT Function

Module 10 : AVERAGEA Function

Module 11 : AVERAGEIF

Module 12 : AVERAGEIFS Function

Module 13 : CELL Function With 10 Variations

Module 14 : LARGE Function

Module 15: MAX Function

Module 16: MEDIAN Function

Module 17: MIN Function

Module 18: MODE Function

Module 19 : N Function

Module 20 : RANDBETWEEN Function (Insert Random Numbers)

Module 21 : RANK Function

Module 22 : Remove Duplicate Values

Module 23 : ROUND Function Up/Down

Module 24 : Add Custom Background Image

Module 25: Change Text To Lower Case

Module 26: Change Text To Upper Case

Module 27: Change Text To Proper Case

Module 28: Insert Special Character

Module 29: Use Autofill : A Time Saving Trick

Module 30: Treemap Chart

Module 31: Sunburst Chart

Module 32: Use Tables

Module 33: Use Templates

Module 34: Use Themes

FIND OUT HOW WE CAN HELP TRAIN YOUR STAFF



FAQ's

  • Who can take the Microsoft Excel Certification Level 2 course?

    There are no entry requirements to take the course.
  • What is the structure of the course?

    The course is broken down into 34 individual modules. Each module takes between 20 and 90 minutes on average to study. Although students are free to spend as much or as little time as they feel necessary on each module.
  • Where / when can the course be studied?

    The course can be studied study at any time and from any internet connected device
  • Is there a test at the end of the course?

    Once you have completed all 34 modules there is a multiple choice test. The questions will be on a range of topics found within the 34 modules. The test, like the course, is online and can be taken a time and location of your choosing.
  • What is the pass mark for the final test?

    The pass mark for the test is 70%.
  • What happens if a user fails the test?

    If the user doesn’t pass the test first time they will get further opportunities to take the test again after extra study. There are no limits to the number of times a test can be taken.
  • How long does it take to complete the Microsoft Excel Certification Level 2 course?

    We estimate that the course will take about 10 hours to complete in total, plus an additional 30 minutes for the end of course test.

FIND OUT HOW WE CAN HELP TRAIN YOUR STAFF

Complete the short form below and one of our advisors will be in touch to tell you how your staff can have access to all of our courses for a low monthly fee.

Learn with Confidence

We work in association with industry experts including:

approved online courses

As featured in:

course partners
SST

Part of the Be-a Education Family

Reg no: 08761384
VAT no: 128024147

Visit Our Learning Portal
  • Blog
  • Terms & Conditions of Supply of Products
  • Terms of Website Use
  • Website Acceptable Use Policy
  • Privacy Notice
  • Cookies Policy

© Staff Skills Training 2021

close