{"id":4367,"date":"2026-09-11T19:12:02","date_gmt":"2026-09-11T17:12:02","guid":{"rendered":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/"},"modified":"2026-10-01T06:05:28","modified_gmt":"2026-10-01T04:05:28","slug":"microsoft-office-excel-expert-externe-gegevens-en-macros","status":"publish","type":"product","link":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/","title":{"rendered":"Microsoft Office &#8211; Excel Expert: Externe Gegevens en Macro&#8217;s"},"content":{"rendered":"<p>De doelgroep van de training &#x22;Expert Excel: Externe Gegevens en Macro&#x27;s&#x22; zijn professionals die al uitstekende kennis van Excel hebben en hun vaardigheden verder willen ontwikkelen. Deze training is ideaal voor gebruikers die repetitieve werkzaamheden willen automatiseren, gegevens uit verschillende externe bronnen willen integreren en dieper willen duiken in geavanceerde Excel-functies zoals macro&#x27;s en VBA voor complexere processen.<\/p>\n<p>De volgende doelen worden na afloop van de cursus bereikt:<\/p>\n<ul>\n<li>Het effici&euml;nt navigeren en controleren van werkbladen.<\/li>\n<li>Het gebruik van het dialoogvenster &#8220;Ga Naar&#8221; voor snelle toegang.<\/li>\n<li>Het uitvoeren van wat-ifs analyses voor scenario-vergelijking.<\/li>\n<li>Het importeren en exporteren van gegevens uit verschillende bronnen.<\/li>\n<li>Het werken met tabellen en relaties om gegevens te organiseren.<\/li>\n<li>Het leren van basisprincipes van macro&#8217;s en automatisering.<\/li>\n<li>Het maken van formulieren voor interactieve Excel-toepassingen<\/li>\n<\/ul>\n<p><strong>Inhoud<\/strong><\/p>\n<ul>\n<li>Werkbladen controleren<\/li>\n<li>Het dialoogvenster Ga Naar<\/li>\n<li>Wat-als-analyse<\/li>\n<li>Importeren en exporteren van gegevens<\/li>\n<li>Tabellen en relaties<\/li>\n<li>Introductie macro&#8217;s<\/li>\n<li>Introductie formulieren<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Leer externe data koppelen, processen automatiseren met macro&rsquo;s en VBA gebruiken voor maximale effici&euml;ntie in Excel.<\/p>\n<p>De training &#8220;Expert Excel: Externe Gegevens en Macro&#8217;s&#8221; is gericht op het uitbreiden van je Excel-kennis door gebruik te maken van externe gegevensbronnen en het automatiseren van repetitieve taken via macro&#8217;s.&nbsp;Je leert data in Excel te importeren vanuit verschillende externe bronnen, effici&euml;nt te werken met macro&#8217;s om handmatige processen te automatiseren en de kracht van VBA (Visual Basic for Applications) te benutten voor complexere taken en optimalisaties. Hierdoor kun je nog productiever en effectiever met Excel werken.<\/p>\n","protected":false},"featured_media":4349,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[506],"product_tag":[],"class_list":["post-4367","product","type-product","status-publish","has-post-thumbnail","product_cat-cb-klassikaal","first","instock","taxable","shipping-taxable","purchasable","product-type-variable"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Office - Excel Expert: Externe Gegevens en Macro&#039;s | Train IT Now B.V. | Netherlands<\/title>\n<meta name=\"description\" content=\"Leer externe data koppelen, processen automatiseren met macro&rsquo;s en VBA gebruiken voor maximale effici&euml;ntie in Excel. De training &quot;Expert Excel: Externe Gegevens en Macro&#039;s&quot; is gericht op het uitbreiden van je Excel-kennis door gebruik te maken van externe gegevensbronnen en het automatiseren van repetitieve taken via macro&#039;s.&nbsp;Je leert data in Excel te importeren vanuit verschillende externe bronnen, effici&euml;nt te werken met macro&#039;s om handmatige processen te automatiseren en de kracht van VBA (Visual Basic for Applications) te benutten voor complexere taken en optimalisaties. Hierdoor kun je nog productiever en effectiever met Excel werken.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Office - Excel Expert: Externe Gegevens en Macro&#039;s | Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"og:description\" content=\"Leer externe data koppelen, processen automatiseren met macro&rsquo;s en VBA gebruiken voor maximale effici&euml;ntie in Excel. De training &quot;Expert Excel: Externe Gegevens en Macro&#039;s&quot; is gericht op het uitbreiden van je Excel-kennis door gebruik te maken van externe gegevensbronnen en het automatiseren van repetitieve taken via macro&#039;s.&nbsp;Je leert data in Excel te importeren vanuit verschillende externe bronnen, effici&euml;nt te werken met macro&#039;s om handmatige processen te automatiseren en de kracht van VBA (Visual Basic for Applications) te benutten voor complexere taken en optimalisaties. Hierdoor kun je nog productiever en effectiever met Excel werken.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/\" \/>\n<meta property=\"og:site_name\" content=\"Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-01T04:05:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/09\/2_Excel-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"174\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-expert-externe-gegevens-en-macros\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-expert-externe-gegevens-en-macros\\\/\",\"name\":\"Microsoft Office - Excel Expert: Externe Gegevens en Macro's | Train IT Now B.V. | Netherlands\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-expert-externe-gegevens-en-macros\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-expert-externe-gegevens-en-macros\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/2_Excel-logo.jpg\",\"datePublished\":\"2026-09-11T17:12:02+00:00\",\"dateModified\":\"2026-10-01T04:05:28+00:00\",\"description\":\"Leer externe data koppelen, processen automatiseren met macro&rsquo;s en VBA gebruiken voor maximale effici&euml;ntie in Excel. De training \\\"Expert Excel: Externe Gegevens en Macro's\\\" is gericht op het uitbreiden van je Excel-kennis door gebruik te maken van externe gegevensbronnen en het automatiseren van repetitieve taken via macro's.&nbsp;Je leert data in Excel te importeren vanuit verschillende externe bronnen, effici&euml;nt te werken met macro's om handmatige processen te automatiseren en de kracht van VBA (Visual Basic for Applications) te benutten voor complexere taken en optimalisaties. Hierdoor kun je nog productiever en effectiever met Excel werken.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-expert-externe-gegevens-en-macros\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-expert-externe-gegevens-en-macros\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-expert-externe-gegevens-en-macros\\\/#primaryimage\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/2_Excel-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/2_Excel-logo.jpg\",\"width\":300,\"height\":174},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-expert-externe-gegevens-en-macros\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Products\",\"item\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/shop\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Office &#8211; Excel Expert: Externe Gegevens en Macro&#8217;s\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#website\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\",\"name\":\"Train IT Now | Netherlands\",\"description\":\"Opleidingen op gebied van IT\",\"publisher\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#organization\"},\"alternateName\":\"Train IT Now B.V.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#organization\",\"name\":\"Train IT Now B.V.\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Trainitnow-VERT-POS.png\",\"contentUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Trainitnow-VERT-POS.png\",\"width\":846,\"height\":564,\"caption\":\"Train IT Now B.V.\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/p\\\/Train-it-Now-61573405935953\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/106495503\",\"https:\\\/\\\/www.instagram.com\\\/trainitnow\\\/\",\"https:\\\/\\\/nl.linkedin.com\\\/company\\\/train-it-now\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Office - Excel Expert: Externe Gegevens en Macro's | Train IT Now B.V. | Netherlands","description":"Leer externe data koppelen, processen automatiseren met macro&rsquo;s en VBA gebruiken voor maximale effici&euml;ntie in Excel. De training \"Expert Excel: Externe Gegevens en Macro's\" is gericht op het uitbreiden van je Excel-kennis door gebruik te maken van externe gegevensbronnen en het automatiseren van repetitieve taken via macro's.&nbsp;Je leert data in Excel te importeren vanuit verschillende externe bronnen, effici&euml;nt te werken met macro's om handmatige processen te automatiseren en de kracht van VBA (Visual Basic for Applications) te benutten voor complexere taken en optimalisaties. Hierdoor kun je nog productiever en effectiever met Excel werken.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/","og_locale":"nl_NL","og_type":"article","og_title":"Microsoft Office - Excel Expert: Externe Gegevens en Macro's | Train IT Now B.V. | Netherlands","og_description":"Leer externe data koppelen, processen automatiseren met macro&rsquo;s en VBA gebruiken voor maximale effici&euml;ntie in Excel. De training \"Expert Excel: Externe Gegevens en Macro's\" is gericht op het uitbreiden van je Excel-kennis door gebruik te maken van externe gegevensbronnen en het automatiseren van repetitieve taken via macro's.&nbsp;Je leert data in Excel te importeren vanuit verschillende externe bronnen, effici&euml;nt te werken met macro's om handmatige processen te automatiseren en de kracht van VBA (Visual Basic for Applications) te benutten voor complexere taken en optimalisaties. Hierdoor kun je nog productiever en effectiever met Excel werken.","og_url":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/","og_site_name":"Train IT Now B.V. | Netherlands","article_publisher":"https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/","article_modified_time":"2026-10-01T04:05:28+00:00","og_image":[{"width":300,"height":174,"url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/09\/2_Excel-logo.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/","url":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/","name":"Microsoft Office - Excel Expert: Externe Gegevens en Macro's | Train IT Now B.V. | Netherlands","isPartOf":{"@id":"https:\/\/trainitnow.com\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/#primaryimage"},"image":{"@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/#primaryimage"},"thumbnailUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/09\/2_Excel-logo.jpg","datePublished":"2026-09-11T17:12:02+00:00","dateModified":"2026-10-01T04:05:28+00:00","description":"Leer externe data koppelen, processen automatiseren met macro&rsquo;s en VBA gebruiken voor maximale effici&euml;ntie in Excel. De training \"Expert Excel: Externe Gegevens en Macro's\" is gericht op het uitbreiden van je Excel-kennis door gebruik te maken van externe gegevensbronnen en het automatiseren van repetitieve taken via macro's.&nbsp;Je leert data in Excel te importeren vanuit verschillende externe bronnen, effici&euml;nt te werken met macro's om handmatige processen te automatiseren en de kracht van VBA (Visual Basic for Applications) te benutten voor complexere taken en optimalisaties. Hierdoor kun je nog productiever en effectiever met Excel werken.","breadcrumb":{"@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/#primaryimage","url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/09\/2_Excel-logo.jpg","contentUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/09\/2_Excel-logo.jpg","width":300,"height":174},{"@type":"BreadcrumbList","@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-expert-externe-gegevens-en-macros\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trainitnow.com\/nl\/"},{"@type":"ListItem","position":2,"name":"Products","item":"https:\/\/trainitnow.com\/nl\/shop\/"},{"@type":"ListItem","position":3,"name":"Microsoft Office &#8211; Excel Expert: Externe Gegevens en Macro&#8217;s"}]},{"@type":"WebSite","@id":"https:\/\/trainitnow.com\/nl\/#website","url":"https:\/\/trainitnow.com\/nl\/","name":"Train IT Now | Netherlands","description":"Opleidingen op gebied van IT","publisher":{"@id":"https:\/\/trainitnow.com\/nl\/#organization"},"alternateName":"Train IT Now B.V.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trainitnow.com\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/trainitnow.com\/nl\/#organization","name":"Train IT Now B.V.","url":"https:\/\/trainitnow.com\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/08\/Trainitnow-VERT-POS.png","contentUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/08\/Trainitnow-VERT-POS.png","width":846,"height":564,"caption":"Train IT Now B.V."},"image":{"@id":"https:\/\/trainitnow.com\/nl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/","https:\/\/www.linkedin.com\/company\/106495503","https:\/\/www.instagram.com\/trainitnow\/","https:\/\/nl.linkedin.com\/company\/train-it-now"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product\/4367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/comments?post=4367"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/media\/4349"}],"wp:attachment":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/media?parent=4367"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_brand?post=4367"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_cat?post=4367"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_tag?post=4367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}