Microsoft Excel 2016 Intermediate Level

Welcome to the Microsoft Excel 2016 Intermediate Level Course. The Microsoft Excel 2016 Intermediate Level Course provides a fantastic insight into using the Excel software. The course will explore various ways in which you prepare financial reports in the Excel system.

In order to complete the course candidates must do the following:

    • Read the course modules
    • Complete final assessment test

How can I access the Software?

As part of the course, it is useful for you to follow along and practice each function discussed by using the trial version of the Excel software. The free Excel trial will give you access for 1 month.

Try Excel for Free

We hope you enjoy the course and good luck! As part of the course it is essential for you to read the course information, please use the button below to access the course instructions prior to starting the course.

Module 1 Defined Names
Defined Names
Unit 1 Defined Names
Module 2 Sorting Data
Sorting Data
Unit 1 Sorting Data
Module 3 Excel Tables
Excel Tables
Unit 1 Excel Tables
Module 4 Filtering Data
Filtering Data
Unit 1 Filtering Data
Module 5 Chart Basics
Chart Basics
Unit 1 Chart Basics
Module 6 Chart Design Tools
Chart Design Tools
Unit 1 Chart Design Tools
Module 7 Chart Format Tools
Chart Format Tools
Unit 1 Chart Format Tools
Module 8 More About Charts
More About Charts
Unit 1 More About Charts
Module 9 Introduction to Functions
Introduction to Functions
Unit 1 Introduction to Functions
Module 10 Date Functions
Date Functions
Unit 1 Date Functions
Module 11 Information Functions
Information Functions
Unit 1 Information Functions
Module 12 Logical Functions
Logical Functions
Unit 1 Logical Functions
Module 13 Financial Functions
Financial Functions
Unit 1 Financial Functions
Module 14 Find and Replace
Find and Replace
Unit 1 Find and Replace
Module 15 Headers and Footers
Headers and Footers
Unit 1 Headers and Footers
Module 16 Adding Comments
Adding Comments
Unit 1 Adding Comments
Module 17 Conditional Formatting
Conditional Formatting
Unit 1 Conditional Formatting

Final Exam

To get to this stage you should now have completed all course modules above and be ready to take your Microsoft Excel Beginners Level exam.

We would strongly advise that you read through the entire course units more than once and make relevant notes where necessary ensuring that you have absorbed all the information.

The Test

To book your exam the fee is £9.00 and will give you unlimited attempts to pass. Use the button below to book your exam.

Once you have booked the exam a link will be emailed to you within 24 hours.

Exam Results & Certifications

The course includes a FREE Digital certification which is issued within 7 – 12 working days.



Ready to present your newly accomplished skills and knowledge? Take a look below to order your Hard Copy Certified Accredited Certificate for £19.99.

Once you have placed your order, one of the team will process your certificate and dispatch it to your address via Royal Mail Post and so you should receive it within 7-14 days of your order.

We’ll let you know when it’s on the way.

To order your course Certificate, simply click the button below.

This will add the certificate to your basket; you can add as many as you like.

We will process and send each certificate out individually

Once you have ordered the certificate, please send us an email with your postal address to

Order your course certificate

Hard Copy Certificate – £19.99


Order your Course Extension

Course Extension – £14.99

  • Course Extended for 12 Months
  • Continual Access to Exams and Testing
  • 12 Months Access to Student Services