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.
...Search results
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.
Turning on...
By default, all users who have a chi.ac.uk email account can see other users' free / busy calendar information. To view this information, follow the instructions below.
Adding a calendar from the university directory - Office 365There 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...
If you are concerned about the health impact of "Blue Light" (the light that comes from a PC monitor, tablet, mobile phone, TV), then there is a filter built into Windows 10 that you may wish to enable.
Windows 10 has a Night Light setting which gently reduces the monitors blue-tones,...
Please complete the fire incident report form following any activation of the fire alarm system.
Forms:Fire indicent report form
This should only be completed by members of the FIC team. If you would like to report any fire incident please email...
Different methods have been made available to students and staff which allow you to report emails which are considered as either Spam or Phishing.
Spam or Junk emails are often classed as unsolicited emails which may focus on advertising and selling goods or services. You may have never...
There are 4 ways to add references:
Please note: when you first open your library, a pop-up box appears, highlighting where...