Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses
In this video, we explore a fantastic new feature in Excel Desktop - the ability to import data directly from pictures! Previously, you could just do this in the Office app. This tool can be a game-changer for Excel users, offering a simple way to digitize data from various sources like screenshots, websites, and even newspaper photos.
What's Inside:
▪️ Use Cases: We dive into practical scenarios where this feature shines, such as dealing with sensitive data in screenshots and extracting data from websites where traditional methods like Power Query fall short.
▪️ Step-by-Step Guide: Follow a detailed walkthrough on how to use this feature, from accessing it in Excel's Data tab to inserting and reviewing the imported data.
▪️ Real-Life Tests: Witness the feature in action with diverse examples, including a student's spreadsheet screenshot, Fortune Global 500 list data from a website, and a challenging newspaper photo.
▪️ Honest Review: I share my firsthand experience with the feature's current performance, highlighting its strengths and areas for improvement.
With the NEW Data from Picture feature in Excel for Windows, you can now convert an image of text & numbers into a worksheet. This could be a photo from a newspaper, a screenshot from a website or a jpg file. It's also a great trick when you can't use Power Query to get data from a website because the table isn't an html table. You could just grab a screen capture and import it in Excel desktop using the new "data from picture" feature. In this video I'll show you how it works and how well it gets the job done.
00:00 Import Data from Picture in Excel for Windows
01:16 Import Data from Screenshot
04:21 Import Data from Website
06:28 Import Data from Picture
08:21 Wrap Up
My Online Courses ► https://www.xelplus.com/courses/
LINKS to related videos:
Convert Image to Word or Excel - Office Mobile App: https://youtu.be/KG4Jz0FLY5w
️ 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/
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 #office365