Recent Posts

How to resize a photo to use as your Desktop Wallpaper

How to resize a photo to use as your Desktop Wallpaper

As a follow-up to my previous post, how to set your own photo as your Desktop Wallpaper, I’m going to show you how to adjust the size of a photo being ...
Read More

How to set your own photo as your Desktop Wallpaper

Let’s talk wallpaper! Just to be clear, I’m not referring to the type which you might find stuck to a wall, I’m talking about that desktop area of your computer ...
Read More

Create a rule to move email to a specified folder

In this age of email and the internet, we tend to find our inbox can get clogged with a lot of email from various different sources. A great way of ...
Read More
My favourite shortcut keys in Microsoft PowerPoint

My favourite shortcut keys for Microsoft PowerPoint

If you've read a few of my posts, you may have noticed that I’m a fan of efficiency. If there is an option to do something faster in any of ...
Read More
Introduction to the AutoFill tool in Excel

How to use the AutoFill tool in Excel

Of all the features available within Microsoft Excel, the AutoFill tool has to be high up on the list of those used most frequently. Often though the AutoFill feature is ...
Read More
Convert workbooks to the latest file format in Excel

Convert workbooks to the latest file format in Excel

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 More

Customise a Sparkline in Excel

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 More

Create a Sparkline to show data trends in Excel

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 More
Adjust the brightness of your computers screen

Adjust the brightness of your computers screen to avoid eyestrain

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 More
10 Tips for Effective Presentations using PowerPoint

10 Tips for Effective Presentations using PowerPoint

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 More
Back up email within Outlook

Backup your Email folder in Outlook

I’ve now published several articles where I discuss the importance of backing up the data on your computer (See Backing up your files – a vital step to securing your ...
Read More
Create a cross-reference in Word

Create a cross-reference in Word

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 More

Create a Vlookup function in Excel

A common request in Excel training courses is to learn how to perform a vlookup function in Excel. Many people have heard about the VLOOKUP and HLOOKUP functions in Excel ...
Read More
Change a Contacts Display Name in Outlook

How to customise the display of a Contact’s name in Outlook

When we are forced to spend vast amounts of our working day using email, it’s important that we are able to configure and utilise the features to the best of ...
Read More
Customise numbered list alignment in Word

Customise numbered list alignment in Word

I recently saw an issue arise on a discussion forum where a user submitted a question related to the alignment of a numbered list. The solution was a simple one ...
Read More
Display Multiple Clocks in Windows 10

How to display multiple clocks in Windows 10

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 More
Convert Text to SmartArt

Convert text to SmartArt in PowerPoint

When creating presentations using Microsoft PowerPoint, it is common to see slides containing a heading and a bullet list. Let’s be honest, we’ve all sat through a boring presentation which ...
Read More

How to create a screenshot using Office or Windows

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 More
Create a table of contents in Word

Create a Table of Contents in Word

In many aspects of our daily life, we encounter and use a table of contents. Whether it is opening a magazine or reading the newspaper, you will see this feature ...
Read More
Create a quick chart in Excel

Create a quick and easy chart in Excel

Microsoft Excel provides a great way to summarise and analyse data within a spreadsheet using charts. Charts provide a graphical representation of data and allow you to highlight important information ...
Read More
/ charts, column chart, data, excel, Microsoft Excel

Create a distribution list in Microsoft Outlook

The use of email for most people has become a daily occurrence. Companies and organisations rely heavily on the use of email for correspondence with both internal and external contacts ...
Read More
Improve performance of your Windows 10 computer

Improve performance of your Windows 10 computer

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 More
Create a photo album slideshow in PowerPoint

How to create a photo album slide show using PowerPoint

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 More
Create a cover page using Word

Create a cover page using Microsoft Word

Thinking back to when I began working I remember spending countless hours creating a cover page using Word. I would spend time creating the perfect heading, adjusting its alignment and ...
Read More

Introduction to Functions in Microsoft Excel

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 More