Search Not Just Numbers

Tuesday, 22 January 2013

Why do I need pivot tables? - and a song!

Before we get to the song, I want to answer a question I am asked over and over again:

"Why do I need pivot tables?"

Regular readers will know what a big fan I am of pivot tables, and how they can transform how you use Excel. However the biggest obstacle that people seem to face is not that pivot tables are complex, but that they don't understand what they are for.

In short, Pivot tables allow you to analyse and summarise large amounts of data quickly, easily and incredibly flexibly (if that's  word!).


It can take seconds to transform tens of thousands of rows of data into a summary table, displaying the important information you need to see.

For example: from a list of sales invoices pulled from your accounting system, you can create a 12 month sales summary by customer with a column for each month. That should typically take less than a minute to create from scratch.


Building pivot tables is all done with wizards and the layout is built visually using drag and drop - no complicated coding just a simple way to analyse your data.

Flexibly (if it's not a word, it should be):

In the sales summary example above, what if you (or your boss) now wants to see the same sales summary by salesperson and region, rather than by customer. This can be done in about 20 seconds. Just think if you'd built that summary without pivot tables - how long would it take to change it?

If I've convinced you that you need to know more about pivot tables, you can still take advantage of my January deal if you're quick. Just click here and you can have mastered pivot tables within the next hour.

Or alternatively, maybe these boys can convince you with a song:

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get your free report "The 5 Excel features that you NEED to know".

1 comment:

  1. Men and women normally creates understanding with regards to someone's individuality via precisely what they has on sometimes fake rolex can be outfits, sneakers as well as equipment. Nevertheless you are likely to declare that will it's not the correct fake rolex watches to judge any individual, nevertheless this can be what is actually going on. Nevertheless it won't imply you should search additional popular looking at people rolex replica watches. In relation to basic visual appeal and then it is just a should preserve popular issues quiet since often one particular seems to be additional gleaming along with you know that will any situation that glitters is just not platinum. Consequently in case, you would like very good addition that will accommodates your lifestyle the other is going pertaining to classy omega replica watches. Nevertheless you are likely to declare that it must be pretty a high priced matter while the many exceptional wrist fake chanel 2.55 may be high-priced with out every one's bank account have enough money the idea.