GETPIVOTDATA in PivotTable

GETPIVOTDATA is an amazing formula use to extracts summary data from a PivotTable report. The good thing about this function is how it makes use of criteria to ensure that the right data are extracted without being mindful of any change made to the PivotTable layout. Below is the syntax that appears automatically whenever you[…]

Shares 0

Apply Styles to PivotTable

In order to make PivotTable reports more readable and visual appealing, there is need to apply style of our choice  from eighty-five (85) built-in styles. This categories in to “Light”, “Medium”, “Dark” plus sixteen (16) combinations of styles options in the PivotTable styles gallery located on the design tab under PivotTable tools. You can go a[…]

Shares 0

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