How-to videos
Check out our very own Top Tech Tips or these Microsoft’s how-to videos on Microsoft Excel, Microsoft Word, Microsoft Outlook and Microsoft Teams showing you time-saving tips and helpful hints . Or watch our celebratory video made to commemorate or 25th anniversary in business.
Hands On IT’s Top Tech Tips
Encrypt your Word or Excel documents with a password for safe sending and sharing.
Here's how to open and edit or copy any text from a PDF file in Microsoft Word.
If you need to send sensitive information by WhatsApp, make sure you know how to make your image or video will disappear once the recipient has seen it.
Inside the Google Photos app, you can use 'Google Lens' to learn more about the picture you've taken. Perfect for shopping or learning about something new.
Whether you want to send your document as a PDF, make your file smaller or perhaps you want to make the document harder to edit, you can easily print your file to PDF from any program.
Do you have a habit of forgetting where you've left the car? - Use Google Maps on your mobile to temporarily save your location.
Using Clipboard History can save you loads of time.
Watch our short video to see how!
A really handy tip to use if you are meeting friends somewhere, or perhaps you want to temporarily track a family member home safely.
8 easy ways to help extend your phone's battery consumption plus extend it's life!
Easily and quickly remove the background from any of your images.
Snip Snip ✂✂ - Easily copy and paste with this handy tip.
Want to take a trip down memory lane? Google Archives will show you how your neighbourhood used to look in the past.
Give it a try!
Yes! - There really are 11 really useful internet browser keyboard shortcuts.
How many do you know already?
* No energy to move your mouse to the address bar on your browser?
* Frightened of spraining a wrist?
Then this is the shortcut for you! 😝
Microsoft Excel
7th April 2022
Get started on how to create formulas and use built-in functions to perform calculations and solve problems.
21st April 2022
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons and trends in your data.
13th April 2022
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
7th April 2022
Apply Excel Styles to make your cells
stand out.
Check out the short tutorial.
31st March 2022
With Power Query in Microsoft Excel, you can add an Index or Custom (you define the formula) column to your current query.
24th March 2022
To make sense of your data, you may need to promote the first table row to column headers.
17th March 2022
Conditional formatting provides visual cues to help you make sense of your data. Find out how below ⬇
10th March 2022
Copy cell formatting in your Excel worksheet using copy and paste options, Format Painter, and dragging techniques.
3rd March 2022
Did you know you can take the text in one or more cells, and split it into multiple cells using the Convert Text to Columns Wizard?
10th February 2022
In Microsoft Excel, you can easily add, rename, and delete worksheets in your workbook.
17th February 2022
Manage all your mailing addresses and save to your OneDrive. Colleagues will then be able to co-author it, and add or edit entries.
10th February 2022
In Microsoft Excel, you can easily add, rename, and delete worksheets in your workbook.
3rd February 2022
Do you know how to keep an area of a worksheet visible while you scroll to another area of the worksheet?
27th January 2022
Take a look at this quick tutorial to learn how to keep an area of a worksheet visible while you scroll to another area of the worksheet.
13th January 2022
A short tutorial on how to change your cell formats into currency, percentages, decimals, dates and phone numbers.
Microsoft Word
16th December 2021
Learn how to insert and remove page numbers to make it easier for people to navigate your documents.
9th December 2021
Create a table of contents that's easy to keep up-to-date, apply your heading styles and Word will build it automatically.
2nd December 2021
Pictures make Word documents more engaging. Take a look at this quick re-cap on how to insert and adjust pictures in your document.
25th November 2021
A simple tutorial on how to check your word count in Microsoft Word.
18th November 2021
Need everything to fit on a particular number of pages? This video will guide you.
11th November 2021
Apply a theme to quickly format an entire Word document to give it a modern, professional look.
4th November 2021
Simple but very useful tips on how to change the look of your Microsoft Word document.
28th October 2021
Check out this tutorial video that could change the look of your documents for the better.
21st October 2021
A fantastic way of tracking any changes made by other users when sharing documents.