Although there are two good chapters in my book on the creation and development of pivot tables, I have not, until now, discussed this topic here.
A friend of mine knows nothing at all about Excel but I needed to show him some pivot table based analysis. We discussed things for a while but we got nowhere. So I created a short video for him to explain what was happening and bingo!
The video presentation attached to this page is a more detailed version of the video for my friend. It’s about 13 minutes long and of course you can watch it over and over again to make sure you missed nothing.
I have chosen the analysis of a telephone account as the subject and that is something most people can relate to too.
All in all this video should prove to be a perfect way to unleash the power of pivot tables.
Watch the video here.