Excel - Intermediate

 

Courses By Theme

Tailored Programmes

IT Courses

Enter a keyword(s) below to search through our courses.


Purpose

This course will enhance your ability to manipulate data and practice functions.

Learning Outcomes

  • Use autofill to complete a series
  • Apply conditional formatting to data within cells
  • Filter data within lists
  • Apply subtotal to data within lists
  • Use absolute cell referencing
  • Use functions such as If, Countif, Sumif, Averageif
  • Link and consolidate data between worksheets
  • Apply protection to workbooks and worksheets
  • Create and format charts
  • Create templates

 

 

Audience

For anyone who has a basic knowledge of Microsoft Excel and would like to consolidate and expand their understanding and skills.

 

When applying for this course please select the Microsoft Office version that is applicable to you. This course is run in 2007/2010.

 

If applying for the 2007/10 course please state which Microsoft Office version you currently use on the "Additional Information" section of the application form.

 

Method

1 day

Cost

£97.00
(Prices do not include VAT)

Please select an appropriate time and venue and click the apply button to register for this course.

Label Dates & Times Venue Facilitator Administrator
Office 2007/2010 Wednesday 22nd November 2017
(9.30am - 3.30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Cathy Holt
Office 2007/2010 Tuesday 19th December 2017
(9.30am - 3.30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Cathy Holt
Office 2007/2010 Wednesday 7th February 2018
(9.30am - 3.30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Cathy Holt
Office 2007/2010 Thursday 29th March 2018
(9.30am - 3.30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Cathy Holt