Microsoft Office Tutorials and References
In Depth Information
Understanding the Internal Data Model
You can find the example file for this chapter on this topic’s companion website at
www.wiley.com/go/exceldr in the workbook named Chapter 17 Samples.xlsx.
On the Web
The first step in building your data model is to convert your separate data ranges to named Excel
Tables. Converting a range to a table ensures that the internal Data Model will recognize it as an
actual data source.
Convert your data ranges to Tables
For each data range you want to import into the internal Data Model, follow these steps:
1. Click anywhere in the Transactions data table and press Ctrl+T on your keyboard.
The Create Table dialog box opens, as shown in Figure 17-3.
2. Ensure that the range for the table is correct and click OK.
Figure 17-3: Convert your first data range into an Excel Table.
Click inside your Excel Table, and you will see a Table Tools Design tab on the Ribbon. Note
that if you create multiple tables in a worksheet, the Table Tools Design tab will apply to the
Excel Table you have selected.
3. Click the Table Tools Design tab and enter a friendly name for your table in the Table Name
box (see Figure 17-4).
This step ensures that you will be able to recognize the table when adding it to the internal
Figure 17-4: Give your newly created Excel Table a friendly name.
In this scenario, you use the same steps to convert your Generators range to an Excel Table.