Link unstructured web data & images to Excel using AI
HTML-код
- Опубликовано: 12 июл 2024
- Unstructured web data can be hard to analyse, but with Excel's new get data from web using examples this is much easier. I show how to link it and type out examples, then how to get the pictures and extract them into cells using the new picture in cells feature and how to troubleshoot when you get CONNECT! or BLOCKED! errors on the pictures
Optionally, I also show how to clean up data even more using Power Query.
00:00 Introduction
00:43 Import the data
02:29 Getting the image
05:30 Get a bar chart in the table
07:49 Clean up with Power Query Авто/Мото
Solid work, David. 💪
Glad you like it!
Cool !! Bunch of learning 😊 . Little more zoom while you write formula or modify somethihg important will be helpful. Thank you..
That’s great feedback, I’ll try to do more zooming in future
Wow nice 🎉.
Cheers!