Lesson 2

Preview

Convert a Range to a Table; Practice Exercise 1

Practice Exercise 1: ​Convert a Range to a Table

Open data file: RANGE TO TABLE TO PIVOT TABLE2

STEP 1: Select the sheet name RANGE. We need to create a table from this range.
Select Insert tab from the Ribbon shown in FIGURE 1; and select Table choice.​

​STEP 2: The Create Table dialog box appears (FIGURE 2). The range in the Create Table dialog box should be \$A\$1:\$L\$109. If it’s different, correct it to that range by selecting the correct cells with your mouse.  Press OK button and table is created.

The range has now been converted to our new table, as shown in FIGURE 3 below:

STEP 3: We now have our table as shown in FIGURE 3 below.

Step 4: Notice that we have a new contextual tab, “Table Design” on the Ribbon (FIGURE 4). This tab is only visible when one of the cells in the data table is selected.

STEP 5: Click on the newly created tab, “Table Design”. You will see a new toolbar on the Ribbon, as shown in FIGURE 5 below. This entire toolbar is dedicated to customizing a table. Change the name of this table from “Table1” to “XYZ_SALES” (you must insert underscores between the words; no spaces are allowed).

Step 6: In FIGURE 6, we see a closer view of our renamed table. ​

In this practice exercise, we have converted a range to a table. From here, the next step is to create a pivot table from the table such as the one we have created in the above steps. In the next practice exercise we will be creating a pivot table from a table. It should be understood that we did not have to convert the range to a table to create a pivot table. You can also create a pivot table from a range. This range-to-table conversion has been included to increase the student’s understanding of the conversion process.

END OF LESSON

Back to: Intro to Excel 2016 Pivot Tables > Module 1 – Intro to Excel 2016 Pivot Tables