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:
Ribbon1.png
This menu...
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:
Ribbon1.png
This menu...
When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;
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...
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.
Toolbar
Microsoft Teams allows you to set up online meetings with up to 350 people.
Tip! Setting your meeting so that everyone can by...
You can contact individuals via Microsoft Teams to communicate by text, voice, video and share your screen. This does not require you to join a Team and can be useful for direct communication.
Any undergraduate or postgraduate student who believes that they have serious and unexpected short-term personal or medical circumstances which have impacted on their ability to submit, or that have seriously affected his or her performance in an assessment, and which he or she wishes a Board of...
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...