In addition, David discusses several helpful Excel features, including the Table feature, PivotTable feature, Slicer feature, Custom List feature, and others.ĭavid demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel.
Advanced pivot tables in excel how to#
You’ll learn how to extract data from Microsoft Access databases and other sources, minimize repetitive steps in Excel by creating keyboard shortcuts, and much more. Congratulations! You have created a PivotTable from scratch.In this presentation, Excel expert David Ringstrom, CPA, digs deeper into pivot tables to show you step-by-step how to manipulate your pivot table data faster and more efficiently. Move fields around into new areas until you have created a table giving you the best insight into your data.
![advanced pivot tables in excel advanced pivot tables in excel](https://www.howtoexcelatexcel.com/wp-content/uploads/2018/03/PIVOT-TABLE-COLUMN-ROW-NAME-1024x576.gif)
In the box under the “Choose the data you want to analyze” area, type in the table/range area for the table for example ‘Sales Orders’!$A$1:$G$4, or drag the cursor over the data area for the table and the range will be added to the Table/Range field.
![advanced pivot tables in excel advanced pivot tables in excel](https://static.wixstatic.com/media/fa8f76_8162d2478ed84feab45a14f716158e20~mv2.png)
Once the area is selected, click the PivotTable button under the Insert tab, Tables Group.
![advanced pivot tables in excel advanced pivot tables in excel](https://www.stellarising.com/hs-fs/hubfs/Imported_Blog_Media/Advanced-PPC-4.png)
If you are more familiar with pivot tables, or simply wish to create one from the ground up, this button allows you select and reorganize the data however you want to see the data interpreted. In this example, the Sum of Unit Sale by Region is selected. Scroll through the options, select one and click OK.