Scanned PDF or picture to Excel data |

Рет қаралды 814

26 күн бұрын

Scanned documents, usually PDFs contain tabular data. We need it in Excel. Now, using Power Query, you can easily convert scanned tabular data into Excel. No manual data entry needed.
Contents 📚
00:10 - Scanned PDF
00:35 - Excel - data from Picture
00:52 - Text recognition in Excel
01:20 - Error correction
03:01 - Insert data after corrections
03:14 - Data formatting
04:11 - Check version of Excel
04:31 - Direct PDF import
Related videos 📺
Import PDF to Excel - Part 1 - • Import PDF to Excel -...
Import from PDF to Excel - Part 2 - • Import from PDF to Exc...
How to edit PDF in Word, Search Scanned PDF and more - • How to edit PDF in Wor...
Extract text from scanned PDF using #onenote free - • #efficiency365 Extract...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency365.com/ptyt
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Adobe Premiere: www.adobe.com/in/creativeclou...
AI based captions: videoindexer.ai (Microsoft service)

Пікірлер: 4

@power-reconcile 23 күн бұрын

Nice video, thanks for sharing!

@efficiency365 16 күн бұрын

Thanks @power-reconcile Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@jaswinderbhatti3352 24 күн бұрын

Sir can you share more video about Power BI dashboards.

@efficiency365 16 күн бұрын

Thanks @jaswinderbhatti3352 Sure. More videos coming soon. Check out my other best practices videos as well. Task Management Best Practices - kzfaq.info/get/bejne/erCTq7Ol2pPWk5s.html Efficient Tasks Management using the New Planner 2024 - kzfaq.info/get/bejne/oc2opN11ztjbYaM.html Microsoft Teams Meetings - 16 Best Practices - kzfaq.info/get/bejne/oplyqdRerpbMqWg.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html OneDrive Best Practices Part 1 - kzfaq.info/get/bejne/ep2Kpcmhzb2YpqM.html Part 2 - kzfaq.info/get/bejne/pKyoabyC3cmRkmg.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Cheers. Doc.