Читать книгу Excel Power Pivot & Power Query For Dummies - Michael Alexander - Страница 28

When linking Excel data to Power Pivot, best practice is to first convert the Excel data to explicitly named tables. Although not technically necessary, giving tables friendly names helps track and manage your data in the Power Pivot data model. If you don’t convert your data to tables first, Excel does it for you and gives your tables useless names like Table1, Table2, and so on.

Follow these steps to convert each data set into an Excel table:

1 Go to the Customers tab and click anywhere inside the data range.

2 Press Ctrl+T on the keyboard.This step opens the Create Table dialog box, shown in Figure 2-3.FIGURE 2-3: Convert the data range into an Excel table.

3 In the Create Table dialog box, ensure that the range for the table is correct and that the My Table Has Headers check box is selected. Click the OK button.You should now see the Table Design tab on the Ribbon.

4 Click the Table Design tab, and use the Table Name input to give your table a friendly name, as shown in Figure 2-4.This step ensures that you can recognize the table when adding it to the Internal Data Model.

5 Repeat Steps 1 through 4 for the Invoice Header and Invoice Details data sets.

FIGURE 2-4: Give your newly created Excel table a friendly name.