Before beginning Practice Exercise 18, ensure the following is in place:

• For Report Layout, ensure you are in the Tabular Form.
• In the Columns quadrant of the Fields List, ensure that the Values field is above the Category field, as shown in FIGURE 1.

Now we will address readability issue #2 – Change Value Field Settings

STEP 1: On our pivot table, select the field header, “Sum of SalesQty” (FIGURE 2)

STEP 2: Right-button mouse that click that cell and select the shortcut menu choice, “Value Field Settings” (FIGURE 3).

STEP 3: In the Custom Name window, enter “SalesQty” (FIGURE 4).
Since there is already a field name with this name, Excel will not allow this name, so after entering “SalesQty” add a space.

STEP 4: Select the OK button.
Field header, “Sum of SalesQty” has been replaced with “SalesQty”. Notice that the other field “Total Sum of SalesQty” has also changed to “Total SalesQty” (shown below in FIGURE 8).

STEP 5: ​Select the field header, “Sum of Sales” (FIGURE 5).

STEP 6: Right-button mouse click that cell and select the shortcut menu choice, “Value Field Settings” (FIGURE 6).

STEP 7: In the Value Field Settings dialog box, in the Custom Name window, enter “Sales” (FIGURE 7). Since there is already a field name with this name, Excel will not allow this name, so after entering “Sales” add a space.

​STEP 8: Select the OK button.

Field header, “Sum of Sales” has been replaced with “Sales”. Notice that the “Total Sum of Sales” header has been changed to “Total Sales” (shown below in FIGURE 8).

It is better to format using Value Field Settings interface when formatting data. If you move the data, the formatting will stay intact. If you do not go through the Value Field Settings interface to format data, the formatting can change.

STEP 9: Select the “Sales” header (FIGURE 9).

STEP 10: ​Right button mouse click cell and select “Value Field Settings” from shortcut menu (FIGURE 10).

STEP 11: Select Number Format button, which will open the Format Cells dialog box (FIGURE 11).

STEP 12: On the Format Cells dialog box (FIGURE 12), select:

• Currency category
• 0 Decimal places
• Select OK button twice (once for the Format Cells box and once for the Value Field Settings box).