Freeze Panes
Freeze Panes
Freeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data.
In the view tab of the ribbon you will find the "freeze panes" drop down menu:
Software and apps
Resizing Columns and Rows
Resizing Columns and Rows in Excel
There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.
Excel Training
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.
Beginner
Powerpoint - Animation Pane
Animation Pane
You can change the order objects animate without needing to remove and reapply animations to other objects by using the Animation Pane.
Powerpoint - How to add Notes to your presentation (Presenter View)
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 preview of the current slide, the next slide and your notes:
Powerpoint - Add Animations to your Objects
How to Add Animations to your objects
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.
Powerpoint - Add Audio
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 computer
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.
Powerpoint - How to Embed a YouTube Video
How to Embed a YouTube Video In PowerPoint
This page will show you how to embed YouTube video in your PowerPoint Presentation.
synchronising a University OneDrive account with a personal device
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.
Installing the HP Remote Software (Windows)
The following guide will help you install the appropriate supporting software to allow remote control of HP Computers for access to specialist software that would not normally be accessible via existing remote access methods.
Installing the software will install the following components on your machine: