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...
Search results
Sparklines
Charts and Graphs...
Create a chart
Select the data for which you want to create a chart.
Pivot TablesIntroduction to pivot tables
Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format. What we mean by this is that you should log each transaction individually and not...
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...
Track Changes
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...
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....
Specialist software on University managed Windows desktops and laptops can be accessed using the ‘Managed Software Centre’, which contains a list of all the software currently licensed for you and/or your device.
In the Start Menu, scroll down to ‘Managed Software Centre’,
...
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...
Submitted PDF files can be downloaded and annotated in the Microsoft Edge browser:
After all students have submitted to an assessment, you may wish to lock the submissions to stop them from making any further changes. You can do this for a whole assignment or for an individual/select students.
Please note: If students have extensions, or permission to resubmit, you will...