| Title | Excel: managing and analysing data |
| Category | Digital Skills |
| Overview | Virtual and in-person sessions are available for this course. Please check when booking.
Virtual sessions will be delivered via Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom.
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
The aim of this session is to help you prepare your data for analysis, and effectively extract important information from large spreadsheets. Focusing on how to clean, organise and analyse large amounts of data using Excel’s tools, features and functions, this session will include:
• Arranging data ready for analysis
• Cleaning up data, including duplicates and stray values
• Sorting and filtering data
• Using new features like Power Query and dynamic arrays
• Using IF functions and PivotTables for basic analysis
• Basic concepts of data analysis
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 | |
| Presenter | Katherine Trafford |
| Location | Zoom Training |
| Campus | Zoom Training |
| Date and time | 14:00 to 16:30 Thursday 30 January 2025 |
| Duration | 02:30 |
| Available places | 20 |
| Presenter | Katherine Trafford |
| Location | Zoom Training |
| Campus | Zoom Training |
| Date and time | 09:30 to 12:00 Tuesday 25 February 2025 |
| Duration | 02:30 |
| Available places | 20 |
| Presenter | Katherine Trafford |
| Location | Zoom Training |
| Campus | Zoom Training |
| Date and time | 09:30 to 12:00 Thursday 20 March 2025 |
| Duration | 02:30 |
| Available places | 20 |
| Presenter | Katherine Trafford |
| Location | Zoom Training |
| Campus | Zoom Training |
| Date and time | 09:30 to 12:00 Wednesday 16 April 2025 |
| Duration | 02:30 |
| Available places | 20 |
| 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. |