{"id":2062,"date":"2025-01-06T12:45:54","date_gmt":"2025-01-06T12:45:54","guid":{"rendered":"https:\/\/wordpress.givigroup.net\/nl\/?page_id=2062"},"modified":"2025-01-06T12:45:54","modified_gmt":"2025-01-06T12:45:54","slug":"excel-power-query","status":"publish","type":"page","link":"https:\/\/wordpress.givigroup.net\/nl\/excel-power-query\/","title":{"rendered":"Excel: Power Query"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-layout-1 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h3 class=\"wp-block-heading has-text-color has-link-color has-large-font-size wp-elements-fcd4d3ace417ad12e6e6c0bf2b5e7646\" style=\"color:#ff6633\">Gegevens ophalen en transformeren met Power Query!<\/h3>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background\" style=\"background-color:#ff6633;color:#ff6633\"\/>\n<\/div>\n<\/div>\n\n\n\n<p>Op het einde van de training kan de cursist gegevens ophalen vanuit verschillende bronnen en deze gegevens transformeren om er in Excel deftige analyses op te bouwen. Analyseren door middel van interactieve rapporten, die gebruik maken van draaitabellen en draaigrafieken. De training is bedoeld voor mensen die een grote hoeveelheid aan gegevens moeten kunnen transformeren, analyseren en aantrekkelijk moeten kunnen voorstellen. De deelnemers aan deze training moeten een basiskennis van Excel bezitten.<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-layout-2 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:50px\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-ea360a1a88bcea869583f375dd20fd89\" style=\"color:#ff6633\"><span style=\"text-decoration: underline\">Inhoud<\/span><\/h2>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul>\n<li>Wat is Power Query<\/li>\n\n\n\n<li>Schermelementen in Power Query<\/li>\n\n\n\n<li>Gegevens ophalen van:\n<ul>\n<li>Excel Workbook<\/li>\n\n\n\n<li>Text\/CSV<\/li>\n\n\n\n<li>Folder<\/li>\n\n\n\n<li>&#8230;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Gegevens transformeren\n<ul>\n<li>Overbodige\/lege rijen verwijderen<\/li>\n\n\n\n<li>Kolommen splitsen<\/li>\n\n\n\n<li>Draaitabel opheffen voor kolommen<\/li>\n\n\n\n<li>&#8230;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Query&#8217;s samenvoegen\n<ul>\n<li>Merge queries<\/li>\n\n\n\n<li>Append queries<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Berekende kolommen aanmaken<\/li>\n\n\n\n<li>Voorwaardelijke kolommen aanmaken<\/li>\n\n\n\n<li>Datatypes corrigeren<\/li>\n\n\n\n<li>Query&#8217;s vernieuwen<\/li>\n\n\n\n<li>Analyse van gegevens in draaitabellen\/grafieken<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-thumbnail\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/wordpress.givigroup.net\/nl\/wp-content\/uploads\/sites\/3\/2025\/01\/PowerQuery-150x150.jpg\" alt=\"\" class=\"wp-image-2046\" style=\"object-fit:cover\"\/><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/wordpress.givigroup.net\/nl\/excel-opleidingen\/\"><em>Beschikbare data<\/em><\/a><\/figcaption><\/figure><\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Gegevens ophalen en transformeren met Power Query! Op het einde van de training kan de cursist gegevens ophalen vanuit verschillende bronnen en deze gegevens transformeren om er in Excel deftige analyses op te bouwen. Analyseren door middel van interactieve rapporten, die gebruik maken van draaitabellen en draaigrafieken. De training is bedoeld voor mensen die een [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/pages\/2062"}],"collection":[{"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/comments?post=2062"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/pages\/2062\/revisions"}],"predecessor-version":[{"id":2063,"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/pages\/2062\/revisions\/2063"}],"wp:attachment":[{"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/media?parent=2062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}