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

Block
HandsOnITNews

Protect yourself from becoming a victim of spoofing.

HandsOnITNews

Encrypt your Word or Excel documents with a password for safe sending and sharing.

HandsOnITNews

Here's how to open and edit or copy any text from a PDF file in Microsoft Word.

HandsOnITNews

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.

HandsOnITNews

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.

HandsOnITNews

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.

HandsOnITNews

Do you have a habit of forgetting where you've left the car? - Use Google Maps on your mobile to temporarily save your location.

HandsOnITNews

Using Clipboard History can save you loads of time.

Watch our short video to see how!

HandsOnITNews

A really handy tip to use if you are meeting friends somewhere, or perhaps you want to temporarily track a family member home safely.

HandsOnITNews

8 easy ways to help extend your phone's battery consumption plus extend it's life!

HandsOnITNews

Easily and quickly remove the background from any of your images.

HandsOnITNews

Snip Snip ✂✂ - Easily copy and paste with this handy tip.

HandsOnITNews

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!

HandsOnITNews

Yes! - There really are 11 really useful internet browser keyboard shortcuts.

How many do you know already?

HandsOnITNews

* 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

Block

7th April 2022

Excel Applying Styles

Get started on how to create formulas and use built-in functions to perform calculations and solve problems.

21st April 2022

Excel Index Column

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

HandsOnITNews

You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.

7th April 2022

Excel Applying Styles

Apply Excel Styles to make your cells
stand out.
Check out the short tutorial.

31st March 2022

Excel Index Column

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

HandsOnITNews

To make sense of your data, you may need to promote the first table row to column headers.

17th March 2022

HandsOnITNews

Conditional formatting provides visual cues to help you make sense of your data. Find out how below ⬇

10th March 2022

HandsOnITNews

Copy cell formatting in your Excel worksheet using copy and paste options, Format Painter, and dragging techniques.

3rd March 2022

HandsOnITNews

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

HandsOnITNews

In Microsoft Excel, you can easily add, rename, and delete worksheets in your workbook.

17th February 2022

HandsOnITNews

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

HandsOnITNews

In Microsoft Excel, you can easily add, rename, and delete worksheets in your workbook.

3rd February 2022

HandsOnITNews

Do you know how to keep an area of a worksheet visible while you scroll to another area of the worksheet?

27th January 2022

HandsOnITNews

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

HandsOnITNews

A short tutorial on how to change your cell formats into currency, percentages, decimals, dates and phone numbers.

Microsoft Word

Block

16th December 2021

HandsOnITNews

Learn how to insert and remove page numbers to make it easier for people to navigate your documents.

9th December 2021

HandsOnITNews

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

HandsOnITNews

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

HandsOnITNews

A simple tutorial on how to check your word count in Microsoft Word.

18th November 2021

HandsOnITNews

Need everything to fit on a particular number of pages? This video will guide you.

11th November 2021

HandsOnITNews

Apply a theme to quickly format an entire Word document to give it a modern, professional look.

4th November 2021

HandsOnITNews

Simple but very useful tips on how to change the look of your Microsoft Word document.

28th October 2021

HandsOnITNews

Check out this tutorial video that could change the look of your documents for the better.

21st October 2021

HandsOnITNews

A fantastic way of tracking any changes made by other users when sharing documents.