Search results
Accessing desktop Mendeley on a personal computer Go to https://www.mendeley.com/reference-management/mendeley-desktop and download the software. Follow the instructions under Register for an account. Creating an online account Go to https://www.mendeley.com/reference-...
What is the Focused Mailbox?
When focused mailbox mode is enabled it will split your Inbox into two Tabs:
Focused & OtherHigh priority emails are directed to the Focused tab, whilst low priority emails like advertisements and generic newsletter items are directed to the "Other" Mailbox...
Create foldersFrom the folders panel on the left-hand side, choose “create folder”. Give the folder a name and press return. The folder will now be listed in the folders pane. Go to either the All Documents folder or the Unsorted folder. Highlight a reference and drag...
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...
=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.