Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in...
Search results
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...
SharePoint 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:
You can add a Poll in any chat window, whether you are in a meeting or if you are just using chat on its own.
If you are in a meeting and you want to set up a poll, open the Chat window and click on the ellipses (...) at the bottom of the chat
...
Once you have clicked into your meeting you have a number of ways to manage your participants.
If one person will be speaking at a time, it is advisable to ask all other participants to mute their microphones. Teams will try to prioritise the loudest noise it detects so if you have...