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
£120.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, 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 |
|
|