Excel Intermediate
Awarding Body Image Branding Image
About this course

This course aimed at experienced users of Excel that have previously attended an Introductory Excel course or who have equivalent experience of Excel.

If you are an employer and require one or more employees to enrol onto this course please contact 0845 345 2235 or BusinessDevelopment@wiltshire.ac.uk

What will I learn?

This course will teach you how to:

Use Excel for more complex workplace tasks

Use a variety of built in functions

Create effective and visual ways of displaying data

You will learn how to:

Create complex formulae

Use and understand the relative/absolute/mixed function

Link data between worksheets/workbooks

Name a range for any frequently used constant or formulae

Sort and filter data

Use and understand conditional functions, including an introduction to the IF function

Show data visually with the use of conditional formatting and Sparklines

Entry requirements

This course is suitable for those that already have experience of using Excel on a day to day basis and wish to extend their knowledge of the more complex features of the software.

Study, assessment and qualifications

The is a bespoke training course written by our Wiltshire Enterprise trainer. Upon successful completion, you will receive a certificate of competance.

Additional costs and information

This course is also available as an in-house company course at your chosen company location or at any of our satellite centres in Devizes, Corsham or Warminster.

If you have any questions please contact 0845 345 2235 or BusinessDevelopment@wiltshire.ac.uk

What could I do next?

Successful candidates may want to proceed to the Advanced Excel course.