Part II

Wrangling Data with Power Query

image

webextra Discover how to integrate Power Pivot and Power Query to create dynamic reporting from a web service at www.dummies.com/extras/excelpowerpivotpowerquery.

In this part …

check.png Discover the fundamentals of using Power Query to import and process data from various data sources.

check.png Explore Power Query tools and formulas that can automate and simply your data-transformation processes.

check.png Uncover methods of merging and appending multiple queries to go beyond simple data imports.

check.png Get the skinny on creating your own custom functions to extend the functionality of Power Query.

Get Excel Power Pivot and Power Query For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.