Microsoft Excel 2019 VBA and Macros, First Edition

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 ...