{"id":50655,"date":"2017-01-06T11:21:46","date_gmt":"2017-01-06T10:21:46","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50655"},"modified":"2017-01-05T11:45:39","modified_gmt":"2017-01-05T10:45:39","slug":"draaitabel-per-maand","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/draaitabel-per-maand\/","title":{"rendered":"Draaitabel per maand"},"content":{"rendered":"<p>V. Hoe kan ik een draaitabel maken per maand?<br \/>\nA. Begin met een blad met de gegevens, met daarin een kolom <em>datum<\/em> naast de andere kolommen (in dit voorbeeld:<em> bedrag<\/em> en<em> rubriek<\/em>). Bij het maken van de draaitabel krijg je dit te zien:<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50661\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand1-249x300.png\" alt=\"\" width=\"249\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand1-249x300.png 249w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand1.png 275w\" sizes=\"auto, (max-width: 249px) 100vw, 249px\" \/><\/a><br \/>\nJe ziet dat Excel de datums (ik gebruik even dit woord, omdat data dubbelzinnig is) groepeert per Kwartaal.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50660\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand2.png\" alt=\"\" width=\"117\" height=\"260\" \/><\/a><br \/>\nDat is niet wat je wil: je wil het per maand. Rechtsklik en kies <em>Groeperen<\/em>.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50659\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand3-197x300.png\" alt=\"\" width=\"197\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand3-197x300.png 197w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand3.png 275w\" sizes=\"auto, (max-width: 197px) 100vw, 197px\" \/><\/a><br \/>\nDan kan je met Ctrl+klik (meervoudig selecteren) de kwartalen uitselecteren.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50658\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand4-230x300.png\" alt=\"\" width=\"230\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand4-230x300.png 230w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand4.png 235w\" sizes=\"auto, (max-width: 230px) 100vw, 230px\" \/><\/a><br \/>\nDan krijg je dit:<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50656\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand5-43x300.png\" alt=\"\" width=\"43\" height=\"300\" \/><\/a><\/p>\n<p>Maar mogelijk is dat ook niet wat je wil. Als je in de voorgaande stap ook de jaren wegselecteert, krijg je dit:<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50657\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-draaitabelpermaand6.png\" alt=\"\" width=\"105\" height=\"293\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Hoe kan ik een draaitabel maken per maand? A. Begin met een blad met de gegevens, met daarin een kolom datum naast de andere kolommen (in dit voorbeeld: bedrag en rubriek). Bij het maken van de draaitabel krijg je dit te zien: Je ziet dat Excel de datums (ik<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":69,"footnotes":""},"categories":[104,448,464,54,79,10],"tags":[],"class_list":["post-50655","post","type-post","status-publish","format-standard","hentry","category-business","category-draaitabel","category-ebp","category-excel","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 12:08:28","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\/50655","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=50655"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50655\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}