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
Number Formatting in Excel
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:
Ribbon1.png
This menu...
Creating a TableTable data can be sorted and filtered faster and at the table...
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;
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...
In the participants window you can also click on the ellipses at the top of the page (in the same line as the heading People) and from here you can change the meeting options by clicking manage permissions or you can download an attendee list. This can be useful for online lectures in the...
If you hover over a participant and click the Ellipses that appear, you have a number of options, such as:
You can share your screen or other content in Teams meetings by clicking on the Share content button on your control bar (this is the button with an up arrow)
Choose your desktop (if you wish to play a video as part of your meeting or lecture, make sure you also select Include computer...
If your participants wish to say something or ask a question in a Teams meeting, you can advise them at the beginning to unmute themselves if you want them to be able to speak as and when they choose, or if you don't want to be interrupted, you can ask them to submit questions in the chat window...
There are two ways to set up Breakout roomsIn Teams meetings, you can either create them on the moodle page in advance, or use the Microsoft breakout rooms feature, so which should you use?
Setting them up on the Moodle page in advance