{"id":144,"date":"2022-08-10T02:35:19","date_gmt":"2022-08-10T02:35:19","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=144"},"modified":"2024-02-08T16:40:17","modified_gmt":"2024-02-08T16:40:17","slug":"how-to-create-pivot-table-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-create-pivot-table-in-excel\/","title":{"rendered":"How to Create a Pivot Table in Excel?"},"content":{"rendered":"

Pivot Table in Excel offers unparalleled flexibility in data analysis, allowing users to summarize, organize, and visualize vast datasets effortlessly. With its intuitive interface and powerful features, Pivot Table in Excel empowers users to derive valuable insights, identify trends, and make informed decisions. Whether you’re analyzing sales figures, tracking expenses, or evaluating marketing campaigns, Pivot Table in Excel is your go-to tool for streamlining data analysis and driving business success. Unlock the full potential of your data with Pivot Table in Excel and take your analysis to the next level.<\/p>\n

Pivot Tables in Excel<\/strong><\/h2>\n

Pivot tables are a type of table in Excel that allow you to easily summarize data. Typically, you would use a pivot table to summarize data from a large data set. The data is divided into rows and columns, and the pivot table allows you to summarize the data by different criteria. For example, you could summarize sales data by product, by region, or by month.<\/p>\n

How do I create a pivot table ?<\/strong><\/h2>\n

To create a pivot table excel, you first need to have some data in Excel that is divided into rows and columns. Once you have the data set up, go to the Insert tab and select Pivot Table.<\/p>\n

A new worksheet will open with a blank pivot table. Drag and drop the fields from your data set into the appropriate places in the pivot table.<\/p>\n

We use following sample table from a large data set to summarize in a pivot table:<\/p>\n

\"Pivot<\/p>\n

The table has 7 columns with sales and profit data in different segments and in different countries for two years splitting into months. Let\u2019s see the process of creating the pivot table from very first stage.<\/p>\n

How pivot table in excel inserted?<\/strong><\/h2>\n

To create a pivot table, keep your cursor in any cell of data.<\/p>\n

\"Pivot<\/p>\n

Then click on Insert menu tab and choose PivotTable<\/p>\n

\"Pivot<\/p>\n

A new dialog box will appear indicating the Table\/range of data and to choose an option where the pivot table will be placed.<\/p>\n

By default, pivot table will place in a new worksheet. Click OK to create a pivot table in a new worksheet.<\/p>\n

You can choose existing worksheet, in that case you need to select the location i.e., cell number of existing sheet (e.g., J1).<\/p>\n

\"Pivot<\/p>\n

After clicking OK, two pop up menus will be appeared. First one is showing where the Pivot Table will be place and second one is showing the fields which can be included in the Pivot Table.<\/p>\n

\"Pivot<\/p>\n

Now from second pop up drag \u2018Country\u2019 to Rows section, \u2018Sales\u2019 and \u2018Profit\u2019 to Values section. As a result, we will get the summary result of 700 columns each country\u2019s Sales and Profit data in just 7 columns.<\/p>\n

\"Pivot<\/p>\n

Add a Filter in Pivot Table<\/strong><\/h2>\n

Filters in Pivot Table help you to segregate your data in more customize way. Pivot table filters work same way as Excel filters which summarize data as per selected attributes.<\/p>\n

To create filter in Pivot Table, please see the following steps in our example:<\/p>\n

Now drag \u2018Segment\u2019 to Filter section<\/p>\n

\"Filter<\/p>\n

Pivot table will look like below<\/p>\n

\"Filter<\/p>\n

Now from Segment drop down select Government to summarize its data and click OK.<\/p>\n

\"Filter<\/p>\n

Data will be filtered by \u2018Government\u2019 segment.<\/p>\n

\"pivot<\/p>\n

Application of Pivot Table in Excel<\/strong><\/h2>\n