12Pivot Tables
IN THIS CHAPTER
Creating a Vanilla Pivot Table in Excel Interface
Building a Pivot Table in Excel VBA
Revenue by Customer for a Product Line Manager
Handling Additional Annoyances
Product Profitability-Issues with Two or More Data Fields
Summarizing Date Fields with Grouping
Advanced Pivot Table Techniques
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, ...
Get VBA and Macros for Microsoft Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
