This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
Search results
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.
BeginnerExcel...
Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up...
Below are a list of Word 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.
ToolbarSharePoint 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, Office 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 the...
With Microsoft Forms you can create a form, such as a survey or quiz, invite others to respond to it using almost any web browser or mobile device, see real-time results as they're submitted, use built-in analytics to evaluate responses, and export results to Excel for additional analysis or...
Objects in Microsoft Office (Word, Excel, Powerpoint etc) can be grouped together to perform as a singular object. This includes; images, textboxes, shapes and SmartArt.
Once grouped, the layout of each object relative to one another will stay the same even if you move or...
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-...