CHAPTER 12Using VBA to create pivot tables
In this chapter, you will:
Find out how pivot tables evolved
Build a pivot table
Use advanced pivot table features
Filter a data set
Use the data model in Excel 2019
Use other pivot table features
Pivot tables are the most powerful tools that Excel has to offer. The concept was first put into practice by Lotus, with its Improv product.
I love pivot tables because they help you very quickly summarize massive amounts of data. The name pivot table comes from the ability you have to drag fields in the PivotTable Fields list and have them recalculate. You can use a basic pivot table to produce a concise summary in seconds. However, pivot tables come in so many varieties that they can be the tools of choice ...