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'...
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...
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...
New government regulations published in September 2018 require all content posted online to be accessible. This online guide has been produced to support content creators in understanding what they need to do to comply with these national regulations.
The definition of accessible...
Sometimes you may need to convert your PowerPoint presentation to a PDF for various reasons including printing. This is a very easy process and will duplicate your file assuming you have also saved as a PowerPoint file to start with. But it is reasonably well...
Many of the keyboard shortcuts used in PowerPoint are also used in the rest of the Microsoft office suite.
The following table itemizes the most frequently used shortcuts in PowerPoint.
To do this...
