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

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.

For example, an item referring to the date March 5, 1999 could be entered as 36224 or DATE (1999,3,5). Times can be entered as decimal values or by using the TIME function. If the pivot_table …

With Get & Transform and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Use these resources to find out what's possible, and how to get started.

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.

Each of these tables contain fields you can combine in a single PivotTable to slice your data in multiple ways. No manual formatting or data preparation is necessary.

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.

The following links and information can get you going with Power Pivot, including how to enable Power Query in Excel, how to get started using Power Pivot, then tutorials, and community connections.

Measures, also known as measures in Power Pivot in Excel 2013, are calculations used in data analysis. Examples commonly found in business reports include sums, averages, minimum or …

Although Excel can tell you when a relationship is needed, it can't tell you which tables and columns to use, or whether a table relationship is even possible. Try following these steps to get the answers …