{"id":1478,"date":"2025-03-14T14:57:35","date_gmt":"2025-03-14T18:57:35","guid":{"rendered":"https:\/\/damicrosolutions.com\/?post_type=special-course&#038;p=1478"},"modified":"2025-03-28T17:23:09","modified_gmt":"2025-03-28T21:23:09","slug":"excel-power-query","status":"publish","type":"special-course","link":"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-power-query\/","title":{"rendered":"Excel Power Query"},"content":{"rendered":"<h5 class=\"wp-block-heading has-ast-global-color-1-color has-text-color has-link-color wp-elements-98d13375a5a0a04ac0d8b62609c84612\" id=\"block-5c76e4f4-6fc1-44cd-815e-66ddd68a1a10\">Aper\u00e7u du cours<\/h5>\n\n\n\n<p style=\"font-size:16px\">Lib\u00e9rez tout le potentiel de <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-query\/power-query-what-is-power-query\">Microsoft Power Query<\/a>, un outil essentiel pour les utilisateurs d&#039;Excel permettant de connecter, nettoyer et transformer efficacement les donn\u00e9es. Ce cours pratique aborde les principes cl\u00e9s de la gestion de bases de donn\u00e9es, de l&#039;extraction de donn\u00e9es et des techniques de transformation gr\u00e2ce aux puissantes fonctionnalit\u00e9s de Power Query.<\/p>\n\n\n\n<h5 class=\"wp-block-heading has-ast-global-color-1-color has-text-color has-link-color wp-elements-b2abec2309e1a75a6bb86f48fb290190\">Points forts du cours<\/h5>\n\n\n\n<ul class=\"wp-block-list is-style-checkbox\">\n<li style=\"margin-top:0;margin-bottom:0;margin-left:0;padding-top:4px;padding-bottom:4px;font-size:16px\"><strong>Introduction \u00e0 Power Query<\/strong> \u2013 Comprendre son objectif, son interface et ses capacit\u00e9s.<\/li>\n\n\n\n<li style=\"margin-top:0;margin-bottom:0;margin-left:0;padding-top:4px;padding-bottom:4px;font-size:16px\"><strong>Connexion \u00e0 diverses sources de donn\u00e9es<\/strong> \u2013 Travaillez avec Excel, CSV, PDF, fichiers texte, MS Access, ERP, CRM et donn\u00e9es Web.<\/li>\n\n\n\n<li style=\"margin-top:0;margin-bottom:0;margin-left:0;padding-top:4px;padding-bottom:4px;font-size:16px\"><strong>Nettoyage et transformation des donn\u00e9es<\/strong> \u2013 Apprenez \u00e0 diviser des colonnes, \u00e0 supprimer les doublons, \u00e0 formater des donn\u00e9es et \u00e0 appliquer des transformations structur\u00e9es.<\/li>\n\n\n\n<li style=\"margin-top:0;margin-bottom:0;margin-left:0;padding-top:4px;padding-bottom:4px;font-size:16px\"><strong>Op\u00e9rations de requ\u00eate avanc\u00e9es<\/strong> \u2013 Explorez la fusion de requ\u00eates, la cr\u00e9ation de relations, l\u2019utilisation de tableaux crois\u00e9s dynamiques et l\u2019utilisation de colonnes conditionnelles.<\/li>\n\n\n\n<li style=\"margin-top:0;margin-bottom:0;margin-left:0;padding-top:4px;padding-bottom:4px;font-size:16px\"><strong>Automatisation et consolidation des donn\u00e9es<\/strong> \u2013 Utilisez les fonctionnalit\u00e9s d\u2019ajout et de combinaison de dossiers de Power Query pour rationaliser la consolidation des donn\u00e9es.<\/li>\n\n\n\n<li style=\"margin-top:0;margin-bottom:0;margin-left:0;padding-top:4px;padding-bottom:4px;font-size:16px\"><strong>Applications concr\u00e8tes<\/strong> \u2013 Acqu\u00e9rir une exp\u00e9rience pratique avec divers ensembles de donn\u00e9es et sc\u00e9narios commerciaux.<\/li>\n<\/ul>\n\n\n\n<p style=\"font-size:16px\">Ce cours est destin\u00e9 aux professionnels souhaitant am\u00e9liorer leurs comp\u00e9tences en gestion de donn\u00e9es dans Excel et au-del\u00e0 en apprenant \u00e0 utiliser Excel Power Query. Que vous soyez analyste d&#039;affaires, comptable ou passionn\u00e9 de donn\u00e9es, vous repartirez avec des connaissances pratiques pour am\u00e9liorer votre efficacit\u00e9 et votre prise de d\u00e9cision.<\/p>\n\n\n\n<div class=\"gb-element-8615d25f\">\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped has-lightbox wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-full\" style=\"margin-right:0;margin-left:0\"><img data-dominant-color=\"ecebe7\" data-has-transparency=\"true\" style=\"--dominant-color: #ecebe7;\" loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"960\" data-id=\"1482\" src=\"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png.webp\" alt=\"\" class=\"wp-image-1482 has-transparency\" srcset=\"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png.webp 1680w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-300x171.webp 300w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-1024x585.webp 1024w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-768x439.webp 768w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-1536x878.webp 1536w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-18x10.webp 18w\" sizes=\"auto, (max-width: 1680px) 100vw, 1680px\" \/><\/figure>\n<\/figure>\n<\/div>\n\n\n\n<div class=\"gb-element-f46974a2\">\n<a class=\"gb-text gb-text-524d6629\" href=\"https:\/\/damicrosolutions.com\/contact-us\/\" target=\"_blank\" rel=\"noopener\">En savoir plus sur ce cours<\/a>\n<\/div>","protected":false},"featured_media":1883,"parent":0,"template":"","meta":{"_acf_changed":false,"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"pgc_sgb_lightbox_settings":""},"class_list":["post-1478","special-course","type-special-course","status-publish","has-post-thumbnail","hentry"],"mb":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Power Query &#8211; Damicro Inc.<\/title>\n<meta name=\"description\" content=\"Learn how to use Excel Power Query to extract, transform, and automate data from multiple sources efficiently.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-power-query\/\" \/>\n<meta property=\"og:locale\" content=\"fr_CA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Power Query &#8211; Damicro Inc.\" \/>\n<meta property=\"og:description\" content=\"Learn how to use Excel Power Query to extract, transform, and automate data from multiple sources efficiently.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Damicro Inc.\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/damicrosolutions\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-28T21:23:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png\" \/>\n\t<meta property=\"og:image:width\" content=\"665\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimation du temps de lecture\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-query\\\/\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-query\\\/\",\"name\":\"Excel Power Query &#8211; Damicro Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-query\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Damicro-courses-rs.png\",\"datePublished\":\"2025-03-14T18:57:35+00:00\",\"dateModified\":\"2025-03-28T21:23:09+00:00\",\"description\":\"Learn how to use Excel Power Query to extract, transform, and automate data from multiple sources efficiently.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-query\\\/#breadcrumb\"},\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-query\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-query\\\/#primaryimage\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Damicro-courses-rs.png\",\"contentUrl\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Damicro-courses-rs.png\",\"width\":665,\"height\":375},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-query\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/damicrosolutions.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Power Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#website\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/\",\"name\":\"Damicro Solutions\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/damicrosolutions.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-CA\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#organization\",\"name\":\"Damicro Inc.\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-logo-removebg-1-1.png\",\"contentUrl\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-logo-removebg-1-1.png\",\"width\":512,\"height\":512,\"caption\":\"Damicro Inc.\"},\"image\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/damicrosolutions\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/damicrosolutions\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@damicrosolutions\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Power Query &#8211; Damicro Inc.","description":"Learn how to use Excel Power Query to extract, transform, and automate data from multiple sources efficiently.","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:\/\/damicrosolutions.com\/fr\/special-course\/excel-power-query\/","og_locale":"fr_CA","og_type":"article","og_title":"Excel Power Query &#8211; Damicro Inc.","og_description":"Learn how to use Excel Power Query to extract, transform, and automate data from multiple sources efficiently.","og_url":"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-power-query\/","og_site_name":"Damicro Inc.","article_publisher":"https:\/\/www.facebook.com\/damicrosolutions","article_modified_time":"2025-03-28T21:23:09+00:00","og_image":[{"width":665,"height":375,"url":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimation du temps de lecture":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-query\/","url":"https:\/\/damicrosolutions.com\/special-course\/excel-power-query\/","name":"Excel Power Query &#8211; Damicro Inc.","isPartOf":{"@id":"https:\/\/damicrosolutions.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-query\/#primaryimage"},"image":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","datePublished":"2025-03-14T18:57:35+00:00","dateModified":"2025-03-28T21:23:09+00:00","description":"Learn how to use Excel Power Query to extract, transform, and automate data from multiple sources efficiently.","breadcrumb":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-query\/#breadcrumb"},"inLanguage":"fr-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/damicrosolutions.com\/special-course\/excel-power-query\/"]}]},{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-query\/#primaryimage","url":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","contentUrl":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","width":665,"height":375},{"@type":"BreadcrumbList","@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/damicrosolutions.com\/"},{"@type":"ListItem","position":2,"name":"Excel Power Query"}]},{"@type":"WebSite","@id":"https:\/\/damicrosolutions.com\/#website","url":"https:\/\/damicrosolutions.com\/","name":"Damicro Solutions","description":"","publisher":{"@id":"https:\/\/damicrosolutions.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/damicrosolutions.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-CA"},{"@type":"Organization","@id":"https:\/\/damicrosolutions.com\/#organization","name":"Damicro Inc.","url":"https:\/\/damicrosolutions.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/damicrosolutions.com\/#\/schema\/logo\/image\/","url":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/cropped-logo-removebg-1-1.png","contentUrl":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/cropped-logo-removebg-1-1.png","width":512,"height":512,"caption":"Damicro Inc."},"image":{"@id":"https:\/\/damicrosolutions.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/damicrosolutions","https:\/\/www.linkedin.com\/in\/damicrosolutions\/","https:\/\/www.youtube.com\/@damicrosolutions"]}]}},"mfb_rest_fields":["title","yoast_head","yoast_head_json"],"_links":{"self":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/special-course\/1478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/special-course"}],"about":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/types\/special-course"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/media\/1883"}],"wp:attachment":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=1478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}