Power Pivot

The PowerPivot add-in is a data analysis tool which provides an extension to Pivot Tables.
This add-in allows users to easily connect to different data sources to analyse data.
This add-in was not installed (by default) for everyone, it depended on which Microsoft 365 subscription you had.
You could use the Data Analysis Expression (DAX) language to create advanced formulas.
A power pivot data model can be used to create a pivot table.

Manage - Displays the separate Power Pivot application window allowing you to load and prepare data or continue working on data already added to this workbook.
Measures - Drop-Down. The drop-down contains the commands: New Measure (previously New Calculated Field), Manage Measures (previously called Calculated Fields)
KPIs - Drop-Down. The drop-down contains the commands: New KPI, Manage KPIs.
Add to Data Model - Create a linked table by adding this Excel table to the Data Model. Linked tables are a live link between the table in Excel and the table in the Data Model, so any updates to the table in Excel automatically update the data in the model. If this table is already in the data model, this action adds a copy to the data model.
Detect - Automatically detect and create relationships between tables used on the selected Pivot Table.
Settings - Displays the "PowerPivot Settings" dialog box. Define settings for your Power Pivot environment and specify language options.

Installing the Add-in

Add-in Location

Excel 365 - C:\Program Files\Microsoft Office\root\Office16\ADDINS\PowerPivot Excel Add-in\PowerPivotExcelClientAddIn.dll 
Excel 2021 - 

Manage Data Model

On the Data tab there is a button called "Data Model".
Pressing this command displayed a prompt saying "Enable the Data Analysis add-ins to use this feature".
Pressing Enable provided a shortcut to manually ticking the add-in in the COM Add-ins dialog box.

Excel 2021

The "Microsoft Power View for Excel" COM Add-in was removed.
The Power View add-in functionality was incorporated into the Power BI Desktop application.

Excel 2013

In Excel 2013 this add-in was installed with Office Professional Plus 2013 by default.
The add-in required Visual Studio Runtime 2010 and .NET Runtime 4.0 to also be installed

Manage - This launches a separate application window
Calculated Fields - Drop-Down. The drop-down contains the commands: New Calculated Field and Manage Calculated Fields.
KPIs - Drop-Down. The drop-down contains the commands: New KPI and Manage KPIs.
Align Vertically -
Align Horizontally -
Add to Data Model - Create a linked table by adding this Excel table to the Data Model. Linked tables are a live link between the table in Excel and the table in the Data Model, so any updates to the table in Excel automatically update the data in the model. If this table is already in the data model, this action adds a copy to the data model.
Update All - Update all the Power Pivot tables that are linked to tables in Excel.
Detect - Automatically detect and create relationships between tables used on the selected Pivot Table.
Settings - Define settings for your Power Pivot environment and specify language options.

Excel 2010

In Excel 2010 this add-in was a standalone application that had to be downloaded and installed separately.

PowerPivot Window - This launches a separate application window
New Measure -
Delete Measure -
Measure Settings -
Pivot Table - Drop-Down. The drop-down contains the commands:
Create Linked Table -
Update All -
Options & Diagnostics - ?
Settings -
Field List - Toggles the display of the PowerPivot Field List task pane.
Detection - Detects relationships (previously Relationship Detection).