If functions are used when we want to specify a criteria to limit our function to. For instance, if we were interested in values above a certain amount we could use =countIf in order to count the number of the values in a range, that are above a certain value. There are multiple...
Search results
IF functions
Relative cell references and absolute cell references
Cell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:
The fill handle is shown when a cell is selected (by left clicking it), you will...
Excel Tutorials
Below are a list of Excel guides currently available, these are a work in progress and will be added to as time goes on. If however you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.
BeginnerQuick...
Contents
What to do if you've tested positive for COVID-19
What to do if you live with/have been in close contact with someone who has tested positive
NHS guidance
What can I do to help keep myself and other safe?
Covid pass for travel abroad
University contacts...
Overview
Although we take all of the cyber security precautions that any other major organisation should do, there are some vulnerabilities that technology alone cannot fully avoid, and example of which, is social engineering (see section lower down). It is important that you are aware of how to...
Overview
The University of Chichester provides the following types of transcripts, depending on when you completed your studies:
Basic Academic TranscriptBasic academic transcripts will list all the modules or subjects you studied in each year, the marks or grades you achieved for each...
Chichester International Advice Service at the UniversityMore information: International Student Support section on the University's websiteMore information: Book an appointment via the Student Support PortalMore information: Visit our Moodle pages Chichester International Advice
The University of Chichester Library Service is committed to open access for staff, students, and its wider communities.
Members of the public may use all open access material for reference use only. We also offer a ‘Walk-in Access’ scheme for use of Microsoft Office, our electronic...
Screening for specific learning differences such as dyslexia and dyspraxiaWhat is a screening?
A screening is a meeting between you and a specialist Adviser that lasts up to one hour, during which time you will have the opportunity to discuss your difficulties. The screening is a way of...
Reporting noise in silent areas
If you are working in the silent areas and the noise levels are disturbing you, please let a member of the library or Support and Information Zone (SIZ) teams know. Email help@chi.ac.uk or text the library team on 07876 870 711 and we will respond.
Study areas...