How to make a pivot table in Excel

To complete the data in the table in the most convenient way and always be able to quickly access them, try to make a summary table in the Microsoft Office Excel program. Drawing up this type of table will take you a couple of minutes, and its use will save the precious time in the future.

Go to the Excel program. In the program header among the sets of sections, find the "Insert" and click on it.

You will need the "Summary Table" tool if the data you have already entered and formatted. If not, proceed to enter.

When you fill in the cells with the desired information, do not forget to immediately align the data as you need.

Now click on the Summary Table window, select the same name in the drop-down list. Please note: do not click by chance to the second point with a similar name, it is responsible for the chart.

Before you appears such a window to create a table. Select in the first column "Select a table or range" in order to manually select the area to create a table. In the second column, check on what sheet it is required to make a summary table: the current or next.
This is especially convenient when you are not sure one hundred percent that you will not change your values \u200b\u200bin cells. You just create a table on the next sheet, and when fixes, you can delete it without losing information.

Pull the cursor in the table area, from where you want to capture the data. You will see that new coordinates appear in the "Table or Range" field. Click "OK", how to finish the selection.

Your pivot table is created. On the right you will see separately each column of your table. Check the ticks to display them all individually each.

You can freely move on your pivot table, however, the corrections directly in the cells are invalid. Note that the formatting parameters will be saved and fully transferred to this table.
The amount value will be displayed separately under each column automatically, on the bottom from the bottom you will see some options for editing the table.

Now you can easily create consolidated tables in the Microsoft program - Excel program. It has options for building data from a completely different table, even on another sheet. And highlighting different columns, you have the ability to combine many tables in one.

This type of tables is better to use with very volumetric and large tables, as you do not have to manually set the amount value for each column.