Pivot tables are an interactive display of information that allows users to analyze groups and large amounts of data in a compressed, tabular form for easier reporting and analysis. One of the advantages of this function in Excel is that it allows you to change, hide and display different categories in one file to provide an alternative representation of the data. In this article, you can read the instructions on how to make a table in Excel.
Step 1 of 3: Setting Up from the Ground Up
Launch Microsoft Excel.
Click the "Data" item in the menu, and then select the pivot table (note: in Excel 2007/2010, click "Paste"> pivot table).
, . Excel, , . «».
, « » «» . , «».
2 3: «»
. « ». , ( , Access), « ». « », « ».
. Excel , . , «» , , « », «».
«». , « ». .
« » .
«» ? , , , , , .
« » . « » .
, .
3 3: , «»
. , , , .
? , , , - . . , «» , .
- , , .
- , , .
, , . , , ( ).
A field from the source data that you assign to the page (or filter) is displayed in the pivot table report.
Understanding the above values, as well as some other settings, will allow you to better understand how to make a table in Excel. Remember that in different versions of the program, some menu items may differ.