Excel 2019 Bible

Chapter 35: Introducing Power Pivot

35

Adding your Excel tables to the data model

Once you’ve converted your data to Excel tables, you’re ready to add them to the Power

Pivot data model. Follow these steps to add your newly created Excel tables to the data

model using the Power Pivot tab:

1. Click any cell inside your Customers Excel table.


2. Click the Power Pivot tab on the Ribbon, and click the Add to Data Model
   command. Power Pivot creates a copy of your table and activates the Power Pivot
   window (shown in Figure 35.5).

FIGURE 35.5

The Power Pivot window shows all the data that currently exists in your data model.

Although the Power Pivot window looks like Excel, it’s actually a separate program alto-

gether. You’ll notice that the grid for the Customers table has row numbers but no column

references. You’ll also notice that you can’t edit the data within the table. This data is sim-

ply a snapshot of the actual Excel table you imported.

Additionally, if you look at your Windows taskbar at the bottom of your screen, you’ll see

that Power Pivot has a separate window from Excel. You can switch between Excel and the

Power Pivot window by clicking each respective program in the taskbar.

Repeat steps 1 and 2 for your other Excel tables: Invoice Header and Invoice Details. Once

you have imported all your Excel tables into the data model, your Power Pivot window will

show each data set on its own tab, as shown in Figure 35.6.