Students Staff

Learning activity

Description
TitleExcel: conditional formatting
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/92161555447 Task workbook: https://essexuniversity.box.com/s/pzb3oc98lzbc634a1mbq20afj6ppoj7z 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 Conditional formatting in Excel allows you to automatically apply formatting such as colours, icons, and data bars, to one or more cells, in order to highlight specific data in your spreadsheet. Applying conditional formatting to your data can not only help make your data easier to read, it will also allow you to isolate and then sort and filter your data to get specific results. In this training session you will follow a series of conditional formatting examples using both pre-set functions as well as applying a variety of formulas for more advanced formatting. - Naming ranges to use in formulas - Using pre-set conditional formatting rules - Modifying pre-set rules - Using a variety of formulas to create conditional formatting rules 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 create conditional formatting rules using formulas
  • Learn how to name a data range
  • Learn how to use Excel's preset conditional formatting functions
Schedule
Book Event 1
PresenterSally Swaine
LocationITex5 Task Booklet: http://bit.ly/ITex5-tasks
Campuszoom
Date and time10:00 to 12:00 Wednesday 2 June 2021
Duration02:00
Available places16
Book Event 2
PresenterSally Swaine
LocationITex5 Zoom link: https://essex-university.zoom.us/j/92161555447
Campuszoom
Date and time10:00 to 12:00 Wednesday 7 July 2021
Duration02:00
Available places20
Book Event 3
Presenter
LocationITex5 Zoom link: https://essex-university.zoom.us/j/92161555447
Campuszoom
Date and time10:00 to 12:00 Wednesday 1 September 2021
Duration02:00
Available places20
Book Event 4
PresenterSally Swaine
LocationITex5 Task Booklet: http://bit.ly/ITex5-tasks
Campuszoom
Date and time10:00 to 12:00 Wednesday 6 October 2021
Duration02:00
Available places20
Book Event 5
PresenterSally Swaine
LocationITex5 Zoom link: https://essex-university.zoom.us/j/92161555447
Campuszoom
Date and time10:00 to 12:00 Wednesday 3 November 2021
Duration02:00
Available places20
Book Event 6
PresenterSally Swaine
LocationITex5 Task Booklet: http://bit.ly/ITex5-tasks
Campuszoom
Date and time10:00 to 12:00 Wednesday 1 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.