Tips & Tricks

If you have a paragraph of text that’s in a bit of a mess with indents, line spacing etc – there’s a really useful shortcut that will return it back to its default settings so you can apply the correct formats…

Read more ...

In older versions of Excel, if you wanted to extract data from cells or combine data from cells you had to use formulas. Now you can use a really handy technique called ‘Flash Fill’ without the use of formulas...

Read more ...

If you have monthly reports to produce which rely on data from an Excel Sheet or Chart, you may not be aware that there is a feature in Microsoft Office that allows you to link the Excel data when you paste it into the file, so that it will update the figures or chart automatically when changes occur in the original file.  It is known as Paste Link...

Read more ...

One of the most powerful features in Excel is to convert a range of data into a Table. You can create a table via the Home tab or via the Data tab but there is also a quick keyboard method, which is a lot faster...

Read more ...

Last month we looked at a quick way to insert the Copyright ©, Trademark ™ or Registered ® symbols into a Word document.   Word’s AutoCorrect feature is responsible for transforming the characters into the correct symbols, but this clever feature has more to offer.  Here we look at what other time saving shortcuts it provides us with and how we can add to its library or amend the features that we do not want to use...

Read more ...

If you need to type documents with references to Copyright ©, Trademark ™ or Registered ® information you can quickly add the correct symbols without opening the Symbol toolbox...

Read more ...

There will always be times where we want to speak up, express our views and stand our ground but in reality it is not that simple.  If you feel like sometimes you can be a bit of a doormat, saying yes all too often and never truly expressing your feelings and opinions, then read on for a few of our top tips to becoming more assertive at work. 

Read more ...

Here at TrainingU, we understand that good mental health and wellbeing amongst employees is becoming increasingly relevant and important for corporate companies to consider. To aid you with tackling this, we have put together a brand new one day self-development workshop consisting of our most popular personal effectiveness courses as short 90-minute sprint sessions.

Read more ...

AutoComplete addresses are handy in addressing people that we email frequently in a new message, they help us to access our email addresses quickly, but sometimes the wrong name pops up or an old address is displayed.  This is when you may want to remove certain addresses from the list…

Read more ...

We all know about the incredibly useful AutoSum tool on the Home ribbon, but did you know you can also add up a column or row by using a keyboard shortcut...

Read more ...