Power Query & Pivot Table in Excel | Advanced Excel Tutorials




About this tutorial:

Video duration: 7:52
Power Query & Pivot Table in Excel | Advanced Excel Tutorials

Power Query is known as Getting & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

Power Query and Pivot Table complement each other. Power Query is the recommended experience for discovering, connecting to and importing data. Pivot Table is great for modeling the data you’ve imported. Use both to mold your data in Excel so you can explore and visualize it with Power Map, Power View, PivotTables, and Pivot Charts, and then interact with the resulting…

Incoming search terms:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

11 thoughts on “Power Query & Pivot Table in Excel | Advanced Excel Tutorials

    bm gamer

    (February 10, 2019 - 8:37 am)

    nice video

    Mark Healy

    (February 10, 2019 - 8:37 am)

    I've added 3 files in a folder to power query. They are sales figures. My problem is one of the files total sales doubled in sum when combined to PQ table. Is there something I've done that you may have some knowledge to share?

    Pritam Srivastava

    (February 10, 2019 - 8:37 am)

    Pls share the sheet for practice

    Shaikh A. Y

    (February 10, 2019 - 8:37 am)

    Thanks, but I have a very simple time consuming method, instead of doing all this you just simply sorted the data with employee id number in the first column, in a second you can get that data without using power query.
    Correct me if am mistaken.
    Thanks

    bintz

    (February 10, 2019 - 8:37 am)

    Thx mate ! Neat

    vivek thakkar

    (February 10, 2019 - 8:37 am)

    please share the excel sheet for practise

    Vikesh Rajwadi

    (February 10, 2019 - 8:37 am)

    How to activate power pivot in 2016? It's not showing in add-ins. Please Rishabh Sir help me.

    Puneet Vij

    (February 10, 2019 - 8:37 am)

    Sir,
    Kindly launch a detailed tutorial on Power query. This is not enough. : )

    Nir Singgih

    (February 10, 2019 - 8:37 am)

    thanks u

    Thiru Arasu

    (February 10, 2019 - 8:37 am)

    Tqnkxzzz super sir….keep it up

    Vikas Bhalekar Excel

    (February 10, 2019 - 8:37 am)

    Power query hindi me sikhao sir pahile pass se.. plz sir sikhao na

Leave a Reply

Your email address will not be published. Required fields are marked *