A 3-Hour MS Excel intermediate -Advanced Course – This session is perfect for learners who already understand Excel basics and want to improve their skills for data analysis, automation, and more efficient spreadsheet use.
Course Overview
Course Code
XP1MICT2L0
Course Fee
£50.00
Start Time
10:30
End Time
13:30
End Date
Fri, 17 Oct 2025
Entry Requirements
Basic command of the English Language
Basic knowledge of Excel (entering data, using simple formulas)
Course information
By the end of the course, you will be able to:
★ Use complex formulas, including IF, LOOKUP, and conditional functions
★ Analyse data using filters, pivot tables, and conditional formatting
★ Create charts and dashboards with dynamic and visual elements
★ Save time with tools like Flash Fill, named ranges, and data validation
★ Automate tasks using basic macros and understand cell referencing
★ Collaborate effectively and prepare spreadsheets for printing and sharing
The tutor will tailor the session to meet individual learner needs, focusing on the skills they want to develop and how they intend to use them in everyday life.
3 Hour session
The course will be delivered face-to-face in a computer room at the college.
No written exams – just practical, supportive learning
Upon successful completion of the course, you will receive a college certificate.
Once you have completed this workshop, you will be ready to progress to other IT workshops from our programme.