Creating a Pivot Table Using Recommended Pivot Table Feature; Practice Exercise 2
Practice Exercise 2: Creating a Pivot Table Using the Recommended Pivot Table Feature
Continue to 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.
Ensure you have a table cell selected before beginning. Select the Insert tab and in the Tables section, select Recommended Pivot Tables (FIGURE 1).
STEP 2: Select the recommended pivot table that is highlighted; Sum of Cost by Category (FIGURE 2). Press the OK button.
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.
END OF LESSON
Leave a Reply