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 virtual delivery

Due to current guidelines regarding social distancing, we have taken the decision to run our IT course portfolio virtually until further notice.

 

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

Cost

£150.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	Thursday, 7 October, 2021 (09:30-17:00)	HSC Leadership Centre	Keith Bailey	Lauren Camlin
Excel Intermediate	Thursday, 4 November, 2021 (09:30-17:00)	HSC Leadership Centre	Keith Bailey	Lauren Camlin
Excel Intermediate	Thursday, 2 December, 2021 (09:30-17:00)	HSC Leadership Centre	Keith Bailey	Lauren Camlin