{"id":57173,"date":"2020-08-21T13:20:45","date_gmt":"2020-08-21T12:20:45","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=57173"},"modified":"2022-04-29T11:06:04","modified_gmt":"2022-04-29T10:06:04","slug":"excel-goal-seek-doelzoeken","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/excel-goal-seek-doelzoeken\/","title":{"rendered":"Excel goal seek \/ doelzoeken"},"content":{"rendered":"<p>De Excel Goal seek (in het Nederlands genaamd Doelzoeken) is een tool om de oplossing van een vergelijking te laten berekenen. In dit voorbeeld berekenen we het kwadraat van x.<\/p>\n<ul>\n<li>In de eerste kolom plaats ik de X waarden, in de tweede bereken ik de Y waarde (het kwadraat).<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-57174\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker1.png\" alt=\"\" width=\"1503\" height=\"773\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker1.png 1503w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker1-300x154.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker1-1024x527.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker1-768x395.png 768w\" sizes=\"auto, (max-width: 1503px) 100vw, 1503px\" \/><\/p>\n<p>Het is belangrijk te weten dat Solver alleen berekende formules kan oplossen &#8211; maar die mogen complex zijn.<\/li>\n<li>Indien Solver geactiveerd is, vind je die onder <em>Gegevens, Wat-als analyse, Doelzoeken<\/em>.<\/li>\n<li>Duid een cel aan in de Y reeks, zeg welke waarde er zou moeten komen en welke cel mag wijzigen<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-57175\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker2.png\" alt=\"\" width=\"1435\" height=\"731\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker2.png 1435w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker2-300x153.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker2-1024x522.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker2-768x391.png 768w\" sizes=\"auto, (max-width: 1435px) 100vw, 1435px\" \/><\/li>\n<li>En Excel rekent<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-57176\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker3.png\" alt=\"\" width=\"1437\" height=\"757\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker3.png 1437w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker3-300x158.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker3-1024x539.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/08\/xl-doelzoeker3-768x405.png 768w\" sizes=\"auto, (max-width: 1437px) 100vw, 1437px\" \/><\/li>\n<li>Meer informatie vind je bv. in\n<ul>\n<li>Use Goal Seek to find the result you want by adjusting an input value &#8211; Office Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-goal-seek-to-find-the-result-you-want-by-adjusting-an-input-value-320cb99e-f4a4-417f-b1c3-4f369d6e66c7\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/office\/use-goal-seek-to-find-the-result-you-want-by-adjusting-an-input-value-320cb99e-f4a4-417f-b1c3-4f369d6e66c7<\/a><\/p>\n<p>&nbsp;<\/li>\n<li>Met Doelzoeken de gewenste resultaten verkrijgen door een invoerwaarde aan te passen &#8211; Office-ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/met-doelzoeken-de-gewenste-resultaten-verkrijgen-door-een-invoerwaarde-aan-te-passen-320cb99e-f4a4-417f-b1c3-4f369d6e66c7?ui=nl-nl&#038;rs=nl-nl&#038;ad=nl\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/met-doelzoeken-de-gewenste-resultaten-verkrijgen-door-een-invoerwaarde-aan-te-passen-320cb99e-f4a4-417f-b1c3-4f369d6e66c7?ui=nl-nl&#038;rs=nl-nl&#038;ad=nl<\/a><\/p>\n<p>&nbsp;<\/li>\n<li>Use Excel Goal Seek For Quick Answers | Productivity Portfolio<br \/>\n<a href=\"https:\/\/www.timeatlas.com\/excel-goal-seek\/\" rel=\"nofollow\">https:\/\/www.timeatlas.com\/excel-goal-seek\/<\/a><\/p>\n<p>&nbsp;<\/li>\n<li>Goal Seek in Excel &#8211; Easy Excel Tutorial<br \/>\n<a href=\"https:\/\/www.excel-easy.com\/examples\/goal-seek.html\" rel=\"nofollow\">https:\/\/www.excel-easy.com\/examples\/goal-seek.html<\/a><\/p>\n<p>&nbsp;<\/li>\n<li>Doelzoeken en invoer controleren in Excel &#8211; c&#8217;t<br \/>\n<blockquote class=\"wp-embedded-content\" data-secret=\"vyRspl3hKa\"><p><a href=\"https:\/\/www.ct.nl\/workshops\/doelzoeken-invoer-controleren-excel\/\">Doelzoeken en invoer controleren in Excel<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Doelzoeken en invoer controleren in Excel&#8221; &#8212; c&#039;t\" src=\"https:\/\/www.ct.nl\/workshops\/doelzoeken-invoer-controleren-excel\/embed\/#?secret=vyRspl3hKa\" data-secret=\"vyRspl3hKa\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/li>\n<li>Tips voor Excel: Doelzoeken &#8211; Functie TW<br \/>\n<a href=\"https:\/\/tipsvoorexcel.blogspot.com\/2014\/02\/doelzoeken-functie-tw.html\" rel=\"nofollow\">https:\/\/tipsvoorexcel.blogspot.com\/2014\/02\/doelzoeken-functie-tw.html<\/a><\/p>\n<p>Excel: Doelzoeken &#8211; YouTube<br \/>\n<a href=\"https:\/\/www.youtube.com\/watch?v=P_B9gR4gJCg\" rel=\"nofollow\">https:\/\/www.youtube.com\/watch?v=P_B9gR4gJCg<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>De Excel Goal seek (in het Nederlands genaamd Doelzoeken) is een tool om de oplossing van een vergelijking te laten berekenen. In dit voorbeeld berekenen we het kwadraat van x. In de eerste kolom plaats ik de X waarden, in de tweede bereken ik de Y waarde (het kwadraat). Het<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":352,"footnotes":""},"categories":[539,464,54,375,79,10],"tags":[],"class_list":["post-57173","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-ebp","category-excel","category-excel-office-2010","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 21:36: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\/57173","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=57173"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/57173\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=57173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=57173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=57173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}