Create a PivotTable to analyze worksheet data - Microsoft Support
Select a table or range of data in your sheet and select Insert > PivotTable to open the Insert PivotTable pane. You can either manually create your own PivotTable or choose a recommended PivotTable to be created for you.
Overview of PivotTables and PivotCharts - Microsoft Support
About PivotTables. A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.
Video: Create a PivotTable and analyze your data - Microsoft …
Learn what a PivotTable and PivotCharts are, and how you can use them to summarize and analyze data in Excel 2013. Create a PivotTable to analyze worksheet data. Being able to analyze all the data in your worksheet can help you make better business decisions.
Video: Create a PivotTable manually - Microsoft Support
Create a PivotTable to analyze data in multiple tables. Show different calculations in PivotTable value fields. Create a PivotChart. Available chart types
Create a PivotChart - Microsoft Support
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.
Insert a PivotTable - Microsoft Support
Create a PivotTable to analyze worksheet data. Overview of PivotTables and PivotCharts. Excel help & training. Office for the web Quick Starts. Training: Watch this video to learn how you can insert a PivotTable in Excel for the web.
Power Pivot - Overview and Learning - Microsoft Support
Power Pivot Tutorials. Seeing Power Pivot in action can help you learn how to use it, and provide helpful use cases that demonstrate the power of Power Pivot. The following tutorials can help you get started: Create a Data Model in Excel (starts with a …
Design the layout and format of a PivotTable - Microsoft Support
To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.
Use multiple tables to create a PivotTable - Microsoft Support
Create a PivotTable with multiple tables. 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. You can import multiple tables at the same time: Connect to an Oracle database.
Use the Field List to arrange fields in a PivotTable
Rearrange fields in your PivotTable (pivot table) by using the Field List, and show the Field List again when it disappears.