Add Format to Numbers in PivotTable Values Area

It is important to format number in PivotTable values area in order to make your reports more readable. Though there are many ways to accomplish this task which I will explain in details later. Let me quickly demonstrate how to perform formatting on numbers in values area of the above PivotTable. Right-click any cell in[…]

Shares 0

What PivotTable is all about?

PivotTable is an essential Excel tool used to explore and analyse huge data set in order to generate an interactive and user friendly summary reports. Its ability to automatically group, sort and filter different subset of data, and ensure data are summarised by categories and sub categories are its cool features that stand it out[…]

Shares 0