We have launched a new website and applicants will need to reset their password before accessing their account.  Reset your password.

Skip to content
0

Excel - Advanced Functions and Formulae

Level X
Cheltenham

Course Overview

Part Time
Certificate

If you have previously attended Excel - Functions and Formulae or you already have a good knowledge of creating basic functions and formula, this is a great way of expanding your skills further using some more advanced calculation and option within Excel.

The workshop will cover:

  • Revision of basic functions, absolute cell references and naming ranges.
  • Using SUMIF and COUNTIF, which will count or add up values, if a given criteria is met.
  • Use HLOOKUP and VLOOKUP to display information from a separate tables of data stored in the workbook.
  • How to create formulas that link across sheets or other Excel workbooks
  • Using Consolidation to summarise or join together related sheets and workbooks.

People with a good level of Excel skills are sought after by employers. This course will make you standout out in the workplace.

  • You will need to have previously attended the Excel - Functions and Formulae workshop or already have a good knowledge of creating basic functions and formula. 

    This workshop will be free of charge for learners aged 19 and over (as at 31st August of the academic year) in receipt of certain benefits or employed learners earning less than £20,319.00 annual gross salary.

    For further information and to secure a place please contact our Jobsmart team on 01452 563278 or email jobsmart@gloscol.ac.uk

  • 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

What You Will Pay

Our departments are the training ground for generations of artists, writers, police officers, athletes and other amazing people!

British and European Union students

Age: 16-18

You will pay

£0

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

British and European Union students

Age: 19+

You will pay

£65

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

Overseas students

Please contact us to discuss your fees for this course

0345 155 2020