September 8, 2014
Excel Pivot Tables Year on Year Change
PivotTables are a treasure trove of features and one that has been brought out of the dungeons in more recent
Read More
June 5, 2014
Sorting in Excel PivotTables
My second Excel love is PivotTables (VLOOKUP is still my number 1). PivotTables make short work of summarising data and
Read More
July 18, 2012
Excel Factor 6 Auto Refresh PivotTables
This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Excel PivotTables are one of the greatest
Read More
June 20, 2012
Excel Factor Entry 1 – Reverse PivotTable
How to Create a Reverse PivotTable - this is genius. This tutorial was sent in by Bryon Smedley of Bristol,
Read More
August 17, 2011
Create a Pivot Table Direct From Access
Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data
Read More