How to use the Access Zoom Box
The Access Zoom Box allows you to temporarily change the font properties within the zoom dialog box e.g. colour and size of font in order to make viewing or editing easier.
How to Cut or Copy to Spike in Word
The Spike is a feature I don’t see used very often. When you normally copy and paste the copy goes into the clipboard, but you can only copy one section at a time. The spike allows you to copy several sections one at a time and stacks them together so when you past from the spike all the sections are pasted. This also removes the copied sections from the spike.
Change Prices or Values on Spreadsheet without using Formulas
If you have an Excel spreadsheet with lots of values and you want to change them all very quickly then watch this video. You can add, subtract, multiply or divide all the values in one go.
Remove Page Break Lines in Excel
This video explains how to remove those really annoying page break lines on an Excel worksheet using one line of VBA code. Any level of user can do this.
Download the Code here>>>
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.