{"id":2243,"date":"2025-01-06T13:22:09","date_gmt":"2025-01-06T13:22:09","guid":{"rendered":"https:\/\/wordpress.givigroup.net\/fr\/?page_id=2243"},"modified":"2025-01-06T13:22:09","modified_gmt":"2025-01-06T13:22:09","slug":"excel-power-query","status":"publish","type":"page","link":"https:\/\/wordpress.givigroup.net\/fr\/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-cc064db4e7b5927b47410b84ce45e992\" style=\"color:#ff6633\">R\u00e9cup\u00e9rer et transformer des donn\u00e9es !<\/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>A la fin du cours, les apprenants seront capables d&rsquo;extraire des donn\u00e9es de diff\u00e9rentes sources et de les transformer pour construire des analyses d\u00e9centes dans Excel. Analyser \u00e0 travers des rapports interactifs en utilisant des tableaux crois\u00e9s dynamiques et des graphiques crois\u00e9s dynamiques. La formation est con\u00e7ue pour les personnes qui doivent \u00eatre capables de transformer, d&rsquo;analyser et de pr\u00e9senter de mani\u00e8re attrayante une grande quantit\u00e9 de donn\u00e9es. Les participants \u00e0 cette formation doivent avoir une connaissance de base d&rsquo;Excel.<\/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\" style=\"flex-basis:650px\">\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-7217ab858aae1dea5f68868d1c04e5e8\" style=\"color:#ff6633\"><span style=\"text-decoration: underline\">Contenu<\/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>Qu\u2019est-ce Power Query?<\/li>\n\n\n\n<li>\u00c9l\u00e9ments d&rsquo;\u00e9cran dans Power Query<\/li>\n\n\n\n<li>R\u00e9cup\u00e9rer les donn\u00e9es de :\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>Transformer les donn\u00e9es\n<ul>\n<li>Fractionner colonne<\/li>\n\n\n\n<li>Supprimer le tableau crois\u00e9 dynamique des colonnes<\/li>\n\n\n\n<li>Supprimer les espaces et mettre en majuscule chaque mot<\/li>\n\n\n\n<li>&#8230;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Fusionner des requ\u00eates\n<ul>\n<li>Merge queries<\/li>\n\n\n\n<li>Append queries<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Calculs en Power Query<\/li>\n\n\n\n<li>Type de donn\u00e9es de colonnes<\/li>\n\n\n\n<li>Actualiser une requ\u00eate<\/li>\n\n\n\n<li>Analyse de donn\u00e9es<\/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\/fr\/wp-content\/uploads\/sites\/4\/2025\/01\/PowerQuery-150x150.jpg\" alt=\"\" class=\"wp-image-2231\" style=\"object-fit:cover\"\/><figcaption class=\"wp-element-caption\"><em><a href=\"https:\/\/wordpress.givigroup.net\/fr\/excel-opleidingen\/\">Dates disponibles<\/a><\/em><\/figcaption><\/figure><\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>R\u00e9cup\u00e9rer et transformer des donn\u00e9es ! A la fin du cours, les apprenants seront capables d&rsquo;extraire des donn\u00e9es de diff\u00e9rentes sources et de les transformer pour construire des analyses d\u00e9centes dans Excel. Analyser \u00e0 travers des rapports interactifs en utilisant des tableaux crois\u00e9s dynamiques et des graphiques crois\u00e9s dynamiques. La formation est con\u00e7ue pour les [&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\/fr\/wp-json\/wp\/v2\/pages\/2243"}],"collection":[{"href":"https:\/\/wordpress.givigroup.net\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wordpress.givigroup.net\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.givigroup.net\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.givigroup.net\/fr\/wp-json\/wp\/v2\/comments?post=2243"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.givigroup.net\/fr\/wp-json\/wp\/v2\/pages\/2243\/revisions"}],"predecessor-version":[{"id":2244,"href":"https:\/\/wordpress.givigroup.net\/fr\/wp-json\/wp\/v2\/pages\/2243\/revisions\/2244"}],"wp:attachment":[{"href":"https:\/\/wordpress.givigroup.net\/fr\/wp-json\/wp\/v2\/media?parent=2243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}