Use buttons to filter articles by category..
This week I had a request to show how to join text together from different columns in Excel. For this example, the Concatenate function in Excel works perfectly as it …
For anyone who is completely new to Excel or is wanting to venture into the world of formulas and functions, this post is here to give you some basic tips …
Generally, I like to try and keep an organised desktop area and where possible keep my files in a somewhat organised fashion. I have files which I use on a …
One of the first things I do when I set up a new computer, or rebuild my computer, is customise! One of the ways that I achieve this is by sticking, or …
A common complaint I hear in relation to email is that email is too slow to appear in the inbox. With current technology, we expect instant response and instant receipt. …
Microsoft Outlook provides a great solution for managing your email, contacts, calendar, and to do lists all within the one location. In cases where I need to send contact information …
Microsoft Outlook allows you to assign two email tracking options within an email message. The options include a delivery receipt and/or a read receipt. It is useful to know the …
These days the use of a signature within an email message is considered standard practice, especially in any corporate environment. Signatures can provide an email user with time-saving possibilities whether …
One of the main reasons most people create a presentation in Microsoft PowerPoint is so that the information can be presented to an audience. It is important that you test …
Ever wondered how to create a quick PowerPoint presentation? Maybe you’re in a hurry and don’t have hours to spend playing with design, colours and slide layouts. Let me show …
If you are a regular user of PowerPoint then you may find yourself wanting to reuse slides in PowerPoint presentations you’ve created in the past. Many users resort to using …
Microsoft PowerPoint, or PPT, is a program used to create presentations – or slideshows as they are more commonly referred to. PPT allows you to automatically create presentation slides, handouts, …
Any of the Microsoft Office programs includes the ability to create a PDF file for you. I’m always surprised at how many people are still unaware that this function is …
Microsoft Word includes some very useful shapes which allow you to use your imagination and create your own graphical charts or diagrams. The shapes available include lines, banners, callouts, various …
There are several methods to resize an image in Microsoft Word. In this exercise we will use the resize handles to make changes to an image in your document. One …
Microsoft Office includes the powerful Autocorrect feature which helps to reduce typing errors whilst you work. AutoCorrect is set up by default to correct common spelling and punctuation errors. Common …
When working in Microsoft Excel there are several references or names which will appear on a regular basis, as well as different methods for navigating within the program. Which navigation …
Let’s take a look now at the terminology and names of the various areas within the Microsoft Excel 2016 window. Even if you have been an avid user of Excel …
Conditional formatting is one of my favourite parts of Excel. I am a very visual person and would much rather look at colour charts or visual representations of data to …
Microsoft Excel provides various number formatting options which allows you to easily format numbers as currency, dates, percentages, time and even fractions. Occasionally you may run into a situation where …