Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

Are you looking for an effortless way to transfer data from PDFs to Excel? Say goodbye to complicated methods and hello to Power Query's new feature! In this video, we dive into how Power Query transforms the way you import data from PDF to Excel.

Key Highlights:
▪️ Automatic Refresh Feature: Learn how to maintain dynamic links between your PDF documents and Excel data, ensuring that your information updates automatically.
▪️ Real-Life Examples: We walk you through three practical examples, including importing safety reports, financial data from Tesla's quarterly reports, and a manual's table of contents.
▪️ Step-by-Step Guide: Follow our simple, clear instructions on using Power Query, from selecting the right data to transforming and cleaning it for your Excel sheets.
▪️ Time-Saving Tips: Discover how to bypass traditional, time-consuming methods like copy-pasting and manual formatting.

In this video we will test the functionality with 3 different business cases. We will first test the automatic refresh in Excel when the content of the PDF changes. In the second example we will import a specific table from a PDF document (Tesla's quarterly financial report). And finally we'll get creative and import the table of contents from a PDF eBook into Excel.

The new PDF data connector is available as part of a Microsoft 365 subscription

⯆ Read the full blog post: https://www.xelplus.com/import-pdf-to-excel

Complete Excel Power Query playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-

00:00 Import from PDF to Excel with Power Query
00:41 Automatic Refresh - Import from PDF to Excel with Power Query
03:36 Convert Financial Report from PDF to Excel with Power Query
07:10 Import Table of Contents from PDF to Excel with Power Query

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel #PowerQuery