Search results

How to use social media responsibly

Social media tools such as Facebook, Instagram and Twitter are a part of everyday life. Used well, they can add to your learning experience at university, and make you more employable when you graduate. But used poorly, they can cause lasting damage to you and others.

Your responsibility

By...
Accessing Teams

You can use Microsoft Teams either from the Teams App or by using the web version. You will get the best user experience by using the Desktop App this is installed on all university computers.

If you are joining a meeting or lecture you will be prompted when you click on the meeting or...
How to Webcast to Panopto from OBS
  • From the Panopto Webpage, create a normal Webcast, and configure any customisations you’d like.
  • Under the “Manage” section of the Webcast settings, change the WebCast type to RTMP Source, and make a note of the server URL and Stream key
    Panopto_1.png...
    •
    Word - Show hidden formatting - Pilcrow
    Displaying hidden formattingWord has many formatting symbols which are not immediately obvious and are hidden from view by default. 
    The following formatting options have no visibility unless the ¶ button is selected:
  • Section breaks,
  • Page breaks,
  • Soft and Hard carriage...
    •
    Word - Styles
    Styles

    Styles can be quickly used to apply a formatting choice over a large area of a document. All text is initially created under the Normal style and will remain in this style unless Word is told otherwise. You can modify any existing style or create your own if there is not a pre-existing...
    Excel - =Unique Function
    =Unique function 

    =Unique is a function used in Excel to find only Unique values in a range or array. 

    e.g. If you have a list of Departments: 

    We can use the unique function to identify all the unique values in this list and produce a list of them...
    Quick selection Techniques

     

    Excel Quick Selection Techniques

    In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more efficiently. Especially when you have large amounts of data. 

    I shall...
    Find and replace
    Excel - Find and Replace

    Find and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...
    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...
    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...
    Show All Results