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 delivery

We are pleased to be introducing a hybrid learning approach for all our I.T. programmes. Please check course information to see if your course date is held in centre or online via Microsoft Teams.

 

If you have any questions concerning this, please do not hesitate to contact our Digital Consultancy team via digitallearning@leadership.hscni.net

Cost

£175.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 Wednesday, 5 April, 2023
(09:30- 15.30)
HSC Leadership Centre Daniel Bled
Lauren Camlin
Excel Intermediate Wednesday, 3 May, 2023
(09:30- 15.30)
HSC Leadership Centre Daniel Bled
Lauren Camlin
Excel Intermediate Wednesday, 28 June, 2023
(09:30- 15.30)
HSC Leadership Centre Daniel Bled
Lauren Camlin