Excel Pivots - tips and tricks
Latest Articles
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