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...
Search results
Freeze Panes
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;
What is a Mathematical operator?
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...
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...
Accessing the SharePoint siteSharePoint site - e.g. 'UOC staff SharePoint' - Can be accessed by clicking the...
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:
How many times have you clicked to download a zip file, image, or document to find that your computer has automatically saved the file to a folder called “Downloads”… and how many times have you deleted the files in this folder?
Many of us will have a Downloads folder that is full of files...
Microsoft To Do overviewA smart daily planner Set yourself up for success with My Day, intelligent and personalised suggestions to update your daily or weekly to do list. With both a Microsoft to do desktop app and mobile app available, it is easy to stay on task all day long. ...
What is Grouping?
Objects in Microsoft Office (Word, Excel, Powerpoint etc) can be grouped together to perform as a singular object. This includes; images, textboxes, shapes and SmartArt.
Once grouped, the layout of each object relative to one another will stay the same even if you move or...
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 ...