{"id":50629,"date":"2017-01-04T10:58:40","date_gmt":"2017-01-04T09:58:40","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50629"},"modified":"2017-01-04T10:58:40","modified_gmt":"2017-01-04T09:58:40","slug":"draaitabel-in-google-spreadsheet","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/draaitabel-in-google-spreadsheet\/","title":{"rendered":"Draaitabel in Google spreadsheet"},"content":{"rendered":"<p>V. Kan ik draaitabellen maken van Google spreadsheets? Ik heb er een aantal die uit formulieren komen (enqu\u00c3\u00aates) en een aantal andere.<br \/>\nA. Jazeker. Sinds 2011 kan je rechtstreeks draaitabellen maken in Google drive.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50634\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel1-242x300.png\" alt=\"\" width=\"242\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel1-242x300.png 242w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel1.png 301w\" sizes=\"auto, (max-width: 242px) 100vw, 242px\" \/><\/a><\/p>\n<p><em>Gegevens, Draaitabel<\/em><\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50633\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel2-227x300.png\" alt=\"\" width=\"227\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel2-227x300.png 227w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel2.png 234w\" sizes=\"auto, (max-width: 227px) 100vw, 227px\" \/><\/a>\u00c2\u00a0<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50632\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel3-219x300.png\" alt=\"\" width=\"219\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel3-219x300.png 219w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel3.png 222w\" sizes=\"auto, (max-width: 219px) 100vw, 219px\" \/><\/a><\/p>\n<p>Daarna kan je toevoegen: rijen en kolommen, en waarden<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50631\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel4-144x300.png\" alt=\"\" width=\"144\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel4-144x300.png 144w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel4.png 233w\" sizes=\"auto, (max-width: 144px) 100vw, 144px\" \/><\/a><\/p>\n<p>Nadien kan je bv. groeperen, en kan je instellen welke bewerking de samenvatting moet bevatten (som of iets anders).<\/p>\n<p>Meer info nodig? Bekijk de handleiding op <a href=\"https:\/\/support.google.com\/docs\/answer\/1272900?co=GENIE.Platform%3DDesktop&#038;hl=nl\" rel=\"nofollow\">https:\/\/support.google.com\/docs\/answer\/1272900?co=GENIE.Platform%3DDesktop&#038;hl=nl<\/a><\/p>\n<p>Als Google Drive niet doet wat je wil (er staan bv. geen veldnamen bovenaan), kan je natuurlijk exporteren naar Excel en in Excel verderwerken.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel3.png\">\u00c2\u00a0<\/a><\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel2.png\">\u00c2\u00a0<\/a><\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/googlespreadsheetdraaitabel1.png\">\u00c2\u00a0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik draaitabellen maken van Google spreadsheets? Ik heb er een aantal die uit formulieren komen (enqu\u00c3\u00aates) en een aantal andere. A. Jazeker. Sinds 2011 kan je rechtstreeks draaitabellen maken in Google drive. Gegevens, Draaitabel \u00c2\u00a0 Daarna kan je toevoegen: rijen en kolommen, en waarden Nadien kan je bv.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":55,"footnotes":""},"categories":[448,464,447,10],"tags":[],"class_list":["post-50629","post","type-post","status-publish","format-standard","hentry","category-draaitabel","category-ebp","category-google-drive","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 18:29:42","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\/50629","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=50629"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50629\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}