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. The Excel Vlookup function is a fantastic time-saver as it ...

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 of our ability. Often it’s the small things that can ...

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 but as the author commented, how would anyone not familiar ...

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 can add additional clocks to your Windows 10 clock display ...

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 presentation which was text, text and more text. A simple ...

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 information about a technical problem or error, and the list ...

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 types of publications. Microsoft Word provides a Table of Contents ...

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 it is the charting feature within Excel which will create ...

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. One aspect of email which can provide great time saving ...

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 have installed, how much disk space is being used, and ...

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 the Photo Album function available in Microsoft PowerPoint. I’ve used ...

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 border. When I started working I used to spend a ...

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 out results from your data analysis. Microsoft Excel has the ...

One feature that MOST users are familiar with is the Cut, Copy and Paste function. The ability to cut, copy and paste within any of the Microsoft applications or third-party apps provides a user with a high level of productivity ...

The first step to using Microsoft Outlook is setting up and configuring your email account. Whether you wish to access an email account through your workplace or one available through your internet provider you will need to know how to ...

Today I am going to discuss the use of the slide layout feature and how it can assist you to create a consistent and professional looking presentation. Microsoft PowerPoint is probably one of my favourite applications to teach. It provides ...

Today I am going to show you the best keyboard shortcuts for use in Microsoft Word. You may have noticed that I’m a fan of efficiency. If there is an option to do something faster in any of the Microsoft ...

Microsoft Outlook has the ability to be able to set up rules that allow you to create an action that Outlook will make on your behalf. Rules can be a great method to assist you in managing your incoming and ...

There is nothing worse than pressing the “on” button on your computer to find no response, no lights, and no sounds, nothing, zip, zilch… I have had this happen before, and in fact, my husband’s computer has decided to do ...

This post is written using Microsoft PowerPoint 2010. For steps on how to achieve this using Microsoft PowerPoint 2016 please see this updated post. This week I saw a great question on an online forum relating to Microsoft PowerPoint. The ...

Let’s face it, we are a population of multi-taskers and when we are on our computer it is no different. I always have multiple windows and applications running at once. It is rare for me to have just one or ...

Now let’s be honest, the title of this post got you a little intrigued right? I remember the first time I heard about a hidden feature of Windows called GodMode I thought for sure it was a joke, but then ...

A common issue when working with long documents is how to maintain consistent formatting across all pages? Learning how to use Styles in Word is a fundamental skill that all users should have yet many users don't understand. Working with ...

At the start of almost every Microsoft course I teach, I discuss the options you have to customise any of the Microsoft Office products. The Quick Access toolbar (QAT) is right up there on my list of favourite ways to ...