Excel 2019 Bible

Part V

Understanding Power

Pivot and Power Query

P

art V introduces to the world of Power

Pivot and Power Query. Here, you’ll

discover how to develop powerful

reporting with external data and the Power

Pivot data model. You’ll also explore how

the rich set of tools Power Query offers can

help you save time, automate data clean-up,

and substantially enhance your data analy-

sis and reporting capabilities.

IN THIS PART

Chapter 35

Introducing Power Pivot

Chapter 36

Working Directly with the Internal Data Model

Chapter 37

Adding Formulas to Power Pivot

Chapter 38

Introducing Power Query

Chapter 39

Transforming Data with Power Query

Chapter 40

Making Queries Work Together

Chapter 41

Extending Power Query with Custom Functions

Excel® 2019 Bible, First Edition. Michael Alexander, Dick Kusleika and John Walkenbach.
© 2019 John Wiley & Sons, Inc. Published 2019 by John Wiley & Sons, Inc.