How To Make A Pivot Table In Excel 2010 Youtube

You can enter your data range manually or quickly select it by dragging the mouse cursor across all cells in the range including the labeled column headers.

How to make a pivot table in excel 2010 youtube. Select COM Add-Ins and click GoCOM Add-Ins list Dialogue box pop-ups. If necessary adjust the range in the TableRange text box under the Select a Table or Range option button. A pivot table is an interactive table that lets you group and summarize data in a concise tabular format.

The foremost thing is to enable Power Pivot in your MS Excel. First of all please make sure to select the data range for which you want to make the pivot table. To begin with launch Excel 2010 spreadsheet that contains pivot table.

Pivot table tutorial in Excel 2010. A new sheet will be created with the pivot table tools. A tutorial showing how to summarize data by creating an interactive Pivot Table in Microsoft Excel 2010.

Excel should now remember the previous range so you just have to click on OK button. In this example weve selected cell A1 on Sheet2. We start off with enabling Platform field and then other fields.

Select all the data. After clicking on Go check the box which is next to Microsoft Power Pivot for Excel. To create a pivot table in Excel 2010 you will need to do the following steps.

Just enable the fields checkboxes seen at the right side of the window and Excel will automatically start populating pivot table report. In this example weve selected cell A1 on Sheet2. Select the fields as shown in the image below.