Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 40

Power Pivot

Questions answered in this chapter:

• How do I import data into Power Pivot?

• How do I use Power Pivot to create a PivotTable?

• How can I use slicers with Power Pivot?

• What are DAX functions and calculated columns?

• How does the RELATED function work?

• How does the CALCULATE function work, and what is a calculated measure?

Power Pivot is an Excel add-in that enables you to do the following:

• Efficiently store and query large volumes of data—as in hundreds of millions of rows of data. You can combine this data from multiple data sources and multiple data formats. For example, some of your data could come from a Microsoft Access database, some from a text file, some from several Excel files, and some from live data imported ...