Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Master Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding). That video is uploaded by Leila Gharani at 2023-12-14T02:00:08-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [EOhSODFLqic]
| Name | Master Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding) |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 14-12-2023 10:00:08 |
| Video Discription | Learn Power Query now with our Beginner to Pro course: https://link.xelplus.com/yt-pqweb 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter With the recent updates to the Power Query web connector you can grab data from pretty much any web page and bring it over to Microsoft Excel. Plus you'll have a connection to the webpage. Which means, just click the "refresh" button and pull over the latest information. 🤔 One challenge I was excited to tackle was to import "clickable" URL links AND images with Power Query into Excel. Yes. It's possible to have clickable links in the Power Query extract. It's also possible to extract images from web pages! Check out the video to see my solution. 👉 What You'll Learn: How to use Excel's web connector for easy data import. Tips for importing data from web pages without HTML tables. Creating dynamic, clickable links and images in Excel with ease. 📊 Excel Your Skills: Perfect for analysts, Excel enthusiasts, and anyone interested in data management. Step-by-step guidance, making it accessible for beginners and a time-saver for advanced users. 🌍 Join 400,000+ professionals in our courses ► https://www.xelplus.com/courses/ 🔍 Key Moments in This Video: 00:00 - Introduction to Excel's Web Connector 02:30 - Importing Data from Web Pages 04:38 - Add Table Using Example 09:10 - Creating Clickable hyperlinks in Power Query 12:01 - Importing web images 12:40 - Updating webpage to test 13:28 - Wrap Up 🎬 LINKS to related videos: How Power Query Will Change the Way You Use Excel: https://youtu.be/6lBqYInBldk You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query: https://youtu.be/8hjgmJk5RiA ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ More resources on my Amazon page: https://www.amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel EOhSODFLqic |
| Category | Education |
| Tags | XelplusVis | Leila Gharani | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts | Microsoft Excel tutorials | Microsoft Excel | Excel 2016 | Excel 2013 | Excel 2019 | XelPlus | Microsoft 365 | Excel 365 | webscraping | web-scraping | excel import from web | import web page to excel | how to | web scraping | web scraping tutorial | data scraping | power query clickable links | power query import images | excel import web images | excel import URL |
