Latest COVID Update – click here for more info.

Excel - Advanced Functions and Formulae

  • Students

    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.

Shortlist and Apply

Course Variant

Excel - Advanced Functions and Formulae



Choose a Start Date

2 December 2020 at 9:30 am finishes 1:00 pm

1 February 2021 at 9:30 am finishes 1:00 pm

29 March 2021 at 9:30 am finishes 1:00 pm

21 June 2021 at 9:30 am finishes 1:00 pm

Shortlist and Apply

Please select the specific course you would like to apply for.

What You Will Pay

Please select a course to see pricing information.

Why Gloucestershire College?

We have a lot of experience offering Apprenticeships and work-related training. We have industry-standard facilities and experienced teaching staff which provide the ideal complement to work-based learning.

We are here to help

0345 155 2020

90% of students would recommend GC and 95% said that the teaching on their course was good.

Ofsted has rated us good.

  • We offer industry relevant facilities
  • Our lecturers are passionate subject specialists
  • Employers value our students' skills

We'll look after you. We have dedicated teams to help you and a great Learning Mentor scheme.