Excel 2019 Bible

(singke) #1

Part V: Understanding Power Pivot and Power Query


FIGURE 36.5
You can explicitly choose the internal data model as the source for a PivotTable.


  1. The Import Data dialog box will open. As Figure 36.6 illustrates, you will choose
    to create a PivotTable report on a new worksheet. Click OK to confirm.


FIGURE 36.6
Creating a new PivotTable on a new worksheet
Free download pdf