Complete Your Profile

Please provide your first and last name to continue.

Sign out

Warning: You will need to sign in again to access your account.

Are you sure you want to sign out?

You will be logged out of your account.
Digital Skills

Microsoft Excel - Intermediate

Download PDF

Course Overview

This half-day course is designed to assist those wishing to build upon their basic knowledge of Microsoft Excel.


Course Content

  • Relative and absolute cell referencing
  • Using the =If () function and logical functions
  • Understanding statistical formulas such as MAX, MIN etc.
  • Using the =VLookup() function
  • Date, time or percentage formatting
  • Understanding the auto-calculate, basic filter, table and sort functions
  • Using the freeze pane function
  • Creating a basic graph from data, editing and formatting the chart and changing chart type


Benefits

This course will equip you with a sound intermediate level knowledge of excel and is the second of our Excel series, the others being Excel Beginners and Excel Advanced.


Prerequisites

Ideally you will have completed the ‘Beginners’ module or have a good working knowledge of other Excel versions to begin with.


Next Steps

If you would like to book a place on this course please click on the ‘Book Course’ button to the right of this page and login or register for a user account to complete your booking(s). Any queries please do not hesitate to contact us via admin@gta.gg or call us on 01481 224570.

If no date is scheduled for this course at the present time please click on the ‘Register Interest’ button and login or register for a user account so that we can add you to our course interest register. This register allows us to contact our tutors and finalise dates for a course as soon as we have a few people who have expressed their interest, so the more delegates who register their interest, the sooner we can schedule a particular course.

Course Details

Start date

25 February 2026

CPD Points

4.0

Price

£215.00

Length

Half day (09:00-13:00)

Course Tutor

Tonia Meakin

Digital Skills Lecturer at The Guernsey Institute. With over 20 years of experience across various roles in the IT industry, she has a real passion for teaching and upskilling. Specialising in Microsoft, she can provide you with the knowledge and confidence to succeed with technology, regardless of your current skill level.

Select which organisation you would like to book for

Select Attendees to Book

Booking Summary

Free Course Summary

Register Interest Summary

Course
Course Title
Notification
You will be notified when this course becomes available for booking

Apply for course

Message

Join others bettering their lives through learning

quote left
Jacqui has a very understanding way about her and no question is a stupid question.
Emma Sparks
quote left
In many ways exceeded my expectations, I didn't think it was possible to train on Excel in such an illuminating way. Jacqui is a great tutor
Peter C
quote left
Jacqui is excellent at explaining the process in simple terms
Tracey R

Related Courses

Take your career to the next level with higher education that works for you

View all courses
Digital Skills
Microsoft Excel - Advanced
This half-day course is designed to assist those wishing to build upon their knowledge of Microsoft Excel.

16 December 2025

Half day (09:00-13:00)

Find out more
Digital Skills
Microsoft PowerPoint - Intermediate/Advanced
The Microsoft PowerPoint Intermediate to Advanced Level course is suitable for those with a working knowledge of PowerPoint who wish to use the more...
Find out more
Digital Skills
Microsoft Word - Beginners
On completion you will be far more confident in your ability to create and amend Word documents. You will understand how important it is to use the...
Find out more
Data Protection Digital Skills Director Development Finance Human Resources Law Leadership & Management Personal Development Project Management Sales & Marketing Wellbeing

Sign up to our mailing list

Sign up for more info including course updates, upcoming courses and the latest news from the GTA