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...
Search results
Number Formatting in Excel
IF functions
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...
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...
sp coll.png
The Anita White Collection
The collection comprises papers accumulated by leaders in the women’s sports movement and is held in the archives at Chichester. These papers were amassed in the course of their research, study and work in the fields of the...
Roz Hall
Learning Technologies & Skills Development Manager
Twitter, LinkedIn
Roz Hall has over a decade of...
Opening Times Bognor campus
Breakfast, 8am to 10am
Lunch, 12pm to 2pm
Dinner, 4.30pm to 6.30pm
Costa LRC, 8am to 4pm
Otters Weekend, 11am to 2pm
Starbucks, 9am to 4pm
Chichester campus
Breakfast, 8am to 10...
Catered card information
How much is the daily allowance?
You will have £9.10 per day during the week and £4.50 per day on weekends
Where can I use my card?Cards can be used on both campuses at Otters Restaurant, Costa and Starbucks
What can I buy...
Meal deals
Deli item must be a single protein Voucher can be used at lunch or dinner Voucher must be used on the day of purchase Voucher is...
Deli wrap, baguette or sandwich, + Full hot meal voucher, + Postmix drink - £9.10
Meal deals
Hot dinner + simple sandwhich or pastry + 2 snacks (choose from Walkers crisps, Milkyway, piece of fruit and a cookie) + 1 drink (choose from standard bottled still or sparkling water or flavoured water) - £9.10