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

Yes indeed Excellers it is Pivot Table week at how to excel at excel.com For some they are something they cannot live without in Excel world, for others they make them run screaming away at the very...