{"id":78,"date":"2012-09-22T10:42:03","date_gmt":"2012-09-22T02:42:03","guid":{"rendered":"http:\/\/excelchamp.net\/?p=78"},"modified":"2023-12-03T21:38:41","modified_gmt":"2023-12-03T13:38:41","slug":"how-to-analyze-data-using-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/","title":{"rendered":"How to Analyze Data using Excel Pivot Tables"},"content":{"rendered":"<p><strong>Do you know how easy it is to use the Pivot Tables in Excel, for Data Analysis?<\/strong><\/p>\n<p>To demonstrate this, I went to the Internet, and \u00a0found some travel data. It belongs to an unnamed Travel Company. The travel company collects the amount of ticket sales, the age of the passenger, and their gender only.<\/p>\n<p>Based on this, how do we analyze the data, and find some hidden gems of information that can make the data come alive, and aid us in doing some real life Marketing.<\/p>\n<p>Watch this <strong>step by step video on analyzing this data, using the <a href=\"https:\/\/www.excelchamp.net\/excel-data-analysis-waitinglist\" target=\"_blank\" rel=\"noopener\">Pivot Table technique in Microsoft Excel.<\/a> I am using Excel 2010 version<\/strong> for this demonstration.<br \/>\n<iframe src=\"http:\/\/www.youtube.com\/embed\/KIOXtVr4UAM\" width=\"560\" height=\"315\" frameborder=\"0\"><\/iframe><\/p>\n<p>As you can see,<strong> many hidden insights can be found by using the Pivot Tables in Excel<\/strong>. So get started&#8230; Use them in your day to day work, and become a Data Analyst, rather than a Data Gatherer or Data Reporter&#8230;<br \/>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"705\" class=\"elementor elementor-705 elementor-bc-flex-widget\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f5e9af elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f5e9af\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f6d494f\" data-id=\"f6d494f\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-db6834f elementor-widget elementor-widget-text-editor\" data-id=\"db6834f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div style=\"background-color: #ffffcc; color: black; border: thin Black; border-style: none; align = center; line-height: 27px; width: 95%; padding: 20px 30px 10px;\"><p style=\"text-align: center;\"><span style=\"color: #0000cd;\"><strong>Want to Improve Your Excel Skills?<\/strong><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">Learn the Key Features of Excel Quickly &amp; Easily, by <\/span><span style=\"color: #0000cd;\">Joining the<br \/> <a href=\"https:\/\/www.trueducate.com\/courses\/basic-excel-online\/\" target=\"_blank\" rel=\"noopener\"><u><strong>Online Training<\/strong> on <\/u><strong><u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">To Get Most out of Excel, Learn the\u00a0 <b><u><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Pivot Table techniques in our<br \/> Pivot Table Masterclass Training<\/a><\/u><\/b><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\"><strong>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t<br \/>\nHave you subscribed to the <a title=\"Subscribe to Excel Tips Newsletter\" href=\"http:\/\/excelchamp.net\/subscribe-to-excel-tips-newsletter\/\">ExcelChamp.Net Email Newsletter<\/a>, where we send you such tips by email?<\/p>\n<p><strong>Additional Resources<\/strong><\/p>\n<ul>\n<li><a title=\"How To Show Values &amp; Percentages in Excel Pivot Tables\" href=\"http:\/\/excelchamp.net\/how-to-show-values-percentages-in-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\">Showing Values &amp; Percentages in Excel Pivot Tables<\/a><\/li>\n<li><a href=\"https:\/\/www.youtube.com\/excelchamp\" target=\"_blank\" rel=\"noopener noreferrer\">Watch ExcelChamp Video Tutorials on YouTube<\/a><\/li>\n<li><a href=\"http:\/\/excelchamp.net\/creating-a-two-axis-chart-in-excel-2010\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Create a 2 Axis Charts in Excel<\/a><\/li>\n<\/ul>\n<p>Cheers,<br \/>\nVinai Prakash, PMP, ITIL, MBA, GAP<br \/>\nFounder: ExcelChamp.Net &#8211; Providing Everyday Tips for Improving Productivity, Using Excel!<br \/>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"514\" class=\"elementor elementor-514\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-14e69bc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14e69bc6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31f6f1ef\" data-id=\"31f6f1ef\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b580a03 elementor-widget elementor-widget-heading\" data-id=\"3b580a03\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Are you facing any problem in using Excel?  Any Question?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2709bfb elementor-widget elementor-widget-text-editor\" data-id=\"2709bfb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong><span style=\"color: #ff9900;\"><span class=\"st\">You have come to the right place<\/span>. Tell us your needs. We&#8217;ll be glad to help you!<\/span><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e758d36 elementor-button-align-center elementor-widget elementor-widget-form\" data-id=\"6e758d36\" data-element_type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Quick Enquiry\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"514\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"6e758d36\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"ExcelChamp\" \/>\n\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-field_1 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_1\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tName\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[field_1]\" id=\"form-field-field_1\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Name\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-field_2 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_2\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[field_2]\" id=\"form-field-field_2\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Email\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-textarea elementor-field-group elementor-column elementor-field-group-field_3 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_3\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tQuestion\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<textarea class=\"elementor-field-textual elementor-field  elementor-size-sm\" name=\"form_fields[field_3]\" id=\"form-field-field_3\" rows=\"3\" placeholder=\"Question\" required=\"required\" aria-required=\"true\"><\/textarea>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-recaptcha_v3 elementor-field-group elementor-column elementor-field-group-field_9c3764f elementor-col-100 recaptcha_v3-bottomright\">\n\t\t\t\t\t<div class=\"elementor-field\" id=\"form-field-field_9c3764f\"><div class=\"elementor-g-recaptcha\" data-sitekey=\"6Let3GkeAAAAABfVEzbSL0GVAq2ejuG2VI3tGriG\" data-type=\"v3\" data-action=\"Form\" data-badge=\"bottomright\" data-size=\"invisible\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button type=\"submit\" class=\"elementor-button elementor-size-sm elementor-animation-grow\">\n\t\t\t\t\t\t<span >\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-align-icon-right elementor-button-icon\">\n\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-arrow-right\"><\/i>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Help Me Out<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t<\/p>\n<p>&lt;div class=&#8221;ml-form-embed&#8221;<br \/>\ndata-account=&#8221;3112195:l6l5i4i1x0&#8243;<br \/>\ndata-form=&#8221;5497493:o9q9a8&#8243;&gt;<br \/>\n&lt;\/div&gt;<\/p>\n<h2>Additional Resources for Learning Excel &amp; Become A Pro<\/h2>\n<ol>\n<li><a href=\"https:\/\/www.excelchamp.net\/top-12-most-important-excel-functions\/\">Top 12 Most Important Excel Functions You Absolutely Must Know<\/a><\/li>\n<li><a href=\"https:\/\/www.excelchamp.net\/beginners-guide-to-microsoft-excel\/\">Excel Beginners Guide<\/a><\/li>\n<li><a href=\"https:\/\/www.excelchamp.net\/essentials\">Excel Essentials: From Beginner To Pro in Just 6 Weeks<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Do you know how easy it is to use the Pivot Tables in Excel, for Data Analysis? To demonstrate this, I went to the Internet, and \u00a0found some travel data. It belongs to an unnamed Travel Company. The travel company collects the amount of ticket sales, the age of the passenger, and their gender only. &#8230; <a title=\"How to Analyze Data using Excel Pivot Tables\" class=\"read-more\" href=\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\" aria-label=\"More on How to Analyze Data using Excel Pivot Tables\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[6,10],"tags":[15,50],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Analyze Data Using Pivot Tables in Excel<\/title>\n<meta name=\"description\" content=\"Tips to get started in data analysis using Microsoft Excel. Simple, step by step procedure shown in Video Post, by ExcelChamp guru Vinai Prakash.\" \/>\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.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Analyze Data Using Pivot Tables in Excel\" \/>\n<meta property=\"og:description\" content=\"Tips to get started in data analysis using Microsoft Excel. Simple, step by step procedure shown in Video Post, by ExcelChamp guru Vinai Prakash.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"ExcelChamp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:published_time\" content=\"2012-09-22T02:42:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:38:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash-e1654524348231.png?fit=331%2C314&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"331\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vinai Prakash\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vinai Prakash\" \/>\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.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\"},\"author\":{\"name\":\"Vinai Prakash\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"headline\":\"How to Analyze Data using Excel Pivot Tables\",\"datePublished\":\"2012-09-22T02:42:03+00:00\",\"dateModified\":\"2023-12-03T13:38:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\"},\"wordCount\":274,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"keywords\":[\"analyze data in excel\",\"excel pivot table analysis\"],\"articleSection\":[\"Excel In-Built Functionality\",\"Pivot Table\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\",\"url\":\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\",\"name\":\"How To Analyze Data Using Pivot Tables in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/#website\"},\"datePublished\":\"2012-09-22T02:42:03+00:00\",\"dateModified\":\"2023-12-03T13:38:41+00:00\",\"description\":\"Tips to get started in data analysis using Microsoft Excel. Simple, step by step procedure shown in Video Post, by ExcelChamp guru Vinai Prakash.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excelchamp.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Analyze Data using Excel Pivot Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excelchamp.net\/#website\",\"url\":\"https:\/\/www.excelchamp.net\/\",\"name\":\"ExcelChamp\",\"description\":\"Solving Everyday Problems With Excel\",\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excelchamp.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\",\"name\":\"Vinai Prakash\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"width\":487,\"height\":720,\"caption\":\"Vinai Prakash\"},\"logo\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\"},\"description\":\"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.\",\"sameAs\":[\"https:\/\/ExcelChamp.Net\",\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\",\"https:\/\/www.linkedin.com\/in\/vinaiprakash\/\",\"https:\/\/www.youtube.com\/user\/ExcelChamp\"],\"url\":\"https:\/\/www.excelchamp.net\/author\/ppfdd\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Analyze Data Using Pivot Tables in Excel","description":"Tips to get started in data analysis using Microsoft Excel. Simple, step by step procedure shown in Video Post, by ExcelChamp guru Vinai Prakash.","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.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/","og_locale":"en_US","og_type":"article","og_title":"How To Analyze Data Using Pivot Tables in Excel","og_description":"Tips to get started in data analysis using Microsoft Excel. Simple, step by step procedure shown in Video Post, by ExcelChamp guru Vinai Prakash.","og_url":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/","og_site_name":"ExcelChamp","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_author":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_published_time":"2012-09-22T02:42:03+00:00","article_modified_time":"2023-12-03T13:38:41+00:00","og_image":[{"width":331,"height":314,"url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash-e1654524348231.png?fit=331%2C314&ssl=1","type":"image\/png"}],"author":"Vinai Prakash","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vinai Prakash","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/#article","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/"},"author":{"name":"Vinai Prakash","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"headline":"How to Analyze Data using Excel Pivot Tables","datePublished":"2012-09-22T02:42:03+00:00","dateModified":"2023-12-03T13:38:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/"},"wordCount":274,"commentCount":0,"publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"keywords":["analyze data in excel","excel pivot table analysis"],"articleSection":["Excel In-Built Functionality","Pivot Table"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/","url":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/","name":"How To Analyze Data Using Pivot Tables in Excel","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/#website"},"datePublished":"2012-09-22T02:42:03+00:00","dateModified":"2023-12-03T13:38:41+00:00","description":"Tips to get started in data analysis using Microsoft Excel. Simple, step by step procedure shown in Video Post, by ExcelChamp guru Vinai Prakash.","breadcrumb":{"@id":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excelchamp.net\/"},{"@type":"ListItem","position":2,"name":"How to Analyze Data using Excel Pivot Tables"}]},{"@type":"WebSite","@id":"https:\/\/www.excelchamp.net\/#website","url":"https:\/\/www.excelchamp.net\/","name":"ExcelChamp","description":"Solving Everyday Problems With Excel","publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excelchamp.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba","name":"Vinai Prakash","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","width":487,"height":720,"caption":"Vinai Prakash"},"logo":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/"},"description":"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.","sameAs":["https:\/\/ExcelChamp.Net","https:\/\/www.facebook.com\/profile.php?id=100079767634794","https:\/\/www.linkedin.com\/in\/vinaiprakash\/","https:\/\/www.youtube.com\/user\/ExcelChamp"],"url":"https:\/\/www.excelchamp.net\/author\/ppfdd\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/78"}],"collection":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/comments?post=78"}],"version-history":[{"count":2,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/78\/revisions"}],"predecessor-version":[{"id":2548,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/78\/revisions\/2548"}],"wp:attachment":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/media?parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/categories?post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/tags?post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}