Excel 2016 VBA and Macros

12. Using VBA to Create Pivot Tables

In This Chapter

Understanding How Pivot Tables Evolved Over Various Excel Versions

While Building a Pivot Table in Excel VBA

Using Advanced Pivot Table Features

Filtering a Data Set

Using the Data Model in Excel 2016

Using Other Pivot Table Features

Next Steps

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 vanilla pivot table to produce a concise summary in seconds. However, pivot ...