Tagged: pivot table

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...

Excel Timeline

Excel Timeline is a new pivot table filter introduced in Excel 2013. It automatically evaluates date data and provides year, quarter, month and day filters...