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...
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...
1. Introduction
Our Learning Resource Centres (LRC) are the hub of our learning environment and play a vital part in providing students and staff with the resources, services and support required to...
This page now redirects to the Electronic Information Security Policy - IT Code of Conduct
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...
PowerPoint has a feature which allows you to remove the background from an image. There are limitations such as needing a high-resolution, decent quality image and a clearly defined background/foreground, It still has many uses and can allow you to bypass the need for you to search for a 'cut-...
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 ...