Search the guides

Microsoft Outlook

Add a shared mailbox in Outlook

Get info@ or accounts@ showing in your Outlook, and send replies from that address rather than your own.

Intermediate · 6 min read Microsoft Word

How to do a mail merge in Word (letters and labels)

Send the same letter to a whole list of people with each one personalised, using a spreadsheet as the source.

Intermediate · 12 min read Microsoft Word

Fixing a Word document where the formatting has gone wrong

Wonky spacing, mystery indents and text that changes size on its own — how to see what is really happening and put it right.

Beginner · 8 min read Microsoft Excel

VLOOKUP and XLOOKUP explained simply

Pull a price, name or code from one sheet into another automatically, and understand why it sometimes says #N/A.

Intermediate · 10 min read Microsoft Excel

Build your first pivot table in Excel

Turn thousands of rows of sales, hours or invoices into a one-page summary in about two minutes.

Intermediate · 9 min read Microsoft Excel

Recovering an Excel or Word file you did not save

Three places to look before you accept that a morning of work has gone.

Beginner · 6 min read Microsoft Outlook

Set up an email signature in Outlook

Add your name, job title and logo to the bottom of every email, on both the desktop app and webmail.

Beginner · 5 min read Microsoft Outlook

Tame a busy inbox with Outlook rules

File newsletters, supplier notifications and CC-all-staff messages automatically so your inbox holds only what needs you.

Beginner · 7 min read Microsoft PowerPoint

Use the Slide Master to brand a whole deck at once

Change fonts, colours and logo placement across every slide in one place, rather than editing forty slides by hand.

Intermediate · 8 min read Microsoft Teams

Run a Teams meeting without the usual problems

Scheduling, inviting people outside your organisation, sharing your screen and fixing the "nobody can hear me" moment.

Beginner · 8 min read