Register now or log in to join your professional community.
Its a good way to filter and present available data as a meaningful information
A Pivot table is a special type of summary table that's unique to Excel. Pivot tables are great for summarizing values in a table because they do their magic without making you create Formulas to perform the calculations. Pivot tables also let you play around with the arrangement of the summarized data. It's this capability of changing the arrangement of the summarized data on the fly simply by rotating row and column headings that gives the pivot table its name.
Pivot table help to represent data more systematically and clearly. so over all it help us to build report more agressively and representively...
sorry bro,,, not my subject.......
It is important to make a decision for what-if analysis
It is certainly an important tool in communication.
An effective tool for handling or managing the team and project.
it helps me not to use a calculator and provides me with up to date information when I need it.
The importance of pivot tables for project manager
* - Present complex data easily
* - Display the data in any way
* - Linking data together to obtain useful informations
* - Sort and filter the data as you want
We process data through any system or software and we get information, but to do a statistical analysis of that information, I use pivots, which save my time and efforts, if I have to do all that myself.
Pivot tables is a powerful tool when dealing with project management tables (excel sheets).This is important to study, analyze, understand and communicate the project management status to those who need to know and take actions accordingly.
In my past experience in project/program management , specially in the iPMO service where we had over170 projects all running at the same time, including50+ IT projects involving many vendors and suppliers.
