Tips

If there is just one thing that I would do away with in Excel it is the Merge & Centre button found on the home tab in the Alignment section. This may...

I have shown you how to create a simple Pivot Table in my last tip. Now I would like to show you how to expand on that. This is the result of...

Whenever I train Excel and Pivot tables are on the menu I get a varied response. Either people are terrified of them or they just don’t understand how to use them...

In a previous tip – How to create the count functions in Excel I showed you how to use the function Count and CountA. I do hope you found it both...

Every afternoon, at around 3pm, offices hit a wall. You're tired from staring at a screen, full from lunch and generally unenthused about your progress. You find yourself scrolling mindlessly through...

You can create anything you like in your email. If you want the same stuff every so often, it makes sense to have it at your fingertips just when you need...

I am often asked if there is an easy way to use some of a colleague’s slide deck as part of the presentation they are putting together for a conference or...

There are many times when looking at a spreadsheet you need to know how many items there are in a certain section of how many rows are filled with data. Simply...

There is nothing more annoying than sending an email to someone, expecting a reply and receiving none. When you later find out that they were out the office for several days...

An entrepreneur's biggest asset is time. While you might have the motivation, the passion and the ideas, it doesn't mean a whole lot if you're not actually getting anything done. So...