Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How important MS Excel - Pivot table feature is for your job as a Project Manager/Manager? Please share..

user-image
Question added by Salauddin Mohammad , Sr. Manager, Software Development , Aspen Technology Inc
Date Posted: 2014/07/07
Mohammad Aslam
by Mohammad Aslam , Projects Manager , National Aluminium & Steel Factory

Its a good way to filter and present available data as a meaningful information

Ramy Zakher
by Ramy Zakher , Executive director , EEP

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.

 

Shaikh Urf Salim Bagban
by Shaikh Urf Salim Bagban , Manager- Business Development , Managing Entire PAN

Pivot table help to represent data more systematically and clearly. so over all it help us to build report more agressively and representively...

zafar abbas minhas
by zafar abbas minhas , Freelance Writer , DAILY MASHRAQ

sorry bro,,, not my subject.......

Raafat Sallam
by Raafat Sallam , Organizational Development and Training Consultant , Training Centers, Marketing Organizations.

It is important to make a decision for what-if analysis

IRPHAN GHANI
by IRPHAN GHANI , Senior Management , A

It is certainly an important tool in communication.

An effective tool for handling or managing the team and project.

Wolf Klaas Kinsbergen
by Wolf Klaas Kinsbergen , Managing Director, Designer , ingenieursbureau KB International NV

it helps me not to use a calculator and provides me with up to date  information when I need it.

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

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

Faraz Shiwani
by Faraz Shiwani , Managing Partner , Shiwani Traders

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.

Mohammed Thiab
by Mohammed Thiab , Founder / Chief Consultant , MV Consulting

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.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.