Below are a list of Word guides currently available. If you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.
Basic Document EditingSearch results
Word Tutorials Styles How to show hidden formatting symbols Format Painter How to...
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...
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 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
Summation, the addition of a...
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 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...
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 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.
BeginnerQuick...
You can access your timetable in Publish. You will find a link in either Moodle or ChiView.
Moodle and ChiViewIn 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...
Introducing the Microsoft Stream workflowUploading: you can upload previously recorded content (such as your downloaded Panopto recordings) into OneDrive, SharePoint or a...
This workflow outlines how you can use Microsoft Teams to record your videos and how you can store and share them.