Here you must select the source of data for the PivotTable. Click the “PivotTable” drop-down button in the “Tables” group and choose either the “PivotTable” or “PivotChart” command, as desired.Įither way, next you will see the “Create PivotTable” dialog box appear.

Next, click the “Insert” tab in the Ribbon. To create a PivotTable, first select the worksheet that contains the data from which you want to create a PivotTable. Excel makes it easy to create a PivotTable from your data.

The best way to learn how to use PivotTables is to actually create one with which you can experiment and practice. In addition to the PivotTables, you can also create PivotCharts, which use the data from PivotTables but display it in a graphic format. When you create a PivotTable, you are comparing information in your worksheet and then calculating intersecting values of your choosing. Probably the most helpful feature of PivotTables is the ability that they have to be reorganized quickly and easily to change what information they are displaying and calculating. PivotTables allow you to organize massive amounts of data in more coherent and meaningful ways to extract from the data exactly what you want to know. You can use the PivotTable feature of Excel to access some of the most powerful data-analysis that Excel can provide.

QuickBooks Desktop (PC/Windows) 2022-2015.

Mac OS Ventura-Mojave Keyboard Shortcuts.

Pivot excel 2013