{"id":244,"date":"2014-09-24T11:38:57","date_gmt":"2014-09-24T09:38:57","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=244"},"modified":"2024-06-03T03:58:00","modified_gmt":"2024-06-03T01:58:00","slug":"insert-a-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-a-pivot-table\/","title":{"rendered":"Insert a Pivot Table"},"content":{"rendered":"<p>Pivot Tables allow you to analyze thousands of rows of data with just a few mouse clicks.\u00a0 It is the most powerful tool within Excel due to its speed and output and I will show you just how easy it is to create one.<\/p>\n<p>If you are using a table or data set to analyze your information, then you should always use a <a class=\"wpil_keyword_link\" title=\"Pivot Table\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> which will enhance your analytical capabilities as well as save you heaps of time off your daily routine.<\/p>\n<p>Pivot Tables are used by Project Managers, Finance Analysts, Auditors, Cost Controllers, Sales Analysts, Financial Controllers, Human Resources, Doctors and Statisticians just to name a few.\u00a0 Heck, I even created an in depth <span style=\"color: #0000ff;\"><strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #0000ff;\">online course on Pivot Tables<\/span><\/a><\/strong><\/span>, that&#8217;s how in demand this Excel tool is in right at this moment!<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-Pivot-Table.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-Pivot-Table.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Insert-a-Pivot-Table.xlsx<\/span><\/a><\/p>\n<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-a-pivot-table\/#Insert_a_Pivot_Table\" title=\"Insert a Pivot Table\">Insert a Pivot Table<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Insert_a_Pivot_Table\"><\/span>Insert a Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Click in your dataset.\u00a0 Make sure your data does not have any blank cells, columns or rows!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6688\" title=\"Insert a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-01.jpg\" alt=\"Insert a Pivot Table\" width=\"631\" height=\"230\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-01.jpg 631w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-01-300x109.jpg 300w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Go to\u00a0<strong><em>Insert &gt; Pivot Table<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6689\" title=\"Insert a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-02.jpg\" alt=\"Insert a Pivot Table\" width=\"217\" height=\"123\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>Place the Pivot Table in a\u00a0<strong>New or Existing Worksheet<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6690\" title=\"Insert a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-03.jpg\" alt=\"Insert a Pivot Table\" width=\"416\" height=\"301\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-03.jpg 416w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-03-300x217.jpg 300w\" sizes=\"(max-width: 416px) 100vw, 416px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong> <\/span>Drag and Drop the fields<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6691\" title=\"Insert a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-04.jpg\" alt=\"Insert a Pivot Table\" width=\"341\" height=\"493\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-04.jpg 341w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-04-208x300.jpg 208w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/p>\n<p>You now have your Pivot Table!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6692\" title=\"Insert a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-05.jpg\" alt=\"Insert a Pivot Table\" width=\"343\" height=\"186\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-05.jpg 343w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/02-insert-a-pivot-table-05-300x163.jpg 300w\" sizes=\"(max-width: 343px) 100vw, 343px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot Tables allow you to analyze thousands of rows of data with just a few mouse clicks.\u00a0 It is the most powerful tool within Excel due to its speed and output and I will show you just how easy it is to create one. If you are using a table or data set to analyze [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17505,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Insert a Pivot Table","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[17,4],"tags":[87,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/244"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=244"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/244\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17505"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}