Pivot Tabelle Excel. A pivot table allows you to create visual reports of the data from a spreadsheet. Excel automatically selects the data for you.
Click any single cell inside the data set. Excel will display the create pivottable dialog with your range or table name selected. Click a cell in the source data or table range.
If you re using excel for mac 2011 and earlier the pivottable button is on the data tab in the analysis group.
Go to insert pivottable. How to create pivot tables in excel. Click any single cell inside the data set. The steps below will walk through the process.