{"id":1497,"date":"2023-03-04T15:03:38","date_gmt":"2023-03-04T15:03:38","guid":{"rendered":"https:\/\/www.excelandmacros.com\/?p=1497"},"modified":"2025-10-13T22:17:52","modified_gmt":"2025-10-13T22:17:52","slug":"who-has-better-pivot-tables-excel-vs-google-sheets","status":"publish","type":"post","link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/pivot-tables\/who-has-better-pivot-tables-excel-vs-google-sheets\/","title":{"rendered":"Who has better Pivot Tables? Excel vs. Google Sheets"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"1497\" class=\"elementor elementor-1497\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-eed1c0f elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"eed1c0f\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\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-36c9ca9f\" data-id=\"36c9ca9f\" 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-1fea780c elementor-widget elementor-widget-text-editor\" data-id=\"1fea780c\" 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\t\t<p>PIVOT TABLES<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1629d842 elementor-widget elementor-widget-heading\" data-id=\"1629d842\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Who has better Pivot Tables? Excel vs. Google Sheets<\/h2>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4b37c942 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"4b37c942\" 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-25 elementor-top-column elementor-element elementor-element-4e852542\" data-id=\"4e852542\" 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-61a1f639 elementor-widget elementor-widget-sidebar\" data-id=\"61a1f639\" data-element_type=\"widget\" data-widget_type=\"sidebar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"ocean_social_share-2\" class=\"sidebar-box widget-oceanwp-social-share social-share clr\">\t\t\t\t<ul class=\"owp-social-share style-colored name-hidden\">\r\n\t\t\t\t\t<li class=\"twitter\"><a href=\"https:\/\/twitter.com\/share?text=Who%20has%20better%20Pivot%20Tables?%20Excel%20vs.%20Google%20Sheets&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fpivot-tables%2Fwho-has-better-pivot-tables-excel-vs-google-sheets%2F\" title=\"Share on X\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-twitter-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"facebook\"><a href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fpivot-tables%2Fwho-has-better-pivot-tables-excel-vs-google-sheets%2F\" title=\"Share on Facebook\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-facebook-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15\t\t\t\t\t\t\t\t37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11\t\t\t\t\t\t\t\t71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"linkedin\"><a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fpivot-tables%2Fwho-has-better-pivot-tables-excel-vs-google-sheets%2F&#038;title=Who%20has%20better%20Pivot%20Tables?%20Excel%20vs.%20Google%20Sheets&#038;summary=PIVOT+TABLES+Who+has+better+Pivot+Tables%3F+Excel+vs.+Google+Sheets+Today+we+will+explain+the+main+similarities+and+differences+between+Microsoft+Excel+Pivot+Tables+and+Google+Sheets+Pivot+Tables.+Each+of+them+has+its+own+pros+and+cons%2C+so%26hellip%3B&#038;source=https:\/\/www.excelandmacros.com\/sr\/\" title=\"Share on LinkedIn\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-linkedin-icon\" role=\"img\" viewbox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4\t\t\t\t\t\t\t\t416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1\t\t\t\t\t\t\t\t243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"viber\"><a href=\"\" title=\"Share on Viber\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-viber-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M444 49.9C431.3 38.2 379.9.9 265.3.4c0 0-135.1-8.1-200.9 52.3C27.8 89.3 14.9 143 13.5 209.5c-1.4 66.5-3.1 191.1 117\t\t\t\t\t\t\t\t224.9h.1l-.1 51.6s-.8 20.9 13 25.1c16.6 5.2 26.4-10.7 42.3-27.8 8.7-9.4 20.7-23.2 29.8-33.7 82.2 6.9 145.3-8.9 152.5-11.2 16.6-5.4 110.5-17.4\t\t\t\t\t\t\t\t125.7-142 15.8-128.6-7.6-209.8-49.8-246.5zM457.9 287c-12.9 104-89 110.6-103 115.1-6 1.9-61.5 15.7-131.2 11.2 0 0-52 62.7-68.2 79-5.3 5.3-11.1\t\t\t\t\t\t\t\t4.8-11-5.7 0-6.9.4-85.7.4-85.7-.1 0-.1 0 0 0-101.8-28.2-95.8-134.3-94.7-189.8 1.1-55.5 11.6-101 42.6-131.6 55.7-50.5 170.4-43 170.4-43 96.9.4\t\t\t\t\t\t\t\t143.3 29.6 154.1 39.4 35.7 30.6 53.9 103.8 40.6 211.1zm-139-80.8c.4 8.6-12.5 9.2-12.9.6-1.1-22-11.4-32.7-32.6-33.9-8.6-.5-7.8-13.4.7-12.9 27.9\t\t\t\t\t\t\t\t1.5 43.4 17.5 44.8 46.2zm20.3 11.3c1-42.4-25.5-75.6-75.8-79.3-8.5-.6-7.6-13.5.9-12.9 58 4.2 88.9 44.1 87.8 92.5-.1 8.6-13.1 8.2-12.9-.3zm47 13.4c.1\t\t\t\t\t\t\t\t8.6-12.9 8.7-12.9.1-.6-81.5-54.9-125.9-120.8-126.4-8.5-.1-8.5-12.9 0-12.9 73.7.5 133 51.4 133.7 139.2zM374.9 329v.2c-10.8 19-31 40-51.8\t\t\t\t\t\t\t\t33.3l-.2-.3c-21.1-5.9-70.8-31.5-102.2-56.5-16.2-12.8-31-27.9-42.4-42.4-10.3-12.9-20.7-28.2-30.8-46.6-21.3-38.5-26-55.7-26-55.7-6.7-20.8 14.2-41\t\t\t\t\t\t\t\t33.3-51.8h.2c9.2-4.8 18-3.2 23.9 3.9 0 0 12.4 14.8 17.7 22.1 5 6.8 11.7 17.7 15.2 23.8 6.1 10.9 2.3 22-3.7 26.6l-12 9.6c-6.1 4.9-5.3 14-5.3 14s17.8\t\t\t\t\t\t\t\t67.3 84.3 84.3c0 0 9.1.8 14-5.3l9.6-12c4.6-6 15.7-9.8 26.6-3.7 14.7 8.3 33.4 21.2 45.8 32.9 7 5.7 8.6 14.4 3.8 23.6z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li>\t\t\t\t<\/ul>\r\n\r\n\t\t\t\t\r\n\t\t\r\n\t\t\t<\/div>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-18e1a2f2\" data-id=\"18e1a2f2\" 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-7fd8151 elementor-widget elementor-widget-text-editor\" data-id=\"7fd8151\" 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\t\t<p>Today we will explain the main similarities and differences between Microsoft Excel Pivot Tables and Google Sheets Pivot Tables. Each of them has its own pros and cons, so we will also address them.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-203f5c4 elementor-widget elementor-widget-text-editor\" data-id=\"203f5c4\" 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\t\t<p>The frequent use of Google tools makes people often confuse <a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/basics\/how-to-learn-excel\/\">Microsoft Excel<\/a> with Google Sheets. These are two different products, but with very similar, almost the same, functionalities. They are also compatible, so the Microsoft Excel document can be converted to Google Sheets document, and vice versa.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2544b454 elementor-widget elementor-widget-heading\" data-id=\"2544b454\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">The process of Pivot Tables creation<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9c160e5 elementor-widget elementor-widget-text-editor\" data-id=\"9c160e5\" 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\t\t<p>Both Microsoft Excel and Google Sheets have the same steps of Pivot Table creation. There are six steps in the Pivot Table creation process. Here they are:<\/p><ol><li>Open or create raw data table<\/li><li>Go to Insert tab and select Pivot Table<\/li><li>Select a data range<\/li><li>Choose Pivot Table location<\/li><li>Confirm the creation of Pivot Table<\/li><li>Customize a Pivot Table<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7209ca1 elementor-widget elementor-widget-text-editor\" data-id=\"7209ca1\" 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\t\t<p>You need more details on how to create Google Sheets Pivot Tables? We encourage you to download and read our eBook <a href=\"http:\/\/excelandmacros.gumroad.com\/l\/google-sheets-pivot-tables\">The Ultimate Guide to Google Sheets Pivot Tables<\/a>. Here you will find all you need.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3eb37fa elementor-widget elementor-widget-text-editor\" data-id=\"3eb37fa\" 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\t\t<p>Although the process has the same steps, the major difference in this area is related to the visual appearance of windows which guide you through the process. Here below is the comparison of <strong>Create Pivot Table<\/strong> windows.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-3213e17 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3213e17\" 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-50 elementor-inner-column elementor-element elementor-element-bd4b3b3\" data-id=\"bd4b3b3\" 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-1df736b elementor-widget elementor-widget-image\" data-id=\"1df736b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"501\" height=\"348\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/microsoft-excel-create-pivot-table.png\" class=\"attachment-large size-large wp-image-1501\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-53088e7\" data-id=\"53088e7\" 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-a7df073 elementor-widget elementor-widget-image\" data-id=\"a7df073\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"484\" height=\"455\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/google-sheets-create-pivot-table.png\" class=\"attachment-large size-large wp-image-1499\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\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 class=\"elementor-element elementor-element-7121900 elementor-widget elementor-widget-text-editor\" data-id=\"7121900\" 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\t\t<p>In case you try to create a Pivot Table without raw data selection, Microsoft Excel will inform you with a warning presented in a new window. Google Sheets will inform you inside the existing Pivot Table creation window.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-619d56d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"619d56d\" 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-50 elementor-inner-column elementor-element elementor-element-f37ed61\" data-id=\"f37ed61\" 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-22af225 elementor-widget elementor-widget-image\" data-id=\"22af225\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"748\" height=\"421\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/microsoft-excel-create-pivot-table-warning.png\" class=\"attachment-large size-large wp-image-1502\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-baf5656\" data-id=\"baf5656\" 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-e2e6861 elementor-widget elementor-widget-image\" data-id=\"e2e6861\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"477\" height=\"466\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/google-sheets-create-pivot-table-warning.png\" class=\"attachment-large size-large wp-image-1500\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\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 class=\"elementor-element elementor-element-a64d329 elementor-widget elementor-widget-heading\" data-id=\"a64d329\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Pivot Table Field List vs. Pivot table editor<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7bd6aade elementor-widget elementor-widget-text-editor\" data-id=\"7bd6aade\" 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\t\t<p>After you confirm the Pivot Table creation, the final step is to customize a Pivot Table. This is the moment where you can start noticing main differences between Microsoft Excel Pivot Tables and Google Sheets Pivot Tables.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab28e56 elementor-widget elementor-widget-text-editor\" data-id=\"ab28e56\" 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\t\t<p>Microsoft Excel Pivot Tables offer customization through <strong>PivotTable Field List<\/strong> window. Pivot Tables in Google Sheets offer these functionalities through <strong>Pivot table editor<\/strong> window. Here is how they look.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-29409ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"29409ea\" 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-50 elementor-inner-column elementor-element elementor-element-0763d7f\" data-id=\"0763d7f\" 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-976a44a elementor-widget elementor-widget-image\" data-id=\"976a44a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/elementor\/thumbs\/pivot-table-field-list-q30qja5ztl5aczizmzgwtigwseri4mbj3rvvre8q2o.png\" title=\"pivot-table-field-list\" alt=\"pivot-table-field-list\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-8eca056\" data-id=\"8eca056\" 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-c5c2a52 elementor-widget elementor-widget-image\" data-id=\"c5c2a52\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"569\" height=\"761\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-table-editor.png\" class=\"attachment-large size-large wp-image-1503\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\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 class=\"elementor-element elementor-element-783a89a8 elementor-widget elementor-widget-text-editor\" data-id=\"783a89a8\" 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\t\t<p>The purpose of both of them is the same, because both give instructions to Pivot Table how to arrange the raw data inside it. Both of the windows have the area with shown columns from the raw data table which you can arrange. In our example case, these are: Shop ID, Salesman, Product sold, Product quantity and Product value.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9424d5 elementor-widget elementor-widget-text-editor\" data-id=\"b9424d5\" 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\t\t<p>Both of the windows have four fields where data can be placed. Their names differ between Microsoft Excel and Google Sheets, but they do the same. You can present your raw data in rows and columns. You can put them in the Values field to be calculated with some math operation. At the end, you can use data as filter criteria in order to narrow their representation depending on your needs.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a81f513 elementor-widget elementor-widget-heading\" data-id=\"a81f513\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Rich Pivot Tables advanced controls vs. convenience of use<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-011c532 elementor-widget elementor-widget-text-editor\" data-id=\"011c532\" 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\t\t<p>Google Sheets is more intuitive and user-friendly than Microsoft Excel.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f378cbf elementor-widget elementor-widget-text-editor\" data-id=\"f378cbf\" 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\t\t<p>The main notic\u0435able difference for all Google Sheets functionalities is that Google Sheets is much more <strong>intuitive<\/strong>. Google Sheets in Pivot table editor offers suggestions which you can simply choose. The suggestions are based on Google\u2019s assumption of what you might need in this Pivot Table.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0bee715 elementor-widget elementor-widget-text-editor\" data-id=\"0bee715\" 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\t\t<p>When you choose which data will be in Rows, Columns, Values or Filters fields, the new functionalities are at your disposal in both windows.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-33ce91f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"33ce91f\" 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-50 elementor-inner-column elementor-element elementor-element-baab6b8\" data-id=\"baab6b8\" 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-8853e86 elementor-widget elementor-widget-image\" data-id=\"8853e86\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"255\" height=\"802\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-table-field-list-with-data.png\" class=\"attachment-large size-large wp-image-1506\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-09f1cd5\" data-id=\"09f1cd5\" 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-564ef60 elementor-widget elementor-widget-image\" data-id=\"564ef60\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"246\" height=\"675\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-table-editor-with-data.png\" class=\"attachment-large size-large wp-image-1504\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\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 class=\"elementor-element elementor-element-662d7ef elementor-widget elementor-widget-text-editor\" data-id=\"662d7ef\" 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\t\t<p>Microsoft Excel in this area is a little richer than Google Sheets, because it can offer you additional controls through sub-windows for every field you insert. For example, you can control data through Field Settings and Value Field Settings windows.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4cef788 elementor-widget elementor-widget-text-editor\" data-id=\"4cef788\" 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\t\t<p>Google Sheets on the other side focused on the convenience of use and created a more modern and user-friendly environment. We must say that both of them offer everything you need for basic Pivot Table creation and usage.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-34b51303 elementor-widget elementor-widget-text-editor\" data-id=\"34b51303\" 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\t\t<p>Microsoft Excel is richer with advanced Pivot Table controls.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-26b2f71 elementor-widget elementor-widget-text-editor\" data-id=\"26b2f71\" 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\t\t<p><!-- [if gte mso 9]><xml><br \/>\n <w:WordDocument><br \/>\n  <w:View>Normal<\/w:View><br \/>\n  <w:Zoom>0<\/w:Zoom><br \/>\n  <w:TrackMoves\/><br \/>\n  <w:TrackFormatting\/><br \/>\n  <w:PunctuationKerning\/><br \/>\n  <w:ValidateAgainstSchemas\/><br \/>\n  <w:SaveIfXMLInvalid>false<\/w:SaveIfXMLInvalid><br \/>\n  <w:IgnoreMixedContent>false<\/w:IgnoreMixedContent><br \/>\n  <w:AlwaysShowPlaceholderText>false<\/w:AlwaysShowPlaceholderText><br \/>\n  <w:DoNotPromoteQF\/><br \/>\n  <w:LidThemeOther>EN-US<\/w:LidThemeOther><br \/>\n  <w:LidThemeAsian>X-NONE<\/w:LidThemeAsian><br \/>\n  <w:LidThemeComplexScript>X-NONE<\/w:LidThemeComplexScript><br \/>\n  <w:Compatibility><br \/>\n   <w:BreakWrappedTables\/><br \/>\n   <w:SnapToGridInCell\/><br \/>\n   <w:WrapTextWithPunct\/><br \/>\n   <w:UseAsianBreakRules\/><br \/>\n   <w:DontGrowAutofit\/><br \/>\n   <w:SplitPgBreakAndParaMark\/><br \/>\n   <w:DontVertAlignCellWithSp\/><br \/>\n   <w:DontBreakConstrainedForcedTables\/><br \/>\n   <w:DontVertAlignInTxbx\/><br \/>\n   <w:Word11KerningPairs\/><br \/>\n   <w:CachedColBalance\/><br \/>\n   <w:UseFELayout\/><br \/>\n  <\/w:Compatibility><br \/>\n  <w:BrowserLevel>MicrosoftInternetExplorer4<\/w:BrowserLevel><br \/>\n  <m:mathPr><br \/>\n   <m:mathFont m:val=\"Cambria Math\"\/><br \/>\n   <m:brkBin m:val=\"before\"\/><br \/>\n   <m:brkBinSub m:val=\"--\"\/><br \/>\n   <m:smallFrac m:val=\"off\"\/><br \/>\n   <m:dispDef\/><br \/>\n   <m:lMargin m:val=\"0\"\/><br \/>\n   <m:rMargin m:val=\"0\"\/><br \/>\n   <m:defJc m:val=\"centerGroup\"\/><br \/>\n   <m:wrapIndent m:val=\"1440\"\/><br \/>\n   <m:intLim m:val=\"subSup\"\/><br \/>\n   <m:naryLim m:val=\"undOvr\"\/><br \/>\n  <\/m:mathPr><\/w:WordDocument><br \/>\n<\/xml><![endif]--><!-- [if gte mso 9]><xml><br \/>\n <w:LatentStyles DefLockedState=\"false\" DefUnhideWhenUsed=\"true\" DefSemiHidden=\"true\" DefQFormat=\"false\" DefPriority=\"99\" LatentStyleCount=\"267\"><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"0\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Normal\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"heading 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 7\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 8\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 9\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 7\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 8\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 9\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"35\" QFormat=\"true\" Name=\"caption\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"10\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Title\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"1\" Name=\"Default Paragraph Font\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"11\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Subtitle\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"22\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Strong\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"20\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Emphasis\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"59\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Table Grid\"\/><br \/>\n  <w:LsdException Locked=\"false\" UnhideWhenUsed=\"false\" Name=\"Placeholder Text\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"1\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"No Spacing\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Shading\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light List\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Grid\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Dark List\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Shading\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful List\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Grid\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Shading Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light List Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Grid Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" UnhideWhenUsed=\"false\" Name=\"Revision\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"34\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"List Paragraph\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"29\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Quote\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"30\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Intense Quote\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Dark List Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful List Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 1\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Shading Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light List Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Grid Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Dark List Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful List Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 2\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Shading Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light List Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Grid Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Dark List Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful List Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 3\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Shading Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light List Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Grid Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Dark List Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful List Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 4\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Shading Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light List Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Grid Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Dark List Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful List Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 5\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Shading Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light List Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Light Grid Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Dark List Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful List Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 6\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"19\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Subtle Emphasis\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"21\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Intense Emphasis\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"31\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Subtle Reference\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"32\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Intense Reference\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"33\" SemiHidden=\"false\" UnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Book Title\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"37\" Name=\"Bibliography\"\/><br \/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" QFormat=\"true\" Name=\"TOC Heading\"\/><br \/>\n <\/w:LatentStyles><br \/>\n<\/xml><![endif]--><!-- [if gte mso 10]><\/p>\n<style>\n \/* Style Definitions *\/<br \/>\n table.MsoNormalTable<br \/>\n\t{mso-style-name:\"Table Normal\";<br \/>\n\tmso-tstyle-rowband-size:0;<br \/>\n\tmso-tstyle-colband-size:0;<br \/>\n\tmso-style-noshow:yes;<br \/>\n\tmso-style-priority:99;<br \/>\n\tmso-style-qformat:yes;<br \/>\n\tmso-style-parent:\"\";<br \/>\n\tmso-padding-alt:0cm 5.4pt 0cm 5.4pt;<br \/>\n\tmso-para-margin-top:0cm;<br \/>\n\tmso-para-margin-right:0cm;<br \/>\n\tmso-para-margin-bottom:10.0pt;<br \/>\n\tmso-para-margin-left:0cm;<br \/>\n\tline-height:115%;<br \/>\n\tmso-pagination:widow-orphan;<br \/>\n\tfont-size:11.0pt;<br \/>\n\tfont-family:\"Calibri\",\"sans-serif\";<br \/>\n\tmso-ascii-font-family:Calibri;<br \/>\n\tmso-ascii-theme-font:minor-latin;<br \/>\n\tmso-hansi-font-family:Calibri;<br \/>\n\tmso-hansi-theme-font:minor-latin;}<br \/>\n<\/style>\n<p><![endif]--><\/p><p>Having in mind Pivot Table Layout options, Microsoft Excel offers more options related to Subtotals, Grand Totals, Report Layout and Blank Rows. Some of these controls you can find in Google Sheets too, but are more limited than Microsoft Excel Pivot Tables.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54c619d0 elementor-widget elementor-widget-heading\" data-id=\"54c619d0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Google Sheets collaboration features<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac9acf7 elementor-widget elementor-widget-text-editor\" data-id=\"ac9acf7\" 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\t\t<p>Collaboration between multiple users on the Google Sheets document is easy by having a document sharing option. Microsoft Excel doesn\u2019t have this feature, unless the Excel file is stored on a shared server. In the modern time of remote work this feature is far more significant and provides great flexibility for users. This is a great competitive advantage when comparing Microsoft Excel and Google Sheets in general.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-82f1a3a elementor-widget elementor-widget-heading\" data-id=\"82f1a3a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Which Pivot Table to choose?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7066791 elementor-widget elementor-widget-text-editor\" data-id=\"7066791\" 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\t\t<p>Now when we have reached the end, it\u2019s good to conclude our comparison with some final words. As we already mentioned, both products will bring you to a main goal, and that is to create a flexible and easy to modify Pivot Table.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67ad161 elementor-widget elementor-widget-text-editor\" data-id=\"67ad161\" 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\t\t<p>If you need some advanced features of Pivot Tables, Microsoft Excel will offer you more. On the other side, Google Sheets will offer you more convenience and a user-friendly environment with a modern look. Google Sheets Pivot Tables are also more intuitive with their suggestions. This is not available in Microsoft Excel Pivot Tables. When we talk about supporting the remote work, Google Sheets have share options.\u00a0 Chance to collaborate on the same document with your colleagues is really precious.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a519f3 elementor-widget elementor-widget-text-editor\" data-id=\"2a519f3\" 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\t\t<p>It is up to you and your team to decide what you prefer more. In case you missed it before, here you can download our eBook <a href=\"http:\/\/excelandmacros.gumroad.com\/l\/google-sheets-pivot-tables\">The Ultimate Guide to Google Sheets Pivot Tables<\/a>.<\/p>\t\t\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<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-1ea5d57d\" data-id=\"1ea5d57d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\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>","protected":false},"excerpt":{"rendered":"<p>PIVOT TABLES Who has better Pivot Tables? Excel vs. Google Sheets Today we will explain the main similarities and differences between Microsoft Excel Pivot Tables and Google Sheets Pivot Tables. Each of them has its own pros and cons, so we will also address them. The frequent use of Google tools makes people often confuse [&hellip;]<\/p>","protected":false},"author":1,"featured_media":2477,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"on","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"off","ocean_gallery_id":[],"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1497","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pivot-tables","entry","has-media"],"aioseo_notices":[],"rttpg_featured_image_url":{"full":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179.jpeg",1792,1010,false],"landscape":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179.jpeg",1792,1010,false],"portraits":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179.jpeg",1792,1010,false],"thumbnail":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179-150x150.jpeg",150,150,true],"medium":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179-300x169.jpeg",300,169,true],"large":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179-1024x577.jpeg",1024,577,true],"1536x1536":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179-1536x866.jpeg",1536,866,true],"2048x2048":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179.jpeg",1792,1010,false],"trp-custom-language-flag":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/03\/pivot-tables-excel-vs-google-sheets-e1760393720179-18x10.jpeg",18,10,true]},"rttpg_author":{"display_name":"adminMilos","author_link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/author\/adminmilos\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/category\/pivot-tables\/\" rel=\"category tag\">Pivot Tables<\/a>","rttpg_excerpt":"PIVOT TABLES Who has better Pivot Tables? Excel vs. Google Sheets Today we will explain the main similarities and differences between Microsoft Excel Pivot Tables and Google Sheets Pivot Tables. Each of them has its own pros and cons, so we will also address them. The frequent use of Google tools makes people often confuse&hellip;","_links":{"self":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/1497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/comments?post=1497"}],"version-history":[{"count":65,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/1497\/revisions"}],"predecessor-version":[{"id":2480,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/1497\/revisions\/2480"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/media\/2477"}],"wp:attachment":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/media?parent=1497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/categories?post=1497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/tags?post=1497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}