Search results

Basic Functions
Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)

This page will cover the 5 basic functions found in the auto-sum drop-down menu:

  • SUM

  • AVERAGE

  • COUNT NUMBERS

  • MAX

  • MIN

    • SUM

  • Summation, the addition of a...

    •
    Fill Handle
    Flash fill and the fill handle

    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...
    IF Functions
    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...
    Cell Referencing
    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 Training
    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.

    Beginner

  • Quick...

    •
    Online timetables (Publish)

    You can access your timetable in Publish. You will find a link in either Moodle or ChiView.

    Moodle and ChiView

    In Moodle there is a timetable option in the menu. Once expanded you will see a link to Teaching Timetables.

    In ChiView, once you are logged in, you will...
    Microsoft Stream
     Introducing the Microsoft Stream workflow

    This workflow outlines how you can use Microsoft Teams to record your videos and how you can store and share them. 

  • Uploading: you can upload previously recorded content (such as your downloaded Panopto recordings) into OneDrive, SharePoint or a...
    •
    ESports FAQ

    At the University of Chichester, we're committed to providing as best an experience for gaming as we can, whilst remaining within the confines of a secure environment for all staff and students.

    To facilitate this, we have implemented a dual boot system, where-by computers in the BRC Tech...
    ESports - Recording gameplay footage

    As the ESports system removes all changes upon reboot, creating local file recordings of gameplay is impractical.

    Therefore, we have created an onsite streaming server, to which you can direct your OBS / Streamlabs etc output. Anything streamed to this server will then save to MP4 file on...
    Start of semester checklist for Moodle
    This guide has been setup to support you when preparing your Moodle pages for the new semester.

    Please review each section carefully:

    */ 1. Import your content from a previous years' Moodle page

    Moodle allows you to move content from one page to another. You will need to have...
    Show All Results