Search results

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...

    •
    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...
    Set up a Teams Meeting

     

    Microsoft Teams allows you to set up online meetings with up to 350 people.

  • Set up a Meeting using your online calendar
  • Set up a Meeting using your desktop Outlook calendar
  • Set up a Meeting from within Teams

    • Note: Creating a Teams meeting may link the...
    PowerPoint Tutorials
    PowerPoint Tutorials

    Layouts, Design Theme and Slide Size

    Text

     

    How to create a text box
    SmartArt
    Adding/editing shapes
    Grouping

    Images

    Adding Images
    Remove background (Images)
     

    Video

    Embedding Videos
    Adding Audio

     

    Animations/...
    Pivot tables
    Pivot TablesIntroduction to pivot tables

    Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format.  What we mean by this is that you should log each transaction individually and not...
    Microsoft Forms

    With Microsoft Forms you can create a form, such as a survey or quiz, invite others to respond to it using almost any web browser or mobile device, see real-time results as they're submitted, use built-in analytics to evaluate responses, and export results to Excel for additional analysis or...
    synchronising a University OneDrive account with a personal device
    What is OneDrive?

    OneDrive is used to store files, folders, and photos in the 'cloud' (Online) so you can access them easily on multiple devices and share them with colleagues, or with people outside the university.

    How can I access my OneDrive Quickly?

    OneDrive can be accessed in your web...
    Show All Results