{"id":64022,"date":"2024-06-28T10:57:07","date_gmt":"2024-06-28T09:57:07","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=64022"},"modified":"2024-08-28T17:13:17","modified_gmt":"2024-08-28T16:13:17","slug":"groupby-en-pivotby-draaitabellen-met-functies","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/groupby-en-pivotby-draaitabellen-met-functies\/","title":{"rendered":"GROUPBY en PIVOTBY: draaitabellen met functies"},"content":{"rendered":"<p>Microsoft is nieuwe functies aan het uitvouwen waarmee je dingen die je kan doen waarvoor je (vroeger?*) draaitabellen nodig hebt (had?*)<\/p>\n<p>* = laat ons nog even wachten om te zien of dit effectief opvolgers worden. Maar in elk geval: je moet eerst weten wat draaitabellen zijn, hoe ze werken en waar je ze voor kan gebruiken, vooraleer je kan begrijpen waar dit over gaat<\/p>\n<p>De functies heten GROUPBY en PIVOTBY<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/groupby-functie-5e08ae8c-6800-4b72-b623-c41773611505\">GROUPBY-functie<\/a> &#8211; Microsoft Ondersteuning<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/de-functie-pivotby-de86516a-90ad-4ced-8522-3a25fac389cf\">De functie PIVOTBY<\/a> &#8211; Microsoft Ondersteuning<\/p>\n<p>Ze hebben als onmiddellijk voordeel dat de resultaten dynamisch zijn. Verder kan je ook met strings werken, en makkelijk filteren<\/p>\n<p>Een mooie demo van Leila Garani:<\/p>\n<p><iframe loading=\"lazy\" title=\"Excel GROUPBY &amp; PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables? ????)\" width=\"900\" height=\"506\" src=\"https:\/\/www.youtube.com\/embed\/mCJzhCxEQlM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>Meer info:<\/p>\n<p><a href=\"https:\/\/techcommunity.microsoft.com\/t5\/microsoft-365-insider-blog\/new-aggregation-functions-in-excel-groupby-and-pivotby\/ba-p\/4222707\">Excel aggregation functions<\/a> &#8211; Tech Community<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft is nieuwe functies aan het uitvouwen waarmee je dingen die je kan doen waarvoor je (vroeger?*) draaitabellen nodig hebt (had?*) * = laat ons nog even wachten om te zien of dit effectief opvolgers worden. Maar in elk geval: je moet eerst weten wat draaitabellen zijn, hoe ze werken<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":5,"footnotes":""},"categories":[448,54,79,10],"tags":[],"class_list":["post-64022","post","type-post","status-publish","format-standard","hentry","category-draaitabel","category-excel","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 16:17:12","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\/64022","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=64022"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64022\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=64022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=64022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=64022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}