{"id":2239,"date":"2011-08-26T14:42:32","date_gmt":"2011-08-26T19:42:32","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=2239"},"modified":"2011-08-29T15:21:48","modified_gmt":"2011-08-29T20:21:48","slug":"pivot-table-comparison-excel-v-google-v-web-based","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2011\/08\/pivot-table-comparison-excel-v-google-v-web-based\/","title":{"rendered":"Pivot table comparison:  Excel v. Google v. Web-based"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-725\" title=\"Education\" src=\"https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2010\/11\/Education.jpg\" alt=\"Education\" width=\"76\" height=\"100\" \/>Pivot tables are great tools for spotting hidden details and trends in a sea of data. One pivot table lets you quickly examine nearly any aspect of your data. Also, unlike static reports, the user determines what parts of the data to analyze.<\/p>\n<p>The big question with pivot tables is this: Which pivot table option is best for my company? Right now, there are three main pivot table options: Google Docs, MS Excel, and database-driven web pivot tables. How do they compare? We\u2019ve put together a handy <a onclick=\"javascript:pageTracker._trackPageview('\/blog\/Click\/B110830_PivotTablesCompared');\" href=\"https:\/\/www.mrc-productivity.com\/research\/pivottables.pdf\" target=\"_blank\"><span style=\"color: red; font-weight: bold;\">one-page guide which explains the differences between each pivot table option<\/span><\/a>. I hope you find it useful.<a name=\"20110825\"><\/a><!--more--><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot tables are great tools for spotting hidden details and trends in a sea of data. One pivot table lets you quickly examine nearly any aspect of your data. Also, unlike static reports, the user determines what parts of the data to analyze. The big question with pivot tables is this: Which pivot table option &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.mrc-productivity.com\/blog\/2011\/08\/pivot-table-comparison-excel-v-google-v-web-based\/\"> <span class=\"screen-reader-text\">Pivot table comparison:  Excel v. Google v. Web-based<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","slim_seo":{"title":"Pivot table comparison: Excel v. Google v. Web-based - mrc&#039;s Cup of Joe Blog","description":"Pivot tables are great tools for spotting hidden details and trends in a sea of data. One pivot table lets you quickly examine nearly any aspect of your data. A"},"footnotes":""},"categories":[8],"tags":[37],"class_list":["post-2239","post","type-post","status-publish","format-standard","hentry","category-education","tag-web-pivot-tables"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/2239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/comments?post=2239"}],"version-history":[{"count":9,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/2239\/revisions"}],"predecessor-version":[{"id":2278,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/2239\/revisions\/2278"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/media?parent=2239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/categories?post=2239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/tags?post=2239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}