12/3/2022 0 Comments 2010 excel pivot table tutorial![]() ![]() Next you will see the “PivotTable Field List” task pane appear at the side of your workbook window. When you are finished, click “OK” to create your new PivotTable or PivotChart. If you click the “Existing Worksheet” choice, then you’ll have to click into the “Location:” text box and then click into the worksheet to select the cell that will become the upper left corner of the PivotTable or PivotChart. Your choices are: “Select a table or range,” which pulls the data from your Excel worksheet, or “Use an external data source,” which allows you to use data from a query or an open database connection.īelow that area, you have to select whether you want to place the PivotTable or PivotChart into a new worksheet or an existing worksheet. ![]() 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. Need more Excel training? Click here for the complete tutorial! ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |