{"id":4350,"date":"2026-09-11T19:09:26","date_gmt":"2026-09-11T17:09:26","guid":{"rendered":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/"},"modified":"2026-09-24T14:47:52","modified_gmt":"2026-09-24T12:47:52","slug":"microsoft-office-excel-voor-gevorderden-formules-functies","status":"publish","type":"product","link":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/","title":{"rendered":"Microsoft Office &#8211; Excel voor gevorderden: Formules &amp; Functies"},"content":{"rendered":"<p>Deze cursus is gericht op gebruikers die al bekend zijn met de basisprincipes van Microsoft Excel en hun vaardigheden willen uitbreiden. Het is ideaal voor professionals en studenten die meer willen halen uit de geavanceerde mogelijkheden van Excel, zoals complexe berekeningen, databeheer en visuele presentaties. Als je regelmatig met gegevens werkt en je effici&euml;ntie en inzicht wilt verbeteren, is deze training perfect voor jou.<\/p>\n<p>De volgende doelen worden na afloop van de cursus bereikt:<\/p>\n<ul>\n<li>Het toepassen van geavanceerde Excel-functies voor data-analyse.<\/li>\n<li>Het stroomlijnen van werkprocessen om effici&euml;ntie te verbeteren.<\/li>\n<li>Het effectief samenwerken in gedeelde Excel-bestanden.<\/li>\n<li>Het gebruiken van gestructureerde verwijzingen voor flexibele data-organisatie.<\/li>\n<li>Het importeren en exporteren van gegevens tussen verschillende bestendtypes.<\/li>\n<li>Het koppelen van werkbladen voor integratie van gegevens.<\/li>\n<li>Het combineren en nesten van functies voor complexere formules.<\/li>\n<\/ul>\n<p><strong>Inhoud<\/strong><\/p>\n<ul>\n<li><strong>Populaire functies<\/strong>: Leer hoe je functies zoals ALS (IF), SOMMEN.ALS (SUMIF), AANTALLEN.ALS (COUNTIF) en VERT.ZOEKEN (VLOOKUP) effectief inzet voor complexere berekeningen en datamanipulatie.<\/li>\n<li><strong>Werkprocessen stroomlijnen<\/strong>: Automatiseren van repetitieve taken en effici&#xEB;nter werken met Excel.<\/li>\n<li><strong>Samenwerken binnen Excel<\/strong>: Delen en gezamenlijk werken aan Excel-bestanden.<\/li>\n<li><strong>Gestructureerde verwijzingen<\/strong>: Werken met tabellen voor een overzichtelijke en flexibele benadering van gegevens.<\/li>\n<li><strong>Importeren en exporteren<\/strong>: Gegevens uit andere programma&#x27;s in Excel importeren en exporteren.<\/li>\n<li><strong>Gegevens analyseren<\/strong>: Gebruik van geavanceerde analysetools binnen Excel.<\/li>\n<li><strong>Koppeling met andere werkbladen<\/strong>: Gegevens tussen werkbladen koppelen voor ge&#xEF;ntegreerd werken.<\/li>\n<li><strong>Functies combineren en nesten<\/strong>: Complexe formules maken door functies in elkaar te nestelen.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Verdiep je Excel-vaardigheden met deze training gericht op het gebruik van geavanceerde formules, functies en datamanagement.<\/p>\n<p>Leer effici&euml;nt werken met draaitabellen, grafieken en tabellen om complexe data te analyseren en professioneel te presenteren. Deze cursus is ideaal voor gebruikers die hun basiskennis willen uitbreiden en meer inzicht willen krijgen in de krachtige mogelijkheden van Excel.<\/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":[1024,1003],"class_list":["post-4350","product","type-product","status-publish","has-post-thumbnail","product_cat-cb-klassikaal","product_tag-cb-excel","product_tag-cb-microsoft","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 voor gevorderden: Formules &amp; Functies | Train IT Now B.V. | Netherlands<\/title>\n<meta name=\"description\" content=\"Leer in 1 dag de Formules &amp; Functies binnen MS Excel. Enige basiskennis is vereist.\" \/>\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-voor-gevorderden-formules-functies\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Office - Excel voor gevorderden: Formules &amp; Functies | Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"og:description\" content=\"Leer in 1 dag de Formules &amp; Functies binnen MS Excel. Enige basiskennis is vereist.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/\" \/>\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-09-24T12:47:52+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-voor-gevorderden-formules-functies\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-voor-gevorderden-formules-functies\\\/\",\"name\":\"Microsoft Office - Excel voor gevorderden: Formules &amp; Functies | Train IT Now B.V. | Netherlands\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-voor-gevorderden-formules-functies\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-voor-gevorderden-formules-functies\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/2_Excel-logo.jpg\",\"datePublished\":\"2026-09-11T17:09:26+00:00\",\"dateModified\":\"2026-09-24T12:47:52+00:00\",\"description\":\"Leer in 1 dag de Formules & Functies binnen MS Excel. Enige basiskennis is vereist.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-voor-gevorderden-formules-functies\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-voor-gevorderden-formules-functies\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/microsoft-office-excel-voor-gevorderden-formules-functies\\\/#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-voor-gevorderden-formules-functies\\\/#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 voor gevorderden: Formules &amp; Functies\"}]},{\"@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 voor gevorderden: Formules &amp; Functies | Train IT Now B.V. | Netherlands","description":"Leer in 1 dag de Formules & Functies binnen MS Excel. Enige basiskennis is vereist.","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-voor-gevorderden-formules-functies\/","og_locale":"nl_NL","og_type":"article","og_title":"Microsoft Office - Excel voor gevorderden: Formules &amp; Functies | Train IT Now B.V. | Netherlands","og_description":"Leer in 1 dag de Formules & Functies binnen MS Excel. Enige basiskennis is vereist.","og_url":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/","og_site_name":"Train IT Now B.V. | Netherlands","article_publisher":"https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/","article_modified_time":"2026-09-24T12:47:52+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-voor-gevorderden-formules-functies\/","url":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/","name":"Microsoft Office - Excel voor gevorderden: Formules &amp; Functies | Train IT Now B.V. | Netherlands","isPartOf":{"@id":"https:\/\/trainitnow.com\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/#primaryimage"},"image":{"@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/#primaryimage"},"thumbnailUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/09\/2_Excel-logo.jpg","datePublished":"2026-09-11T17:09:26+00:00","dateModified":"2026-09-24T12:47:52+00:00","description":"Leer in 1 dag de Formules & Functies binnen MS Excel. Enige basiskennis is vereist.","breadcrumb":{"@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/product\/microsoft-office-excel-voor-gevorderden-formules-functies\/#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-voor-gevorderden-formules-functies\/#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 voor gevorderden: Formules &amp; Functies"}]},{"@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\/4350","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=4350"}],"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=4350"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_brand?post=4350"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_cat?post=4350"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_tag?post=4350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}