Home >> Pivot Table
A pivot table is a summarizing feature of MS Excel, unique from a chart or graph, and is much more useful. You can create many new tables from it just by restructuring the fields and that too through a drag-and-drop movement of your mouse –and hence the name “pivot” table. A pivot table can do calculations, assort data, and present them in an easy-to-comprehend layout. Pivot tables and charts are essential parts of Excel –though they may not be as widely used. Merely storing data is not enough unless it is rendered meaningful, communicated and used to detect trends and patterns in the data for decision-making purposes. This can be possible only through simpler and clearer data representation which in turn calls for use of pivot tables. Pivot tables consist of columns, rows and data. Here we’ll teach you how to create a pivot table from Excel. It’s a 3-steps process. Open a pivot table from an existing Excel sheet that contains a list of data by clicking on “Data” and then selecting “PivotTable” from it. You’ll be directed by Excel to go through 3 steps to create a pivot table.
Step 1: A PivotTable and PivotChart wizard dialog box will open. Choose PivotTable option and then click Next.
Step 2: Dialog box will then ask you to determine the data range you want pivot table to include and analyze. You can select a portion of data or select all.
Step 3: Choose to save the just created pivot table either in the same sheet or in a new sheet.
Now you can choose the fields you want to compare and analyze from the PivotTable Field List. Drag the desired fields to the column and row drop fields to make a table and compare values for deriving conclusions. You can also send a field back to field list. You can aslo keep changing fields in the column and row drop fields to get as many table structures as you need to for your purpose.
Isn’t it easy to do so much good work with an Excel pivot table? It is indeed, and very useful too. However, pivot tables much as they are important analyzing and summarizing tools, they are as prone to get corrupted and damaged. Corruption can result from a number of hardware, software or application malfunctioning that may lead to partial or total loss of data not only from the pivot tables but from entire Excel sheets too. The best way is to use Stellar Phoenix Excel Recovery Software to repair all corruption, no matter what actually prompted it, and to recover your valuable pivot tables and whole Excel files. Buy your copy of the software to repair your corrupted Excel files and pivot tables. A demo version is available online for free. It allows you to repair Excel spreadsheets and pivot tables and see a preview of repaired files. To save, you need to have the full version of software.