{"id":4275,"date":"2018-08-20T10:45:01","date_gmt":"2018-08-20T10:45:01","guid":{"rendered":"https:\/\/www.isumsoft.com\/it\/?p=4275"},"modified":"2019-11-27T09:59:38","modified_gmt":"2019-11-27T09:59:38","slug":"how-to-create-pivottable-in-excel-2016-manually","status":"publish","type":"post","link":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/","title":{"rendered":"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually"},"content":{"rendered":"<p>Making charts with excel is part of the job. In order to make the charts more intuitive to reflect the data, many editors often create PivotTable in Excel 2016, but many friends are not clear about how to make the charts. Here is <a href=\"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/\">how to create PivotTable in Excel 2016<\/a>.<\/p>\n<h2>Steps to create PivotTable in Excel 2016 manually<\/h2>\n<p>Step 1: Open the data document in excel 2016, which is the cost reimbursement situation of 3 salesmen in 2017-2018.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"609\" class=\"alignnone size-full wp-image-4281\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/open-the-data-document.png\" alt=\"open the data document\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/open-the-data-document.png 491w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/open-the-data-document-242x300.png 242w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/open-the-data-document-80x99.png 80w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/p>\n<p>Step 2: Click any cell in the data area with the mouse, and click <strong>Insert<\/strong>, go to <strong>Tables<\/strong> &gt; <strong>PivotTable<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"488\" height=\"609\" class=\"alignnone size-full wp-image-4277\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-pivottable.png\" alt=\"click PivotTable\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-pivottable.png 488w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-pivottable-240x300.png 240w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-pivottable-80x100.png 80w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/><\/p>\n<p>Step 3: At this time, a dialog box &#8220;<strong>Create PivotTable<\/strong>&#8221; pops up. You can see the data (<strong>Sheet1!$A$1:$F$15<\/strong>) we selected is displayed in the text behind &#8220;<strong>Table\/Range<\/strong>&#8220;, then select <strong>New Worksheet<\/strong> and click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"401\" height=\"352\" class=\"alignnone size-full wp-image-4282\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-new-worksheet.png\" alt=\"select new worksheet\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-new-worksheet.png 401w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-new-worksheet-300x263.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-new-worksheet-80x70.png 80w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/p>\n<p>Step 4: In the <strong>PivotTable Fields<\/strong> list, click the <strong>triangle symbol<\/strong> on the right and select <strong>Fields Section and Areas Section Side-By-Side<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"488\" height=\"416\" class=\"alignnone size-full wp-image-4278\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-the-triangle-symbol.png\" alt=\"click the triangle symbol\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-the-triangle-symbol.png 488w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-the-triangle-symbol-300x256.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-the-triangle-symbol-80x68.png 80w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/><\/p>\n<p>Step 5: Drag <strong>Year<\/strong> into <strong>FILTERS<\/strong> area, drag <strong>Usage<\/strong> into <strong>ROWS<\/strong> area and drag <strong>Zhang San<\/strong>, <strong>Li Si<\/strong>, <strong>Wang Wu<\/strong> into the <strong>VALUES<\/strong> area.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"534\" height=\"609\" class=\"alignnone size-full wp-image-4279\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/drag-to-the-appropriate-position.png\" alt=\"drag to the appropriate position\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/drag-to-the-appropriate-position.png 534w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/drag-to-the-appropriate-position-263x300.png 263w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/drag-to-the-appropriate-position-80x91.png 80w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/p>\n<p>Step 6: After you select the options that need to be summarized, you can see that the table data will be summed up well. Click any cell that has aggregated the data, click <strong>Insert<\/strong> and choose the <strong>chart format<\/strong> you want.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"418\" class=\"alignnone size-full wp-image-4276\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/choose-the-chart-format.png\" alt=\"choose the chart format\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/choose-the-chart-format.png 610w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/choose-the-chart-format-300x206.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/choose-the-chart-format-80x55.png 80w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/p>\n<p>Step 7: Next, a PivotTable will be generated. Then you can see at a glance the sum of each person&#8217;s cost for operating and recruiting respectively.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"514\" height=\"710\" class=\"alignnone size-full wp-image-4280\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/generate-pivottable.png\" alt=\"generate a PivotTable\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/generate-pivottable.png 514w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/generate-pivottable-217x300.png 217w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/generate-pivottable-80x111.png 80w\" sizes=\"auto, (max-width: 514px) 100vw, 514px\" \/><\/p>\n<p>The above is the method of creating the PivotTable in Excel 2016. The operation is so simple, you just follow the above steps to operate, I hope to help you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Making charts with excel is part of the job. In order to make the charts more intuitive to reflect the data, many editors often create PivotTable in Excel 2016, but many friends are not clear about how to&#8230; <\/p>\n","protected":false},"author":2,"featured_media":5673,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[217,216],"class_list":["post-4275","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","tag-create-a-pivottable","tag-make-chart"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually<\/title>\n<meta name=\"description\" content=\"If you are not clear about how to create a PivotTable manually, no worries, this guide\u00a0shows you how to create PivotTable in Excel 2016.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually\" \/>\n<meta property=\"og:description\" content=\"If you are not clear about how to create a PivotTable manually, no worries, this guide\u00a0shows you how to create PivotTable in Excel 2016.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/\" \/>\n<meta property=\"og:site_name\" content=\"iSumsoft\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/isumsofthome\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-20T10:45:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-27T09:59:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/excel-pivot-table.png\" \/>\n\t<meta property=\"og:image:width\" content=\"606\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Darren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:site\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Darren\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/\"},\"author\":{\"name\":\"Darren\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\"},\"headline\":\"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually\",\"datePublished\":\"2018-08-20T10:45:01+00:00\",\"dateModified\":\"2019-11-27T09:59:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/\"},\"wordCount\":273,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/excel-pivot-table.png\",\"keywords\":[\"create\u00a0a PivotTable\",\"make chart\"],\"articleSection\":[\"Office\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/\",\"name\":\"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/excel-pivot-table.png\",\"datePublished\":\"2018-08-20T10:45:01+00:00\",\"dateModified\":\"2019-11-27T09:59:38+00:00\",\"description\":\"If you are not clear about how to create a PivotTable manually, no worries, this guide\u00a0shows you how to create PivotTable in Excel 2016.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/excel-pivot-table.png\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/excel-pivot-table.png\",\"width\":606,\"height\":400,\"caption\":\"Excel Pivot Table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-create-pivottable-in-excel-2016-manually\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"name\":\"iSumsoft\",\"description\":\"Tell You More about IT World\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\",\"name\":\"iSumsoft Studio\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"width\":16,\"height\":16,\"caption\":\"iSumsoft Studio\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/isumsofthome\\\/\",\"https:\\\/\\\/x.com\\\/iSumsoft\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL9RaYqRcQ0f0buIzXiaNDw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\",\"name\":\"Darren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"caption\":\"Darren\"},\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/author\\\/darren-king\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually","description":"If you are not clear about how to create a PivotTable manually, no worries, this guide\u00a0shows you how to create PivotTable in Excel 2016.","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:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/","og_locale":"en_US","og_type":"article","og_title":"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually","og_description":"If you are not clear about how to create a PivotTable manually, no worries, this guide\u00a0shows you how to create PivotTable in Excel 2016.","og_url":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/","og_site_name":"iSumsoft","article_publisher":"https:\/\/www.facebook.com\/isumsofthome\/","article_published_time":"2018-08-20T10:45:01+00:00","article_modified_time":"2019-11-27T09:59:38+00:00","og_image":[{"width":606,"height":400,"url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/excel-pivot-table.png","type":"image\/png"}],"author":"Darren","twitter_card":"summary_large_image","twitter_creator":"@iSumsoft","twitter_site":"@iSumsoft","twitter_misc":{"Written by":"Darren","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/#article","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/"},"author":{"name":"Darren","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798"},"headline":"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually","datePublished":"2018-08-20T10:45:01+00:00","dateModified":"2019-11-27T09:59:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/"},"wordCount":273,"commentCount":0,"publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/excel-pivot-table.png","keywords":["create\u00a0a PivotTable","make chart"],"articleSection":["Office"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/","url":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/","name":"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/#primaryimage"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/excel-pivot-table.png","datePublished":"2018-08-20T10:45:01+00:00","dateModified":"2019-11-27T09:59:38+00:00","description":"If you are not clear about how to create a PivotTable manually, no worries, this guide\u00a0shows you how to create PivotTable in Excel 2016.","breadcrumb":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/#primaryimage","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/excel-pivot-table.png","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/excel-pivot-table.png","width":606,"height":400,"caption":"Excel Pivot Table"},{"@type":"BreadcrumbList","@id":"https:\/\/www.isumsoft.com\/it\/how-to-create-pivottable-in-excel-2016-manually\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.isumsoft.com\/it\/"},{"@type":"ListItem","position":2,"name":"How to\u00a0Create\u00a0PivotTable in\u00a0Excel\u00a02016 Manually"}]},{"@type":"WebSite","@id":"https:\/\/www.isumsoft.com\/it\/#website","url":"https:\/\/www.isumsoft.com\/it\/","name":"iSumsoft","description":"Tell You More about IT World","publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.isumsoft.com\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.isumsoft.com\/it\/#organization","name":"iSumsoft Studio","url":"https:\/\/www.isumsoft.com\/it\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","width":16,"height":16,"caption":"iSumsoft Studio"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/isumsofthome\/","https:\/\/x.com\/iSumsoft","https:\/\/www.youtube.com\/channel\/UCL9RaYqRcQ0f0buIzXiaNDw"]},{"@type":"Person","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798","name":"Darren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","caption":"Darren"},"url":"https:\/\/www.isumsoft.com\/it\/author\/darren-king\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/4275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/comments?post=4275"}],"version-history":[{"count":0,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/4275\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media\/5673"}],"wp:attachment":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media?parent=4275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/categories?post=4275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/tags?post=4275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}