Tips & Tricks

Outlook has a little-known but really useful view called ‘Outlook Today’. This provides you with an instant snapshot summary of your recent messages, calendar appointments and tasks…

Read more ...

Excel has a really useful shortcut that can automatically identify & select cells containing formulas in worksheets. This is particularly useful when working on others’ data, but also helpful when you suspect a formula may have gone missing…

Read more ...

Did you know that you can use Word as an e-Reader? Reading Mode will automatically scale the contents of each page to fit your device’s screen. Other options allow you to change the page colour and mark up the text. Read on…

Read more ...

It’s not uncommon for the team at TrainingU to receive emails and calls along the lines of “we need time management training for some of our staff” or “we need customer service training for our staff to be more professional”...

Read more ...

When you are presenting a PowerPoint slideshow, did you know that you can have popup text appear as you hover your mouse over an object or text on the screen?  ‘Rollover text’ is great if you feel that the object or text requires an additional ‘optional’ explanation…

Read more ...

As part of their commitment to delivering ongoing training and development to their employees, Wenta decided to run a series of in-house sessions focusing specifically on the use of OneDrive, in order to ensure that all employees would feel confident using this going forwards. 

Read more ...

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 ...