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
What is a Mathematical operator?
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.
BeginnerExcel...
Wrap Text & Merge and CentreWrap Text
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...
What is Grouping?
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...
How to Add Notes to your Presentation (Presenter View)
While giving a PowerPoint Presentation you can make use of something called Presenter view, this mode allows the projector* to display your presentation full screen without your notes showing to the audience. The second monitor* will show a ...
Animation Pane
The Animation pane allows you to change the order objects animate in, without needing to remove and reapply animations.
The Animation pane can be found in the Animations tab of the ribbon:
When selected the animation pane open in the sidebar and will...
Adding an audio file to your presentation
There are two ways to add audio to a presentation:
1. Adding Audio already on your PC (saved)
2. Record Audio (record live)
To add a clip from your computerHave the audio file saved to the computer locally as an MP3 file - (if you have...
How to create a text box
PowerPoint will generally create placeholders for text and images on each new slide unless you choose a blank slide specifically. However, sometimes you will want to create your own. The insert text-box tool is available for this situation.
In the 'Insert' tab of...
In order to reduce the file size of any Microsoft document (Word, Powerpoint or Excel) there are a few steps we can take without removing content.
Images usually make up the vast majority of a document's file size as text uses very little file space by comparison. Although removing...
Automatic Table of Contents
Word has a feature that allows users to automatically generate an automatic table of contents, assuming that heading styles have been used. This table of contents supports different levels of indentation to highlight chapters and sub-chapters of the document itself. ...