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.
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.
Certificates
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 info@harleyoxford.com.
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
