Scanned PDF or picture to Excel data |

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.efficiency36...
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.efficiency36...
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365....
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envat...
Created using Adobe Premiere: www.adobe.com/...
AI based captions: videoindexer.ai (Microsoft service)

[@power-reconcile]

Nice video, thanks for sharing!

[@efficiency365]

Thanks @power-reconcile
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - czcams.com/video/rtDlORLmjlE/video.html
Excel Green Marks - Error Checking - Best Practices - czcams.com/video/XeLtlzd9lRY/video.html
Excel Best Practices - Part 1 of 3 - Data Management - czcams.com/video/rr_1ha6g6lc/video.html
Excel Best Practices - Part 2 of 3 - Formulas - czcams.com/video/kz_zAvMINAk/video.html
Excel Best Practices - Part 3 of 3 - Analytics - czcams.com/video/JNR5yx_Pg4A/video.html
10 Excel Settings You Must CHANGE! - czcams.com/video/vXrrXdKyJFk/video.html
Automatic data clean up with Excel Flash Fill - czcams.com/video/N3p_x_lXT_c/video.html
Instant Excel Audit, Comparison and Analysis - Inquire - czcams.com/video/cDdvUZxOUis/video.html
Six powerful Excel Navigation Shortcuts - czcams.com/video/bR-yMbGPq50/video.html
Handle millions of rows in Excel - Slow to fast - czcams.com/video/93h7rRsLF7Y/video.html
Convert crosstab to tabular - Unpivot - Excel Power Query - czcams.com/video/mTtOtZH-nNM/video.html
Cheers.
Doc

[@jaswinderbhatti3352]

Sir can you share more video about Power BI dashboards.

[@efficiency365]

Thanks @jaswinderbhatti3352
Sure. More videos coming soon.
Check out my other best practices videos as well.
Task Management Best Practices - czcams.com/video/DJcxPtu-rcg/video.html
Efficient Tasks Management using the New Planner 2024 - czcams.com/video/kgxqzDirw1o/video.html
Microsoft Teams Meetings - 16 Best Practices - czcams.com/video/l3Bvq-I0hy4/video.html
Microsoft Teams - 15 Best Practices - czcams.com/video/W8Ufx_znKxI/video.html
OneDrive Best Practices Part 1 - czcams.com/video/D7ZrfphW4vo/video.html Part 2 - czcams.com/video/nFx6YQxc-b4/video.html
Smart and Effective Email - 5 powerful ways - czcams.com/video/6NEFSMqHgQE/video.html
Outlook Calendar Best Practices : Part 1 - czcams.com/video/GzsQnecjAQo/video.html and Part 2 - czcams.com/video/padKH8ys5Cs/video.html
OneNote - Best Practices - czcams.com/video/m-4AY1cMi8s/video.html
Microsoft 365 Best Practices - czcams.com/video/kVC_YcL5ObU/video.html
Cheers. Doc.