{"id":48527,"date":"2015-10-10T18:13:13","date_gmt":"2015-10-10T17:13:13","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=48527"},"modified":"2026-02-14T14:41:42","modified_gmt":"2026-02-14T13:41:42","slug":"excel-2016-kan-prognoses-maken","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/excel-2016-kan-prognoses-maken\/","title":{"rendered":"Excel 2016 kan prognoses maken"},"content":{"rendered":"<p>Een leuke nieuwigheid in Excel 2016: de nieuwste versie kan automatische prognoses maken op een apart blad. Het ziet er zo uit:<\/p>\n<p><a href=\"https:\/\/support.office.com\/nl-be\/article\/Een-prognose-maken-in-Excel-2016-voor-Windows-22c500da-6da7-45e5-bfdc-60a7062329fd\"><\/a><\/p>\n<p>Details staan uitgelegd in Een prognose maken in Excel 2016 voor Windows &#8211; <a href=\"https:\/\/support.office.com\/nl-be\/article\/Een-prognose-maken-in-Excel-2016-voor-Windows-22c500da-6da7-45e5-bfdc-60a7062329fd\" rel=\"nofollow\">https:\/\/support.office.com\/nl-be\/article\/Een-prognose-maken-in-Excel-2016-voor-Windows-22c500da-6da7-45e5-bfdc-60a7062329fd<\/a><\/p>\n<p>Het komt hierop neer: selecteer de bekende gegevens, Gegevens, Prognoseblad, begin en einde opgeven.<\/p>\n<p>Nog geen Excel 2016? Geen nood &#8211; in 2013 kan er ook zo iets, maar dan heel rudimentair. Selecteer de gegevens, maak een grafiek en voeg een trendlijn toe. Bij de opties voor die trendlijn kies je Voorspelling en stelt in voor hoeveel stappen \/ periodes.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/10\/xl2013-voorspellingen.png\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-48528\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/10\/xl2013-voorspellingen-300x131.png\" alt=\"xl2013-voorspellingen\" width=\"400\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/10\/xl2013-voorspellingen-300x131.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/10\/xl2013-voorspellingen-1024x448.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/10\/xl2013-voorspellingen.png 1355w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Een leuke nieuwigheid in Excel 2016: de nieuwste versie kan automatische prognoses maken op een apart blad. Het ziet er zo uit: Details staan uitgelegd in Een prognose maken in Excel 2016 voor Windows &#8211; https:\/\/support.office.com\/nl-be\/article\/Een-prognose-maken-in-Excel-2016-voor-Windows-22c500da-6da7-45e5-bfdc-60a7062329fd Het komt hierop neer: selecteer de bekende gegevens, Gegevens, Prognoseblad, begin en einde opgeven.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3,"footnotes":""},"categories":[375,366,10,455],"tags":[],"class_list":["post-48527","post","type-post","status-publish","format-standard","hentry","category-excel-office-2010","category-grafieken","category-office","category-office-2016"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 03:16: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\/48527","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=48527"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/48527\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=48527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=48527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=48527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}