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

£106.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, 7 July, 2020 (9.30 am - 3.30 pm)	HSC Leadership Centre	Barbara Patton Caroline Baird	Patricia Bell
Excel Intermediate	Tuesday, 8 September, 2020 (9.30 am - 3.30 pm)	HSC Leadership Centre	Barbara Patton Caroline Baird	Patricia Bell
Excel Intermediate	Tuesday, 10 November, 2020 (9.30 am - 3.30 pm)	HSC Leadership Centre	Barbara Patton Caroline Baird	Patricia Bell
Excel Intermediate	Thursday, 7 January, 2021 (9.30 am - 3.30 pm)	HSC Leadership Centre	Barbara Patton Caroline Baird	Patricia Bell