Pivot Tables

Pivot tables are the most powerful tools that Excel has to offer. The concept was first put into practice by Lotus with their Improv product.

I love pivot tables because they are a really fast way to summarize massive amounts of data. The basic vanilla pivot table can be used to produce a concise summary in seconds. However, pivot tables come in so many flavors that they can be the tools of choice for many different uses. You can build pivot tables to act as the calculation engine to produce reports by store, by style, or to quickly find the top 5 or bottom 10 of anything.

I am not suggesting you use VBA to build pivot tables to give to your user! I am suggesting you use pivot tables as a means to an end—use a pivot table to extract a summary of data, and then take this summary on to better uses.

0 0

Post a comment