We tend to think of social media like real life. We have a conversation or a thought and then move on – forgetting that in the digital world a copy could be kept forever, unless we take steps to remove it. This guide explains how to minimise any potential damage your previous use of social media...
Search results
Access to the Business School Webserver is provided by a username and password sent to you in an email. If you don't have an email with these details, and you feel you should have access, then please log a support call at https://supportme.chi.ac.uk or speak with your lecturer.
In your...
Displaying hidden formattingWord has many formatting symbols which are not immediately obvious and are hidden from view by default.
The following formatting options have no visibility unless the ¶ button is selected:Section breaks, Page breaks, Soft and Hard carriage...
The following formatting options have no visibility unless the ¶ button is selected:
=Unique function
=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...
Excel Quick Selection Techniques
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...
Excel - Find and Replace
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...
Conditional Formatting
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...
Sparklines
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...
Charts and Graphs...
Create a chart
Select the data for which you want to create a chart.
Adding Chart Elements
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...