{"id":5783,"date":"2022-02-15T06:25:00","date_gmt":"2022-02-15T05:25:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=5783"},"modified":"2022-12-12T13:23:22","modified_gmt":"2022-12-12T12:23:22","slug":"shortcuts-to-manage-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/","title":{"rendered":"Shortcuts to manage Excel pivot tables"},"content":{"rendered":"\n<p>Here is a selection of the best keyboard shortcuts to manage Excel pivot tables. Excel Pivot Tables, Excel Pivot table in English, allow you to cross reference data in a file very efficiently. Whether the source is a flat CSV file, another Excel tab, an SQL source such as a SQL Server table or an SSAS cube.<\/p>\n\n\n\n<p>First of all, how can you manipulate pivot tables efficiently in Excel and save time and productivity on your projects? Here are seven Excel shortcuts specific to pivot tables created in Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-best-office-shortcuts-to-handle-dynamic-tables\">Best Office shortcuts to handle dynamic tables<\/h2>\n\n\n\n<p>For starters, people working in finance are familiar with many facets and features of Excel. However, many Excel users are not familiar with pivot tables, but only with the classic tables. Here, for example, is a selection of the best Excel shortcuts to manage pivot tables. The goal here is to answer the following questions with simple but effective shortcuts.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>How to select the whole pivot table?<\/em><\/li>\n\n\n\n<li><em>Or how to group or separate elements in my Excel pivot table?<\/em><\/li>\n\n\n\n<li><em>How do I hide elements of the pivot table?<\/em><\/li>\n\n\n\n<li><em>What shortcut can I use to create a chart from the data in an existing table?<\/em><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Seven shortcuts to manage MS Excel pivot tables<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>Excel action<\/strong><\/td><td><strong>Excel shortcut<\/strong><\/td><\/tr><tr><td>Check or uncheck a box for a field.<\/td><td><strong>SPACE<\/strong><\/td><\/tr><tr><td>Group elements of an Excel pivot table.<\/td><td><strong>ALT + SHIFT + RIGHT ARROW<\/strong><\/td><\/tr><tr><td>Separate elements of an Excel pivot table.<\/td><td><strong>ALT + SHIFT + LEFT ARROW<\/strong><\/td><\/tr><tr><td>Hide an element of an Excel pivot table.<\/td><td><strong>CTRL + &#8211; (Minus sign)<\/strong><\/td><\/tr><tr><td>Create a chart from the table data in the same Excel tab.<\/td><td><strong>ALT + F1<\/strong><\/td><\/tr><tr><td>Create a chart from the table data in a new Excel tab.<\/td><td><strong>F11<\/strong><\/td><\/tr><tr><td>Open the Excel Pivot Table Wizard.<\/td><td><strong>ALT + D + P<\/strong><\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\"><strong>Excel Pivot Table Shortcuts<\/strong><\/figcaption><\/figure>\n\n\n\n<p><br>In the same way, the use of &#8220;pivot tables&#8221; is very widespread among finance, accounting and data professionals. In fact, they allow you to analyse a large amount of data in just a few clicks.<\/p>\n\n\n\n<p>To conclude , shortcuts are useful once mastered and especially with powerful data analysis tools such as <a href=\"https:\/\/simple.wikipedia.org\/wiki\/Pivot_table\" target=\"_blank\" rel=\"noreferrer noopener\">pivot tables<\/a>. To go further, here is an article on <a href=\"https:\/\/expert-only.com\/en\/excel\/how-to-remove-value-na-div0-excel-errors\/\">how to better manage the common Excel errors such as #VALUE, #NA or #DIV0<\/a>.<\/p>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1647936101234\"><strong class=\"schema-faq-question\">What is an Excel pivot table?<\/strong> <p class=\"schema-faq-answer\">An Excel pivot table is a table that has rows and columns, it allows you to analyse data by aggregating it across each column. It is built from an Excel table or a multi-dimensional Cube for example.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Here is a selection of the best keyboard shortcuts to manage Excel pivot tables. Excel Pivot Tables, Excel Pivot table in English, allow you to cross reference data in a file very efficiently. Whether the source is a flat <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/\" title=\"Shortcuts to manage Excel pivot tables\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5657,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[457],"tags":[],"class_list":{"0":"post-5783","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Shortcuts to manage Excel pivot tables - Excel Tips - MS Office<\/title>\n<meta name=\"description\" content=\"What are the best keyboard shortcuts to manage Excel pivot tables? Pivot tables allows to you analyse data from multiple dimensions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Shortcuts to manage Excel pivot tables\" \/>\n<meta property=\"og:description\" content=\"What are the best keyboard shortcuts to manage Excel pivot tables? Pivot tables allows to you analyse data from multiple dimensions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-15T05:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-12T12:23:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Shortcuts to manage Excel pivot tables\",\"datePublished\":\"2022-02-15T05:25:00+00:00\",\"dateModified\":\"2022-12-12T12:23:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/\"},\"wordCount\":419,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg\",\"articleSection\":[\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/\",\"url\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/\",\"name\":\"Shortcuts to manage Excel pivot tables - Excel Tips - MS Office\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg\",\"datePublished\":\"2022-02-15T05:25:00+00:00\",\"dateModified\":\"2022-12-12T12:23:22+00:00\",\"description\":\"What are the best keyboard shortcuts to manage Excel pivot tables? Pivot tables allows to you analyse data from multiple dimensions.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#faq-question-1647936101234\"}],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shortcuts to manage Excel pivot tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#faq-question-1647936101234\",\"position\":1,\"url\":\"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#faq-question-1647936101234\",\"name\":\"What is an Excel pivot table?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"An Excel pivot table is a table that has rows and columns, it allows you to analyse data by aggregating it across each column. It is built from an Excel table or a multi-dimensional Cube for example.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Shortcuts to manage Excel pivot tables - Excel Tips - MS Office","description":"What are the best keyboard shortcuts to manage Excel pivot tables? Pivot tables allows to you analyse data from multiple dimensions.","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:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/","og_locale":"en_US","og_type":"article","og_title":"Shortcuts to manage Excel pivot tables","og_description":"What are the best keyboard shortcuts to manage Excel pivot tables? Pivot tables allows to you analyse data from multiple dimensions.","og_url":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-02-15T05:25:00+00:00","article_modified_time":"2022-12-12T12:23:22+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Shortcuts to manage Excel pivot tables","datePublished":"2022-02-15T05:25:00+00:00","dateModified":"2022-12-12T12:23:22+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/"},"wordCount":419,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg","articleSection":["Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/","url":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/","name":"Shortcuts to manage Excel pivot tables - Excel Tips - MS Office","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg","datePublished":"2022-02-15T05:25:00+00:00","dateModified":"2022-12-12T12:23:22+00:00","description":"What are the best keyboard shortcuts to manage Excel pivot tables? Pivot tables allows to you analyse data from multiple dimensions.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#faq-question-1647936101234"}],"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/light-bulb-B4BACF3D6C0_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Shortcuts to manage Excel pivot tables"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}},{"@type":"Question","@id":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#faq-question-1647936101234","position":1,"url":"https:\/\/expert-only.com\/en\/excel\/shortcuts-to-manage-excel-pivot-tables\/#faq-question-1647936101234","name":"What is an Excel pivot table?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"An Excel pivot table is a table that has rows and columns, it allows you to analyse data by aggregating it across each column. It is built from an Excel table or a multi-dimensional Cube for example.","inLanguage":"en-US"},"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5783","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=5783"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5657"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=5783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=5783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=5783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}