Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

Chapter 12

Using 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

• Use other pivot table features

• Compare VBA to TypeScript

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