Search results

In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more effciently. Esspecially when you have large ammounts of data. 

I...

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:

This menu...

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...

Cell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:

The fill handle is shown when a cell is selected (by left clicking it), you will...

Change font, style, point size and all formatting, in one go to match pre-existing text

Many times in Word you have copied and pasted something into your document only to find it is in a different font, size or is in bold or italics or some completely different format. Format...

A sparkline is a small graphic designed to give a quick representation of numerical or statistical information within a piece of text, taking the form of a graph without axes. This is displayed within a single cell and can be used to visualise data when you don't have enough room or it...

Create a chart

When creating charts/graphs in Excel you may find that some labels are not added by default and must be added manually or are in an unsuitable place. Excel also allows for modification of these labels, as well as their placement. In this example i'm going to amend a pie...

Track changes can be used to lock a document. Any changes made to the document after it has been locked will feature in a list of 'tracked changes' that can be approved or denied. These are similar to comments but will update the original document if approved. 

There are multiple ways of highlighting or removing duplicates from an Excel worksheet. 

Conditional formatting can be used to highlight duplicates ready for manual removal. This will use any formatting you select to overlay the data and show you any duplicates....

Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as...

In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more efficiently. Especially when you have large amounts of data. 

I shall...

Conditional formatting is a feature that has a variety of uses. Mainly surrounding different ways of displaying data corresponding to the value found within the cell or range of data. This can help you visualise the data faster...

Create a chart

Excel can use a function to lookup and retrieve data from a specific column or row within a table. Vlookup works to return back a column of data and Hlookup works to return a row of data instead, therefore the V stands for vertical lookup and the H, Horizontal lookup. 

Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as...

Excel provides a feature that is intended to split a single column of data into multiple columns. For instance, if you had a column of full names (first and last) and needed to separate these out into two columns: 

'Text to columns' is found in the 'data'...

Find and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...

The SORT function sorts the contents of a range or array.

In this example we are sorting an array of sales which currently unordered. When =SORT(B3:E51) is used we will see the array now sorted by the first column, in this case A-Z of the Item column: 

There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.

To resize an individual column or row you can click...

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;

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.

If you have a shared document in Teams, Office 365 groups, in SharePoint or in Onedrive, you can edit it at the same time as other people when it is opened online in a browser.  This enables you to work collaboratively on the same document, either in real time or at separate times, without the...

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 ...

There are two ways to add audio to a presentation: 

1. Adding Audio already on your PC (saved)

2. Record Audio (record live)

Have the audio file saved to the computer locally as an MP3 file - (if you have...

In order to reduce the file size of any Microsoft document (Word, Powerpoint or Excel) there are a few steps we can take without removing content.

Images usually make up the vast majority of a document's file size as text uses very little file space by comparison. Although removing...

You can create a group to store a list of people you want to send email to. Use this group to send messages to multiple contacts without having to enter each contact separately in the message.

Groups that you create in your Contacts folder aren't available to other users in the University...

Clutter can help you filter low-priority emails, saving time for your most important messages. The email server keeps track of the emails you read and the ones you don't. Once turned on, Clutter is automatic. As new email comes in, it takes messages you're most likely to ignore...

Automatic replies are used whenever you're unable to respond to email for an extended period of time. After automatic replies are turned on, they'll be sent once to each sender.

The process is very similar whether you are using Office 365 or Outlook. You only need to set the automatic...

By default, all users who have a chi.ac.uk email account can see other users' free / busy calendar information.

If you want to give other people additional rights to view your calendar, such as subject / location or full details, you...

The default reply method in Office 365 is reply all (which is different to the Outlook desktop client installed on University computers).

This guide will show you how change the setting from 'reply all' to 'reply' in Office 365.

Word has a feature that allows users to automatically generate an automatic table of contents, assuming that heading styles have been used. This table of contents supports different levels of indentation to highlight chapters and sub-chapters of the document itself. ...

Page & Section breaks have multiple uses. They are most notably used to create different sections within the same document, so that you can apply a different page orientation, affect page numbers and different headers/footers per section.

You can find the...

Footnotes and endnotes are useful tools for adding citations, comments, or explanations to your text.

This guide will walk you through the steps to insert and manage footnotes and endnotes in Microsoft Word.

Footnotes and...

This guide will show you the several types of views available within Microsoft Word that will be able to help you view your document the way you'd like to.

Word has several different ways you can view documents:

These can all...

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.

To access OneDrive login to Email/Office 365 then click OneDrive via the apps icon...

You are entitled to a free subscription to Microsoft Office for computers and mobile devices.
More information: Microsoft Office installation.

Dell Advantage offers discounts on selected products...

Adding images to a slide is one the features of PowerPoint you will use most often. You can insert Images from multiple locations: On your computer, from the web or off of your clipboard:

Inside the 'Insert' tab of the menu ribbon, you...

Below are a list of Word guides currently available. If you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.

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-...

The fill handle can be used in a variety of ways that may save you time. From repeating sequences or repeating data to repeating a formula over a large area. 

The fill handle is the name given to the green dot found on the bottom right corner of the selected...

If functions are used when we want to specify a criteria to limit our function to. For instance, if we were interested in values above a certain amount we could use =countIf in order to count the number of the values in a range, that are above a certain value. There are multiple...

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.