Home
» Wiki
»
How to use PivotTable to analyze Excel data
How to use PivotTable to analyze Excel data
For accountants, you probably know that the PivotTable is a specialized Excel tool for statistics and data processing in reports , especially general reports that contain a lot of data.
In addition, the advanced features of the PivotTable allow you to analyze data according to one or more different requirements to extract data to create reports, statistics very accurate and scientific. In this article Download.com.vn will guide you how to use the PivotTable tool to analyze Excel spreadsheet data in detail on the Microsoft Office office toolkit .
Instructions to create PivotTable to analyze data on Excel spreadsheets
Step 1:
Select the data table you want to create a PivotTable on your Excel page, then click Insert on the menu bar and select PivotTable.
Step 2:
The Create PivotTable window appears, here we will see the selected table data is pre-filled and default opens on a new page. Click OK to close this window.
Step 3:
Immediately after a new Sheet is created, the selected columns are listed in the PivotTable Fields section .
To sum or statistic data of any table, you just need to select that column in PivotTable Fields and the data will appear on the screen for you.
Video tutorial on using PivotTable to analyze Excel data
Above we have shown you how to statistic data through the PivotTable feature. Hopefully the Excel PivotTable tool will be useful for your work.