How To Extract Data From Multiple PDF To an Excel PIVOT Table Using Power Query

👀🚀Learn How To Extract Data From Multiple Invoices To an Excel PIVOT Table Using Power Query. Another step by step tutorial for those who wants know more about the possibilities of the Excel. 🔗 Learn how to seamlessly connect and analyze data in this video and I hope this one will help one of you in your work life. "Microsoft POWER QUERY is easier than you think ! 📢📊
#excel #pdf #pivot_table #powerpivot #data #microsoft #office365 #powerquery #automation #advancepowerquery

[@anujshah1236]

Amazing 🙌

[@officeuniverse]

Thank you 🙌

[@Luciano_mp]

Thank you!

[@officeuniverse]

You bet!

[@user-lb3ll3me5b]

This is amazing 👏

[@officeuniverse]

Thank you for your kind feedback !

[@alexrosen8762]

Your tutorials are at another level 👏

[@officeuniverse]

I appreciate that!

[@StuartEscott]

Awesome video, this saved me a lot of time at work manually processing supplier data - thanks for sharing this!

[@officeuniverse]

I am glad 😊 it was useful

[@wasanthaarachchi295]

great work, could you give materials to practice us

[@officeuniverse]

I am working on a landing page which will provide training materials, such as actual files with solutions, as well as raw data samples.

[@mikeflex1234]

Hi, got to admit, this is one of the best video on that topic, question tho, the row filter by table is good when the are few columns, what if the info inquired is better seen on the pages ? Are the remaining steps the same?.. thanks in advance

[@officeuniverse]

I truly appreciate your words. If you want to import the entire PDF, the basic steps remain the same; however, the transformation of the query table will require additional steps. As I mentioned in my video, first, you need to study the structure of the PDF, and then decide how to transform it. If you need support on a specific topic, please do not hesitate to email me.

[@geerliglecluse5297]

VERY good video. Could you please share the practice PDFs with us?! That would be incredibly helpful to exercise myself. Thank you!

[@officeuniverse]

Thanks 🙏 I am working on a landing page to share all my files

[@ubaidillahmuhammad20]

Nice, but give the practise files

[@officeuniverse]

I am working on it !