Skip to content
referalearnerFind my match

Excel - Advanced Functions and Formulae

at Gloucestershire College, Gloucester · college

Not statedOther coursesOther1 dayPart timeFree

What the college says

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 workbooksUsing 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

What you need to get on

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.For further information please contact our Jobsmart team on 01452 563278 or email jobsmart@gloscol.ac.uk

How you are assessed

Short courses, awards and certificates that do not fit the main routes.

What this level means

The level was not stated in the source data.

Is it open to 16 to 18 year olds?

The provider describes this as being for learners aged 19 and over.

Where it runs

  • Cheltenham Campus

    Cheltenham Campus, Cheltenham, GL51 7SJ

    DaytimeClassroom based
    Check the journey

Who else teaches this exact qualification

Same qualification, different college. Entry requirements and how it is taught can differ a lot between them, which is the whole reason to compare.

See all 17 providers teaching it