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…