Microsoft Support

Microsoft Home Page

Sign in

Select the product you need help with

Select a solution

Create a PivotTable to analyze data in multiple tables - Excel - Office.com
Create a PivotTable (pivot table) that uses fields from related tables in the Field List. Relate tables by importing tables from an external relational database like Access or SQL Server, or add your ...
Create a PivotTable to analyze external data - Excel - Office.com
Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.
Create a PivotTable to analyze worksheet data - Excel - Office.com
Pivot worksheet data to view it from different angles by creating a PivotTable (pivot table) to analyze the data.