Excel - Data from Picture - Microsoft 365 New Feature
Vložit
- čas přidán 29. 07. 2024
- Have you ever had a printed page of data and needed to put the data in Excel? Typing the data is a real pain. Excel for M365 allows you to put the data in a worksheet using Data from Picture. It is a great feature and is extremely accurate. Data from Picture can be used with webpages, pictures on your clipboard from a screenshot, or pictures taken of printed data from a book. You have two options when using Data from Picture. You can use Data from Picture from an image on your clipboard on a file on your computer.
Chapters:
0:00 Intro
0:32 Live in-person events with Chris
0:57 Why use Data from Picture?
1:37 Insert Picture
2:05 Data from Picture
3:44 Data from Picture accuracy
4:30 Conditional Formatting
5:45 Closing comments
Blog post chrismenardtraining.com/post/...
Steps:
Select the Data tab, click From Picture and then click Picture From File. If your image is on the clipboard, select Picture from File.
Screenshot Data from Picture
drive.google.com/file/d/1QENN...
Chris Menard will be presenting this new Excel feature at the Administrative Professional Conference in Orlando on September 13, 2022.
chrismenardtraining.com/post/...
www.apcevent.com/session/micr...
Microsoft Office Insider for Windows page insider.office.com/en-us/blog...
Mac users support.microsoft.com/en-us/o...
#chrismenardtraining #exceltraining #exceltraining #administrativeprofessional
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ CZcams keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Blog post chrismenardtraining.com/post/excel-data-from-picture-microsoft-365-new-feature
Nice, clear demonstration of the function. Very useful tip. Thanks.
Glad you liked it
This look great. Thanks for sharing. I wanted to try. However, my excel doesn't have this icon. I didn't even find it within the Customize Ribbon menu. I seek it as "from picture".
Tks, Chris, huge help
.
You're welcome, Brad.
Wich version of excel? I don't have pictures from data in my excel
Hi Chris, I have an excel file with loads of information for different time periods. We have over a thousand companies segregated into specific business units. This sheet also tracks some fees incurred by each company and are structured in diff columns: Opening balance for FY2020, Fees for additional scope, Fees for new standards, Closing balance of FY2020/Opening for FY2021, Fees for additional scope in 2021, blah blah. Is it possible to create a table instantly that shows the different business units and the fees for each year but at the same time reflect the movements? So sorry for the long message.
hello just wanna ask i am using excelM365 huawei however there are no picture to data how can i get that feature do i have to update my excel? hope you replay thank u
respected sir
how can i use other than 365 use
hi Chris, does it work for 32-bit systems?
@ChrisMenardTraining on M365 and this feature is not showing ... even 1 year Later ... any thoughts?
how to get that feature sir can you explain
I have 16.72 excel ,including 365 apps , I’m using excel at the moment insert picture was really good , working , all of a sudden insert picture is greyed out , can’t find what caused that…
How to get that feature sir,without that feature how can we do this process
Hi Chris i use Microsoft 365 , i will try it,great , thank you, I want to add image or document as link to columns in excel document in teams, so everyone in the group can work on it, I have 200 numbers and image or document also 200, can i do it, 😊,Thank you
Great video please advise does Microsoft office 365 professional plus excel have data picture function. Do you know what year did 365 implemented picture data. I want to check whether it has picture data before I buy. Thank you.
درس مفيد جدا،،،شكرا
Its not available in 2016 version
That you man but i have question i have office 365 enterprise but i donot see get data from excel in it why PLS?
You will have it soon. It is rolling out to M365 users slowly.
Hi Chris, I have a Mac M1 with MS Excel 2021 (Office Home and Student 2021) Version 16.68. But nowhere do I see the "Data from Picture" option. Can you please help? Thank you
This is for M365 users only.
@@ChrisMenardTraining the same case with mine, I use original office 365 and I've tried to update the app, but there is still no option for "data from picture"
Hi, I am also a beta user and I have the option, but it is grayed out! Does the same apply to me? Just wait?
Even with Beta features, they don't roll them out all at the same time. Which does aggravate me when I don't get one.
Wich version of excel are using coz on me I don't have this feature
Microsoft 365 with Beta channel. This feature has just been released to Beta users. It may be two to four months before it comes out to the general public for 365 users.
why i dont have this option in my excel under DATA Tab there is no "DATA FROM PIC"
Just released to beta users. Will be out to all M365 users later.
@@ChrisMenardTraining hi, sir. How do I become a beta user?
It's possible to call this feature from VBA?
I don't think it is possible.
This option is not available in my excel
Just came out to Office insiders. If you have M365, you should have in a couple of months.
Hello @chrismenardtraining ! Is this rolled out yet?
Slowly rolling out. I have it on one computers but not on another computer. Same Excel version. I hope you get it soon. I use it frequently.
Microsoft® Excel® 2019 (Version 2307 Build 16.0.16626.20170) 64-bit why not showing data from picture
Need to be on M365.
just tried it and it isn't available
It is just out for Beta users. It may be a few months before they release it to all M365 users.
♨😑This is the main problem................data from picture is not showing I also checked the whole get data options but from from picture is not these🚫
It is just rolling out.