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
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
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.
The is a bespoke training course written by our Wiltshire Enterprise trainer. Upon successful completion, you will receive a certificate of competance.
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
Successful candidates may want to proceed to the Advanced Excel course.