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 inperson 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 https://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
https://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.
https://chrismenardtraining.com/post/...
https://www.apcevent.com/session/micr...
Microsoft Office Insider for Windows page https://insider.office.com/enus/blog...
Mac users https://support.microsoft.com/enus/o...
#chrismenardtraining #exceltraining #exceltraining #administrativeprofessional
And make sure you subscribe to my channel!
EQUIPMENT USED
○ My camera – https://amzn.to/3vdgF5E
○ Microphone https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights https://amzn.to/3vaxyy5
○ Dual monitor mount stand https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount https://amzn.to/3g96FGj
○ Boom Arm https://amzn.to/3g8cNi6
SOFTWARE USED
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://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!