Pivot Table Di Excel 2010. Pivot tables are great for summarizing values in a table because they do their magic without making you create formulas to perform the calculations. In this example we ve selected cell a1.
Select the target cells where you want to. Excel automatically selects the data for you. Under choose the data that you want to analyze select select a table or range.
The following dialog box appears.
Under choose where you want the pivottable report to be placed select new worksheet to place the pivottable in a new worksheet or existing worksheet and then select the location you want the pivottable to appear. Before we get started we first want to show you the data for the pivot table. You can use a pivottable to analyze numerical data in detail and answer unanticipated questions about your data. The following dialog box appears.
