Free Online Microsoft Training

Use the buttons below to filter articles by category..

Convert workbooks to the latest file format in Excel

March 18, 2015 No Comments

A common question I see during training is “Why do my files say [Compatibility Mode] in the title bar area?” and this is a good question. Today I want to ...

Read Now →

Microsoft Excel

Customise a Sparkline in Excel

March 17, 2015 No Comments

So you’ve discovered Sparklines in Microsoft Excel and now you want to jazz them up? You’ve come to the right place. In my previous post (link here) I outlined what ...

Read Now →

Microsoft Excel

Create a Sparkline to show data trends in Excel

March 16, 2015 No Comments

I can hear you asking it now, what is a Sparkline? It’s a very good question which I’m going to answer for you now. Sparklines were introduced in Excel 2010 ...

Read Now →

Adjust the brightness of your monitor to avoid eyestrain

Microsoft Windows

Adjust the brightness of your computers screen to avoid eyestrain

March 9, 2015 No Comments

With us spending more and more time at our computer screens, it’s important that you adjust various aspects of your working environment to minimise issues relating to Work Health & ...

Read Now →

Microsoft PowerPoint

10 Presentation Tips for PowerPoint

March 3, 2015 No Comments

Microsoft PowerPoint is a fun program to use and offers many great features. Like me though many people have had the joy of sitting through a terrible presentation! It’s not ...

Read Now →

Microsoft Outlook

How to backup email in Outlook

February 23, 2015 No Comments

I’ve now published several articles where I discuss the importance of backing up data on your computer (see Backing up your files – a vital step to securing your data). ...

Read Now →

Microsoft Word

How to create a cross-reference in Word

February 18, 2015 No Comments

When working with long documents in Word, you may find yourself searching for an easy way to link content between different pages. I’ve seen many imaginative ways of performing this ...

Read Now →

Microsoft Excel

How to create a Vlookup in Excel

February 9, 2015 No Comments

Do you know how to create a Vlookup in Excel? The Vlookup function in Excel is a very popular function but sometimes can be a little tricky to work out. ...

Read Now →

Microsoft Outlook

How to customise a contacts display name in Outlook

January 19, 2015 8 Comments

When we are forced to spend vast amounts of our working day using email, it is important that we are able to configure and utilise the features to the best ...

Read Now →

Microsoft Word

How to customise numbered list alignment in Word

January 16, 2015 3 Comments

I recently saw an issue arise on a discussion forum where a user asked a question related to the alignment of a numbered list. The solution was a simple one ...

Read Now →

Microsoft Windows

How to display multiple clocks in Windows 10

January 10, 2015 No Comments

A great feature of Microsoft Windows 10 is the ability to display multiple clocks from different locations at the same time within the system clock area. The way in which you ...

Read Now →

Microsoft PowerPoint

Convert text to SmartArt in PowerPoint

January 6, 2015 No Comments

When creating presentations using Microsoft PowerPoint, it is common to see slides containing a heading and a bulleted or numbered list. Let’s be honest, we’ve all sat through a boring ...

Read Now →

Microsoft Excel

How to create a screenshot using Office

December 22, 2014 No Comments

For years I have been creating screenshots for various reasons; for use in training courseware; to illustrate to a remote user a button I want them to press; to relay ...

Read Now →

Microsoft Word

Create a Table of Contents in Word

December 19, 2014 No Comments

In many aspects of our daily life, we encounter and use a table of contents. From opening a magazine, or using a cook book, you see this feature in many ...

Read Now →

Microsoft Excel

Create an Excel graph or chart in under 30 sec

December 18, 2014 1 Comment

Microsoft Excel provides a great way to summarise and analyse data using charts. The terminology used can differ between referring to them as charts or an Excel graph. Either way ...

Read Now →

Microsoft Outlook

Create a distribution list in Microsoft Outlook

December 9, 2014 No Comments

The use of email for many people has become a daily event. Companies and organisations rely heavily on the use of email for correspondence with both internal and external contacts. ...

Read Now →

Microsoft Windows

Improve performance of your Windows 10 computer

December 2, 2014 No Comments

Over time any computer regardless of how new or old it is will begin to decrease in its performance. Many factors contribute to this degradation including how much software you ...

Read Now →

Microsoft PowerPoint

How to create a photo album slide show using PowerPoint

November 25, 2014 No Comments

Have you ever attended an event where a slideshow of photos was showing on a screen for everyone to view? Ever wondered how to create one? It’s very easy using ...

Read Now →

Microsoft Word

How to create a cover page in Word

November 19, 2014 No Comments

How much time have you spent creating a cover page in Word? Before you know it you’ve taken 30 minutes and all you have is a heading and a page ...

Read Now →

Microsoft Excel

Introduction to Functions in Microsoft Excel

November 12, 2014 No Comments

Microsoft Excel is a fantastic program allowing you to collate, analyse and sort data in various formats. Gone are the days of needing a calculator beside you to manually work ...

Read Now →