Tagged: pivot table

Ungroup Pivot Table Fields

Excel pivot table groups your dates into years, quarters and months by itself when you drag them into a rows or columns. Many users don’t...

Get Rid of GetPivotData

Almost everybody I know wants to get rid of GetPivotData function. Because when you are writing a formula and use a cell reference from a...

Interactive Excel KPI Dashboard

Here is a super slick Interactive Excel KPI Dashboard I prepared with some slicer magic. It will be a good practice of creative use of...

Pivot Table ToolPack

If you are using Excel daily for data analysis and reporting, you need to know how to use pivot table effectively. Therefore I prepared a...