MS Excel – Import Live Data From Web

MS Excel – Import Live Data From Web to Excel
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

To Buy Full Excel Course:
Use coupon “YOUTUBE” to get FLAT 10% OFF at Checkout.

Check out latest Ebooks :
Check out latest Courses :

Instead of copying and pasting, use the “Get and Transform” (Power Query) from the “Data” tab. This way you can import website data properly into Excel. Once you create a web query you can automatically get the latest data in Excel. You just have to refresh your query and update the query settings so it runs a refresh at specific intervals defined by you.

For more updates on courses and tips follow us on:
Facebook:
Twitter:
LinkedIn: