Search results

Mathematical Operatives
What is a Mathematical operator?

This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
Excel Tutorials - Full Listing
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

  • Excel...

    •
    Wrap Text & Merge and Centre
    Wrap Text & Merge and CentreWrap Text

    Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up...
    Syncing a SharePoint storage area with your computer
    Accessing the SharePoint site

    SharePoint sites exist in a number of different ways and therefore accessing them for the purposes of syncing with your local PC are done differently according to their type:

  • SharePoint site -  e.g. 'UOC staff SharePoint' - Can be accessed by clicking the...
    •
    SNAH Polices and Operational Guidlines
    Please see the various SNAH documents
    Teams Polls
    Add a poll to a Teams chat

    You can add a Poll in any chat window, whether you are in a meeting or if you are just using chat on its own.

    If you are in a meeting and you want to set up a poll, open the Chat window and click on the ellipses (...) at the bottom of the chat

     ...
    Managing a Teams meeting or Lecture

    Once you have clicked into your meeting you have a number of ways to manage your participants.

    If one person will be speaking at a time, it is advisable to ask all other participants to mute their microphones. Teams will try to prioritise the loudest noise it detects so if you have...
    Teams messages, calls or video calls
    Creating a Chat for instant messaging, audio or video calling

    You can contact individuals via Microsoft Teams to communicate by text, voice, video and share your screen. This does not require you to join a Team and can be useful for direct communication.

  •  Select the 'New chat' icon in the...
    •
    Attendance list (Teams)

    In the participants window you can also click on the ellipses at the top of the page (in the same line as the heading People) and from here you can change the meeting options by clicking manage permissions or you can download an attendee list. This can be useful for online lectures in the...
    Manage participants (Teams)

    If you hover over a participant and click the Ellipses that appear, you have a number of options, such as:

  • Lower their hand (if they have it up)
  • Mute them (if they are unmuted)
  • Pin - this will put them in the main teams window rather than the group being tiled across it,...
    •
    Show All Results