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...
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...
There are several email and document properties that you can use to find items in Exchange Online and Outlook 2016.
Exchange Online has limited options for searching without making use of the specified search terms.
Please visit the Microsoft support page to view all the search terms...
By default, all users who have a chi.ac.uk email account can see other users' free / busy calendar information.
If you want to give other people additional rights to view your calendar, such as subject / location or full details, you...
There are two stages to working with managed accounts. The account owner will need to follow the instructions in Part 1 (for a Generic or Shared Mailbox this will be the person named as responsible for it, if you are unsure who this is contact the SIZ). Part 2 is for the delegate (the person who...
Automatic replies are used whenever you're unable to respond to email for an extended period of time. After automatic replies are turned on, they'll be sent once to each sender.
The process is very similar whether you are using Microsoft 365 or Outlook. You only need to set the automatic...
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...
Bcc (Blind carbon copy) vs Cc (Carbon copy)
The option to use Bcc rather than Cc isn’t available by default, but it’s easy to make it appear and it is sometimes more appropriate to use.