Скачать с ютуб Excel: Importing data from an image в хорошем качестве

Excel: Importing data from an image

Recently, I've been getting mail that contains data that I need to get off of the paper and into Excel. Typing the data into Excel is one option. But I figured there must be better ways. In this video I show 2 ways to get data by taking a picture, then converting the text from the data into something that Excel can use. You'll see: Save the image in Microsoft Word as a PDF Import the image into OneNote, then use Extract Text from Image. NOTE: All methods involve some kind of clean-up. The trick is to figure out which method results in the least mess. 0:00 Intro 1:55 A comment about the Excel phone app 2:20 Import work schedule 4:37 Import workshop data 7:16 Import from a magazine page 8:35 Why not import PDF using Power Query? 9:10 Outro For a list of my Excel courses at Lynda/LinkedIn:   / oz-du-soleil   There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday. Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analy... My old blog: http://datascopic.net/blog-2-2