Excel - Intermediate
This course will enhance your ability to manipulate data and practice functions.
- 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
For anyone who has a basic knowledge of Microsoft Excel and would like to consolidate and expand their understanding and skills.
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 email@example.com
(Prices do not include VAT)