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

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