Skip to content
ProjectControls.com
Project Management Issues Discussion

How to plan and control your project using Excel?

In the Open Standard
Moutaz AldeibMember for 22 years 9 months
Created
7
1
0

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

Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Raymund de Laza ·
    #1

    I have excel workbook for

    I have excel workbook for Cost Control to monitor Expenses.

    Report
  2. 0
    Mike Testro ·
    #2

    Hi MoutazHow will you control

    Hi Moutaz

    How will you control criticality on excell?

    Best regards

    Mike T.

    Report
  3. 0
    Moutaz Aldeib ·
    #3

    Hi MikeSure Gantt Chart is

    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

    Report
  4. 0
    Vladimir Liberzon ·
    #4

    Moutaz,Gantt Chart is one of

    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.

    Report
  5. 0
    Moutaz Aldeib ·
    #5

    Yes Vladimir and that is what

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

    Best

    Report
  6. 0
    Rafael Davila ·
    #6

    In cases such as Critical

    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.

     
    Report
  7. 0
    Vladimir Liberzon ·
    #7

    Report templates can be

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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?