{"id":2603,"date":"2016-01-01T15:44:43","date_gmt":"2016-01-01T14:44:43","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2603"},"modified":"2024-02-06T16:19:24","modified_gmt":"2024-02-06T15:19:24","slug":"learn-the-power-of-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/learn-the-power-of-excel-pivot-tables\/","title":{"rendered":"Learn the Power of Excel Pivot Tables!"},"content":{"rendered":"<p><iframe src=\"https:\/\/www.youtube.com\/embed\/SMt7bycFF8E?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>What the heck are <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a>? \u00a0What do they do? \u00a0I have dabbled with them but I can&#8217;t get them to bloody work&#8230;Pfffff!<\/p>\n<p>These are the questions that I was asking myself a few years ago when I ventured into the unknown of Pivot Tables.<\/p>\n<p>Fast forward a few years and I am using Pivot Tables\u00a0in my daily job and creating management reports and dashboards that are the standard within my company. \u00a0I even got a promotion and was the go to guy for anything related to Excel!<\/p>\n<p>Since that day I have been helping my colleagues understand Pivot Tables and allowing them to harness their power so they too can become better at Excel, get noticed by top management and get that promotion or new job offer that they deserve.<\/p>\n<p>I have since left my corporate job to teach Excel full time &#8211; something I should have done years ago! &#8211; spreading the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> word to professionals juat like you.<\/p>\n<p>Pivot Tables are one of the most powerful features of <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\" title=\"Microsoft Excel\" data-wpil-keyword-link=\"linked\">Microsoft Excel<\/a>. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly presentations.<\/p>\n<p>I am going to show you the potential of Pivot Tables and its different analytical features so you too can overcome your Pivot Table fears and become an advanced user\u00a0in a very-very short time.<\/p>\n<p>I am also going to give you access to register to a\u00a0<span style=\"color: #000000;\"><strong>Free Pivot Table Webinar <\/strong><\/span>where I will teach you how to implement\u00a0the Pivot Table features that I touch upon below, all inside 1 hour!<\/p>\n<p>You can register now using this link:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/webinars\/event-registration\/\" target=\"_blank\">https:\/\/www.myexcelonline.com\/meo-staging\/webinars\/event-registration\/\u00a0<\/a><\/p>\n<p>Ok, lets get started&#8230;<\/p>\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 class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/learn-the-power-of-excel-pivot-tables\/#1_Summarize_Values_By_Total_Sales_Average_Maximum_Minimum%E2%80%A6\" title=\"1. Summarize Values By: Total Sales,\u00a0Average, Maximum, Minimum&#8230;\">1. Summarize Values By: Total Sales,\u00a0Average, Maximum, Minimum&#8230;<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/learn-the-power-of-excel-pivot-tables\/#2_Show_Values_As_of_Grand_Total_Running_Total_In_or_Year_to_Date_Difference_from_previous_monthyear%E2%80%A6\" title=\"2. Show Values As: % of Grand Total, Running Total In or Year to Date, Difference from previous month\/year&#8230;.\">2. Show Values As: % of Grand Total, Running Total In or Year to Date, Difference from previous month\/year&#8230;.<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/learn-the-power-of-excel-pivot-tables\/#3_Group_by_Numbers_Text_or_Dates\" title=\"3. Group by Numbers, Text or Dates:\">3. Group by Numbers, Text or Dates:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/learn-the-power-of-excel-pivot-tables\/#4_Use_interactive_buttons_called_Slicers_to_filter_your_data\" title=\"4. Use interactive buttons called Slicers to filter your data:\">4. Use interactive buttons called Slicers to filter your data:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/learn-the-power-of-excel-pivot-tables\/#5_Insert_Pivot_Charts_to_visualize_your_data\" title=\"5. Insert Pivot Charts to visualize your data:\">5. Insert Pivot Charts to visualize your data:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/learn-the-power-of-excel-pivot-tables\/#6_Create_Interactive_Dashboards\" title=\"6. Create Interactive Dashboards:\">6. Create Interactive Dashboards:<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Summarize_Values_By_Total_Sales_Average_Maximum_Minimum%E2%80%A6\"><\/span><span style=\"color: #ff0000;\">1. Summarize Values By: Total Sales,\u00a0Average, Maximum, Minimum&#8230;<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Summarize-Values-By.png\" rel=\"attachment wp-att-2605\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Learn the Power of Excel Pivot Tables!\"  class=\"alignnone size-full wp-image-2605\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Summarize-Values-By.png\" alt=\"Learn the Power of Excel Pivot Tables!\" width=\"627\" height=\"236\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Summarize-Values-By.png 627w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Summarize-Values-By-300x113.png 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Show_Values_As_of_Grand_Total_Running_Total_In_or_Year_to_Date_Difference_from_previous_monthyear%E2%80%A6\"><\/span><span style=\"color: #ff0000;\">2. Show Values As: % of Grand Total, Running Total In or Year to Date, Difference from previous month\/year&#8230;.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/show-values-as.png\" rel=\"attachment wp-att-2606\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Learn the Power of Excel Pivot Tables!\"  class=\"alignnone size-full wp-image-2606\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/show-values-as.png\" alt=\"Learn the Power of Excel Pivot Tables!\" width=\"549\" height=\"408\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/show-values-as.png 549w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/show-values-as-300x223.png 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Group_by_Numbers_Text_or_Dates\"><\/span><span style=\"color: #ff0000;\">3. Group by Numbers, Text or Dates:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Grouping.png\" rel=\"attachment wp-att-2608\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Learn the Power of Excel Pivot Tables!\"  class=\"alignnone size-full wp-image-2608\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Grouping.png\" alt=\"Learn the Power of Excel Pivot Tables!\" width=\"516\" height=\"531\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Grouping.png 516w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Grouping-292x300.png 292w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Use_interactive_buttons_called_Slicers_to_filter_your_data\"><\/span><span style=\"color: #ff0000;\">4. Use interactive buttons called Slicers to filter your data:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/slicers.png\" rel=\"attachment wp-att-2609\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Learn the Power of Excel Pivot Tables!\"  class=\"alignnone size-full wp-image-2609\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/slicers.png\" alt=\"Learn the Power of Excel Pivot Tables!\" width=\"891\" height=\"207\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/slicers.png 891w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/slicers-300x70.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/slicers-768x178.png 768w\" sizes=\"(max-width: 891px) 100vw, 891px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_Insert_Pivot_Charts_to_visualize_your_data\"><\/span><span style=\"color: #ff0000;\">5. Insert Pivot Charts to visualize your data:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/chart2.png\" rel=\"attachment wp-att-2610\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Learn the Power of Excel Pivot Tables!\"  class=\"alignnone size-full wp-image-2610\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/chart2.png\" alt=\"Learn the Power of Excel Pivot Tables!\" width=\"673\" height=\"390\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/chart2.png 673w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/chart2-300x174.png 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/chart1.png\" rel=\"attachment wp-att-2611\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Learn the Power of Excel Pivot Tables!\"  class=\"alignnone size-full wp-image-2611\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/chart1.png\" alt=\"Learn the Power of Excel Pivot Tables!\" width=\"724\" height=\"391\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/chart1.png 724w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/chart1-300x162.png 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"6_Create_Interactive_Dashboards\"><\/span><span style=\"color: #ff0000;\">6. Create Interactive Dashboards:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>I hope your eyes have now opened to the possibilities and the power of Excel Pivot Tables!<\/p>\n<p>If you want to learn how to apply these awesome features then please join me in my free Pivot Table webinar which I will be hosting from today and up to\u00a0Friday the 25th of March &#8211; three time per day!<\/p>\n<p>Click or copy &amp;paste the following link to join &amp; get better at Excel today:<\/p>\n<p><strong>WEBINAR LINK &gt;&gt;<\/strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/webinars\/event-registration\/\" target=\"_blank\">https:\/\/www.myexcelonline.com\/meo-staging\/webinars\/event-registration\/<\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/webinars\/event-registration\/\" target=\"_blank\" rel=\"attachment noopener wp-att-2466 noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2466 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/380x250.gif\" alt=\"380x250\" width=\"380\" height=\"250\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ufeff What the heck are Pivot Tables? \u00a0What do they do? \u00a0I have dabbled with them but I can&#8217;t get them to bloody work&#8230;Pfffff! These are the questions that I was asking myself a few years ago when I ventured into the unknown of Pivot Tables. Fast forward a few years and I am using [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":15464,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2603"}],"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=2603"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2603\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/15464"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}