PowerQuery c'est quoi? #ExcelTutorial #PowerQueryFrancais #ExcelPowerQuery

What is PowerQuery? This video is a brief introduction to PowerQuery, introducing you to this ETL tool integrated into Excel since version 2016. 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ Summary 0:00 What is PowerQuery? 1:15 ETL (Extract - Transform - Load) 2:40 How long does each step of a dashboard take? 4:29 Proper Data Set 5:04 First Example of a Proper Data Set 11:01 Data Change 11:34 List of PowerQuery Videos 12:32 2nd Example: Extracting the First 7 Letters of a Last Name and First Letter of a First Name 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️〰️ 〰️ 〰️ 〰️ 〰️ 〰️〰️ 〰️ 〰️ 〰️ 〰️ 〰️ ▶ PowerQuery Playlist: https://www.youtube.com/playlist?list... 🔻 What is PowerQuery?    • PowerQuery c'est quoi? #ExcelTutorial #Pow...   🔻 Quickly consolidate multiple Excel files:    • Consolider facilement 3 fichiers excel et ...   🔻 Merge two lists from two different years:    • Fusionner 2 listes de deux annees differen...   🔻 Automatically consolidate all tables in a workbook:    • Consolider tous les tableaux d'un Classeur...   🔻 Text extraction: Flash Fill / Text formulas or PowerQuery?    • Gérer Numéros de Facture   🔻 Manage Your Invoice Numbers Easily and Efficiently with PowerQuery and Without VBA:    • Gérer Numéros de Facture   🔻 How to Import an Up-to-Date Customer Database into Excel and Customize Data with PowerQuery:    • comment importer un fichier client (a jour...   🔻 Automatically Number Invoice Proposals and Delivery Notes (without VBA):    • Numero automatique des Propales factures e...   🔻 How to Efficiently Manage Duplicates in Multiple Files with PowerQuery:    • excel doublons dans multiples fichiers san...   〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️〰️ 〰️ 〰️ 〰️ 〰️ ▶ Power BI Dashboard Playlist    • Dashboards Power BI   🔻 Data Analysis with Excel and Power BI    • Analyse de données avec Excel et Power BI   🔻 Easy Dashboard with Power BI    • Tableau de bord facile avec Power BI #Powe...   〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️〰️ 〰️ 〰️ 〰️ 〰️ ▶ Business Tools Playlist: https://www.youtube.com/playlist?list... 🔻 How to Create a Dynamic Excel Calendar with Public Holidays:    • Comment Realiser un Calendrier dynamique E...   🔻 How to Create a Dynamic Excel Calendar with Public Holidays and Days Off    • Comment Realiser un Calendrier dynamique E...   🔻 Manage Your Invoice Numbers Easily and Efficiently with PowerQuery and Without VBA:    • Gérer Numéros de Facture   🔻 How to Update a Customer File via a Form without VBA:    • Comment mettre a jour un fichier client   🔻 How to Import an Up-to-Date Customer Database into Excel and Customize Data with PowerQuery:    • comment importer un fichier client (a jour...   🔻How to Efficiently Manage Duplicates in Multiple Files with PowerQuery:    • excel doublons dans multiples fichiers san...   🔻Change a Table of Rows to Columns:    • Changer un Tableau de Lignes en colonnes #...   〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 🔔 SUBSCRIBE 🔔 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️    / @businessexcelfrance6441   〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 🔔 SUBSCRIBE 🔔 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ To receive the sample files, you can click on the link below and you will automatically receive them by email! https://businessexcelfrance.aweb.page... 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ 〰️ Thank you for your support!