Tips & Tricks

When sending an email message, by default Outlook will save a copy of the message in the Sent Items folder. However you may prefer that the message is saved to a different folder i.e. a client folder.
Rather than having to move the email from the Sent Items once sent, here is a useful tip on how to select the folder before sending the email:

Read more ...

When a cell reference within a formula needs to an absolute cell reference, you may be aware that dollar signs need to be included within the formula. Rather than having to manually type the $ in each time, try this quick and handy shortcut....

Read more ...

Cropping is the process of chopping off the edge of a picture. It can be used to focus on part of a picture, or to neaten the edges of a messy scanned image.

Read more ...

Cropping is the process of chopping off the edge of a picture. It can be used to focus on part of a picture, or to neaten the edges of a messy scanned image.

We will use Microsoft PowerPoint in this example, however the following can also be done within Microsoft Word and Microsoft Publisher.

Read more ...

Cropping is the process of chopping off the edge of a picture. It can be used to focus on part of a picture, or to neaten the edges of a messy scanned image.

Read more ...

Let’s say you have a list of products and you want to know how many entries there are of a certain product...
Using the COUNTIF function will automatically calculate the answer for you:

Read more ...

When creating a publication within Microsoft Publisher it can be quite hard to read the text on the page due to the default zoom size.

Read more ...

When entering data into an Access Table or Query or an Excel worksheet, try out this shortcut for copying data from the row above:

Read more ...

A lot of people find the Data Validation List feature useful, as it allows you to have a drop down option to choose the required entry from.  But what if the list of entries is to grow?

Here is an example of where a Data Validation List has been used on column E:

Read more ...

Here at TrainingU, we’re serious about training people to increase their effectiveness and efficiency, and strive to ensure that the right learner is on the right course at all times so that they receive the most relevant training.  We fully understand how frustrating it is for a learner to be on a course which is totally the wrong level, either causing them to trail behind or become bored due to knowing the majority of the course content already.  And how,  for an employer, this would seriously reduce the return on investment.  

Read more ...