{"id":58408,"date":"2021-04-09T11:08:09","date_gmt":"2021-04-09T10:08:09","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=58408"},"modified":"2021-04-08T11:13:53","modified_gmt":"2021-04-08T10:13:53","slug":"een-checklist-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/een-checklist-in-excel\/","title":{"rendered":"Een checklist in Excel"},"content":{"rendered":"<ol>\n<li>Is het moeilijk een checklist te maken in Excel? Ik heb een lijst nodig van doelstellingen die aan bod komen in een reeks van modules, en wil weten welke doelstellingen nergens aan bod komen, en op welk niveau.<\/li>\n<li>Neen, het is eenvoudig. Maar je moet weten wat je precies wil checken.<\/li>\n<\/ol>\n<p>Wat ik zou doen:<\/p>\n<ul>\n<li>de doelstellingen oplijsten<\/li>\n<li>de modules voorzien<\/li>\n<li>per module, de behandelde doelstelling coderen met het niveau<\/li>\n<li>een kolom waarin Excel het maximum berekent \u2013 het hoogste niveau<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-58410\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/04\/xlchecklist1.png\" alt=\"\" width=\"567\" height=\"301\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/04\/xlchecklist1.png 567w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/04\/xlchecklist1-300x159.png 300w\" sizes=\"auto, (max-width: 567px) 100vw, 567px\" \/><\/li>\n<li>een kolom voorzien waarin Excel telt hoe dikwijls een doelstelling vermeld is \u2013 en die met voorwaardelijke opmaak rood laat worden als de doelstelling nergens vermeld wordt.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-58409\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/04\/xlchecklist2.png\" alt=\"\" width=\"567\" height=\"301\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/04\/xlchecklist2.png 567w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/04\/xlchecklist2-300x159.png 300w\" sizes=\"auto, (max-width: 567px) 100vw, 567px\" \/><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Is het moeilijk een checklist te maken in Excel? Ik heb een lijst nodig van doelstellingen die aan bod komen in een reeks van modules, en wil weten welke doelstellingen nergens aan bod komen, en op welk niveau. Neen, het is eenvoudig. Maar je moet weten wat je precies wil<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[78,464,54,375,79,160],"tags":[],"class_list":["post-58408","post","type-post","status-publish","format-standard","hentry","category-cvosemper","category-ebp","category-excel","category-excel-office-2010","category-odisee","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 04:26:48","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\/58408","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=58408"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/58408\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=58408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=58408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=58408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}