Excel power query | how to upload excel and CSV Files | power query Class 4 excel 2021, MS Excel 365

#PowerPivot #PowerQuery #Daxformula
#PowerQuery #PowerPivot #Daxformula
Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop.

How does Power Query work?
With Power Query you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.

How do I get Power Query?
Power Query is available as a download for Excel 2013 and 2010. The underlying Query technology that enables Power Query is also found in the Power BI Desktop, which is part of the overall Power BI offering from Microsoft.
#PowerQuery
#PowerPivot
#Daxformula

Time Stamp :-
00:42 how to get power query on system
01:30 how to upload more than 10 lakh rows in excel
03:30 Index Column in power query
03:48 sort descending in power query
04:30 how to upload CSV file in query editor
05:11 Delimiter in query editor
06:00 what is data type deduction in power query
06:36 how to change data type in query editor
07:40 how to load data in excel through query editor
08:28 import data in query editor
09:12 check data in queries and connection in power query
10:32 check data model in query editor



******FOLLOW ON**********
Facebook :- / gohar.rehman.16
Tiktok - XL Maza
Follow me on Instagram :- XL Maza
______________________

XL Maza