There are multiple ways of highlighting or removing duplicates from an Excel worksheet.
Conditional FormattingConditional 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 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'Text to columns' is found in the 'data'...
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...
Term
Explanation
PictureTeams Homepage/TabThis is the screen you will see all of the Teams you are a member or owner of. You can access the Teams Homepage by clicking 'Teams' in the left sidebar TeamA 'Team' is a group that can be joined by staff and students, it...
Origin is a video game digital distribution platform developed by Electronic Arts. This platform is used by the university to install certain items of software from games to applications. To access this platform, you must have an account. If you already have one you may sign in...
A bookmark is a web browser feature used to save a web site's URL address for future reference. Bookmarks save user and browser time, which is especially useful for Web pages with long URLs or accessing a specific part of the site that might not be the homepage for...
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...
Used effectively for activities such as research and self-promotion, social media can dramatically enhance your employability. However, if used carelessly, social media can significantly damage your chances in the job market. This guide outlines some of the things you need to consider, and the...
GIMP (GNU Image Manipulation Program) is a free and open-source raster graphics editor used for image retouching and editing, free-form drawing, converting between different image formats, and more specialised tasks.
How to download GIMPIf you know that you are working with someone with a visual impairment, please make sure you discuss with them how they like to work and if they have any specific requirements.
Whilst not all visually impaired people are the same,...
