Tagged: pivot table

Excel Crash Course

You may not be excel savy. You may not have required to use Excel all that much. But you would like to have a basic...

Power Pivot

Power Pivot takes the power of relational database queries to your desktop. Only requirement is Excel 2010 or 2013. And knowing how to use it...

Data Analysis With Pivot Table Part – 1/2

Pivot table is without a doubt the number one tool for data analysis in excel. Previously I’ve made an introductory post for pivot table. Now...

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