{"id":57125,"date":"2020-08-19T17:37:19","date_gmt":"2020-08-19T16:37:19","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=57125"},"modified":"2020-08-20T17:33:17","modified_gmt":"2020-08-20T16:33:17","slug":"slicers-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/slicers-in-excel\/","title":{"rendered":"Slicers in Excel"},"content":{"rendered":"<p>V. Wat zijn slicers in Excel?<\/p>\n<p>A. Draaitabellen zijn handig &#8211; en slicers maken op zo&#8217;n draaitabel een grafische filter. Je kan die slicers bovendien verplaatsen om een mooi overzicht en een handige filtering te hebben.<\/p>\n<ul>\n<li>maak een draaitabel<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-57127\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/slicer1.png\" alt=\"\" width=\"328\" height=\"688\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/slicer1.png 328w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/slicer1-143x300.png 143w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/><\/li>\n<li>en voeg slicers toe via <em>Analyse<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-57126\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/slicer2.png\" alt=\"\" width=\"554\" height=\"393\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/slicer2.png 554w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/slicer2-300x213.png 300w\" sizes=\"auto, (max-width: 554px) 100vw, 554px\" \/><\/li>\n<\/ul>\n<p>Als er meerdere velden zijn, kan je kiezen welke velden je wil gebruiken \/ opnemen.<\/p>\n<p>Zie verder:<\/p>\n<ul>\n<li>Slicers in Excel &#8211; Easy Excel Tutorial<br \/>\n<a href=\"https:\/\/www.excel-easy.com\/examples\/slicers.html\" rel=\"nofollow\">https:\/\/www.excel-easy.com\/examples\/slicers.html<\/a><\/li>\n<li>Use slicers to filter data &#8211; Office Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/office\/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d<\/a><\/li>\n<li>Slicers gebruiken om gegevens te filteren &#8211; Office-ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/slicers-gebruiken-om-gegevens-te-filteren-249f966b-a9d5-4b0f-b31a-12651785d29d?ui=nl-nl&#038;rs=nl-nl&#038;ad=nl\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/slicers-gebruiken-om-gegevens-te-filteren-249f966b-a9d5-4b0f-b31a-12651785d29d?ui=nl-nl&#038;rs=nl-nl&#038;ad=nl<\/a><\/li>\n<li>Excel Pivot Table Slicers<br \/>\n<a href=\"https:\/\/www.contextures.com\/excelpivottableslicers.html\" rel=\"nofollow\">https:\/\/www.contextures.com\/excelpivottableslicers.html<\/a><\/li>\n<li>Excel slicer: visual filter for pivot tables and charts<br \/>\n<a href=\"https:\/\/www.ablebits.com\/office-addins-blog\/2018\/06\/13\/excel-slicer-pivot-table-chart\/\" rel=\"nofollow\">https:\/\/www.ablebits.com\/office-addins-blog\/2018\/06\/13\/excel-slicer-pivot-table-chart\/<\/a><\/li>\n<\/ul>\n<p>Overigens heeft Excel ook tijdlijnen, een specifieke soort slicer<\/p>\n<ul>\n<li>The Complete Guide To Slicers And Timelines In Microsoft Excel | How To Excel<br \/>\n<a href=\"https:\/\/www.howtoexcel.org\/tutorials\/slicers\/\" rel=\"nofollow\">https:\/\/www.howtoexcel.org\/tutorials\/slicers\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Wat zijn slicers in Excel? A. Draaitabellen zijn handig &#8211; en slicers maken op zo&#8217;n draaitabel een grafische filter. Je kan die slicers bovendien verplaatsen om een mooi overzicht en een handige filtering te hebben. maak een draaitabel en voeg slicers toe via Analyse Als er meerdere velden zijn,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":62,"footnotes":""},"categories":[539,448,464,54,10],"tags":[565],"class_list":["post-57125","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-draaitabel","category-ebp","category-excel","category-office","tag-metingen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 15:43:22","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/57125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=57125"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/57125\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=57125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=57125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=57125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}