Students Staff

Learning activity

Description
TitleExcel: further functions
CategoryDigital Skills
OverviewIMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using 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. PREPARATION FOR THE TRAINING The Zoom link is: https://essex-university.zoom.us/j/98578993558 Task workbook: https://essexuniversity.box.com/s/ar2rspxvvprt932i6g6b67rf5hxl9z23 This training is delivered using Excel 2016. 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 - Basic functions eg SUM, MAX, MIN, DATE eg TODAY() - Concatenate / text to tables - IF functions eg IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF etc - Strings eg LEFT, MID, RIGHT - 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 paste special, naming cell ranges and concatenate
  • Learn how to create a basic VLOOKUP
  • Learn how to apply basic formulas such as SUMIF, COUNTIF
Schedule
Book Event 1
PresenterSally Swaine
LocationITEx2 task booklet: https://bit.ly/ITEx2-tasks
CampusCourse documents
Date and time10:00 to 12:00 Tuesday 1 June 2021
Duration02:00
Available places18
Book Event 2
PresenterSally Swaine
LocationITEx2 task booklet: https://bit.ly/ITEx2-tasks
CampusCourse documents
Date and time10:00 to 12:00 Tuesday 6 July 2021
Duration02:00
Available places20
Book Event 3
PresenterSally Swaine
LocationITex2 Zoom link: https://essex-university.zoom.us/j/98578993558
Campuszoom
Date and time10:00 to 12:00 Tuesday 7 September 2021
Duration02:00
Available places20
Book Event 4
PresenterSally Swaine
LocationITEx2 task booklet: https://bit.ly/ITEx2-tasks
CampusCourse documents
Date and time10:00 to 12:00 Tuesday 5 October 2021
Duration02:00
Available places20
Book Event 5
PresenterSally Swaine
LocationITEx2 task booklet: https://bit.ly/ITEx2-tasks
CampusCourse documents
Date and time10:00 to 12:00 Tuesday 2 November 2021
Duration02:00
Available places20
Book Event 6
PresenterSally Swaine
LocationITEx2 task booklet: https://bit.ly/ITEx2-tasks
CampusCourse documents
Date and time10:00 to 12:00 Tuesday 7 December 2021
Duration02:00
Available places20
Booking instructions
University of Essex employeeUse the link provided above to book your place via HR Organiser.
Partner institutionPlease discuss with your point of contact at your Partner Institution in the first instance.
Student Union contractors; PhD studentsPlease contact the Organisational Development team.