Filter Function
=Filter Function
The FILTER function allows you to filter a range of data based on criteria you define.
Syntax
=FILTER(array,include,[if_empty])
The FILTER function allows you to filter a range of data based on criteria you define.
=FILTER(array,include,[if_empty])
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.
The SORT function sorts the contents of a range or array.
=Unique is a function used in Excel to find only Unique values in a range or array.
'Slide Masters' are the templates or layouts, which are shown in in your 'new slide' button:
You can change the order objects animate without needing to remove and reapply animations to other objects by using the Animation Pane.
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 preview of the current slide, the next slide and your notes:
Every object in PowerPoint can have an entrance, emphasis or exit animation applied to it. These will either enter your object onto the slide, exit it, or simply highlight it depending on which type you select. Multiple animations can be applied and the order these play out can be modified as well.
There are two ways to add audio to a presentation:
1. Adding Audio already on your PC (saved)
2. Record Audio (record live)
Have the audio file saved to the computer locally as an MP3 file - (if you have an obscure file type then email ITskills@chi.ac.uk who may be able to help convert the file to MP3)
Once you have the file as an MP3 on your computer, open PowerPoint and navigate to the slide you wish the audio to appear on.
This page will show you how to embed YouTube video in your PowerPoint Presentation.