If you don’t like the look of your PivotTable after you create it, you can pick a different style. Just choose a different report layout for instant layout changes. When you want to delete a PivotTable, the trick is to select the entire PivotTable before you press Delete, even when it has a lot of data-this article provides a quick way to select an entire PivotTable.ĭesign the layout and format of a PivotTableĪfter you create a PivotTable and add the fields you want, you can change the layout to make the PivotTable easier to read and scan. If you just want an interactive chart, you don’t need to create a PivotTable first. Excel can even recommend a PivotChart for your data. Use the Field List to show data in a PivotTableĪfter you create a PivotTable based on worksheet data, external data, or multiple tables, you can access the Field List to add, arrange, and remove fields in your PivotTable report at any time.įor a visual presentation, you can create a PivotChart with interactive filtering controls so you can analyze a subset of your data. Tutorial: Import Data into Excel, and Create a Data Modelīefore you start out on your own, it might be helpful to follow the instructions in this tutorial to build a sample PivotTable in Excel that combines data from multiple tables into a Data Model. Behind the scenes, Excel creates a Data Model. Learn about different ways to create relationships between multiple tables in a PivotTable report for powerful data analysis. If you want to analyze data in multiple tables, you can do that in Excel. When the data you want to explore is stored in another file outside of Excel, like an Access database or Online Analytical Processing (OLAP) cube file, you can connect to that external data source to analyze its data in a PivotTable report.Ĭreate a PivotTable to analyze data in multiple tables Excel helps you get started by recommending one that works for your data.Ĭreate a PivotTable to analyze external data Make better business decisions by looking at your data from different angles in a PivotTable report. Just click the Power View button on the Insert tab to get started.Ĭreate a PivotTable to analyze worksheet data Power View helps you turn your Power Pivot data (or any other Excel data in a table) into a powerful interactive report that looks professional. There are a few differences you might want to compare before you get started. Tap into the full power of Power Pivot and Power View If you’ve got Office ProPlus installed, try taking advantage of these powerful add-ins:Ī built-in Data Model might be all you need to analyze data in multiple tables, but Power Pivot helps you create a sophisticated data model in a separate Power Pivot window. Plot your data directly into an interactive PivotChart In Excel, you can create a standalone (decoupled) PivotChart that lets you interact with and filter data right in the chart. Voila! You now have a Data Model to add more power to your data analysis. Just add data in multiple tables in Excel and then create relationships between them in a PivotTable or Power View sheet. The Data Model functionality is built into Excel. You can analyze data from more than one table in your PivotTable report in Excel, even if you don’t use Power Pivot.

Let Excel recommend a PivotTable To quickly show the data you want to analyze in Excel, start by picking a PivotTable in a layout that Excel recommends for your data.

Microsoft excel pivot tables