Search results

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

=Unique is a function used in Excel to find only Unique values in a range or array. 

e.g. If you have a list of Departments: 

We can use the unique function to identify all the unique values in this list and produce a list of them...

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

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;

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

The Animation pane allows you to change the order objects animate in, without needing to remove and reapply animations.

The Animation pane can be found in the Animations tab of the ribbon: 

When selected the animation pane open in the sidebar and will...

PowerPoint will generally create placeholders for text and images on each new slide unless you choose a blank slide specifically. However, sometimes you will want to create your own. The insert text-box tool is available for this situation.

In the 'Insert' tab of...

PowerPoint has a new feature which mimics the style of presentation of Prezzi, using one large slide to place all of the subsequent slides on. Throughout the presentation, these slides will be zoomed into when that slide is reached, giving the impression that the whole...

Captions are useful for providing context to images, charts, and other illustrations in your document. A table of figures helps readers navigate these elements quickly by creating a table with all 'captions' in it as well as their page number. ...

The Dictation feature allows you to speak into your microphone, and Word will convert your speech into text. Here’s how to use it:

Check Your Microphone: Ensure you have a working microphone connected to your computer.

Open Microsoft Word: Launch Microsoft Word and open the...

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.

OneDrive can be accessed in your web...

Layouts, Design Theme and Slide Size

How to create a text box
SmartArt
Adding/editing shapes
Grouping

Adding Images
Remove background (Images)
 

Embedding Videos
Adding Audio

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