EP:06 | Connect to the Web in Excel | Free Power Query Course in Hindi
Free Power Query Full Course in Hindi!
Hello Friends,
In this video, you will learn How to connect with Web with Power Query in Excel. Below mentioned topics are covered:
1. Use power query to connect “Yahoo Finance”
2. Extract historical share prices of stock.
3. Transform data using power query
4. Load transformed data to a table and use the amazing “stock charts”
5. Refresh the query to get the updated stock prices.
6. Copy the query, change the source and get new stock historical prices in few seconds.
__________________________________________________________________________
Please subscribe to Excel Pathshala for more video updates.