| Title | Excel: further functions |
| Category | Digital Skills |
| Overview | Virtual and in-person sessions are available for this course. Please check when booking.
This training is delivered on a Windows machine using the latest version of Excel from the Microsoft Office 365 suite. Participants wanting to follow along, should make sure they have the software installed before the session starts.
Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365
OUTLINE
Improve the efficiency and productivity of your Spreadsheets by learning how to construct functions, manipulate data and format outputs. In this training session, you’ll work through a series of exercises using the following:
- Autofill, paste special and format painter
- Tables vs named ranges
- Relative vs absolute referencing
- Concatenate / text to tables
- IF functions eg IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF etc
- VLOOKUP, XLOOKUP
For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following:
UKPSF areas of activities: A2, K4
JISC framework: 1, 2
If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient. |
| Learning outcomes | - Learn how to use some basic excel functions such as tables, naming cell ranges and concatenate
- Learn how to create a basic VLOOKUP
- Learn how to apply basic formulas such as SUMIF, COUNTIF
|
| Presenter | Katherine Trafford |
| Location | ITex2 Zoom link: https://essex-university.zoom.us/j/93483746346 |
| Campus | zoom |
| Date and time | 10:00 to 12:00 Wednesday 1 May 2024 |
| Duration | 02:00 |
| Available places | 14 |
| Presenter | Katherine Trafford |
| Location | ITex2 Zoom link: https://essex-university.zoom.us/j/93483746346 |
| Campus | zoom |
| Date and time | 10:00 to 12:00 Tuesday 25 June 2024 |
| Duration | 02:00 |
| Available places | 18 |
| Presenter | Katherine Trafford |
| Location | ITex2 Zoom link: https://essex-university.zoom.us/j/93483746346 |
| Campus | zoom |
| Date and time | 10:00 to 12:00 Tuesday 9 July 2024 |
| Duration | 02:00 |
| Available places | 19 |
| University of Essex employee | Use the link provided above to book your place via HR Organiser. |
| Partner institution | Please discuss with your point of contact at your Partner Institution in the first instance. |
| Student Union contractors; PhD students | Please contact the Organisational Development team. |