Search results

Embedding Videos
How to Embed a YouTube Video In PowerPoint

This page will show you how to embed an online video like YouTube in your PowerPoint Presentation.

1. Find the Youtube video you wish to embed in your Internet browser (on Youtube.com Website): 

2. Select the URL (address)...
Shapes and Shape formatting
How to add shapes and customise them

Images and text boxes can be shaped into more than just a square that we start with, as PowerPoint allows for custom shapes. This guide will show the steps required first generate a shape and then to edit it.

Inserting a shape (to customise)

Powerpoint...
Remove background (Images)

PowerPoint has a feature which allows you to remove the background from an image.  There are limitations such as needing a high-resolution, decent quality image and a clearly defined background/foreground, It still has many uses and can allow you to bypass the need for you to search for a 'cut-...
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...
    Number Formatting
    Number Formatting in Excel

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

    •
    Second marking

    Dissertation.png
  • Second marking is only available for Dissertations
  • You will not see the option to add Second Marker feedback or grades for anything other than dissertations

    • Review first marker details.png...
    Show All Results