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...
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.
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...
Choose module screen
When you first access MAF Online, you'll be shown a list of the modules you've been given to mark. If you are the module coordinator, you'll automatically have access to the module and will be able to add additional markers.
Choose... 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...
Adding a Comment
To add a comment, first, highlight the text you want to comment on. Then, go to the "Review" tab in the ribbon and click on "New Comment." Type your comment in the box that appears:
Type out your comment and press Ctrl + Enter or click the 'Submit...