This tip is one my most favorite time savers when using Pivot Tables- the ability to create many reports with just a few mouse clicks. The scenario for this example is the national sales manager...
Category: Pivot Tables
To use a Pivot Table we usually need transactional data or a flat data table containing rows and columns of data, that is not summarised already. In my example below, the data already looks...
Before I found out about this little tip, the multiple stacked report filters in my Pivot Tables REALLY annoyed me. So, here is how to avoid all of those stacked up messy filters. Yuk. I have used...
If you use Pivot Tables then you will know the problem- I hope to help you with now. When you create your Pivot Table on certain columns of data, Excel will default to COUNT rather than the...
Like Pivot Tables? Yes me too, I love them, but have you ever wanted to sort them differently, for example to show the top Sales Month by volume. Here is how to do it....really...
Display The Details Behind Your Pivot Table Data With One Click
Ever need to drill down into your Pivot Table to look at the details behind your summary calculations? Simple stuff with the double click of a mouse and Excel will display all of the details behind...