Practice Exercise 2: Creating a Pivot Table Using the Recommended Pivot Table Feature
Still use data file: RANGE TO TABLE TO PIVOT TABLE2
STEP 1: Rolled out with the previous Excel 2013 version, a new feature called Recommended Pivot Tables, is a fast way to create a pivot table if you need one quickly.
|
FIGURE 1
|
STEP 3: The pivot table is shown in the graphic to the right (FIGURE 3). If you want to create a pivot table in a hurry this is the way to go.
The pivot table fields on the far-right graphic (FIGURE 4) can be shown by clicking your mouse on any cell in the pivot table. These pivot table fields can be added to the pivot table by checking the boxes. When using the Recommended Pivot Table choice, a pivot table cell is automatically selected by Excel which causes the Pivot Table Fields list to appear. |
FIGURE 3
|
FIGURE 4
|
This is the end of this Practice Exercise. To continue, go to Mdule 1 Section 1.3.1 Create a Pivot Table Using the Standard Method; Practice Exercise 3