SharePoint sites exist in a number of different ways and therefore accessing them for the purposes of syncing with your local PC are done differently according to their type:
Search results
Accessing the SharePoint siteSharePoint site - e.g. 'UOC staff SharePoint' - Can be accessed by clicking the...
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....
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 - 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...
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...
Adding an audio file to your presentation
There are two ways to add audio to a presentation:
1. Adding Audio already on your PC (saved)
2. Record Audio (record live)
To add a clip from your computerHave the audio file saved to the computer locally as an MP3 file - (if you have...
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...
How to Add Notes to your Presentation (Presenter View)
While giving a PowerPoint Presentation you can make use of something called Presenter view, this mode allows the projector* to display your presentation full screen without your notes showing to the audience. The second monitor* will show a ...
How to add shapes and customise them
Images and text boxes can be shaped into more than just a square that we start with, as PowerPoint allows for custom shapes. This guide will show the steps required first generate a shape and then to edit it.
Inserting a shape (to customise)Powerpoint...
Charts and Graphs...
Create a chart
Select the data for which you want to create a chart.