We’ve just started a new financial year and all our source data has been cleared out ready to start afresh. I was expecting to refresh my standard pivot table reports to see refreshed and tidy tables that had clear pivot...

tips

An easy and risk-free way to compare data from two or more sources is by using a pivot table. In this tutorial I will demonstrate why you should add pivot table comparisons to your data analysis toolbox and forget about...

tips compare

I regularly use pivot filters with multiple items to select from and if these aren’t sorted alphabetically or numerically it is a nightmare task to find the items I’m interested in.

tips sort

If you can create a user-defined calculated field for your pivot table you really need to know how to amend those calculated pivot fields as well:

tips

Here are 5 very quick animated pivot table tips to increase your pivot table skills.

tips