Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to plan and control your project using Excel?

7 replies [Last post]
Sun, 2016-04-03 00:02
moutaz aldeib
User offline. Last seen 2 years 26 weeks ago. Offline
Joined: 31 Dec 2003
Posts: 291
Groups: None

Hi Projects Managers' planners and cost engineers,

I am PMO director and have more than ten years experience in planning and projects control using Primavera and Excel.

I am planning to publish a book "how to plan and control your project using Excel" which will include sophisticated features in Excel with practical examples.

I will be garteful to get your contribution about the topics that shall be addressed in the book and any comments I may get the benefit of them. Also, I need to know if this kind of books will add value to the library of projects management?

Your reply is highly appreciate it.

Best,

Muataz

Top

Replies

Mon, 2016-04-18 09:18
#1
Vladimir Liberzon
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)

Report templates can be created and used in the project management software. This feature is not Excel exclusive.

Top
Tue, 2016-04-05 04:38
#2
Rafael Davila
User offline. Last seen 9 hours 29 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
  1. In cases such as Critical Path Planning Excel is worst option, even Microsoft Project is better for such task.
  2. In cases such as Financial and Accounting Excel is worst option, even QuickBooks is better.
  3. In cases such as large relational databases, Excel is worst option, even Access is better.
  4. In cases such as  multi-user environment where data integrity and security is of concern Excel is worst option, even free applications can unlock any Excel password.

It looks like we all agree. Excel is a "Jack of all trades, master of none". Excel is a great tool but you got to keep perspective on its limits.

 
Top
Mon, 2016-04-04 22:39
#3
moutaz aldeib
User offline. Last seen 2 years 26 weeks ago. Offline
Joined: 31 Dec 2003
Posts: 291
Groups: None

Yes Vladimir and that is what I mentioned, in such complicated cases, Pimavera and MS Project are the best choice.

Best

Top
Mon, 2016-04-04 21:54
#4
Vladimir Liberzon
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)

Moutaz,

Gantt Chart is one of the ways to present project schedule. Excel does not schedule and so is useless for project planning especially when there are multiple constraints and calendars.

Top
Mon, 2016-04-04 21:33
#5
moutaz aldeib
User offline. Last seen 2 years 26 weeks ago. Offline
Joined: 31 Dec 2003
Posts: 291
Groups: None

Hi Mike

Sure Gantt Chart is one of the topics which will be included, however it will not be that complicated as softwares like Primavera and MS Project are the best choice in this case.

Best,

Moutaz

Hoping to suggest topics to be covered in the book

Top
Sun, 2016-04-03 16:42
#6
Mike Testro
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors

Hi Moutaz

How will you control criticality on excell?

Best regards

Mike T.

Top
Sun, 2016-04-03 06:36
#7
Raymund de Laza
User offline. Last seen 31 weeks 1 day ago. Offline
Joined: 23 Nov 2009
Posts: 762
Groups: Civil Engineering, Pinoy Planning Planet Community

I have excel workbook for Cost Control to monitor Expenses.

Top