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

Welcome to Session 4 of Pivot Table Week. Thanks for joining me again for Session 4 in Pivot Table Week.  Today we will be looking at additional calculations in   If you need a recap of...

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