Excel - Intermediate

 

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.

 

 

 

Method

1 day

Cost

£101.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
Excel Intermediate Tuesday, 12 November, 2019
(9:30am-15:30pm )
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Excel Intermediate Tuesday, 7th January, 2020
(9:30am-15:30pm )
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Excel Intermediate Wednesday, 25th March, 2020
(9:30am-15:30pm )
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin