This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
Summation, the addition of a...
This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
Summation, the addition of a...
The fill handle can be used in a variety of ways that may save you time. From repeating sequences or repeating data to repeating a formula over a large area.
The fill handle is the name given to the green dot found on the bottom right corner of the selected...
Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in...
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...
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...
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...
There is a team of professional librarians at each campus who provide specialist support, deliver information skills training and manage the library resources in their subject areas. Contact a member of the library team by using the details below or phone the Support and Information Zone (SIZ)...
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...
Self-service machines are available to issue, renew and return books, using your campus ID card. Follow the on-screen instructions at the...
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
By agreeing, you are giving your consent for us to set cookies.