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 …

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

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

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

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