This 3-hour session is designed for learners who already have a good understanding of spreadsheet basics and want to take their skills to the next level. The course focuses on practical techniques for data analysis, automation, advanced formulas, and efficient spreadsheet management using both Microsoft Excel and Google Sheets.
This course is taught at the Slough & Langley College campus in Langley, Berkshire, with access to industry-standard facilities and industry-experienced tutors.
XP1MICT2L0
09:30
12:30
Mon, 30 Nov 2026
Basic command of the English Language
Basic knowledge of Excel (entering data, using simple formulas)
XP1MICT2L0
09:30
12:30
Mon, 22 Mar 2027
Basic command of the English Language
Basic knowledge of Excel (entering data, using simple formulas)
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.
