Excel - Intermediate - Masterclass

This course may be delivered online - please see the course information box to confirm.

Develop your skill to take advantage of the more advanced features of Excel

Course Content

This course will cover:
Working with large worksheets- viewing options, zoom, freeze and split
Printing large worksheets- page breaks, multiple sheets
Working with multiple worksheets-navigating , linking and creating 3D formula
Conditional formulas and formatting-using IF function,
Sorting- Auto filter, custom filter, advanced filter

Entry Requirements

To be eligible for this course you must be 19 or over on the start date of the course.

Those who wish to take advantage of the advanced features on Excel and who have completed an introduction course or have equivalent knowledge.

First Class Requirements

Pen, paper and USB memory stick

Assessment Methods

Course fee includes:
Training booklet
Certificate of completion

If you have any further questions please contact:

Further Study Options

You can progress to:
Another Microsoft Office short courses
Office Skills Level 2

This course covers the majority of topics required for Microsoft Office Specialist, if you are interested in your suitability to apply to take the assessment for this accreditation you will need to have a more detailed discussion with your course tutor at the end of your course.Further study may be required.

Additional Information

As a result of the government’s closure of schools and colleges, some of our courses will be delivered through remote learning including video conferencing, (using Skype, Zoom, Microsoft Teams) and email contact with your tutor.

If your course is indicated as an ONLINE COURSE, you will need either a PC (with a camera and microphone), laptop, tablet, smartphone and access to the internet to be able to join the lessons. Lessons will run at the published time – so be ready and set up to join in.

We hope you will enjoy this new approach to learning – many of our learners have commented on how they are enjoying the classes and have improved their IT and digital skills in the process.

Please don't worry if some of this is new to you - you are not alone! See here for guidance on how to use our simple software. If you are experiencing any problems with connection or installing software for your online class please contact our learning resource team on We are here to help you.

If you are booking and paying for the course yourself
You can enrol directly online or in person at one of our centre

If your employer is paying for you or you are an employer wishing to pay for your staff

Please email stating:
1.The course code and title
2. The names of the learners and the total fee you are paying
3. The name and contact details for invoicing
We will then contact you to confirm your booking.