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!