How to make PivotTable in Excel

Excel pivot tables let you summarize data in a few clicks. The feature is very flexible and ideal for assisting in the analysis of spreadsheets with large amount of information. The user can toggle the values ​​between columns and rows in real time. The modifications are applied and displayed instantly, allowing you to arrive at the expected result with greater ease.

In the following step-by-step, learn how to create a PivotTable in Excel. The procedure was performed in the latest version of Office, but the tips are also valid for users of previous editions of the Microsoft program.

Seven Excel functions that few people know about

How to Create Charts in Microsoft Excel

Want to buy cell phone, TV and other discount products? Know the Compare

Step 1. Select a cell inside the table that you want to analyze and in the "Insert" tab, choose the "PivotTable" option;

Adding a PivotTable

Step 2. The table should be selected automatically. If this does not happen, click on the button indicated in the image and select your table manually;

If necessary, select the table with the data

Step 3. The PivotTable can be inserted into a new worksheet or the existing worksheet. If you want the table to be in the same worksheet as the data source table, click on the indicated button and select the location;

Choose where the PivotTable will be generated

Step 4. In the right side column, you need to mark the data that will be displayed in the PivotTable. Below you can drag the items between the "Filters", "Columns", "Lines" and "Values" fields;

Adjusting PivotTable Data

Step 5. Notice that with each change, the PivotTable is automatically updated to reflect the new configuration. Make the changes until you reach the desired result;

Adjusting PivotTable Data

Step 6. By default, fields with text are displayed in summed values. You can change this setting by clicking on the arrow to the right of the name of your column and, in the menu that appears, open "Field Settings ...";

Configuring Data Field

Step 7. Select the "Custom" option and choose how the data will be expressed. After making the desired changes, press "OK";

Configuring Data Field

Step 8. In the case of fields with values, the data is displayed together. To change them, access the field settings and, in the "Show Values ​​as" tab, choose the desired option;

Configuring Data Field

Step 9. Whenever an information or value is modified in your data source table, the PivotTable must be updated. To do this, right click on it and in the context menu select "Update". If you want to update all the pivot tables in your spreadsheet, you must go to the "Analyze" tab, go to "Update" and press the "Update All" option.

Updating PivotTable

What is the best way to convert a PDF file to Excel? Exchange tips in the Forum.