Skip to content
0

Excel - Advanced Functions and Formulae

Level X
Cheltenham

Course Overview

Part Time
Certificate
Shortlist and Apply

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 course is aimed at those who are aged 19 and over (as at 31st August of the academic year you are applying for) who are looking to improve their skills to move into work or progress into more sustainable employment.

    In some circumstances you may be able to access this course for free.

    For further information on fee waivers available or 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

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

£85

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