This tip I find useful in converting the Irish/UK take on temperature in comparison to the USA temperatures,  I usually like to see the trends of temperatures of where I am going on my regular road...

It's really easy to to turn ordinary text in your Excel spreadsheet to a hyperlink which is great if you want to insert links to other worksheets,  webpages or Office Documents from plain...

My Top 5 Reasons Why You NEED To Know Pivot Tables. It could be argued that Excel's most powerful analytical tool is the Pivot Table command. The more basic or manual ways of analyzing data in Excel...

Most users in Excel would be used to creating a fill series or auto fill by dragging the auto fill handle to the right or downwards.  This would give you an increasing fill series. You can also...

Welcome to Session 3 of Pivot Table Week. In this session we are going to start getting some good information from our raw data, getting the Pivot Table to all of the hard work really start to Pump...

Welcome to Session 2 in Pivot Table Week. Let's do a quick recap here. I have found to fully understand and get the best out of this fantastic Excel function you need to know the core terminology,...