{"version":"1.0","provider_name":"Microsoft 365 Blog","provider_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","author_name":"The Microsoft 365 Marketing Team","author_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","title":"Excel table or PivotTable? | Microsoft 365 Blog","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"zG0yn0evCp\"><a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2011\/01\/18\/excel-table-or-pivottable\/\">Excel table or PivotTable?<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2011\/01\/18\/excel-table-or-pivottable\/embed\/#?secret=zG0yn0evCp\" width=\"600\" height=\"338\" title=\"&#8220;Excel table or PivotTable?&#8221; &#8212; Microsoft 365 Blog\" data-secret=\"zG0yn0evCp\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"In Excel there are tables and PivotTables. You may wonder why you'd need to create a table when the whole worksheet already looks like one. And you've heard about PivotTables and how complex they are. To be able to use either effectively, it helps to know what each of them does, and when to use one or the other. Continue reading to learn more about the differences between tables and PivotTables.","thumbnail_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/2234.ExcelTable.jpg"}