{"id":306,"date":"2017-06-07T09:05:54","date_gmt":"2017-06-06T23:05:54","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=306"},"modified":"2026-06-24T08:50:55","modified_gmt":"2026-06-23T22:50:55","slug":"creating-slicers-excel","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel","title":{"rendered":"Creating Slicers in Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Slicers<\/strong> are special field filters that can be applied to Excel tables. They are most useful for further dissecting an existing <strong>PivotTable<\/strong> report in a worksheet. <strong>Slicers<\/strong> are actually graphics objects comprising of a rectangle and special filter buttons. <strong>Slicers<\/strong> are inserted into the worksheet from the <strong>Slicer<\/strong> command on the <strong>INSERT<\/strong> tab of the ribbon.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 id=\"h-steps-to-create-slicers\" class=\"wp-block-heading\">Steps to create slicers<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 1<\/span><\/strong>:<br>Click anywhere in the <strong>PivotTable<\/strong> within the worksheet<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 2<\/span><\/strong>:<br>Click on the <strong>Insert<\/strong> tab, then click the Slicer in the Filters group to display the <strong>Insert slicers<\/strong> dialog box<br><em>This box shows a tick box next to each of the fields from the data source\u2026<\/em><\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"561\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining.png\" alt=\"Creating Excel Slicers 2 - Dynamic Web Training\" class=\"wp-image-307\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining-160x300.png 160w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 3<\/span><\/strong>:<br>Click on the tick box for <strong>Salesperson<\/strong> and click on [OK] to display a Slicer box with the salespeople in it.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"235\" height=\"332\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-3-DynamicWebTraining.png\" alt=\"Creating Excel Slicers 3 - Dynamic Web Training\" class=\"wp-image-308\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-3-DynamicWebTraining.png 235w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-3-DynamicWebTraining-212x300.png 212w\" sizes=\"auto, (max-width: 235px) 100vw, 235px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 4<\/span><\/strong>:<br>Click on <strong>Hector Smith<\/strong> to see only the sales made by Hector Smith OR click on <strong>Mary O&#8217;Dwyer<\/strong> to see only the sales made by Mary O&#8217;Dwyer.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"807\" height=\"453\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-4-DynamicWebTraining.png\" alt=\"Creating Excel Slicers 4 - Dynamic Web Training\" class=\"wp-image-309\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-4-DynamicWebTraining.png 807w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-4-DynamicWebTraining-300x168.png 300w\" sizes=\"auto, (max-width: 807px) 100vw, 807px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 5<\/span><\/strong>:<br>Click on <strong>Clear Filter<\/strong> in the <strong>Slicer<\/strong> box to see all of the sales again<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For Your Reference\u2026<br>To <strong>insert<\/strong> a <strong>slicer<\/strong> into a <strong>PivotTable<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click anywhere in the <strong>PivotTable<\/strong><\/li>\n\n\n\n<li>Click on the <strong>INSERT<\/strong> tab and click on Slicer in the <strong>Filters<\/strong> group<\/li>\n\n\n\n<li>Tick the field(s) to slice and click on <strong>[OK]<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Handy to Know:<\/strong><br>You can filter on more than one field. To do this click on the first sample, then hold down the \u2018Ctrl\u2019 button on your keyboard and click on subsequent samples.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The slicer topic is covered in our <a href=\"https:\/\/www.dynamicwebtraining.com.au\/microsoft-excel-training-courses\/advanced-excel-course\">Advanced Excel course<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.dynamicwebtraining.com.au\/power-bi-training-courses\">Dynamic Web Training<\/a>\u00a0is Australia&#8217;s leading provider of instructor-led software training.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Slicers are special field filters that can be applied to Excel tables. They are most useful for further dissecting an existing PivotTable report in a worksheet. Slicers are actually graphics objects comprising of a rectangle and special filter buttons. Slicers are inserted into the worksheet from the Slicer command on the INSERT tab of the&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-306","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"<title>How to Create Slicers in Excel - Dynamic Web Training Blog<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating Slicers in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to create Slicers in Microsoft Excel, which are field filters that can be used to dissecting an existing PivotTable.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-06T23:05:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-23T22:50:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"561\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dynamic Web Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dynamic Web Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel\"},\"author\":{\"name\":\"Dynamic Web Training\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"Creating Slicers in Excel\",\"datePublished\":\"2017-06-06T23:05:54+00:00\",\"dateModified\":\"2026-06-23T22:50:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel\"},\"wordCount\":283,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/CreateExcelSlicers-2-DynamicWebTraining.png\",\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-AU\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel\",\"name\":\"How to Create Slicers in Excel - Dynamic Web Training Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/CreateExcelSlicers-2-DynamicWebTraining.png\",\"datePublished\":\"2017-06-06T23:05:54+00:00\",\"dateModified\":\"2026-06-23T22:50:55+00:00\",\"description\":\"Learn how to create Slicers in Microsoft Excel, which are field filters that can be used to dissecting an existing PivotTable.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/CreateExcelSlicers-2-DynamicWebTraining.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/CreateExcelSlicers-2-DynamicWebTraining.png\",\"width\":300,\"height\":561},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/creating-slicers-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Training Blog\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\\\/microsoft-excel\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Creating Slicers in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\",\"name\":\"Dynamic Web Training Logo\",\"description\":\"Dynamic Web Training official site logo asset\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\",\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dynamic-web-training\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"],\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\"}]}<\/script>","yoast_head_json":{"title":"How to Create Slicers in Excel - Dynamic Web Training Blog","description":"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights","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:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel","og_locale":"en_US","og_type":"article","og_title":"Creating Slicers in Excel","og_description":"Learn how to create Slicers in Microsoft Excel, which are field filters that can be used to dissecting an existing PivotTable.","og_url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel","og_site_name":"Dynamic Web Training Blog","article_publisher":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_author":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_published_time":"2017-06-06T23:05:54+00:00","article_modified_time":"2026-06-23T22:50:55+00:00","og_image":[{"width":300,"height":561,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining.png","type":"image\/png"}],"author":"Dynamic Web Training","twitter_card":"summary_large_image","twitter_creator":"@dynamicwebtrain","twitter_site":"@dynamicwebtrain","twitter_misc":{"Written by":"Dynamic Web Training","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel#article","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel"},"author":{"name":"Dynamic Web Training","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233"},"headline":"Creating Slicers in Excel","datePublished":"2017-06-06T23:05:54+00:00","dateModified":"2026-06-23T22:50:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel"},"wordCount":283,"publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining.png","articleSection":["Microsoft Excel"],"inLanguage":"en-AU"},{"@type":"WebPage","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel","name":"How to Create Slicers in Excel - Dynamic Web Training Blog","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel#primaryimage"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining.png","datePublished":"2017-06-06T23:05:54+00:00","dateModified":"2026-06-23T22:50:55+00:00","description":"Learn how to create Slicers in Microsoft Excel, which are field filters that can be used to dissecting an existing PivotTable.","breadcrumb":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel#primaryimage","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/06\/CreateExcelSlicers-2-DynamicWebTraining.png","width":300,"height":561},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/creating-slicers-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Training Blog","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training"},{"@type":"ListItem","position":3,"name":"Microsoft Excel","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel"},{"@type":"ListItem","position":4,"name":"Creating Slicers in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","name":"Dynamic Web Training Blog","description":"The Ultimate Training Experience.","publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization","name":"Dynamic Web Training","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","width":361,"height":109,"caption":"Dynamic Web Training","name":"Dynamic Web Training Logo","description":"Dynamic Web Training official site logo asset"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/x.com\/dynamicwebtrain"]},{"@type":"Person","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233","name":"Dynamic Web Training","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","caption":"Dynamic Web Training"},"description":"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.","sameAs":["https:\/\/www.dynamicwebtraining.com.au","https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/www.linkedin.com\/company\/dynamic-web-training","https:\/\/x.com\/dynamicwebtrain"],"url":"https:\/\/www.dynamicwebtraining.com.au"}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=306"}],"version-history":[{"count":9,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/306\/revisions"}],"predecessor-version":[{"id":2530,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/306\/revisions\/2530"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=306"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}