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...
Tagged: pivot chart
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...
Multi-Level Filter On Pivot Table
Filtering pivot tables with more than one field at the same time is possible and easy. Here is a guide about how to set up...
Excel Slicers
With Excel 2010, we have a very cool tool named Excel Slicers for filtering pivot tables and pivot charts dynamically with one click. Your reports...
Pivot Chart
Pivot chart is a powerful side product of renowned pivot table. It has all the filters that are present on source pivot table. That...
