Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching PDF to Excel Converter. and this video is uploaded by Kevin Stratvert at 2021-03-16T00:00:08-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [ycBW5dO0UZ0]
| Name | PDF to Excel Converter |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 16-03-2021 07:00:08 |
| Video Discription | In this step-by-step tutorial, learn how to bulk extract data from multiple PDF files into an Excel spreadsheet. To extract data, we use Power Query functionality that is built into Microsoft Excel and this requires no third party add-ins. 👋 Additional resources: - Sample PDF files if you want to follow along: https://1drv.ms/u/s!AmxrofZZlZ-whK5VdVJgd9yhcLqMXA?e=gSHkFj - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 0:32 Overview of sample files 1:51 Import one PDF into Excel 4:07 Refresh data 6:31 Bulk import PDF files into Excel 10:03 Power Query Editor 11:30 Transform data 12:15 Transpose 12:49 Use first row as headers 13:05 Add custom column 16:08 Remove row 16:41 Update column header 17:01 Applied steps 17:49 Review & transform aggregate data 19:07 Update data type 19:58 Remove column 20:14 Close & load 20:44 Bring in more data 21:56 Wrap up 📃 Watch related playlists and videos - Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY - Playlist with all my videos on PDF: https://youtube.com/playlist?list=PLlKpQrBME6xKpM8M7iy0fOz5l7XhvHTBS 🚩 Connect with me on social: - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert [ycBW5dO0UZ0] |
| Category | Science & Technology |
| Tags | kevin stratvert | pdf | excel | extract data | bulk extract | pdf to excel | impo | how to convert pdf to excel | convert pdf to excel | convert | pdf to excel converter | how to change pdf to excel | power query | how to convert pdf into excel | pdf convert to excel | how to convert pdf file to excel | converting pdf to excel | stratvert | convert pdf to excel without losing formatting | import pdf to excel | import | pdf excel | excel pdf | export | transfer | open | converter | pdf file convert to excel | file |
