How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

Excel can help you by recommending, and then, automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data. Make sure your data has column headings or table headers, and that there are no blank rows.

Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel, and become familiar with the PivotTable- and PivotChart-specific elements and terms.

Master the art of creating PivotTables in Excel with our step-by-step guide. Learn how to design and customize PivotTables yourself with ease. Try it now!

PivotTables are great ways to summarize, analyze, explore, and present summary data, and in Excel for the web you can also collaborate with someone on a PivotTable at the same time.

Excel can help you by recommending, and then, automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data. Make sure your data has column headings or table headers, and that there are no blank rows.

Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.

In Excel, you can change the layout and format of the PivotTable data to make it easier to read and scan.

Get started using Power Pivot in Excel to perform powerful data analysis, create sophisticated data models, mash up large volumes of data from various sources, and perform information analysis rapidly.

Here are the three basic steps to get multiple tables into the PivotTable Field List: Import from a relational database, like Microsoft SQL Server, Oracle, or Access.