After creating the pivot table, it is important to format the results from the pivot into an easily viewable format. This is important for your readers as well as for your own data analysis. By having a well formatted pivot table allows you to see the data patterns more clearly.

For example, the “Amount” field can be formatted the same way as a cell. The more important consideration is to ensure that the format remains even if you re-arrange the rows(in this case “customer names”) and columns(Slsman No). This is how it should be done. Double click on the label called (Sum of Amount – from last week example). A dialog box appears. Click on the number button and the familiar dialog box for cell formating appears. Select the desired format and click Ok twice to complete the formating. The formating will be preserved even if the pivot table fields are re-arranged.

If you want to learn about pivot table hands-on and are in Singapore on 12 and 19 Dec, you may want to consider signing up for my course. Click here for more details.

Leave a Reply