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
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?
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.
14th October 2021
Use headers and footers to add titles, dates, page numbers, company addresses to every page in your document.
7th October 2021
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
Did you know you can change the look of your document by simply changing the spacing? Here’s how ⬇
23rd September 2021
Do you know how to edit a pdf using Microsoft Word? You soon will ⬇
15th September 2021
Word will check your document for spelling, grammar & clarity.
9th September 2021
The first of our Word tutorials, easing you in gently with page breaks!
Microsoft Outlook
26th August 2021
Microsoft Dictate enables you to talk instead of type. Learn more here ⬇
19th August 2021
A shared calendar will help you see when people are available for meetings or other events.
12th August 2021
Here’s a few tips on how to use your calendar/s to it’s best.
5th August 2021
When text or static images just won’t do, use an animated GIF to get your point across.
29th July 2021
This short video shows you why setting up visual reminders could be really useful to you. 👇🏿
15th July 2021
Do you know of the time saving benefits from saving your contacts? 🧐
8th July 2021
This 45 second video shows you a simple way to get someone’s attention in an email message or meeting invite.
1st July 2021
A quick and very useful recap video on how to create an online meeting using Microsoft Outlook.
24th June 2021
Watch the quick demo on how to remove yourself from email threads that you don’t need to be part of.
17th June 2021
Stay organised with this quick re-cap on tasks and items.
10th June 2021
How to create appointments, meetings and invites in Outlook.
3rd June 2021
All you need to know on how to create inbox rules based on senders or recipients.
Microsoft Teams
27th May 2021
A quick and easy guide to keep you in control when viewing, managing and scheduling meetings.
20th May 2021
Approvals in Microsoft Teams are a way to streamline your requests and processes with your team and partners.
13th May 2021
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
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
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
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
Watch this short tutorial on how to easily share your screen whilst in a meeting.
8th April 2021
How to work on the same document at the same time as your other team members.
1st April 2021
Learn how to easily upload and share files in this quick Microsoft Teams tutorial.
25th March 2021
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
You can stay connected while managing remote employees with channels and the tutorial below will show you how to use them.
11th March 2021
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
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
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
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
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
4th March 2021
Hands On IT Services celebrated 25 years in business.
