Tips & Tricks

Did you know that instead of using the Insert Chart ribbon, there are two keyboard shortcuts for fast chart creation?  You can use F11 to create a full page sized chart or ALT F1 to create a chart within your worksheet...

Read more ...

Did you know that there is a quick keyboard method to enter hyperlinks into any of the Microsoft Office programs, such as Outlook, Word, Excel or PowerPoint?  For this example, we will use Microsoft Word but this method works in any of the Office applications...

Read more ...

When we see our inbox first, we can often get distracted from our plan because we start to “Fire Fight” immediately and not concentrate on the other priorities.  So why not change this?  Start Outlook with your Calendar, so you can see the plan that you had for the day first, so existing priorities are not put off and your “To Do List” gets done!

Read more ...

Last time we looked at combining data from separate columns into one single cell, this time what if you have your data arranged in a single cell and you need to split it into individual columns?  Excel makes it easy, you can use the Text to Columns feature...

Read more ...

When starting a presentation in a meeting, it can take a while to locate and launch your slideshow. Did you know that you can change the format in which you save your presentations so that they launch into the Slideshow view instantly…

Read more ...

Sometimes data that you are working with isn’t always laid out as you need it to be.  You may have information in separate columns, that you need to combine into one cell.  In this example we will show you how to do just that...

Read more ...

When you have typed up your Word table and realised that you have put the contents in the wrong order, there is a quick keyboard method to move a whole row of data up and down the table with ease…

Read more ...

Did you know that you can still recover emails that you have deleted, even if you have emptied the deleted items folder?  You will need to be using an Exchange account to be able to do this.

Read more ...

Sometimes you need to centre text or images not only in the middle of a page horizontally but also vertically.  For example, in the case of a report heading.  In Word, there is a quick way to achieve this within the Page Setup settings…

Read more ...

If your data is not arranged the way you would like it, you can use the Transpose feature to swap data from displaying down a column to being arranged over rows or vice versa...

Read more ...