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

Поделиться
HTML-код
  • Опубликовано: 4 окт 2024
  • 👀🚀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

Комментарии • 19

  • @gshankar2021
    @gshankar2021 Месяц назад

    Great video superb

  • @alexrosen8762
    @alexrosen8762 7 месяцев назад +1

    Your tutorials are at another level 👏

  • @anujshah1236
    @anujshah1236 10 месяцев назад +1

    Amazing 🙌

  • @Luciano_mp
    @Luciano_mp 10 месяцев назад +2

    Thank you!

  • @user-lb3ll3me5b
    @user-lb3ll3me5b 10 месяцев назад +1

    This is amazing 👏

    • @officeuniverse
      @officeuniverse  10 месяцев назад

      Thank you for your kind feedback !

  • @StuartEscott
    @StuartEscott 5 месяцев назад

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

  • @mikeflex1234
    @mikeflex1234 7 месяцев назад +1

    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
      @officeuniverse  7 месяцев назад +1

      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
    @geerliglecluse5297 5 месяцев назад

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

    • @officeuniverse
      @officeuniverse  4 месяца назад +1

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

  • @wasanthaarachchi295
    @wasanthaarachchi295 7 месяцев назад +1

    great work, could you give materials to practice us

    • @officeuniverse
      @officeuniverse  6 месяцев назад

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

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 10 месяцев назад +3

    Nice, but give the practise files