{"id":20233,"date":"2024-11-19T09:35:25","date_gmt":"2024-11-19T08:35:25","guid":{"rendered":"https:\/\/middleweb.ovh\/asfo_2024\/formation\/excel-power-query\/"},"modified":"2025-02-21T08:56:37","modified_gmt":"2025-02-21T07:56:37","slug":"excel-power-query","status":"publish","type":"formation","link":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/","title":{"rendered":"Power Query"},"content":{"rendered":"

Personnel concern\u00e9<\/strong><\/h3>\n

Tout utilisateur du logiciel EXCEL[vc_row css=\u00a0\u00bb.vc_custom_1599747322694{margin-top: -100px !important;}\u00a0\u00bb][vc_column css=\u00a0\u00bb.vc_custom_1599747574482{margin-top: -20px !important;}\u00a0\u00bb][vc_column_text]<\/p>\n

Pr\u00e9-requis<\/strong><\/h3>\n

Connaissance des bases d’EXCEL, des Tableaux et des Tableaux Crois\u00e9s Dynamiques[vc_row css=\u00a0\u00bb.vc_custom_1599747322694{margin-top: -100px !important;}\u00a0\u00bb][vc_column css=\u00a0\u00bb.vc_custom_1599747587534{margin-top: -20px !important;}\u00a0\u00bb][vc_column_text]<\/p>\n

Objectifs p\u00e9dagogiques<\/strong><\/h3>\n

Comprendre l’offre BI de Microsoft
\nSe connecter \u00e0 des sources de donn\u00e9es externes
\nUtiliser Power Query pour nettoyer et mettre en forme les donn\u00e9es
\nIntervenir dans les requ\u00eates en utilisant l’interface graphique[vc_row css=\u00a0\u00bb.vc_custom_1599748144342{margin-top: -100px !important;background-color: #d6d6d6 !important;border-radius: 5px !important;}\u00a0\u00bb][vc_column css=\u00a0\u00bb.vc_custom_1599747587534{margin-top: -20px !important;}\u00a0\u00bb][vc_column_text]<\/p>\n

Programme<\/strong><\/h3>\n

PRISE EN MAIN DE POWER QUERY<\/strong>
\nPr\u00e9sentation de Power Queryl
\nD\u00e9couverte du ruban<\/p>\n

IMPORTER DES DONNEES<\/strong>
\nD\u00e9couvrir le groupe R\u00e9cup\u00e9rer et transformer des donn\u00e9es
\nCr\u00e9er une requ\u00eate et se connecter \u00e0 des sources de donn\u00e9es.
\nDonn\u00e9es contenues dans le classeur
\nImporter depuis un fichier texte
\nImporter un fichier Excel
\nImporter tous les fichiers d\u2019un dossier
\nImporter des fichiers txt ou csv
\nFiltrer les donn\u00e9es d\u2019importation
\nImporter des fichiers Excel
\nImportation de plusieurs feuilles de calcul d\u2019un m\u00eame classeur
\nImporter depuis une base de donn\u00e9es Access
\nImporter des donn\u00e9es en ligne
\nG\u00e9rer la mise \u00e0 jour des donn\u00e9es et les exploiter dans Excel<\/p>\n

TRANSFORMER LES DONNEES AVEC L’EDITEUR DE REQUETE<\/strong>
\nTrier et filtrer les donn\u00e9es.
\nChoix des lignes et des colonnes.
\nSupprimer les doublons et les erreurs.
\nFormater les textes, nombres et dates.
\nFractionner les colonnes.
\nRemplacer des valeurs.<\/p>\n

MANIPULER LES TABLES<\/strong>
\nAjouter des tables.
\nFusionner des tables.
\nRegrouper les lignes. Choisir les fonctions statistiques.
\nFaire pivoter une table<\/p>\n

AJOUTER DES DONNEES CALCULEES<\/strong>
\nCr\u00e9er de nouvelles colonnes.
\nAjouter des indexes.
\nCr\u00e9er des colonnes calcul\u00e9es.
\nD\u00e9finir les nouvelles colonnes avec des formules.<\/p>\n","protected":false},"featured_media":0,"parent":0,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categorie-formation":[192],"etiquette-formation":[],"types-formation":[],"class_list":["post-20233","formation","type-formation","status-publish","hentry","categorie-formation-informatique-bureautique"],"acf":[],"yoast_head":"\nPower Query - ASFO Pyr\u00e9n\u00e9es<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query - ASFO Pyr\u00e9n\u00e9es\" \/>\n<meta property=\"og:description\" content=\"Personnel concern\u00e9 Tout utilisateur du logiciel EXCEL[vc_row css=\u00a0\u00bb.vc_custom_1599747322694{margin-top: -100px !important;}\u00a0\u00bb][vc_column css=\u00a0\u00bb.vc_custom_1599747574482{margin-top: -20px !important;}\u00a0\u00bb][vc_column_text] Pr\u00e9-requis Connaissance des bases d’EXCEL, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"ASFO Pyr\u00e9n\u00e9es\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-21T07:56:37+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/\",\"url\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/\",\"name\":\"Power Query - ASFO Pyr\u00e9n\u00e9es\",\"isPartOf\":{\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/#website\"},\"datePublished\":\"2024-11-19T08:35:25+00:00\",\"dateModified\":\"2025-02-21T07:56:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/middleweb.ovh\/asfo_2024\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Power Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/#website\",\"url\":\"https:\/\/middleweb.ovh\/asfo_2024\/\",\"name\":\"ASFO Pyr\u00e9n\u00e9es\",\"description\":\"Centre de formation\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/middleweb.ovh\/asfo_2024\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power Query - ASFO Pyr\u00e9n\u00e9es","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"fr_FR","og_type":"article","og_title":"Power Query - ASFO Pyr\u00e9n\u00e9es","og_description":"Personnel concern\u00e9 Tout utilisateur du logiciel EXCEL[vc_row css=\u00a0\u00bb.vc_custom_1599747322694{margin-top: -100px !important;}\u00a0\u00bb][vc_column css=\u00a0\u00bb.vc_custom_1599747574482{margin-top: -20px !important;}\u00a0\u00bb][vc_column_text] Pr\u00e9-requis Connaissance des bases d’EXCEL, […]","og_url":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/","og_site_name":"ASFO Pyr\u00e9n\u00e9es","article_modified_time":"2025-02-21T07:56:37+00:00","twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/","url":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/","name":"Power Query - ASFO Pyr\u00e9n\u00e9es","isPartOf":{"@id":"https:\/\/middleweb.ovh\/asfo_2024\/#website"},"datePublished":"2024-11-19T08:35:25+00:00","dateModified":"2025-02-21T07:56:37+00:00","breadcrumb":{"@id":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/middleweb.ovh\/asfo_2024\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/"},{"@type":"ListItem","position":3,"name":"Power Query"}]},{"@type":"WebSite","@id":"https:\/\/middleweb.ovh\/asfo_2024\/#website","url":"https:\/\/middleweb.ovh\/asfo_2024\/","name":"ASFO Pyr\u00e9n\u00e9es","description":"Centre de formation","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/middleweb.ovh\/asfo_2024\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"}]}},"_links":{"self":[{"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/formation\/20233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/formation"}],"about":[{"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/types\/formation"}],"version-history":[{"count":2,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/formation\/20233\/revisions"}],"predecessor-version":[{"id":27526,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/formation\/20233\/revisions\/27526"}],"wp:attachment":[{"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/media?parent=20233"}],"wp:term":[{"taxonomy":"categorie-formation","embeddable":true,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/categorie-formation?post=20233"},{"taxonomy":"etiquette-formation","embeddable":true,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/etiquette-formation?post=20233"},{"taxonomy":"types-formation","embeddable":true,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/types-formation?post=20233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}