Search results
Managing your emails - Outlook training videosThis video series aims to highlight the features and tools of Outlook (Desktop App) that will help you to comply with your departmental file retention policies and data protection legislation. We have all become used to having powerful search features...
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....
PowerPoint has a feature which allows you to remove the background from an image. Although it has limitations such as needing a high-resolution image and a clearly defined background/foreground, It still has many uses and can allow you to bypass the need for you to search for a cut-out image to...
PowerPoint - Zoom Slides
PowerPoint has a new feature which mimics the style of presentation of Prezzi, using one large slide to place all of the subsequent slides on. Throughout the presentation, these slides will be zoomed into when that slide is reached, giving the impression that the whole...
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...
How to Add Animations to your objects
Every object in PowerPoint can have an entrance, emphasis or exit animation applied to it. These will either enter your object onto the slide, exit it, or simply highlight it depending on which type you select. Multiple animations can be applied and the order...
Animation Pane
You can change the order objects animate without needing to remove and reapply animations to other objects by using the Animation Pane.
The Animation pane can be found in the Animations tab of the ribbon:
When selected the animation pane will open in...
Relative cell references and absolute cell references
Cell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:
The fill handle is shown when a cell is selected (by left clicking it), you will...
IF functions
If functions are used when we want to specify a criteria to limit our function to. For instance, if we were interested in values above a certain amount we could use =countIf in order to count the number of the values in a range, that are above a certain value. There are multiple...
Charts and Graphs...
Create a chart
Select the data for which you want to create a chart.