Excel Is About to Save You Hours
Victor Chan
0:00 / 0:00
Excel Is About to Save You Hours
10 286 просмотров · 1 год назад
Victor Chan
45 тыс. подписчиков
10 286 просмотров · 1 год назад
Learn how to get data from a PDF with a multi page table into Excel 365 for free using Power Query. You don't have to use 3rd party tools or do any coding.
Get the FREE Excel workbook for this video
Step 1: Sign up for free: https://go.launchexcel.com/email-sign...
Step 2: Log in here: https://courses.launchexcel.com/dashb...
Step 3: Get the workbook: https://courses.launchexcel.com/schoo...
TIP: Stay logged in for quick access to ALL workbook downloads
✅ Learn Power Query Fast: https://go.launchexcel.com/moth-power...
Chapters:
00:00 Have you ever spent hours getting data from PDFs into Excel?
00:44 LEVEL 0: Copy and Paste
01:59 LEVEL 1: Basic Power Query Import (for simple PDFs)
05:49 LEVEL 2: What if there are no column headers on page 2+?
10:34 LEVEL 3: How to make it quick and easy to refresh the data
15:58 Watch this next...
Watch this video next
The Easy Way to Scrape Web Data into Excel
• Import PDFs into Excel with Power Query