MENU
Donate
=DIRECTORY.ENTRY
support.microsoft.com

Create a PivotTable to Analyze Worksheet Data

Official Microsoft walkthrough for creating PivotTables from worksheet data and data models.

  • Sites
  • Free
Visit support.microsoft.com (opens in a new tab)

What it is

The hands-on starting point for PivotTables on Microsoft Support, walking through how to select source data, insert a PivotTable, drag fields into the rows, columns, and values areas, and apply slicers or filters. Also covers starting from a data model rather than a flat range, which is the foundation for multi-table analysis in Excel.

At a glance

Source
support.microsoft.com
Type
Microsoft Excel sites
Category
Official Microsoft
Cost
Free

Also in Official Microsoft

All microsoft excel sites