Windows 10 Virtual Desktops
This is an ideal way to organise the work you are working on during the day. This is great if you a multitasking several jobs at once. Also if you wish to toggle through the desktops without the mouse then hold the windows key and use the arrow left and right arrow keys.
VLOOKUP – Approximate Match
This video shows how to use an approximate match Vlookup to find year groups of pupils based on their date of birth.
Excel Shortcut – Ctrl + Enter
How to keep the active cell in position after an entry and how to replicate data across a range.
This video explains how to copy or fill a range of data or headings on one worksheet across to all or a range of selected worksheets in Excel. To learn more about Excel contact InIT Learning and Get on Course for Success. In-house (@ yours) and scheduled open courses available.
How to Customise the Background and Title Bar in Microsoft Office
The customise feature in the Microsoft Office feature has no real practical use other than to be more pleasing to your own eyes. The video shows you how to change background and title bar colours in Office 2010 and Office 2016.
Avoid the Embarrassment of Sending Wrong Emails by Delaying them.
Have you ever sent an email and as you click send realise that you have sent it to the wrong person, forgot some crucial information or forgot the attachment. The new Outlook does now recognise if you have mentioned attachment in your text and have forgot to attach it but if you delay your email by a few minutes at least you have a small window of opportunity to stop it being sent.
here is how to set that feature up.
Entering the degree symbol while typing in Microsoft Word.
- Hold Shift + Ctrl and press the @ key.
- Let go
- Press the space bar