{"version":"1.0","provider_name":"GLOBIS Unlimited","provider_url":"https:\/\/globisunlimited.com\/jp","author_name":"GLOBIS Unlimited","author_url":"https:\/\/globisunlimited.com\/jp","title":"Excel Data Analysis: Pivot Tables - GLOBIS Unlimited","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"PMAQbDSFTe\"><a href=\"https:\/\/globisunlimited.com\/jp\/course\/excel-data-analysis-pivot-tables\/\">Excel Data Analysis: Pivot Tables<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/globisunlimited.com\/jp\/course\/excel-data-analysis-pivot-tables\/embed\/#?secret=PMAQbDSFTe\" width=\"600\" height=\"338\" title=\"&#8220;Excel Data Analysis: Pivot Tables&#8221; &#8212; GLOBIS Unlimited\" data-secret=\"PMAQbDSFTe\" 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\/\/# sourceURL=https:\/\/globisunlimited.com\/wp-includes\/js\/wp-embed.min.js\n<\/script>","thumbnail_url":"https:\/\/globisunlimited.com\/wp-content\/uploads\/2022\/12\/Globis.jpg","thumbnail_width":1910,"thumbnail_height":1000,"description":"Looking for a structured and efficient way to summarize, analyze, and interpret large datasets? Excel\u2019s pivot tables may be of help. This course explains how to: \u2022 Create and manipulate a table, pivot table or multi-level pivot table, \u2022 Group pivot table items, \u2022\u00a0Create a frequency distribution using a pivot table, \u2022\u00a0Create a pivot chart and change its type, \u2022 Insert and set up slicers, \u2022 And, update pivot tables and add calculated fields or items to them. Join us, and explore how pivot tables streamline data analysis by organizing and summarizing large datasets!"}