How to create a PivotTable in Microsoft Excel

When you have a lot of data, it often becomes increasingly difficult to analyze it. But does it really have to be this way? Microsoft Excel offers an amazing built-in feature called Pivot Tables that can be used to easily analyze huge chunks of data. They can be used to efficiently aggregate your data by creating your own custom reports. They can be used to automatically calculate the sum of a column, filters can be applied to it, the data within it can be sorted, etc. The things you can do with pivot tables and how to use them to ease your daily excel hurdles are endless.

Keep reading to learn how to easily create a Pivot Table and learn how to organize it effectively. Hope you enjoyed reading this article.

Section 1: What is a PivotTable

In very basic terms, you can think of a PivotTable as a dynamic report. However, there is a huge difference between reports and pivot tables. Reports are static, they do not provide any interaction. But unlike them, PivotTables allow you to view your data in many different ways. Additionally, a PivotTable does not require any formulas to form the data it holds. You can apply many filters on the pivot table and customize the data as per your requirements.

Part 2: Sample Data

In this article, we created a sample table that contains data for creating a PivotTable report. In the example table we created, there are columns Date, Item, Units Sold, and Profit. We are mainly interested in finding the daily total profit based on different projects. Let's see how to do this with detailed steps and examples.

Part 3: How to Create a Pivot Table

Creating a Pivot Table is very easy once you have your data ready.

Step 1: Click anywhere within the data. Next, click the Insert tab on the top ribbon. Now, click on the button named Pivot Table.

Step 2: NowCreate PivotDataTable window launches in front of you.

Under the "Select data to analyze" section, the radio option corresponding to the "Select a table or range" option will be selected by default Button. If there is no selection, select it.

Now, under the Select where you want the PivotTable to be placed section, you can choose to place it in a New worksheet or Existing worksheet Create a pivot table in the table.

If you select New Worksheet, the PivotTable will be created in a different worksheet. However, it is easier to compare the PivotTable and our sample data if they are both on the same worksheet, so I selected the Existing Worksheet option.

After selecting the radio button corresponding to the existing worksheet, click Select Cell# on the position field ## button.

Step 3:Create PivotDataThe table window will now be minimized. Click the cell where you want to start the PivotTable report. After selecting the cells, click the "Select Cells" button again to maximize the window.

Step 4: After returning to the "Create PivotTableTable" window, click "OK" button.

Step 5: That’s it. Your PivotTable report is now inserted into your worksheet. In the following sections, let us see how data is generated in a PivotTable and how to manipulate the data.

Step 1: Suppose you want to see the sum of profits . You don't need to write any formulas for this.

right pane where the Pivot table settings are located, you simply click on the # corresponding to the Profit column ## Checkbox.

If you look at your Excel worksheet, you will see that your PivotTable now only has one column and it reads Sum of Profit. It calculates the sum of all available profits in the sample data.

The above is the detailed content of How to create a PivotTable in Microsoft Excel. For more information, please follow other related articles on the PHP Chinese website!