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