Power Query

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

learn.microsoft.com

Power Query - Navigating and reviewing ribbon tabs in detail

In this video, we will go through the ribbon tab in detail and review the options available for queries and transformation steps.

www.youtube.com

INTRODUCTION

Power Query Course — Lesson Titles (1–41)

01. Introduction to Power Query

02. Installing Power Query

03. Overview of Query Editor in Power Query

05. Import Data from TEXT Files in Excel using Power Query

06. Import Data from CSV Files into Excel using Power Query

07. Import Data from Another Excel Workbook using Power Query

08. Getting Data from Current Excel Workbook to Power Query

09. Combine Excel Tables in the Same Workbook Using Power Query (Append Method)

10. Combine Excel Tables in the Same Workbook Using Power Query (Formula Method)

11. Merge Tables in Excel using Power Query

12. Combine Tables from Different Workbooks into One Table in Excel (Using Power Query)

13. Combine All the Excel Files in a Folder Using Power Query

14. Combine CSV Files (or Text Files) in a Folder Using Power Query

15. Get a List of File Names from a Folder in Excel Using Power Query

16. Split Columns in Power Query in Excel

17. Merge Columns in Power Query in Excel

18. Filter Data in Power Query in Excel

19. Sort Data in Power Query in Excel

20. Replace Values in Power Query in Excel

21. Fill Down in Power Query in Excel

22. Transpose in Power Query in Excel

23. Group Data in Power Query in Excel

24. Unpivot Data in Excel Using Power Query

25. Using Locale to Manage Dates in Power Query

26. Column Operations: Rename, Move, Delete, Duplicate in Power Query

27. Adding Date and Time Columns in Power Query

28. Transform Text with Extract Options in Power Query

29. Adding an Index Column in Power Query in Excel

30. Adding a Custom Column in Power Query in Excel

31. Adding a Conditional Column in Power Query in Excel

32. Add Column From Examples in Power Query in Excel

33. Overview of Power Query Functions

34. Useful Text Functions in Power Query

35. Creating IF OR and IF AND Functions in Power Query

36. Overview of M Formula Language in Power Query

37. Insert Comments in M Code in Power Query

38. Convert Query to a Function in Power Query

39. Extract Data from a Table based on User Selection in Excel using Power Query

40. Get File Names from a Folder Based on User Selection in Excel using Power Query

41. How to Refresh Queries in Excel Power Query