Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

CHAPTER 13. Using VBA or TypeScript to create pivot tables

In this chapter, you will:

• Enable VBA in your copy of Excel

• Use a file format that enables macros

• Use the Visual Basic Editor

• Discover Visual Basic Tools

• Use the macro recorder

• Understand object-oriented code

• Learn tricks of the trade

• Understand versions

• Build a pivot table in Excel VBA

• Deal with limitations of pivot tables

• Create a report showing revenue by category

• Calculate with a pivot table

• Use advanced pivot table techniques

• Use the Data Model in Excel

• Examine TypeScript Code for Creating Pivot Tables in Excel Online

Version 5 of Excel introduced a powerful new macro language called Visual Basic for Applications (VBA). Every copy of Excel shipped since 1993 has had a copy of ...