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...
Search results
Relative cell references and absolute cell references
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...
Quick links:Sharing your recordings in Moodle (or elsewhere) General information on sharing from OneDrive Sharing your recordings on Moodle (or elsewhere)Navigate to the videos folder location (OneDrive/...
Watch the video guide for Sharing your recordings on Moodle
PowerPoint Tutorials
Layouts, Design Theme and Slide Size
Text
How to create a text box
SmartArt
Adding/editing shapes
Grouping
Adding Images
Remove background (Images)
Embedding Videos
Adding Audio
Animations/...
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...
Accessing the SharePoint siteSharePoint site - e.g. 'UOC staff SharePoint' - Can be accessed by clicking the...
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:
If you have a shared document in Teams, Microsoft 365 groups, in SharePoint or in Onedrive, you can edit it at the same time as other people when it is opened online in a browser. This enables you to work collaboratively on the same document, either in real time or at separate times, without...