Skip to content
0
Advanced Functions and Formulae

Advanced Functions and Formulae

Level X
Cheltenham

Course Overview

Part Time
Certificate
Shortlist and Apply

Build on your existing Excel knowledge with this practical evening workshop, designed for professionals who want to develop more advanced spreadsheet skills and become more confident using Excel in the workplace. Delivered outside of standard working hours, it's ideal for fitting around your existing work commitments.

If you've previously completed our Excel – Functions & Formulae workshop, or you already have a good understanding of creating formulas and functions, this session will help you take your skills to the next level. You'll learn how to work more efficiently with complex data, automate calculations and make the most of Excel's advanced features.

During the workshop, you'll cover:

• A refresher on basic functions, absolute cell references and named ranges.

• Using SUMIF and COUNTIF to calculate or count values that meet specific criteria.

• Using HLOOKUP and VLOOKUP to retrieve information from other tables within a workbook.

• Creating formulas that link across worksheets and multiple Excel workbooks.

• Using Consolidation to combine and summarise data from related worksheets and workbooks.

Advanced Excel skills are highly valued across a wide range of industries. Whether you're looking to improve your performance in your current role, prepare for new responsibilities or enhance your CV, this workshop will help you work more efficiently and confidently with data.


  • You will need to have previously attended the Excel – Functions & Formulae workshop or already have a good understanding of creating basic functions and formulas.

    This course is designed for adults aged 19 and over (as of 31 August in the academic year you are applying for) who are looking to develop their Excel skills, refresh their existing knowledge or enhance their professional development.

    In some circumstances, you may be eligible to access this course free of charge.


  • Your tutor will be able to advise of any further training opportunities.

Shortlist and Apply

To register your interest, please call Student Services on 0345 1 55 2020

Advanced Functions and Formulae

What You Will Pay

British and European Union students

You will pay

£93

for your course

Your course could be free of charge as you may be eligible for financial support to help pay your tuition fees, travel, exams, materials or childcare.

When you enrol you’ll need to pay any course fees for the first year, which you can do by direct debit, cash, debit card or credit card.

Please contact us for more information.

0345 155 2020

To register your interest, please call Student Services on 0345 1 55 2020

There is little left in our modern lives that isn’t affected by computers and technology. You’ll find computing at the centre of almost all businesses and, as a result, employment opportunities within the sector are huge.

We offer a range of qualifications that support a variety of interesting careers, from games and apps development, through to forensic computing and cyber security. Our industry-experienced lecturers will give you the knowledge and skills you need to develop your own computing competency, in an area that interests you.

A computing course is an ideal route to employment, or to progress on to higher-level qualifications at GC or university. You’ll have access to state-of-the-art equipment and software, including a dedicated network for computing students, so that you can get familiar with the latest technology and prepare for the systems you’ll use in the business world.

View Courses
Play Video
Amelia Thomas

My interest in cyber was sparked when I went on a CyberFirst Advanced residential course which I loved, so thought why not pursue cyber security as a career choice! If you have an interest in IT and problem solving, then definitely consider studying cyber.

Amelia Thomas

DIGITAL FORENSICS AND CYBER SECURITY, HND

Cheltenham Campus
Finley Walker

I've always had an interest in cyber security. You'll always have a job, everywhere needs cyber security, it's a growing industry and you can go into anything really. The opportunities are endless.

Finley Walker

Forensic Computing Level 3

Cheltenham Campus
Read More
Matt Dee

Studying at Gloucestershire College was one of the best decisions I have made in terms of my education and setting me up for my future career. It’s made me realise what field I would like to go into.

Matt Dee

Digital Forensics and Cyber Security HND

Cheltenham Campus
Read More
Krish Patel

There is a lot of freedom in computing. I'm enjoying the computer hardware and software programming side of the course as well as cryptography and cryptanalysis. We just recently went on a trip to The National Museum of Computing which was great.

Krish Patel

Forensic Computing Level 3

Cheltenham Campus
Taylor Watson

I feel like if you’re a student who feels ready to work, or someone who wants to learn more than you can at school, I would definitely recommend an apprenticeship; I can only praise how quickly it’s enabled me to evolve as a person and in my career.

Taylor Watson

CYBER SECURITY, DEGREE APPRENTICESHIP

Cheltenham Campus

Proud To Be Working With

Cloud Tamers Logo
Bamboo Connect Grow Logo
SITM Logo
Techop Solutions Group Logo

View Courses

Next Steps

Find out more

Check the progress of your application and find out everything you need to know about the application and enrolment process at GC.

Open Events & Campus Tours

Join us for our next event and check us out for yourself. We hold Open Evenings several times a year where you can explore our campuses, meet the teaching teams and explore life at GC.

Application FAQs

Check out some of our most frequently asked admissions questions or get in touch with the team.