Video: Learn Power Query in Excel for beginners
Van: Miss Microsoft -
Duur: 14:47
Basis-functionaliteiten van Power Query
If you're a beginner in Power Query, watch this video to learn how to get and transform data using Power Query, combine multiple Excel files and automate all your boring data cleanup tasks. Learn how to import multiple files and data sources into Power Query, how to combine data, split columns, merge data, remove duplicate data, correctly format cells, automatically update and clean new data without having to reperform any of the data cleanup steps again, as you learn how to use Power Query applied steps to automate all these tasks! 00:00 Intro 00:34 Let's Have a Look at What Needs to Be Cleaned Up on Our Data 01:58 How to Access Power Query in Excel 02:10 How to Import and Combine Multiple Files into Power Query 03:41 How to Navigate Your Way Around Power Query 05:14 How to Transform and Cleanup Your Data in Power Query 05:43 How to Split Cells / Data into Separate Columns in Power Query by Space Delimiter 06:25 How to Remove Duplicate Values in Power Query 06:33 How to Split Cells / Data into Separate Columns in Power Query by Custom Delimiter 07:14 How to Merge Two Columns in Power Query 07:45 How to Change Date Format in Power Query 08:01 How to Calculate the Date Difference in Power Query 08:38 How to Capitalize First Letter in Power Query Using Add Column 10:00 Difference Between Add Colum and Transform in Power Query 10:43 How to Capitalize First Letter in Power Query Using Transform 10:56 How to Get Month Name from Date in Power Query 11:27 How to Check Data Types in Power Query 11:54 How to Check for Data Errors in Power Query 12:25 How to Export Data from Power Query into Excel 12:40 Queries & Connections and Automation of Data Cleanup 13:14 Create a Pivot Table in Excel 13:54 How to Automatically Update Data in Excel when New Files are Added to Your Folder 14:35 Outro
Functies: Duration.Days(), Text.Proper()
