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

Sometimes the amount of notifications appearing on your screen can be overwhelming. This tech tip shows you a very simple way to mute the alerts before they start getting on your nerves.

Looking for a specific video in Google?
Here’s how to filter your results by duration, time, quality and source!

If there’s a particular and important chat you access frequently, you can create a shortcut for it on your device’s home screen.

If there’s a particular and important chat you access frequently, you can create a shortcut for it on your device’s home screen.

If you’d like to capture long web pages in their entirety – for use in documentation, presentations or competitor analysis – Google Chrome has a lesser-known but built-in way for doing this.

If there’s a particular WhatsApp chat you would like to prioritise, you can pin it to the top of your chat list.

If you’ve found a specific passage of text in a web page that you’d like to show to another person, Google Chrome has a built-in feature that allows you to share the link.

Save yourself time by messaging a group of people the same question whilst making it look as though you’ve asked them individually (so you don’t have to open each chat to ask them separately).

Here’s a fun way to remind yourself of what Google’s search engine looked like back in 1998.

Check your Outlook Online to see whether you have been compromised and to see if any malicious rules have been added

If you’ve got a long list of bookmarks in Google Chrome that’s not in order, using ‘Bookmark Manager’ can help you get your bookmarks organised and easily navigable.

Did you know you can change the font in your WhatsApp messages to add some emphasis to your text?

Watch to see how easy it is!

Are you sitting comfortably?
You will be after watching our tips on how to get a better posture at work.

Get the exact results you are searching for by using this quick and easy tech tip when using Google Search!

How to convert a picture of an Excel Table into a usable table.

Clean up and Free Up space on your device by using Storage Sense.

What exactly is Phishing? How do you spot it and what can you do if you have been attacked.

Set up automatic replies or an Out Of Office response in Outlook and Online.

Protect yourself from becoming a victim of spoofing.

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.

Give it a try!

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

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?

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.

14th October 2021

HandsOnITNews

Use headers and footers to add titles, dates, page numbers, company addresses to every page in your document.

7th October 2021

HandsOnITNews

Most of us know how to confidently insert or amend a table, but do you know how to create a table by drawing one?

30th September 2021

HandsOnITNews

Did you know you can change the look of your document by simply changing the spacing? Here’s how ⬇

23rd September 2021

HandsOnITNews

Do you know how to edit a pdf using Microsoft Word? You soon will ⬇

15th September 2021

HandsOnITNews

Word will check your document for spelling, grammar & clarity.

9th September 2021

HandsOnITNews

The first of our Word tutorials, easing you in gently with page breaks!

Microsoft Outlook

Block

26th August 2021

HandsOnITNews

Microsoft Dictate enables you to talk instead of type. Learn more here ⬇

19th August 2021

HandsOnITNews

A shared calendar will help you see when people are available for meetings or other events.

12th August 2021

HandsOnITNews

Here’s a few tips on how to use your calendar/s to it’s best.

5th August 2021

HandsOnITNews

When text or static images just won’t do, use an animated GIF to get your point across.

29th July 2021

HandsOnITNews

This short video shows you why setting up visual reminders could be really useful to you. 👇🏿

15th July 2021

HandsOnITNews

Do you know of the time saving benefits from saving your contacts? 🧐

8th July 2021

HandsOnITNews

This 45 second video shows you a simple way to get someone’s attention in an email message or meeting invite.

1st July 2021

HandsOnITNews

A quick and very useful recap video on how to create an online meeting using Microsoft Outlook.

24th June 2021

HandsOnITNews

Watch the quick demo on how to remove yourself from email threads that you don’t need to be part of.

17th June 2021

HandsOnITNews

Stay organised with this quick re-cap on tasks and items.

10th June 2021

HandsOnITNews

How to create appointments, meetings and invites in Outlook.

3rd June 2021

HandsOnITNews

All you need to know on how to create inbox rules based on senders or recipients.

Microsoft Teams

Block

27th May 2021

HandsOnITNews

A quick and easy guide to keep you in control when viewing, managing and scheduling meetings.

20th May 2021

HandsOnITNews

Approvals in Microsoft Teams are a way to streamline your requests and processes with your team and partners.

13th May 2021

HandsOnITNews

Now we know how to create Shifts, this tutorial helps you to view, manage, and share your team’s schedule for the day, week, or month.

6th May 2021

HandsOnITNews

To change what appears behind you in a video, you can either blur your background or replace it entirely with any image you want.

29th April 2021

HandsOnITNews

If managing schedules for your team is one of your responsibilities, then this tutorial on Shifts will help you make life easier.

22nd April 2021

HandsOnITNews

Very useful when there are quite a few different ways to join a Teams meeting. Check out the short video to make remote working easier.

15th April 2021

HandsOnITNews

Watch this short tutorial on how to easily share your screen whilst in a meeting.

8th April 2021

HandsOnITNews

How to work on the same document at the same time as your other team members.

1st April 2021

HandsOnITNews

Learn how to easily upload and share files in this quick Microsoft Teams tutorial.

25th March 2021

HandsOnITNews

Stay connected with Teams while working from home with the “Meet now” feature and turn a team conversation into an instant meeting.

18th March 2021

HandsOnITNews

You can stay connected while managing remote employees with channels and the tutorial below will show you how to use them.

11th March 2021

HandsOnITNews

A two-minute tutorial on how to turn the apps and services you use the most into tabs at the top of a channel or chat.

4th March 2021

HandsOnITNews

If you want to talk privately with one person or several members of your team, you can utilise the “Chat” function in Microsoft Teams. Watch the video below to find out how.

25th February 2021

HandsOnITNews

Watch the quick tutorial below to learn how to easily get your team up and running in Microsoft Teams. For more information on Teams please contact us on 020 8649 9911.

18th February 2021

HandsOnITNews

Watch the video below to learn the steps to add members to your teams and channels, and even customise your settings to add a team picture and give your team some personality.

4th March 2021

HandsOnITNews

If you want to talk privately with one person or several members of your team, you can utilise the “Chat” function in Microsoft Teams.
Watch the video below to find out how.

Hands On IT Services

Block

4th March 2021

HandsOnITNews

Hands On IT Services celebrated 25 years in business.

This image has an empty alt attribute; its file name is cropped-HOIT-LOGO-png-1-150x150.png

Back To Knowledge Zone