How to plan and control your project using Excel?

Member for

24 years 8 months

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

Member for

21 years 8 months

  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.

 

Member for

21 years 10 months

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

Best

Member for

24 years 8 months

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.

Member for

21 years 10 months

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

Member for

19 years 10 months

Hi Moutaz

How will you control criticality on excell?

Best regards

Mike T.

Member for

15 years 11 months

I have excel workbook for Cost Control to monitor Expenses.