Power Query Course for Excel Beginners Automate your task using Power Query and Power BI.

We covered the following topics:
00:00 Introduction to Power Query
00:30 Automate a Data Transform in Power Query
02:02 Transform Data Function in Power BI
03:16 Power Query editor
05:33 What is Query in Power Query
06:12 Activate the Formula Bar in Power Query
06:20 Activate the Query Settings in Power Query
06:30 Restore Data in Power Query
07:40 Remove Null Column in Power Query
08:39 Remove Row in Power Query
09:33 How to position Headings in Power Query
11:43 How to Check the Data type in Power Query
11:59 How to Remove Duplicates in Power Query
13:01 How to use Unpivot Columns in Power Query
14:12 How to Rename Column Headers Name in Power Query
15:13 How to Merge Columns in Power Query
16:43 How to use Column from Example in Power Query
19:48 How to use Custom Column in Power Query
23:27 How to use Conditional Column in Power Query
25:55 How to Duplicate the Query in Power Query
26:25 How to use Reference Function in Power Query
27:01 How to use Group By Function in Power Query
29:22 How to Get Data in Excel From Power Query
30:03 How to use Queries and Connection in Power Query
32:25 How to use Advance Editor in Power Query
32:55 How to use Transform Data Button in Power BI

Excel Power Query Crash Course for Beginners
#Powerquery #powerquerycourse #automation

learn more about the Excel Power Query    • Power BI Tutorial  

Let's Connect:

Follow us on Instagram   / yodalearning  
Follow our boards at   / pins