{"id":1182,"date":"2023-08-10T01:47:09","date_gmt":"2023-08-10T01:47:09","guid":{"rendered":"https:\/\/businessyield.com\/tech\/?p=1182"},"modified":"2023-08-10T01:47:12","modified_gmt":"2023-08-10T01:47:12","slug":"how-to-create-a-pivot-table-in-excel","status":"publish","type":"post","link":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/","title":{"rendered":"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Creating a pivot table not only makes your work swift but also very accurate. In other words, nothing can go wrong when using the pivot tables. You are going to learn the pivot table&#8217;s importance and its formula. More importantly, you&#8217;re going to learn how to create a pivot table in Excel. Let&#8217;s begin by explaining what a Pivot table is.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-a-pivot-table-in-excel\"><span id=\"what-is-a-pivot-table-in-excel\">What Is a Pivot Table in Excel?<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A pivot table in Excel&nbsp;is a data summary packaged in a graphic that allows you to report on and examine patterns based on your data. Pivot tables are very handy if you have a long row or column of information that you need to track the sums of and compare to one another.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To put it another way,&nbsp;pivot tables make sense of the seemingly infinite mess of numbers on your screen. And, more particularly, it allows you to group your data in various ways so that you can readily draw useful conclusions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The &#8220;pivot&#8221; part of a pivot table refers to the ability to rotate (or pivot) the data in the table to examine it from a different angle. Just so you know, when&nbsp;you pivot, you are not adding to, subtracting from, or otherwise affecting your data. Instead, you are merely restructuring the data so that useful information can be revealed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-uses-of-pivot-table-in-excel\"><span id=\"uses-of-pivot-table-in-excel\">Uses of Pivot Table in Excel<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The goal of pivot tables is to provide user-friendly methods for quickly summarizing vast volumes of data. They can be used to more thoroughly interpret, display, and analyze numerical data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can use this information to help detect and answer unexpected queries about the data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here are some circumstances in which a pivot table could be useful:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-1-when-comparing-total-sales-of-various-products\"><span id=\"1-when-comparing-total-sales-of-various-products\">#1. When comparing total sales of various products<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Assume you have a spreadsheet with monthly sales data for three different products: product A, product B, and product C. You want to figure out which of the three is bringing in the most money.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One method is to go through the worksheet and manually add the matching sales figure to a running total whenever product A&nbsp;appears. Then repeat the process for products B&nbsp;and C&nbsp;until you get totals for all of them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Consider your monthly sales worksheet to have hundreds upon hundreds of rows. Manually sorting through each necessary piece of data could take an eternity.&nbsp;In less than a minute, pivot tables can automatically combine all of the sales numbers for the products&nbsp;and calculate their respective sums.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-2-when-checking-the-percentage-of-total-sales\"><span id=\"2-when-checking-the-percentage-of-total-sales\">#2. When checking the percentage of total sales<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">When you create a pivot table in Excel, it automatically displays the totals of each row or column. However, that is not the only figure that may be generated automatically.&nbsp;Assume you entered quarterly sales figures for three different items into an Excel sheet and converted the data into a pivot table. The pivot table goes ahead and&nbsp;calculates three totals at the bottom of each column based on the quarterly sales of each product.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">But if you want&nbsp;to know the&nbsp;percentage of overall <a href=\"https:\/\/businessyield.com\/bs-business\/business-sales\/\">business sales<\/a> the products contributed rather than just their total&nbsp;sales, you can arrange each column to tell you the column&#8217;s percentage of all three column totals using a pivot table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Simply right-click the cell containing a sales total and select Show Values As &gt;% of Grand Total to display product sales as percentages of total sales in a pivot table.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-3-bringing-together-duplicate-data\"><span id=\"3-bringing-together-duplicate-data\">#3. Bringing Together Duplicate Data<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">In this case, you&#8217;ve recently finished a blog makeover and have to update a lot of URLs. Unfortunately, your blog reporting platform did not handle the change adequately, and the &#8220;view&#8221; numbers for single posts were spread across two separate URLs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You now have two instances of each unique blog post in your spreadsheet. To obtain accurate statistics, you must add the view totals for each of these duplicates.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can summarize your data (through a&nbsp;pivot table) by blog post title instead of manually searching for and combining all the metrics from the duplicates.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-4-obtaining-an-employee-headcount-for-individual-departments\"><span id=\"4-obtaining-an-employee-headcount-for-individual-departments\">#4. Obtaining an Employee Headcount for Individual Departments<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Pivot tables are useful for automatically calculating items that are difficult to find in a standard Excel spreadsheet. Counting rows that have something in common is one of them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Assume you have a list of employees in an Excel spreadsheet. The departments to which the personnel belong are listed next to their names. You can use this data to create a pivot table that displays the name of each department as well as the number of workers that work in that department.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The automated functions of the pivot table efficiently eliminate the chore of manually sorting the Excel sheet by department name and counting each entry.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-5-filling-in-the-blanks-with-default-values\"><span id=\"5-filling-in-the-blanks-with-default-values\">#5. Filling in the Blanks with Default Values<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Not every dataset entered into Excel will fill every cell. If you&#8217;re waiting for new data, you may have a lot of empty cells that look confused or require more explanation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A pivot table can be readily customized to fill empty cells with a default value, such as $0 or TBD (for &#8220;to be determined&#8221;). When multiple people are studying the same sheet of large data tables, being able to easily tag these cells is a valuable tool.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Right-click your pivot table and select PivotTable Options to automatically format the empty cells.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check the box labeled Empty Cells As and enter what you want to be shown&nbsp;when a cell has no other value in the window that appears.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-pivot-table-formula-in-excel\"><span id=\"pivot-table-formula-in-excel\">Pivot Table Formula in Excel<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pivot Table Field &amp; Formula in Excel is a Pivot Table feature that makes it easier to create calculated fields. A computed field draws its value from other fields. It facilitates easier and smoother data analysis, resulting in better decision-making.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Furthermore, this&nbsp;Pivot Table calculated field and formula feature&nbsp;allows&nbsp;data to be grouped in a sequence and used to calculate fields that are dependent on the values in other fields. The functionality allows users to easily submit data to the system.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-how-to-edit-the-pivot-table-calculated-field-amp-formula-in-excel\"><span id=\"how-to-edit-the-pivot-table-calculated-field-formula-in-excel\">How To Edit The Pivot Table Calculated Field &amp; Formula in Excel<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To add or edit&nbsp;the Pivot Table Calculated Field &amp; Formula in your Excel sheet, do this:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose a date range and create a Pivot Table.<\/li>\n\n\n\n<li>Then, on the ribbon, click the newly created Pivot Table to access the Analyze and Design Tabs.<\/li>\n\n\n\n<li>Lastly, select &#8220;Analyze&#8221; and the &#8220;Insert the Calculated Field&#8221; options.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-creating-pivot-table-in-excel\"><span id=\"creating-pivot-table-in-excel\">Creating Pivot Table in Excel<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It is critical to structure your data correctly before creating a Pivot table in Excel; otherwise, the results will be incorrect. Each data type should be organized in a separate column with a header on top, referred to as a data field. Depending on the kind of data, each data field should be represented as text, numeric, or date. In data fields, there should be no combined cells.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Assume you are employed by a corporation that exports cereals and feed to several countries. You have a data set of orders that have been processed to various nations on a date-by-date basis, and you want to investigate it to determine which product categories are best-selling in which countries. A pivot table lets you separate, filter, and organize data by product category, country, and date.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-create-a-pivot-table\"><span id=\"create-a-pivot-table\">Create a Pivot Table<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After structuring your data, you are now ready to create a Pivot table in Excel. To do this,&nbsp;you must first complete the following steps:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select any cell in your dataset by clicking on&nbsp;it.<br>Navigate to the Insert tab and select PivotTable from the Tables group.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Excel automatically chooses your data collection and, by default, produces a New Worksheet in which to place the Pivot table report. You can also choose the&nbsp;Existing Worksheet and the location where you want the Pivot table report to be displayed and click OK.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-inserting-data-fields\"><span id=\"inserting-data-fields\">Inserting Data Fields<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Excel generates the Report View pane on the left side and lists all the data columns in the Pivot Table Field List panel on the right side after inserting a Pivot Table. To create their report view on the left-hand side, you must select and drag data fields from the Field List panel and set them in the Row Labels, Column Labels, Filter, and Values boxes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can make single-dimensional or two-dimensional Pivot tables by inserting data fields into their relevant Labels. To do a calculation, number fields are placed in the Values area, and additional data fields are placed in the Row, Column, and Filter areas of the Pivot Table Fields list panel as needed.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-pivot-table-in-one-dimension\"><span id=\"pivot-table-in-one-dimension\">Pivot Table in One Dimension<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">For the selected data fields, a one-dimensional Pivot table summarizes the dataset in either a&nbsp;Row or Column arrangement.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A one-dimensional&nbsp;Pivot table, for example, is used when you only want to see a summarized report of all products. To do so, drag and drop the Product field into the Row or Column Label area and the Amount field into the Values area to sum their respective order amounts.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This table summarizes the sales figures for all products in the data set.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-pivot-table-with-two-dimensions\"><span id=\"pivot-table-with-two-dimensions\">Pivot Table with Two Dimensions<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Drag and drop data fields into the Rows and Columns boxes to construct two-dimensional Pivot tables. It divides the data further and provides more insight into the data by producing a new picture of the data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to show a summary of product sales by country, you could create a two-dimensional pivot table by inserting the Product field in the Row area, the Country field in the Column area, and the Amount field in the Values area. It will provide you with a breakdown of product sales by country.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-pivot-table-grouping\"><span id=\"pivot-table-grouping\">Pivot Table Grouping <\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">The pivot table can categorize the data in report view fields based on data type and user requirements. The date and time fields can be grouped into hours, minutes, days, months, quarters, and years. It is best to place such fields in the Row area, then right-click on any cell of that field within the pivot table, select Group, and then select the correct grouping item.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For instance, you could group the Date field in Months and summarize the Pivot table data for products sold by the&nbsp;month. Place the Date field in the Row area, and then the Product field beneath the Date field in the Row area. Go to the Pivot table; right-click in any cell in the Date field in the Pivot table, select Group, Months, and OK.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-display-product-values-in\"><span id=\"display-product-values-in\">Display Product Values in %<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">By default, the Pivot table in Excel displays values as &#8220;No Calculation.&#8221; However, you can change this by changing the Field Value Settings on the Value area field&#8217;s &#8220;Show Value As&#8221; tab.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can display the values as % of Row, % of Column, % of Grand Total, and so on. To do so, simply select &#8220;Value Field Settings&#8230;&#8221; from the drop-down list of the Amount field in the Value section.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On the Show Values As tab, select % of the grand total from the drop-down arrow and click OK.&nbsp;The Pivot table will alter the output as a percentage of the Grand Total values for each product and nation. In this manner, you can determine the contribution of each product to overall revenue by country.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-pivot-table-filtering\"><span id=\"pivot-table-filtering\">Pivot Table Filtering<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">You can filter Pivot Table results by inserting the data field in the Report Filter section and using filters to narrow down your results. If you wish to filter results based on product category, for instance,&nbsp;set the Category field in the Report Filter box and reduce the results by selecting one category from the list. Assume you just want to summarize products in the Feed&nbsp;category.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-summarize-value\"><span id=\"summarize-value\">Summarize Value<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A pivot table in Excel by default summarizes numeric field values using SUM. However, you can adjust this by modifying the Field Value Settings of the Value Area field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Instead of SUM, you can alter the output to COUNT, PERCENTAGE, or AVERAGE.&nbsp;Assume you want to know how many orders have been placed for each product in each country. To do so, simply select &#8220;Value Field Settings\u2026&#8221; from the drop-down list of the Amount field in the Value section.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Instead of the total&nbsp;values, the Report View pane will display a count of values in each country for each product.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-the-purpose-of-an-excel-pivot-table\"><span id=\"what-is-the-purpose-of-an-excel-pivot-table\">What is the purpose of an Excel Pivot Table?<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pivot Tables are used in Microsoft Excel to sort and summarize huge datasets. They allow you to change the pivot table fields, allowing you to easily pick which section of your dataset should be summarized.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By modifying the fields, you may construct interactive summaries that bring together vast amounts of data in the most logical way possible.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-the-simplest-approach-to-incorporating-a-pivot-table-into-your-spreadsheet\"><span id=\"what-is-the-simplest-approach-to-incorporating-a-pivot-table-into-your-spreadsheet\">What is the simplest approach to incorporating a Pivot Table into your spreadsheet?<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To enter a Pivot Table summary into your spreadsheet, navigate to the sheet (the first cell) where you want the Pivot Table summary to appear.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To open the Insert Pivot Table dialog box, go to the Insert Tab &gt; Pivot Table (or click the Alt Key &gt; N &gt; V).<br>Refer to the data-containing cells.<br>Select the &#8216;New Worksheet&#8217; option.<br>Click the Okay button.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-end\"><span id=\"the-end\">The End <\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">There you have it! A detailed guide on how to create a pivot table in Excel and work with ease and precision. With this information, you now have a clear understanding of what you want from your Pivot Table. You can also contact an Excel expert to help you figure it all out, just in case you need more help. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-related-posts\"><span id=\"related-posts\">Related Posts<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-make-a-book-in-minecraft\/\" target=\"_blank\" rel=\"noreferrer noopener\">HOW TO MAKE A BOOK IN MINECRAFT: Simple &amp;amp; Effective Methods<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/businessyield.com\/tech\/technology\/what-does-uc-mean-on-my-phone\/\" target=\"_blank\" rel=\"noreferrer noopener\">What Does UC Mean on My Phone? All You Need to Know<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/businessyield.com\/tech\/how-to\/best-family-cell-phone-plans\/\" target=\"_blank\" rel=\"noreferrer noopener\">BEST FAMILY CELL PHONE PLANS IN 2023<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/businessyield.com\/tech\/technology\/what-does-uc-mean-on-my-phone\/\" target=\"_blank\" rel=\"noreferrer noopener\">What Does UC Mean on My Phone? All You Need to Know<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-check-data-usage-on-iphone\/\" target=\"_blank\" rel=\"noreferrer noopener\">HOW TO CHECK DATA USAGE ON IPHONE: Definitive Guide<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/businessyield.com\/tech\/ecommerce\/what-are-push-notifications\/\" target=\"_blank\" rel=\"noreferrer noopener\">What Are Push Notifications? Everything You Need To Know<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-references\"><span id=\"references\">References<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.got-it.ai\/solutions\/\">got-it.ai<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.wallstreetmojo.com\/\">wallstreetmojo<\/a><\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"Creating a pivot table not only makes your work swift but also very accurate. In other words, nothing&hellip;\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":238,"featured_media":1363,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[11],"tags":[],"class_list":["post-1182","post","type-post","status-publish","format-standard","has-post-thumbnail","category-how-to"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide<\/title>\n<meta name=\"description\" content=\"Pivot Table Field &amp; Formula in Excel is a Pivot Table feature that makes it easier to create calculated fields. To add the Pivot table...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide\" \/>\n<meta property=\"og:description\" content=\"Pivot Table Field &amp; Formula in Excel is a Pivot Table feature that makes it easier to create calculated fields. To add the Pivot table...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Yield Technology\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-10T01:47:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-10T01:47:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/08\/Untitled-design-49.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Stanley Evergreen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stanley Evergreen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/\"},\"author\":{\"name\":\"Stanley Evergreen\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#\\\/schema\\\/person\\\/92de0d2ce310bcd009a2bc1c26621d9a\"},\"headline\":\"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide\",\"datePublished\":\"2023-08-10T01:47:09+00:00\",\"dateModified\":\"2023-08-10T01:47:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/\"},\"wordCount\":2341,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/businessyield.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/Untitled-design-49.jpg?fit=500%2C250&ssl=1\",\"articleSection\":[\"How-to\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/\",\"url\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/\",\"name\":\"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/businessyield.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/Untitled-design-49.jpg?fit=500%2C250&ssl=1\",\"datePublished\":\"2023-08-10T01:47:09+00:00\",\"dateModified\":\"2023-08-10T01:47:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#\\\/schema\\\/person\\\/92de0d2ce310bcd009a2bc1c26621d9a\"},\"description\":\"Pivot Table Field & Formula in Excel is a Pivot Table feature that makes it easier to create calculated fields. To add the Pivot table...\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/businessyield.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/Untitled-design-49.jpg?fit=500%2C250&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/businessyield.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/Untitled-design-49.jpg?fit=500%2C250&ssl=1\",\"width\":500,\"height\":250,\"caption\":\"ExcelNerds\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-create-a-pivot-table-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#website\",\"url\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/\",\"name\":\"Business Yield Technology\",\"description\":\"Best Tech Reviews, Apps, Phones, &amp; Gaming\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#\\\/schema\\\/person\\\/92de0d2ce310bcd009a2bc1c26621d9a\",\"name\":\"Stanley Evergreen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed38f9e6e08ee4271669d798619efc69f911b5cb9ef0cdaa748dbcdf6b5705ad?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed38f9e6e08ee4271669d798619efc69f911b5cb9ef0cdaa748dbcdf6b5705ad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed38f9e6e08ee4271669d798619efc69f911b5cb9ef0cdaa748dbcdf6b5705ad?s=96&d=mm&r=g\",\"caption\":\"Stanley Evergreen\"},\"url\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/author\\\/evergreen\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide","description":"Pivot Table Field & Formula in Excel is a Pivot Table feature that makes it easier to create calculated fields. To add the Pivot table...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide","og_description":"Pivot Table Field & Formula in Excel is a Pivot Table feature that makes it easier to create calculated fields. To add the Pivot table...","og_url":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/","og_site_name":"Business Yield Technology","article_published_time":"2023-08-10T01:47:09+00:00","article_modified_time":"2023-08-10T01:47:12+00:00","og_image":[{"width":500,"height":250,"url":"http:\/\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/08\/Untitled-design-49.jpg","type":"image\/jpeg"}],"author":"Stanley Evergreen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stanley Evergreen","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/#article","isPartOf":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/"},"author":{"name":"Stanley Evergreen","@id":"https:\/\/businessyield.com\/tech\/#\/schema\/person\/92de0d2ce310bcd009a2bc1c26621d9a"},"headline":"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide","datePublished":"2023-08-10T01:47:09+00:00","dateModified":"2023-08-10T01:47:12+00:00","mainEntityOfPage":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/"},"wordCount":2341,"commentCount":0,"image":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/08\/Untitled-design-49.jpg?fit=500%2C250&ssl=1","articleSection":["How-to"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/","url":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/","name":"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide","isPartOf":{"@id":"https:\/\/businessyield.com\/tech\/#website"},"primaryImageOfPage":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/08\/Untitled-design-49.jpg?fit=500%2C250&ssl=1","datePublished":"2023-08-10T01:47:09+00:00","dateModified":"2023-08-10T01:47:12+00:00","author":{"@id":"https:\/\/businessyield.com\/tech\/#\/schema\/person\/92de0d2ce310bcd009a2bc1c26621d9a"},"description":"Pivot Table Field & Formula in Excel is a Pivot Table feature that makes it easier to create calculated fields. To add the Pivot table...","breadcrumb":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/#primaryimage","url":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/08\/Untitled-design-49.jpg?fit=500%2C250&ssl=1","contentUrl":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/08\/Untitled-design-49.jpg?fit=500%2C250&ssl=1","width":500,"height":250,"caption":"ExcelNerds"},{"@type":"BreadcrumbList","@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-create-a-pivot-table-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/businessyield.com\/tech\/"},{"@type":"ListItem","position":2,"name":"HOW TO CREATE A PIVOT TABLE IN EXCEL: Step-By-Step Guide"}]},{"@type":"WebSite","@id":"https:\/\/businessyield.com\/tech\/#website","url":"https:\/\/businessyield.com\/tech\/","name":"Business Yield Technology","description":"Best Tech Reviews, Apps, Phones, &amp; Gaming","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/businessyield.com\/tech\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/businessyield.com\/tech\/#\/schema\/person\/92de0d2ce310bcd009a2bc1c26621d9a","name":"Stanley Evergreen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ed38f9e6e08ee4271669d798619efc69f911b5cb9ef0cdaa748dbcdf6b5705ad?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ed38f9e6e08ee4271669d798619efc69f911b5cb9ef0cdaa748dbcdf6b5705ad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed38f9e6e08ee4271669d798619efc69f911b5cb9ef0cdaa748dbcdf6b5705ad?s=96&d=mm&r=g","caption":"Stanley Evergreen"},"url":"https:\/\/businessyield.com\/tech\/author\/evergreen\/"}]}},"modified_by":"Stanley Evergreen","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/08\/Untitled-design-49.jpg?fit=500%2C250&ssl=1","gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/posts\/1182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/users\/238"}],"replies":[{"embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/comments?post=1182"}],"version-history":[{"count":8,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/posts\/1182\/revisions"}],"predecessor-version":[{"id":1419,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/posts\/1182\/revisions\/1419"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/media\/1363"}],"wp:attachment":[{"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/media?parent=1182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/categories?post=1182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/tags?post=1182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}