How-to videos

Check out 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.

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.

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