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